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$

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0002342) cromero (viewer) 2008-05-21 17:49 edited on: 2008-06-12 09:22	Logged In: YES user_id=1500614 Originator: NO Fixed in the trunk in revision 4437

(0005663) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1811334 [^]

Issue History
Date Modified	Username	Field	Change