[Home] [Help]
8: CHANGE HISTORY:
9: S.No Date Author and Details
10: 1 07/11/200b CSahoo For Bug#7450481, File Version 120.7.12010000.2
11: Issue: AUTOINVOICE IMPORT PROGRAM ENDING IN ERROR FOR BILL ONLY ORDERS
12: Fix: Added the code to call the procedure JAI_AR_RCTA_TRIGGER_PKG.ARD_T1
13: when the base table gets deleted.
14:
15: 2. 24/04/2009 JMEENA for bug#8451356
16: Issue: Procedure jai_ar_match_tax_pkg.acct_inclu_taxes inserts duplicate accounting entries for inclusive taxes in the gl_interface table
28: to display the VAT/Excise Number in AR transaction workbench
29:
30:
31: 5. 29/04/2010 Bo Li for bug#9666476
32: Added a script to handle the non-shippale RMA flow by invoking the procedure JAI_AR_RCTA_TRIGGER_PKG.ARU_T8
33: as updating.
34:
35: 6. 05-May-2010 Bo Li for Bug#9490173
36: Add the logic to control the trigger for invoking the request which updates the reference filed
587: IF ( :NEW.CREATED_FROM <> 'RAXTRX' ) THEN
588:
589: jai_cmn_utils_pkg.print_log ('jai_ar_rcta.log', :NEW.CREATED_FROM || '<> ''RAXTRX''');
590:
591: JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 (
592: pr_old => t_old_rec ,
593: pr_new => t_new_rec ,
594: pv_action => lv_action ,
595: pv_return_code => lv_return_code ,
622: --Added by zhiwei for Open Interface ER bug#11683927 end
623:
624: IF ( :NEW.complete_flag = 'Y' ) THEN
625:
626: JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 (
627: pr_old => t_old_rec ,
628: pr_new => t_new_rec ,
629: pv_action => lv_action ,
630: pv_return_code => lv_return_code ,
639: END IF ;
640:
641: IF ((:NEW.TRX_NUMBER <> :OLD.TRX_NUMBER) OR (:NEW.CUSTOMER_TRX_ID <> :OLD.CUSTOMER_TRX_ID)) THEN
642:
643: JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 (
644: pr_old => t_old_rec ,
645: pr_new => t_new_rec ,
646: pv_action => lv_action ,
647: pv_return_code => lv_return_code ,
655: END IF ;
656:
657: IF ( :NEW.COMPLETE_FLAG = 'Y' AND NVL(:NEW.CREATED_FROM,'###') IN ('ARXTWMAI','ARXTWCMI') ) THEN
658:
659: JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 (
660: pr_old => t_old_rec ,
661: pr_new => t_new_rec ,
662: pv_action => lv_action ,
663: pv_return_code => lv_return_code ,
707: END IF ;
708:
709: IF ( :NEW.COMPLETE_FLAG = 'Y' ) THEN
710:
711: JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 (
712: pr_old => t_old_rec ,
713: pr_new => t_new_rec ,
714: pv_action => lv_action ,
715: pv_return_code => lv_return_code ,
924: END IF ;
925:
926: IF ( NVL(:NEW.COMPLETE_FLAG,'$') ='N' AND :NEW.TRX_DATE <> :OLD.TRX_DATE ) THEN
927:
928: JAI_AR_RCTA_TRIGGER_PKG.ARU_T5 (
929: pr_old => t_old_rec ,
930: pr_new => t_new_rec ,
931: pv_action => lv_action ,
932: pv_return_code => lv_return_code ,
942: END IF ;
943:
944: IF ( (NVL(:NEW.Ship_To_Customer_ID,0) <> NVL(:OLD.Ship_To_Customer_ID,0)) OR (NVL(:NEW.Ship_To_Site_Use_ID,0) <> NVL(:OLD.Ship_To_Site_Use_ID,0)) OR :NEW.invoice_currency_code <> :OLD.invoice_currency_code ) THEN
945:
946: JAI_AR_RCTA_TRIGGER_PKG.ARU_T6 (
947: pr_old => t_old_rec ,
948: pr_new => t_new_rec ,
949: pv_action => lv_action ,
950: pv_return_code => lv_return_code ,
961: -- Start 5631784
962: IF ( NVL(:OLD.COMPLETE_FLAG,'N') = 'N' AND NVL(:NEW.COMPLETE_FLAG,'$') ='Y' ) -- COMPLETION
963: OR ( NVL(:OLD.COMPLETE_FLAG,'N') = 'Y' AND NVL(:NEW.COMPLETE_FLAG,'$') ='N' ) -- INCOMPLETION
964: THEN
965: JAI_AR_RCTA_TRIGGER_PKG.ARU_T7 (
966: pr_old => t_old_rec ,
967: pr_new => t_new_rec ,
968: pv_action => lv_action ,
969: pv_return_code => lv_return_code ,
980: --Added by Bo Li for the VAT non-shippable for Bug9666476 on 2010-4-28 Begin
981: -------------------------------------------------------------------------
982: IF ( :NEW.complete_flag = 'Y' ) THEN
983:
984: JAI_AR_RCTA_TRIGGER_PKG.ARU_T8 (
985: pr_old => t_old_rec ,
986: pr_new => t_new_rec ,
987: pv_action => lv_action ,
988: pv_return_code => lv_return_code ,
1001:
1002: --added the following IF block for bug#7450481
1003: IF DELETING THEN
1004:
1005: JAI_AR_RCTA_TRIGGER_PKG.ARD_T1 (
1006: pr_old => t_old_rec ,
1007: pv_action => lv_action ,
1008: pv_return_code => lv_return_code ,
1009: pv_return_message => lv_return_message