eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAP_CMERGE dependencies on ARP_MESSAGE

Line 223: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()+' );

219: -- to indicate what package name is being executed.
220: --
221: -- update log file to indicate the module being executed.
222: --
223: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()+' );
224: --
225: --Get the profile option for audit of customer merge
226: g_audit_profile :=NVL(FND_PROFILE.value('HZ_AUDIT_ACCT_MERGE'),'N');
227:

Line 232: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

228: -- Lock the rows for the current set_no to avoid indefinate wait
229: --
230: IF process_mode = 'LOCK' THEN
231: --
232: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
233: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS', FALSE );
234: --
235: open cursor_lock_1;
236: close cursor_lock_1;

Line 233: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS', FALSE );

229: --
230: IF process_mode = 'LOCK' THEN
231: --
232: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
233: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS', FALSE );
234: --
235: open cursor_lock_1;
236: close cursor_lock_1;
237: --

Line 238: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

234: --
235: open cursor_lock_1;
236: close cursor_lock_1;
237: --
238: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
239: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );
240: --
241: open cursor_lock_2;
242: close cursor_lock_2;

Line 239: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );

235: open cursor_lock_1;
236: close cursor_lock_1;
237: --
238: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
239: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );
240: --
241: open cursor_lock_2;
242: close cursor_lock_2;
243: --

Line 244: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

240: --
241: open cursor_lock_2;
242: close cursor_lock_2;
243: --
244: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
245: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );
246: --
247: open cursor_lock_3;
248: close cursor_lock_3;

Line 245: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );

241: open cursor_lock_2;
242: close cursor_lock_2;
243: --
244: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
245: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );
246: --
247: open cursor_lock_3;
248: close cursor_lock_3;
249: --

Line 250: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

246: --
247: open cursor_lock_3;
248: close cursor_lock_3;
249: --
250: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
251: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );
252: --
253: open cursor_lock_4;
254: close cursor_lock_4;

Line 251: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );

247: open cursor_lock_3;
248: close cursor_lock_3;
249: --
250: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
251: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );
252: --
253: open cursor_lock_4;
254: close cursor_lock_4;
255: --

Line 256: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

252: --
253: open cursor_lock_4;
254: close cursor_lock_4;
255: --
256: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
257: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );
258: --
259: open cursor_lock_5;
260: close cursor_lock_5;

Line 257: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );

253: open cursor_lock_4;
254: close cursor_lock_4;
255: --
256: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
257: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );
258: --
259: open cursor_lock_5;
260: close cursor_lock_5;
261: --

Line 262: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

258: --
259: open cursor_lock_5;
260: close cursor_lock_5;
261: --
262: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
263: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );
264: --bug3891382
265: --
266: open cursor_lock_6;

Line 263: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );

259: open cursor_lock_5;
260: close cursor_lock_5;
261: --
262: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
263: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );
264: --bug3891382
265: --
266: open cursor_lock_6;
267: close cursor_lock_6;

Line 269: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

265: --
266: open cursor_lock_6;
267: close cursor_lock_6;
268: --
269: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
270: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );
271: --
272: open cursor_lock_7;
273: close cursor_lock_7;

Line 270: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );

266: open cursor_lock_6;
267: close cursor_lock_6;
268: --
269: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
270: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );
271: --
272: open cursor_lock_7;
273: close cursor_lock_7;
274: --

Line 275: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

271: --
272: open cursor_lock_7;
273: close cursor_lock_7;
274: --
275: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
276: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );
277: --
278: open cursor_lock_8;
279: close cursor_lock_8;

Line 276: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );

272: open cursor_lock_7;
273: close cursor_lock_7;
274: --
275: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
276: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );
277: --
278: open cursor_lock_8;
279: close cursor_lock_8;
280: --

Line 281: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );

277: --
278: open cursor_lock_8;
279: close cursor_lock_8;
280: --
281: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
282: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );
283: --
284: open cursor_lock_9;
285: close cursor_lock_9;

Line 282: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );

278: open cursor_lock_8;
279: close cursor_lock_8;
280: --
281: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
282: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );
283: --
284: open cursor_lock_9;
285: close cursor_lock_9;
286: --

Line 291: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

287: GOTO done_locking;
288: --
289: END IF;
290: --
291: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
292: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS' );
293: --
294: /* Added for Bug 3891382. The logic prevents deletion of the customer being
295: merged, if the customer is having sites in single org unit and is being

Line 292: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS' );

288: --
289: END IF;
290: --
291: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
292: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CUSTOMERS' );
293: --
294: /* Added for Bug 3891382. The logic prevents deletion of the customer being
295: merged, if the customer is having sites in single org unit and is being
296: referenced in other org units. */

Line 892: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

888: CLOSE cursor_1;
889: --
890: -- update log file to indicate the total records deleted.
891: --
892: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
893: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
894: total_record_upd_count := 0;
895: --
896: -- update log file to indicate the total records updated.

Line 893: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

889: --
890: -- update log file to indicate the total records deleted.
891: --
892: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
893: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
894: total_record_upd_count := 0;
895: --
896: -- update log file to indicate the total records updated.
897: --

Line 898: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );

894: total_record_upd_count := 0;
895: --
896: -- update log file to indicate the total records updated.
897: --
898: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );
899: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));
900: total_record_del_count := 0;
901: --
902: -- update log file to indicate the table being updated.

Line 899: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));

895: --
896: -- update log file to indicate the total records updated.
897: --
898: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );
899: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));
900: total_record_del_count := 0;
901: --
902: -- update log file to indicate the table being updated.
903: --

Line 1213: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1209: WHERE RACM.PROCESS_FLAG = 'N'
1210: AND RACM.SET_NUMBER = set_no
1211: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1212:
1213: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1215: --
1216: -- update pa_draft_invoice_items for ship_to_address_id only.
1217: --

Line 1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );

1210: AND RACM.SET_NUMBER = set_no
1211: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1212:
1213: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1215: --
1216: -- update pa_draft_invoice_items for ship_to_address_id only.
1217: --
1218: IF g_audit_profile='Y' THEN

Line 1280: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1276: --
1277: -- update log file to indicate the total records being updated.
1278: --
1279: total_record_upd_count := SQL%ROWCOUNT;
1280: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1281: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1282: total_record_upd_count := 0;
1283: --
1284: -- update log file to indicate the table being updated.

Line 1281: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1277: -- update log file to indicate the total records being updated.
1278: --
1279: total_record_upd_count := SQL%ROWCOUNT;
1280: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1281: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1282: total_record_upd_count := 0;
1283: --
1284: -- update log file to indicate the table being updated.
1285: --

Line 1286: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1282: total_record_upd_count := 0;
1283: --
1284: -- update log file to indicate the table being updated.
1285: --
1286: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1287: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1288: --
1289: -- update pa_tasks for address_id ( ship address id ).
1290: --

Line 1287: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );

1283: --
1284: -- update log file to indicate the table being updated.
1285: --
1286: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1287: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1288: --
1289: -- update pa_tasks for address_id ( ship address id ).
1290: --
1291: IF g_audit_profile='Y' THEN

Line 1351: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1347: --
1348: -- update log file to indicate the total records being updated.
1349: --
1350: total_record_upd_count := SQL%ROWCOUNT;
1351: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1352: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1353: total_record_upd_count := 0;
1354: --
1355: -- update log file to indicate the table being updated. For bug# 1676538

Line 1352: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1348: -- update log file to indicate the total records being updated.
1349: --
1350: total_record_upd_count := SQL%ROWCOUNT;
1351: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1352: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1353: total_record_upd_count := 0;
1354: --
1355: -- update log file to indicate the table being updated. For bug# 1676538
1356: --

Line 1357: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1353: total_record_upd_count := 0;
1354: --
1355: -- update log file to indicate the table being updated. For bug# 1676538
1356: --
1357: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1359: --
1360: -- update pa_implementations for customer_id (duplicate_id ).
1361: --

Line 1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );

1354: --
1355: -- update log file to indicate the table being updated. For bug# 1676538
1356: --
1357: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1359: --
1360: -- update pa_implementations for customer_id (duplicate_id ).
1361: --
1362: IF g_audit_profile='Y' THEN

Line 1420: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1416: --
1417: -- update log file to indicate the total records being updated.
1418: --
1419: total_record_upd_count := SQL%ROWCOUNT;
1420: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1421: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1422: total_record_upd_count := 0;
1423:
1424: /* Added by sbsivara for retention related tables */

Line 1421: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1417: -- update log file to indicate the total records being updated.
1418: --
1419: total_record_upd_count := SQL%ROWCOUNT;
1420: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1421: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1422: total_record_upd_count := 0;
1423:
1424: /* Added by sbsivara for retention related tables */
1425: --

Line 1428: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1424: /* Added by sbsivara for retention related tables */
1425: --
1426: -- update log file to indicate the table being updated. For bug# 1676538
1427: --
1428: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1429: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1430: --
1431: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1432:

Line 1429: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );

1425: --
1426: -- update log file to indicate the table being updated. For bug# 1676538
1427: --
1428: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1429: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1430: --
1431: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1432:
1433: IF g_audit_profile='Y' THEN

Line 1499: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1495: --
1496: -- update log file to indicate the total records being updated.
1497: --
1498: total_record_upd_count := SQL%ROWCOUNT;
1499: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1500: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1501: total_record_upd_count := 0;
1502:
1503: --

Line 1500: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1496: -- update log file to indicate the total records being updated.
1497: --
1498: total_record_upd_count := SQL%ROWCOUNT;
1499: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1500: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1501: total_record_upd_count := 0;
1502:
1503: --
1504: -- update log file to indicate the table being updated. For bug# 1676538

Line 1506: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1502:
1503: --
1504: -- update log file to indicate the table being updated. For bug# 1676538
1505: --
1506: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1508: --
1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1510: --

Line 1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );

1503: --
1504: -- update log file to indicate the table being updated. For bug# 1676538
1505: --
1506: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1508: --
1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1510: --
1511: IF g_audit_profile='Y' THEN

Line 1577: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1573: --
1574: -- update log file to indicate the total records being updated.
1575: --
1576: total_record_upd_count := SQL%ROWCOUNT;
1577: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1578: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1579: total_record_upd_count := 0;
1580:
1581: --

Line 1578: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1574: -- update log file to indicate the total records being updated.
1575: --
1576: total_record_upd_count := SQL%ROWCOUNT;
1577: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1578: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1579: total_record_upd_count := 0;
1580:
1581: --
1582: -- update log file to indicate the table being updated. For bug# 1676538

Line 1584: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

1580:
1581: --
1582: -- update log file to indicate the table being updated. For bug# 1676538
1583: --
1584: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1585: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1586: --
1587: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1588: --

Line 1585: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );

1581: --
1582: -- update log file to indicate the table being updated. For bug# 1676538
1583: --
1584: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1585: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1586: --
1587: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1588: --
1589: IF g_audit_profile='Y' THEN

Line 1658: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

1654: --
1655: -- update log file to indicate the total records being updated.
1656: --
1657: total_record_upd_count := SQL%ROWCOUNT;
1658: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1659: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1660: total_record_upd_count := 0;
1661:
1662: /* END Added by sbsivara for retention related tables */

Line 1659: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

1655: -- update log file to indicate the total records being updated.
1656: --
1657: total_record_upd_count := SQL%ROWCOUNT;
1658: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
1659: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
1660: total_record_upd_count := 0;
1661:
1662: /* END Added by sbsivara for retention related tables */
1663: --

Line 1677: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()-' );

1673: <>
1674: --
1675: -- update log file to indicate the successful exit of this module.
1676: --
1677: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()-' );
1678: --
1679: --
1680: EXCEPTION
1681:

Line 1683: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE.MERGE' );

1679: --
1680: EXCEPTION
1681:
1682: WHEN OTHERS THEN
1683: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE.MERGE' );
1684: RAISE;
1685:
1686: END MERGE;
1687: --