0002074: G/L Journal batch process does not report error properly

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0002074	Openbravo ERP	09. Financial management	public	2007-10-11 09:19	2008-06-12 09:43

Reporter	user71
Assigned To	cromero
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version	2.40alpha-r2
Merge Request Status
Review Assigned To
OBNetwork customer	No
Web browser
Modules	Core
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0002074: G/L Journal batch process does not report error properly
Description	Environment: OS: Linux - Centos 4 (test/prod) & Windows XP (dev) DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev) Release: 2.34 Browser: Firefox 2.0.0.6, IE 7 When processing a batch of g/l journal entries, if an error occurs the message is not displayed to the user The problem is in the error handler of the gl_journal_post procedure. This WHEN OTHERS THEN v_ResultStr:= '@ERROR=' \|\| SQLERRM; RAISE NOTICE '%',v_ResultStr; IF(p_PInstance_ID IS NOT NULL) THEN PERFORM Ad_Update_PInstance(p_PInstance_ID, NULL, 'N', 0, v_ResultStr) ; ELSE RAISE EXCEPTION '%', ''; END IF; RETURN; END; $BODY$ should be changed to WHEN OTHERS THEN v_ResultStr:= '@ERROR=' \|\| SQLERRM; RAISE NOTICE '%',v_ResultStr; IF(p_PInstance_ID IS NOT NULL) THEN PERFORM Ad_Update_PInstance(p_PInstance_ID, NULL, 'N', 0, v_ResultStr) ; ELSE RAISE EXCEPTION '%', SQLERRM; END IF; RETURN; END; $BODY$
Steps To Reproduce
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change

Notes