[Home] [Help]
47: return;
48: end if;
49:
50: SELECT 'X' into l_trx_type_check
51: from psa_trx_types_ALL a, ra_cust_trx_types_all b
52: where a.psa_trx_type_id = X_TRANSACTION_TYPE_ID
53: AND a.psa_trx_type_id = b.cust_trx_type_id ;
54:
55: -- EXCEPTION
219: return;
220: end if;
221:
222: SELECT 'X' into l_trx_type_check
223: from psa_trx_types_ALL a, ra_customer_trx_all b
224: where a.psa_trx_type_id = b.cust_trx_type_id
225: and b.customer_trx_id = X_TRX_ID ;
226:
227: if l_trx_type_check is not null then
316:
317: if X_SOURCE_TYPE = 'TRX' then
318:
319: SELECT 'X' into l_validate_trx
320: from psa_trx_types_ALL a, ra_customer_trx_all b
321: where a.psa_trx_type_id = b.cust_trx_type_id
322: and customer_trx_id = X_SOURCE_ID ;
323:
324: if l_validate_trx is not null then
331:
332: elsif X_SOURCE_TYPE = 'ADJ' then
333:
334: SELECT 'X' into l_validate_adj
335: from psa_trx_types_ALL a, ra_customer_trx_all b,
336: ar_adjustments_all c
337: where b.customer_trx_id = c.customer_trx_id
338: and a.psa_trx_type_id = b.cust_trx_type_id
339: and c.adjustment_id = X_SOURCE_ID ;
399:
400: fnd_profile.get('ORG_ID',l_org_id);
401:
402: SELECT 'X' into l_rct_check
403: from psa_trx_types_ALL a, ra_customer_trx_ALL b
404: -- ar_cash_receipts_ALL c,ar_receivable_applications_ALL d
405: -- where b.customer_trx_id = d.applied_customer_trx_id
406: -- and c.cash_receipt_id = d.cash_receipt_id
407: -- and
662: 'CB' ,'Multi Fund TRansactions Can not be Charged Back' ,
663: 'CM' , 'On-Account Credit Can not use Multi Fund Transaction types')
664: FROM ra_interface_lines_gt L,
665: ra_cust_trx_types_all B,
666: psa_trx_types_all C
667: WHERE L.REQUEST_ID = l_request_id
668: AND L.cust_trx_type_id = B.cust_trx_type_id
669: AND B.TYPE in ('GUAR', 'CB', 'CM')
670: AND B.cust_trx_type_id = C.psa_trx_type_id;
686: AND ( L.INVOICING_RULE_ID IS NOT NULL
687: OR L.INVOICING_RULE_NAME IS NOT NULL )
688: AND exists
689: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
690: PSA_TRX_TYPES_ALL C
691: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
692: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID ) ;
693:
694: /* ------------------------------------------------------------------------+
705: FROM RA_INTERFACE_LINES_GT L
706: WHERE L.REQUEST_ID = l_request_id
707: AND exists
708: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
709: PSA_TRX_TYPES_ALL C
710: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
711: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
712: AND not exists
713: (select 'X'
732: FROM RA_INTERFACE_LINES_GT L
733: WHERE L.REQUEST_ID = l_request_id
734: AND exists
735: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
736: PSA_TRX_TYPES_ALL C
737: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
738: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
739: AND exists
740: (SELECT 'X'
761: FROM RA_INTERFACE_LINES_GT L
762: WHERE L.REQUEST_ID = l_request_id
763: AND exists
764: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
765: PSA_TRX_TYPES_ALL C
766: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
767: AND B.TYPE = 'INV'
768: AND L.REFERENCE_LINE_ID is not null
769: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID ) ;
774: | Otherwise this transaction will be qualified as MFAR |
775: | transaction |
776: +-------------------------------------------------------------------------*/
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,
786: FROM RA_INTERFACE_LINES_GT L
787: WHERE L.REQUEST_ID = l_request_id
788: AND exists
789: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
790: PSA_TRX_TYPES_ALL C
791: WHERE fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG') <> 'Y'
792: AND B.TYPE = 'CM'
793: AND L.REFERENCE_LINE_ID is not null
794: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID