0015769: In Oracle, if an extension point throws an exception, this is not thrown upwards.

Description

In Oracle, if an extension point throws an exception, this is not thrown upwards.

Steps To Reproduce

Install intercompany module, and configure it, as shown in the wiki section of the project: http://wiki.openbravo.com/wiki/Projects/intercompanyinvoicing/User_Guide#Overview [^]
Use as counter organization a new one, with no tax or bp defined for it (or for * organization).
Try to process one document (as an intercompany purchase order).
Check that no error is shown, but counter document is created incorrectly, and not processed.

Proposed Solution

Check that ad_extension_point_handler function, calls the required PL/SQL piece of code, but
  EXECUTE v_Sql;
statement do not capture an exception thrown inside it, although the
  WHEN OTHERS THEN
  RAISE NOTICE '%','AD_EXTENSION_POINT_HANDLER exception' ;
  RAISE EXCEPTION '%', SQLERRM;
statement is there.
Research how this call must be done, so it captures the exceptions.

Tags

VMA-Reviewed

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0049737) naiaramartinez (developer) 2012-06-11 17:57	This issue has been closed because the error is shown in the application. We have debbuged in Oracle, and the exception is raised from interco_create_order function to c_order_post1 function. Moreover, in the application we can see the exception, so the user can see the error. That's why we close this issue.

Issue History
Date Modified	Username	Field	Change
2011-01-25 12:07	dalsasua	New Issue
2011-01-25 12:07	dalsasua	Assigned To	=> adrianromero
2011-01-25 12:07	dalsasua	Modules	=> Core
2011-06-03 10:58	dalsasua	Assigned To	adrianromero => dalsasua
2011-07-20 18:16	dalsasua	Assigned To	dalsasua => jonalegriaesarte
2012-02-15 19:05	iciordia	Assigned To	jonalegriaesarte => vmromanos
2012-02-16 15:55	vmromanos	Tag Attached: VMA-Reviewed
2012-05-10 12:13	gorka_gil	Assigned To	vmromanos => mirurita
2012-06-11 11:11	naiaramartinez	Assigned To	mirurita => naiaramartinez
2012-06-11 11:11	naiaramartinez	Status	new => scheduled
2012-06-11 11:11	naiaramartinez	fix_in_branch	=> pi
2012-06-11 17:57	naiaramartinez	Note Added: 0049737
2012-06-11 17:57	naiaramartinez	Status	scheduled => closed
2012-06-11 17:57	naiaramartinez	Resolution	open => no change required