details:   https://code.openbravo.com/erp/devel/pi/rev/1a0de77a8c0d
changeset: 20714:1a0de77a8c0d
user:      Asier Lostalé <asier.lostale <at> openbravo.com>
date:      Tue Jul 09 10:14:15 2013 +0200
summary:   fixed issue 24293: added extension point prior to execute 
C_Invoice_Post

diffstat:

 src-db/database/model/functions/C_INVOICE_POST.xml |  30 ++++++++++++++++++++-
 src-db/database/sourcedata/AD_EXTENSION_POINTS.xml |  10 +++++++
 2 files changed, 38 insertions(+), 2 deletions(-)

diffs (68 lines):

diff -r 7cb5e15ace70 -r 1a0de77a8c0d 
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml        Mon Jul 08 
17:57:50 2013 +0200
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml        Tue Jul 09 
10:14:15 2013 +0200
@@ -22,7 +22,7 @@
   * parts created by ComPiere are Copyright (C) ComPiere, Inc.;
   * All Rights Reserved.
   * Contributor(s): Openbravo SLU
-  * Contributions are Copyright (C) 2001-2012 Openbravo, S.L.U.
+  * Contributions are Copyright (C) 2001-2013 Openbravo, S.L.U.
   *
   * Specifically, this derivative work is based upon the following Compiere
   * file and version.
@@ -387,8 +387,34 @@
       RAISE_APPLICATION_ERROR(-20000, '@AlreadyPosted@');
     END IF;
   END IF;--FINISH_PROCESS
+
+IF (NOT FINISH_PROCESS) THEN
+   --C_Invoice_Post - Valistaion Process Extension Point
+    SELECT count(*) INTO v_count
+    FROM DUAL
+    where exists (select 1 from ad_ep_procedures where ad_extension_points_id 
= 'C3A4ABF2DF544F4694142DA9E79495F7');
+    IF (v_count=1) THEN
+      DECLARE
+        v_ep_instance VARCHAR2(32);
+        v_extension_point_id VARCHAR2(32) := 
'C3A4ABF2DF544F4694142DA9E79495F7';
+      BEGIN
+        v_ep_instance := get_uuid();
+        AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id, 
'Record_ID',
+          v_record_id, NULL, NULL, NULL, NULL, NULL, NULL);
+        AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id, 
'DocAction',
+          v_DocAction, NULL, NULL, NULL, NULL, NULL, NULL);
+        AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id, 'User',
+          v_User_ID, NULL, NULL, NULL, NULL, NULL, NULL);
+        AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id);
+
+        DELETE FROM ad_ep_instance_para
+        WHERE ad_ep_instance_id = v_ep_instance;
+      END;
+    END IF;
+ END IF;
+    
+
   --cbt taxpayment
-
   IF (NOT FINISH_PROCESS) THEN
     IF (v_docaction IN ('VO', 'RE', 'RC')
        AND v_docstatus IN('CO', 'CL')) THEN
diff -r 7cb5e15ace70 -r 1a0de77a8c0d 
src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
--- a/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml        Mon Jul 08 
17:57:50 2013 +0200
+++ b/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml        Tue Jul 09 
10:14:15 2013 +0200
@@ -70,6 +70,16 @@
 <!--830A9E22114C4322BBD2144C215C85E4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--830A9E22114C4322BBD2144C215C85E4--></AD_EXTENSION_POINTS>
 
+<!--C3A4ABF2DF544F4694142DA9E79495F7--><AD_EXTENSION_POINTS>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  
<AD_EXTENSION_POINTS_ID><![CDATA[C3A4ABF2DF544F4694142DA9E79495F7]]></AD_EXTENSION_POINTS_ID>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  <NAME><![CDATA[C_Invoice_Post - 
Validation Process]]></NAME>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  <DESCRIPTION><![CDATA[Extension point 
at the beginning of C_Invoice_Post to perform validations before starting the 
process. Available parameters Record_ID, DocAction, User]]></DESCRIPTION>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C3A4ABF2DF544F4694142DA9E79495F7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C3A4ABF2DF544F4694142DA9E79495F7--></AD_EXTENSION_POINTS>
+
 <!--C485210A6F754FE0A6E32FA24B3B243C--><AD_EXTENSION_POINTS>
 <!--C485210A6F754FE0A6E32FA24B3B243C-->  
<AD_EXTENSION_POINTS_ID><![CDATA[C485210A6F754FE0A6E32FA24B3B243C]]></AD_EXTENSION_POINTS_ID>
 <!--C485210A6F754FE0A6E32FA24B3B243C-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>

------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to