APPS.ARP_DET_DIST_PKG dependencies on RA_INTERFACE_ERRORS

Line 8444: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;

8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8441: l_customer_trx ra_customer_trx%ROWTYPE;
8442: l_last_fetch BOOLEAN := FALSE;
8443:
8444: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
8445: l_return_status VARCHAR2(100);
8446: l_msg_count NUMBER:=0;
8447: l_msg_data VARCHAR2(20000):= NULL;
8448:

Line 8508: INSERT INTO ra_interface_errors

8504:
8505: l_msg := 'Error while stamping the balance amt'||l_ctl_hd_tab(i);
8506:
8507:
8508: INSERT INTO ra_interface_errors
8509: (
8510: --org_id,
8511: interface_line_id,
8512: message_text

Line 8541: FROM ra_customer_trx_lines l, ra_interface_errors e

8537: WHERE ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8538: AND ctt.TYPE in ('INV','DM'))
8539: AND NOT EXISTS (
8540: SELECT 1
8541: FROM ra_customer_trx_lines l, ra_interface_errors e
8542: WHERE l.customer_trx_id = inv.customer_trx_id
8543: AND l.customer_trx_line_id = e.interface_line_id);
8544:
8545: -- Setting the Original and Remaining amounts R12

Line 8585: INSERT INTO ra_interface_errors

8581:
8582: l_msg := 'Error while stamping the balance amt'||l_ctl_app_tab(i);
8583:
8584:
8585: INSERT INTO ra_interface_errors
8586: (
8587: --org_id,
8588: interface_line_id,
8589: message_text