[Home] [Help]
63: inv.org_id
64: FROM
65: ra_customer_trx inv, hz_cust_accounts cus
66: WHERE
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
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:
77:
78: l_ext_entity_tab IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
79: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
92: --
93: IF PG_DEBUG in ('Y', 'C') THEN
94: arp_standard.debug('arp_process_payinfo.copy_payment_ext_id()+ ');
95: arp_standard.debug('Req Id : [' || arp_global.request_id || ']');
96: arp_standard.debug('FND Req Id : [' || fnd_global.conc_request_id || ']');
97: END IF;
98: --
99: l_payer.Org_Type := null;
100: l_payer.Org_id := null;
119: ra_customer_trx_lines line
120: WHERE
121: line.customer_trx_id = c01_rec.customer_trx_id
122: AND line.line_type = 'LINE'
123: AND line.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- 7039838
124:
125: --
126: -- Copy Extension entity
127: --
287: BEGIN
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_standard.debug('arp_process_payinfo.default_payment_attributes()+ ');
290: arp_standard.debug('Req Id : [' || arp_global.request_id || ']');
291: arp_standard.debug('FND Req Id : [' || fnd_global.conc_request_id || ']');
292: END IF;
293: --
294: -- Update transaction header with payment attributes for grouping
295: --
331: AND ext.origin_application_id = a.application_id
332: GROUP BY auth.authorized_flag,
333: ext.instr_assignment_id,
334: ext.trxn_extension_id)
335: WHERE request_id = fnd_global.conc_request_id
336: AND payment_trxn_extension_id IS NOT NULL;
337: --
338: IF PG_DEBUG in ('Y', 'C') THEN
339: arp_standard.debug('arp_process_payinfo.default_payment_attributes()- ');
379: BEGIN
380: IF PG_DEBUG in ('Y', 'C') THEN
381: arp_standard.debug('arp_process_payinfo.validate_payment_ext_id()+ ');
382: arp_standard.debug('Req Id : [' || arp_global.request_id || ']');
383: arp_standard.debug('FND Req Id : [' || fnd_global.conc_request_id || ']');
384: END IF;
385: --
386: -- Validate payment_trxn_ext_id
387: --
410: AR_RECEIPT_METHODS rm,
411: AR_RECEIPT_CLASSES rc,
412: IBY_FNDCPT_PMT_CHNNLS_B P,
413: IBY_FNDCPT_TX_EXTENSIONS X
414: WHERE L.REQUEST_ID = fnd_global.conc_request_id
415: AND L.CUSTOMER_TRX_ID IS NOT NULL
416: AND NVL(L.INTERFACE_STATUS, '~') <> 'P'
417: AND l.receipt_method_id = rm.receipt_method_id (+)
418: AND rm.receipt_class_id = rc.receipt_class_id (+)