details: /erp/stable/2.50/rev/63c194f03f6c
changeset: 9185:63c194f03f6c
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Thu Feb 03 11:25:55 2011 +0100
summary: Fixes issue 0015794: bankstatement in a wrong status: it is not
processed and debt payments are cancelled
It has been added a condition in the C_BANKSTATEMENT trigger that verifies when
saving that there has not been running process concurrently
diffstat:
src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml | 13 +++++----
1 files changed, 7 insertions(+), 6 deletions(-)
diffs (24 lines):
diff -r 820242d519ab -r 63c194f03f6c
src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml
--- a/src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml Wed Feb
02 14:13:34 2011 +0100
+++ b/src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml Thu Feb
03 11:25:55 2011 +0100
@@ -31,13 +31,14 @@
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
- IF ((:OLD.PROCESSED = 'Y' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED =
'N' AND :NEW.PROCESSING='N') OR
- (:OLD.PROCESSED = 'N' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED =
'Y' AND :NEW.PROCESSING='N')) THEN
- -- Checking for concurrent process running
- RAISE_APPLICATION_ERROR(-20501, '@OtherProcessActive@') ;
- END IF;
+ IF UPDATING THEN
- IF UPDATING THEN
+ IF ((:OLD.PROCESSED = 'Y' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED
= 'N' AND :NEW.PROCESSING='N') OR
+ (:OLD.PROCESSED = 'N' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED
= 'Y' AND :NEW.PROCESSING='N')) THEN
+ -- Checking for concurrent process running
+ RAISE_APPLICATION_ERROR(-20501, '@OtherProcessActive@') ;
+ END IF;
+
IF (:old.Processed='Y'
AND ((COALESCE(:old.STATEMENTDATE, v_DateNull) <>
COALESCE(:new.STATEMENTDATE, v_DateNull))
OR(COALESCE(:old.C_BANKACCOUNT_ID, '0') <>
COALESCE(:new.C_BANKACCOUNT_ID, '0'))
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
