APPS.ARP_GROUP_INV dependencies on RA_INTERFACE_ERRORS

Line 230: INSERT INTO ra_interface_errors

226: ******************************************************************/
227:
228: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1810');
229:
230: INSERT INTO ra_interface_errors
231: (interface_line_id,
232: message_text,
233: invalid_value,
234: org_id)

Line 258: INSERT INTO RA_INTERFACE_ERRORS

254: ******************************************************************/
255:
256: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1811');
257:
258: INSERT INTO RA_INTERFACE_ERRORS
259: (interface_line_id,
260: message_text,
261: invalid_value,
262: org_id)

Line 290: INSERT INTO RA_INTERFACE_ERRORS

286: ******************************************************************/
287:
288: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1812');
289:
290: INSERT INTO RA_INTERFACE_ERRORS
291: (interface_line_id,
292: message_text,
293: invalid_value,
294: org_id)

Line 319: INSERT INTO RA_INTERFACE_ERRORS

315: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
316:
317: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1814');
318:
319: INSERT INTO RA_INTERFACE_ERRORS
320: (interface_line_id,
321: message_text,
322: invalid_value,
323: org_id)

Line 360: INSERT INTO RA_INTERFACE_ERRORS

356: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
357:
358: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1813');
359:
360: INSERT INTO RA_INTERFACE_ERRORS
361: (interface_line_id,
362: message_text,
363: invalid_value,
364: org_id)

Line 541: INSERT INTO RA_INTERFACE_ERRORS

537: arp_standard.debug('arp_group_inv.validate_group()+');
538:
539: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1819');
540:
541: INSERT INTO RA_INTERFACE_ERRORS
542: (interface_line_id,
543: message_text,
544: invalid_value,
545: org_id)

Line 557: ( SELECT /*+ leading(L2) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 'x'

553: AND nvl(l.interface_status,'~') <> 'P'
554: AND l.link_to_line_id is null
555: AND l.customer_trx_id is not null
556: AND EXISTS
557: ( SELECT /*+ leading(L2) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 'x'
558: FROM ra_interface_errors e, ra_interface_lines_gt l2
559: WHERE e.INTERFACE_LINE_ID = l2.INTERFACE_LINE_ID
560: AND l2.cons_billing_number = l.cons_billing_number
561: AND l2.request_id = l.request_id );

Line 558: FROM ra_interface_errors e, ra_interface_lines_gt l2

554: AND l.link_to_line_id is null
555: AND l.customer_trx_id is not null
556: AND EXISTS
557: ( SELECT /*+ leading(L2) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 'x'
558: FROM ra_interface_errors e, ra_interface_lines_gt l2
559: WHERE e.INTERFACE_LINE_ID = l2.INTERFACE_LINE_ID
560: AND l2.cons_billing_number = l.cons_billing_number
561: AND l2.request_id = l.request_id );
562: