details: https://code.openbravo.com/erp/devel/pi/rev/4c5cd48e2467
changeset: 13663:4c5cd48e2467
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Sep 06 11:28:56 2011 +0200
summary: Fixes bug 0018315
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_BANKSTATEMENT_TRG.xml
| 15 ++++++++-
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_CASH_TRG.xml
| 15 ++++++++-
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_DP_MANAGEMENT_TRG.xml
| 15 ++++++++-
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_REMITTANCE_TRG.xml
| 15 ++++++++-
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_SETTLEMENT_TRG.xml
| 15 ++++++++-
5 files changed, 65 insertions(+), 10 deletions(-)
diffs (130 lines):
diff -r b92b2fa9d8ea -r 4c5cd48e2467
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_BANKSTATEMENT_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_BANKSTATEMENT_TRG.xml
Mon Sep 05 19:33:03 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_BANKSTATEMENT_TRG.xml
Tue Sep 06 11:28:56 2011 +0200
@@ -25,9 +25,20 @@
FROM DUAL
WHERE EXISTS (SELECT 1 FROM ad_preference WHERE attribute = 'APRM_Ready');
- IF (v_count = 1) THEN
- RAISE_APPLICATION_ERROR(-20000, '@APRM_OldFlowDisabled@');
+ IF(v_count = 1) THEN
+ IF(DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ IF(UPDATING) THEN
+ IF(:old.Processed <> :new.Processed) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ END IF;
+ IF(INSERTING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
END IF;
+
END APRM_C_BANKSTATEMENT_TRG
]]></body>
</trigger>
diff -r b92b2fa9d8ea -r 4c5cd48e2467
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_CASH_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_CASH_TRG.xml
Mon Sep 05 19:33:03 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_CASH_TRG.xml
Tue Sep 06 11:28:56 2011 +0200
@@ -25,9 +25,20 @@
FROM DUAL
WHERE EXISTS (SELECT 1 FROM ad_preference WHERE attribute = 'APRM_Ready');
- IF (v_count = 1) THEN
- RAISE_APPLICATION_ERROR(-20000, '@APRM_OldFlowDisabled@');
+ IF(v_count = 1) THEN
+ IF(DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ IF(UPDATING) THEN
+ IF(:old.Processed <> :new.Processed) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ END IF;
+ IF(INSERTING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
END IF;
+
END APRM_C_CASH_TRG
]]></body>
</trigger>
diff -r b92b2fa9d8ea -r 4c5cd48e2467
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_DP_MANAGEMENT_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_DP_MANAGEMENT_TRG.xml
Mon Sep 05 19:33:03 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_DP_MANAGEMENT_TRG.xml
Tue Sep 06 11:28:56 2011 +0200
@@ -25,9 +25,20 @@
FROM DUAL
WHERE EXISTS (SELECT 1 FROM ad_preference WHERE attribute = 'APRM_Ready');
- IF (v_count = 1) THEN
- RAISE_APPLICATION_ERROR(-20000, '@APRM_OldFlowDisabled@');
+ IF(v_count = 1) THEN
+ IF(DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ IF(UPDATING) THEN
+ IF(:old.Processed <> :new.Processed) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ END IF;
+ IF(INSERTING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
END IF;
+
END APRM_C_DP_MANAGEMENT_TRG
]]></body>
</trigger>
diff -r b92b2fa9d8ea -r 4c5cd48e2467
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_REMITTANCE_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_REMITTANCE_TRG.xml
Mon Sep 05 19:33:03 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_REMITTANCE_TRG.xml
Tue Sep 06 11:28:56 2011 +0200
@@ -25,9 +25,20 @@
FROM DUAL
WHERE EXISTS (SELECT 1 FROM ad_preference WHERE attribute = 'APRM_Ready');
- IF (v_count = 1) THEN
- RAISE_APPLICATION_ERROR(-20000, '@APRM_OldFlowDisabled@');
+ IF(v_count = 1) THEN
+ IF(DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ IF(UPDATING) THEN
+ IF(:old.Processed <> :new.Processed) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ END IF;
+ IF(INSERTING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
END IF;
+
END APRM_C_REMITTANCE_TRG
]]></body>
</trigger>
diff -r b92b2fa9d8ea -r 4c5cd48e2467
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_SETTLEMENT_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_SETTLEMENT_TRG.xml
Mon Sep 05 19:33:03 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_SETTLEMENT_TRG.xml
Tue Sep 06 11:28:56 2011 +0200
@@ -25,9 +25,20 @@
FROM DUAL
WHERE EXISTS (SELECT 1 FROM ad_preference WHERE attribute = 'APRM_Ready');
- IF (v_count = 1) THEN
- RAISE_APPLICATION_ERROR(-20000, '@APRM_OldFlowDisabled@');
+ IF(v_count = 1) THEN
+ IF(DELETING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ IF(UPDATING) THEN
+ IF(:old.Processed <> :new.Processed) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
+ END IF;
+ IF(INSERTING) THEN
+ RAISE_APPLICATION_ERROR(-20501, '@APRM_OldFlowDisabled@') ;
+ END IF;
END IF;
+
END APRM_C_SETTLEMENT_TRG
]]></body>
</trigger>
------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
