APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_INTERFACE_ERRORS

Line 185: FROM ra_interface_errors ie

181: AND ct.term_id = tl.term_id
182: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
183: AND NOT EXISTS
184: (SELECT 'errors'
185: FROM ra_interface_errors ie
186: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
187: AND NOT EXISTS
188: (SELECT 'prevent duplicate contingency'
189: FROM ar_line_conts alc

Line 401: FROM ra_interface_errors ie

397: AND ar_revenue_management_pvt.creditworthy
398: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
399: AND NOT EXISTS
400: (SELECT 'errors'
401: FROM ra_interface_errors ie
402: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
403: AND NOT EXISTS
404: (SELECT 'prevent duplicate contingency'
405: FROM ar_line_conts alc

Line 1298: FROM ra_interface_errors ie

1294: DELETE
1295: FROM ar_line_conts
1296: WHERE customer_trx_line_id IN
1297: (SELECT ie.interface_line_id
1298: FROM ra_interface_errors ie
1299: WHERE request_id = p_request_id);
1300:
1301: END IF;
1302:

Line 1982: FROM ra_interface_errors ie

1978: AND ctl.customer_trx_line_id = ic.interface_line_id
1979: AND ic.contingency_id = dr.contingency_id
1980: AND NOT EXISTS
1981: (SELECT 'errors'
1982: FROM ra_interface_errors ie
1983: WHERE ie.interface_line_id = ctl.customer_trx_line_id);
1984:
1985: debug('itf contingencies inserted: ' || SQL%ROWCOUNT);
1986: debug('insert_contingencies_from_itf()-');

Line 2503: INSERT INTO ra_interface_errors

2499:
2500: -- we will not validate against start and end date until we expose
2501: -- the table.
2502:
2503: INSERT INTO ra_interface_errors
2504: (
2505: interface_line_id,
2506: interface_contingency_id,
2507: message_text,

Line 2543: INSERT INTO ra_interface_errors

2539: contingencies. Complete ones should bypass this as
2540: we use the expiration_date to populate the
2541: event removal date */
2542:
2543: INSERT INTO ra_interface_errors
2544: (
2545: interface_line_id,
2546: interface_contingency_id,
2547: message_text,

Line 4766: FROM ra_interface_errors ie,

4762: FROM ar_deferred_lines
4763: WHERE customer_trx_id IN
4764: (
4765: SELECT DISTINCT il.customer_trx_id
4766: FROM ra_interface_errors ie,
4767: ra_interface_lines il
4768: WHERE ie.interface_line_id = il.interface_line_id
4769: AND il.request_id = p_request_id
4770: )

Line 4782: FROM ra_interface_errors ie,

4778: FROM ar_deferred_lines
4779: WHERE customer_trx_id IN
4780: (
4781: SELECT DISTINCT il.customer_trx_id
4782: FROM ra_interface_errors ie,
4783: ra_interface_lines il
4784: WHERE ie.interface_line_id = il.interface_line_id
4785: AND il.request_id = p_request_id
4786: );