Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0015769Openbravo ERPZ. Otherspublic2011-01-25 12:072012-06-11 17:57
dalsasua 
naiaramartinez 
urgentmajoralways
closedno change required 
20Ubuntu 10.10
2.50MP25 
 
Core
No
0015769: In Oracle, if an extension point throws an exception, this is not thrown upwards.
In Oracle, if an extension point throws an exception, this is not thrown upwards.
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.
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.
VMA-Reviewed
Issue History
2011-01-25 12:07dalsasuaNew Issue
2011-01-25 12:07dalsasuaAssigned To => adrianromero
2011-01-25 12:07dalsasuaModules => Core
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte
2012-02-15 19:05iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 15:55vmromanosTag Attached: VMA-Reviewed
2012-05-10 12:13gorka_gilAssigned Tovmromanos => mirurita
2012-06-11 11:11naiaramartinezAssigned Tomirurita => naiaramartinez
2012-06-11 11:11naiaramartinezStatusnew => scheduled
2012-06-11 11:11naiaramartinezfix_in_branch => pi
2012-06-11 17:57naiaramartinezNote Added: 0049737
2012-06-11 17:57naiaramartinezStatusscheduled => closed
2012-06-11 17:57naiaramartinezResolutionopen => no change required

Notes
(0049737)
naiaramartinez   
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.