details: https://code.openbravo.com/erp/devel/pi/rev/dafbb746f822
changeset: 28556:dafbb746f822
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Sat Jan 30 10:26:12 2016 +0100
summary: Fixed bug 30235: Extension point at the end of
aprm_gen_paymentschedule_inv
Added Extension point at the end of aprm_gen_paymentschedule_inv procedure, so
it now has an extension point at the beginning and at the end of the process.
Solution contributed by partner
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
| 32 +++++++++-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
| 10 +++
2 files changed, 41 insertions(+), 1 deletions(-)
diffs (68 lines):
diff -r 2dd2efccfcc6 -r dafbb746f822
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Fri Jan 29 14:31:54 2016 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Sat Jan 30 10:26:12 2016 +0100
@@ -16,7 +16,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2010-2015 Openbravo SLU
+* All portions are Copyright (C) 2010-2016 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -1230,6 +1230,36 @@
SET em_aprm_processinvoice = docaction
WHERE c_invoice_id = p_record_id;
+ -- BEGIN Extension Point
+ SELECT count(*) INTO v_count FROM DUAL
+ WHERE EXISTS (SELECT 1 FROM ad_ep_procedures WHERE ad_extension_points_id =
'E845069AC5724A019D8A5343C396CAE8');
+ IF (v_count=1) THEN
+ DECLARE
+ v_ep_instance VARCHAR2(32);
+ v_extension_point_id VARCHAR2(32) := 'E845069AC5724A019D8A5343C396CAE8';
+ BEGIN
+ v_ep_instance := get_uuid();
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'Record_ID', p_record_id, NULL, NULL, NULL, NULL, NULL, NULL);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'DocAction', p_docaction, NULL, NULL, NULL, NULL, NULL, NULL);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id, 'User',
p_user, NULL, NULL, NULL, NULL, NULL, NULL);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'Message', NULL, NULL, NULL, NULL, NULL, NULL, p_message);
+ AD_EP_INSTANCE_PARA_INSERT(v_ep_instance, v_extension_point_id,
'Result', NULL, NULL, p_result, NULL, NULL, NULL, NULL);
+ AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id);
+ SELECT p_number INTO p_result
+ FROM ad_ep_instance_para
+ WHERE ad_ep_instance_id = v_ep_instance
+ AND parametername LIKE 'Result';
+ SELECT p_text INTO p_message
+ FROM ad_ep_instance_para
+ WHERE ad_ep_instance_id = v_ep_instance
+ AND parametername LIKE 'Message';
+
+ DELETE FROM ad_ep_instance_para
+ WHERE ad_ep_instance_id = v_ep_instance;
+ END;
+ END IF;
+ -- END Extension Point
+
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('APRM_GENERATE_PAYMENT_SCHEDULE exception: '||
v_ResultStr);
diff -r 2dd2efccfcc6 -r dafbb746f822
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
Fri Jan 29 14:31:54 2016 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
Sat Jan 30 10:26:12 2016 +0100
@@ -1,5 +1,15 @@
<?xml version='1.0' encoding='UTF-8'?>
<data>
+<!--E845069AC5724A019D8A5343C396CAE8--><AD_EXTENSION_POINTS>
+<!--E845069AC5724A019D8A5343C396CAE8-->
<AD_EXTENSION_POINTS_ID><![CDATA[E845069AC5724A019D8A5343C396CAE8]]></AD_EXTENSION_POINTS_ID>
+<!--E845069AC5724A019D8A5343C396CAE8-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E845069AC5724A019D8A5343C396CAE8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E845069AC5724A019D8A5343C396CAE8-->
<NAME><![CDATA[Aprm_Gen_PaymentSchedule_Inv Extension Point End]]></NAME>
+<!--E845069AC5724A019D8A5343C396CAE8--> <DESCRIPTION><![CDATA[Extension point
at the end of Aprm_Gen_PaymentSchedule_Inv for managing migrated orders with
debt payments.]]></DESCRIPTION>
+<!--E845069AC5724A019D8A5343C396CAE8-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--E845069AC5724A019D8A5343C396CAE8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E845069AC5724A019D8A5343C396CAE8--></AD_EXTENSION_POINTS>
+
<!--F489FE52771F42E5B8CF228F26553726--><AD_EXTENSION_POINTS>
<!--F489FE52771F42E5B8CF228F26553726-->
<AD_EXTENSION_POINTS_ID><![CDATA[F489FE52771F42E5B8CF228F26553726]]></AD_EXTENSION_POINTS_ID>
<!--F489FE52771F42E5B8CF228F26553726-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
