APPS.PSA_MFAR_VAL_PKG dependencies on RA_INTERFACE_ERRORS

Line 657: INSERT INTO RA_INTERFACE_ERRORS

653: end if;
654:
655: -- Added Hint to improve performance Bug # 2503680
656:
657: INSERT INTO RA_INTERFACE_ERRORS
658: (INTERFACE_LINE_ID,
659: MESSAGE_TEXT)
660: SELECT /*+ ORDERED */ nvl(L.INTERFACE_LINE_ID,0 ) ,
661: DECODE(B.TYPE ,'GUAR','Commitments Can not be Multi Fund Transactions Type',

Line 679: INSERT INTO RA_INTERFACE_ERRORS

675: | If Invoice has Rules applied then exit the validation |
676: | Else continue further validation |
677: +-------------------------------------------------------------------------*/
678:
679: INSERT INTO RA_INTERFACE_ERRORS
680: (INTERFACE_LINE_ID,
681: MESSAGE_TEXT)
682: SELECT L.INTERFACE_LINE_ID,
683: 'Can not Assign Rules to Multi Fund Transactions'

Line 700: INSERT INTO RA_INTERFACE_ERRORS

696: | Currency exit validation with an error . Otherwise this transaction |
697: | will be qualified as MFAR transaction |
698: +-------------------------------------------------------------------------*/
699:
700: INSERT INTO RA_INTERFACE_ERRORS
701: (INTERFACE_LINE_ID,
702: MESSAGE_TEXT)
703: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
704: 'Transaction Currency Should be Equal to the GL Functional Currency'

Line 727: INSERT INTO RA_INTERFACE_ERRORS

723: | with an error . Otherwise this transaction will be qualified as MFAR |
724: | transaction |
725: +-------------------------------------------------------------------------*/
726: /*
727: INSERT INTO RA_INTERFACE_ERRORS
728: (INTERFACE_LINE_ID,
729: MESSAGE_TEXT )
730: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
731: 'Can not Mark Multi Fund Transactions for Automatic Receipts '

Line 756: INSERT INTO RA_INTERFACE_ERRORS

752: | with an error . Otherwise this transaction will be qualified as MFAR |
753: | transaction |
754: +-------------------------------------------------------------------------*/
755:
756: INSERT INTO RA_INTERFACE_ERRORS
757: (INTERFACE_LINE_ID,
758: MESSAGE_TEXT)
759: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
760: 'Can not Assign Commitments to Multi Fund Transactions'

Line 781: INSERT INTO RA_INTERFACE_ERRORS

777:
778: -- Bug 2571462 : Added Join between ra_cust_trx_types_all and psa_trx_types_all
779: -- This will supersede bug 2503680
780:
781: INSERT INTO RA_INTERFACE_ERRORS
782: (INTERFACE_LINE_ID,
783: MESSAGE_TEXT)
784: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
785: 'Credit Memo Profile Option must use Invoice Accounting for Multi Fund Transactions'