APPS.ARP_DET_DIST_PKG dependencies on RA_INTERFACE_ERRORS

Line 9861: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;

9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9858: l_customer_trx ra_customer_trx%ROWTYPE;
9859: l_last_fetch BOOLEAN := FALSE;
9860:
9861: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
9862: l_return_status VARCHAR2(100);
9863: l_msg_count NUMBER:=0;
9864: l_msg_data VARCHAR2(20000):= NULL;
9865:

Line 9925: INSERT INTO ra_interface_errors

9921:
9922: l_msg := 'Error while stamping the balance amt'||l_ctl_hd_tab(i);
9923:
9924:
9925: INSERT INTO ra_interface_errors
9926: (
9927: --org_id,
9928: interface_line_id,
9929: message_text

Line 9958: FROM ra_customer_trx_lines l, ra_interface_errors e

9954: WHERE ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9955: AND ctt.TYPE in ('INV','DM'))
9956: AND NOT EXISTS (
9957: SELECT 1
9958: FROM ra_customer_trx_lines l, ra_interface_errors e
9959: WHERE l.customer_trx_id = inv.customer_trx_id
9960: AND l.customer_trx_line_id = e.interface_line_id);
9961:
9962: -- Setting the Original and Remaining amounts R12

Line 10002: INSERT INTO ra_interface_errors

9998:
9999: l_msg := 'Error while stamping the balance amt'||l_ctl_app_tab(i);
10000:
10001:
10002: INSERT INTO ra_interface_errors
10003: (
10004: --org_id,
10005: interface_line_id,
10006: message_text