APPS.ARP_PROCESS_PAYINFO dependencies on RA_INTERFACE_ERRORS

Line 71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1

67: inv.request_id = fnd_global.conc_request_id
68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id
70: AND NOT EXISTS (
71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1
72: FROM ra_customer_trx_lines l, ra_interface_errors e
73: WHERE l.customer_trx_id = inv.customer_trx_id
74: AND l.customer_trx_line_id = e.interface_line_id
75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838

Line 72: FROM ra_customer_trx_lines l, ra_interface_errors e

68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id
70: AND NOT EXISTS (
71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1
72: FROM ra_customer_trx_lines l, ra_interface_errors e
73: WHERE l.customer_trx_id = inv.customer_trx_id
74: AND l.customer_trx_line_id = e.interface_line_id
75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838
76:

Line 79: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;

75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838
76:
77:
78: l_ext_entity_tab IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
79: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
80: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
81: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
82: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
83:

Line 206: INSERT INTO ra_interface_errors

202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_standard.debug('Inserting into errors...');
204: END IF;
205: --
206: INSERT INTO ra_interface_errors
207: (
208: org_id,
209: interface_line_id,
210: message_text,

Line 389: INSERT INTO RA_INTERFACE_ERRORS

385: --
386: -- Validate payment_trxn_ext_id
387: --
388: -- 7039838 - perf tuning
389: INSERT INTO RA_INTERFACE_ERRORS
390: (INTERFACE_LINE_ID,
391: MESSAGE_TEXT,
392: INVALID_VALUE,
393: ORG_ID)