[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;
120: ra_customer_trx_lines line
121: WHERE
122: line.customer_trx_id = c01_rec.customer_trx_id
123: AND line.payment_trxn_extension_id IS NOT NULL -- 9274573
124: AND line.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- 7039838
125:
126: --
127: -- Copy Extension entity
128: --
290: BEGIN
291: IF PG_DEBUG in ('Y', 'C') THEN
292: arp_standard.debug('arp_process_payinfo.default_payment_attributes()+ ');
293: arp_standard.debug('Req Id : [' || arp_global.request_id || ']');
294: arp_standard.debug('FND Req Id : [' || fnd_global.conc_request_id || ']');
295: END IF;
296: --
297: -- Update transaction header with payment attributes for grouping
298: --
334: AND ext.origin_application_id = a.application_id
335: GROUP BY auth.authorized_flag,
336: ext.instr_assignment_id,
337: ext.trxn_extension_id)
338: WHERE request_id = fnd_global.conc_request_id
339: AND payment_trxn_extension_id IS NOT NULL;
340: --
341: IF PG_DEBUG in ('Y', 'C') THEN
342: arp_standard.debug('arp_process_payinfo.default_payment_attributes()- ');
382: BEGIN
383: IF PG_DEBUG in ('Y', 'C') THEN
384: arp_standard.debug('arp_process_payinfo.validate_payment_ext_id()+ ');
385: arp_standard.debug('Req Id : [' || arp_global.request_id || ']');
386: arp_standard.debug('FND Req Id : [' || fnd_global.conc_request_id || ']');
387: END IF;
388: --
389: -- Validate payment_trxn_ext_id
390: --
413: AR_RECEIPT_METHODS rm,
414: AR_RECEIPT_CLASSES rc,
415: IBY_FNDCPT_PMT_CHNNLS_B P,
416: IBY_FNDCPT_TX_EXTENSIONS X
417: WHERE L.REQUEST_ID = fnd_global.conc_request_id
418: AND L.CUSTOMER_TRX_ID IS NOT NULL
419: AND NVL(L.INTERFACE_STATUS, '~') <> 'P'
420: AND l.receipt_method_id = rm.receipt_method_id (+)
421: AND rm.receipt_class_id = rc.receipt_class_id (+)