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.OZF_ACCOUNT_MERGE_PKG dependencies on ARP_MESSAGE

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

69: BEGIN
70: IF process_mode='LOCK' THEN
71: NULL;
72: ELSE
73: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);
75: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
76: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
77:

Line 74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);

70: IF process_mode='LOCK' THEN
71: NULL;
72: ELSE
73: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);
75: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
76: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
77:
78: open merged_records;

Line 154: arp_message.set_name('AR','AR_ROWS_UPDATED');

150: EXIT;
151: END IF;
152: END LOOP;
153:
154: arp_message.set_name('AR','AR_ROWS_UPDATED');
155: arp_message.set_token('NUM_ROWS',to_char(l_count));
156: END IF;
157: EXCEPTION
158: WHEN OTHERS THEN

Line 155: arp_message.set_token('NUM_ROWS',to_char(l_count));

151: END IF;
152: END LOOP;
153:
154: arp_message.set_name('AR','AR_ROWS_UPDATED');
155: arp_message.set_token('NUM_ROWS',to_char(l_count));
156: END IF;
157: EXCEPTION
158: WHEN OTHERS THEN
159: arp_message.set_line( 'merge_acct_alloc');

Line 159: arp_message.set_line( 'merge_acct_alloc');

155: arp_message.set_token('NUM_ROWS',to_char(l_count));
156: END IF;
157: EXCEPTION
158: WHEN OTHERS THEN
159: arp_message.set_line( 'merge_acct_alloc');
160: RAISE;
161: END merge_acct_alloc;
162:
163: /*-------------------------------------------------------------

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

216: BEGIN
217: IF process_mode='LOCK' THEN
218: NULL;
219: ELSE
220: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
221: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines',FALSE);
222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
224:

Line 221: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines',FALSE);

217: IF process_mode='LOCK' THEN
218: NULL;
219: ELSE
220: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
221: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines',FALSE);
222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
224:
225: open merged_records;

Line 297: arp_message.set_name('AR','AR_ROWS_UPDATED');

293: EXIT;
294: END IF;
295: END LOOP;
296:
297: arp_message.set_name('AR','AR_ROWS_UPDATED');
298: arp_message.set_token('NUM_ROWS',to_char(l_count));
299: END IF;
300: EXCEPTION
301: WHEN OTHERS THEN

Line 298: arp_message.set_token('NUM_ROWS',to_char(l_count));

294: END IF;
295: END LOOP;
296:
297: arp_message.set_name('AR','AR_ROWS_UPDATED');
298: arp_message.set_token('NUM_ROWS',to_char(l_count));
299: END IF;
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_message.set_line( 'merge_claim_lines');

Line 302: arp_message.set_line( 'merge_claim_lines');

298: arp_message.set_token('NUM_ROWS',to_char(l_count));
299: END IF;
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_message.set_line( 'merge_claim_lines');
303: RAISE;
304: END merge_claim_lines;
305:
306:

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

360: BEGIN
361: IF process_mode='LOCK' THEN
362: NULL;
363: ELSE
364: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
365: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines_hist',FALSE);
366: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
367: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
368:

Line 365: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines_hist',FALSE);

361: IF process_mode='LOCK' THEN
362: NULL;
363: ELSE
364: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
365: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines_hist',FALSE);
366: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
367: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
368:
369: open merged_records;

Line 441: arp_message.set_name('AR','AR_ROWS_UPDATED');

437: EXIT;
438: END IF;
439: END LOOP;
440:
441: arp_message.set_name('AR','AR_ROWS_UPDATED');
442: arp_message.set_token('NUM_ROWS',to_char(l_count));
443: END IF;
444: EXCEPTION
445: WHEN OTHERS THEN

Line 442: arp_message.set_token('NUM_ROWS',to_char(l_count));

438: END IF;
439: END LOOP;
440:
441: arp_message.set_name('AR','AR_ROWS_UPDATED');
442: arp_message.set_token('NUM_ROWS',to_char(l_count));
443: END IF;
444: EXCEPTION
445: WHEN OTHERS THEN
446: arp_message.set_line( 'merge_claim_lines_hist');

Line 446: arp_message.set_line( 'merge_claim_lines_hist');

442: arp_message.set_token('NUM_ROWS',to_char(l_count));
443: END IF;
444: EXCEPTION
445: WHEN OTHERS THEN
446: arp_message.set_line( 'merge_claim_lines_hist');
447: RAISE;
448: END merge_claim_lines_hist;
449:
450:

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

536: BEGIN
537: IF process_mode='LOCK' THEN
538: NULL;
539: ELSE
540: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);
542: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
543: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
544:

Line 541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);

537: IF process_mode='LOCK' THEN
538: NULL;
539: ELSE
540: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);
542: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
543: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
544:
545: open merged_records;

Line 645: arp_message.set_name('AR','AR_ROWS_UPDATED');

641: EXIT;
642: END IF;
643: END LOOP;
644:
645: arp_message.set_name('AR','AR_ROWS_UPDATED');
646: arp_message.set_token('NUM_ROWS',to_char(l_count));
647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN

Line 646: arp_message.set_token('NUM_ROWS',to_char(l_count));

642: END IF;
643: END LOOP;
644:
645: arp_message.set_name('AR','AR_ROWS_UPDATED');
646: arp_message.set_token('NUM_ROWS',to_char(l_count));
647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: arp_message.set_line( 'merge_claims');

Line 650: arp_message.set_line( 'merge_claims');

646: arp_message.set_token('NUM_ROWS',to_char(l_count));
647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: arp_message.set_line( 'merge_claims');
651: RAISE;
652: END merge_claims;
653:
654:

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

740: BEGIN
741: IF process_mode='LOCK' THEN
742: NULL;
743: ELSE
744: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);
746: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
747: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
748:

Line 745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);

741: IF process_mode='LOCK' THEN
742: NULL;
743: ELSE
744: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);
746: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
747: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
748:
749: open merged_records;

Line 849: arp_message.set_name('AR','AR_ROWS_UPDATED');

845: EXIT;
846: END IF;
847: END LOOP;
848:
849: arp_message.set_name('AR','AR_ROWS_UPDATED');
850: arp_message.set_token('NUM_ROWS',to_char(l_count));
851: END IF;
852: EXCEPTION
853: WHEN OTHERS THEN

Line 850: arp_message.set_token('NUM_ROWS',to_char(l_count));

846: END IF;
847: END LOOP;
848:
849: arp_message.set_name('AR','AR_ROWS_UPDATED');
850: arp_message.set_token('NUM_ROWS',to_char(l_count));
851: END IF;
852: EXCEPTION
853: WHEN OTHERS THEN
854: arp_message.set_line( 'merge_claims_history');

Line 854: arp_message.set_line( 'merge_claims_history');

850: arp_message.set_token('NUM_ROWS',to_char(l_count));
851: END IF;
852: EXCEPTION
853: WHEN OTHERS THEN
854: arp_message.set_line( 'merge_claims_history');
855: RAISE;
856: END merge_claims_history;
857:
858:

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

904: BEGIN
905: IF process_mode='LOCK' THEN
906: NULL;
907: ELSE
908: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);
910: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
911: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
912:

Line 909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);

905: IF process_mode='LOCK' THEN
906: NULL;
907: ELSE
908: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);
910: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
911: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
912:
913: open merged_records;

Line 974: arp_message.set_name('AR','AR_ROWS_UPDATED');

970: EXIT;
971: END IF;
972: END LOOP;
973:
974: arp_message.set_name('AR','AR_ROWS_UPDATED');
975: arp_message.set_token('NUM_ROWS',to_char(l_count));
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN

Line 975: arp_message.set_token('NUM_ROWS',to_char(l_count));

971: END IF;
972: END LOOP;
973:
974: arp_message.set_name('AR','AR_ROWS_UPDATED');
975: arp_message.set_token('NUM_ROWS',to_char(l_count));
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN
979: arp_message.set_line( 'merge_code_conversions');

Line 979: arp_message.set_line( 'merge_code_conversions');

975: arp_message.set_token('NUM_ROWS',to_char(l_count));
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN
979: arp_message.set_line( 'merge_code_conversions');
980: RAISE;
981: END merge_code_conversions;
982:
983: /*-------------------------------------------------------------

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

1044: BEGIN
1045: IF process_mode='LOCK' THEN
1046: NULL;
1047: ELSE
1048: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);
1050: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1051: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1052:

Line 1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);

1045: IF process_mode='LOCK' THEN
1046: NULL;
1047: ELSE
1048: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);
1050: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1051: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1052:
1053: open merged_records;

Line 1129: arp_message.set_name('AR','AR_ROWS_UPDATED');

1125: EXIT;
1126: END IF;
1127: END LOOP;
1128:
1129: arp_message.set_name('AR','AR_ROWS_UPDATED');
1130: arp_message.set_token('NUM_ROWS',to_char(l_count));
1131: END IF;
1132: EXCEPTION
1133: WHEN OTHERS THEN

Line 1130: arp_message.set_token('NUM_ROWS',to_char(l_count));

1126: END IF;
1127: END LOOP;
1128:
1129: arp_message.set_name('AR','AR_ROWS_UPDATED');
1130: arp_message.set_token('NUM_ROWS',to_char(l_count));
1131: END IF;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: arp_message.set_line( 'merge_cust_daily_facts');

Line 1134: arp_message.set_line( 'merge_cust_daily_facts');

1130: arp_message.set_token('NUM_ROWS',to_char(l_count));
1131: END IF;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: arp_message.set_line( 'merge_cust_daily_facts');
1135: RAISE;
1136: END merge_cust_daily_facts;
1137:
1138: /*-------------------------------------------------------------

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

1191: BEGIN
1192: IF process_mode='LOCK' THEN
1193: NULL;
1194: ELSE
1195: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);
1197: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1198: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1199:

Line 1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);

1192: IF process_mode='LOCK' THEN
1193: NULL;
1194: ELSE
1195: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);
1197: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1198: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1199:
1200: open merged_records;

Line 1272: arp_message.set_name('AR','AR_ROWS_UPDATED');

1268: EXIT;
1269: END IF;
1270: END LOOP;
1271:
1272: arp_message.set_name('AR','AR_ROWS_UPDATED');
1273: arp_message.set_token('NUM_ROWS',to_char(l_count));
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN

Line 1273: arp_message.set_token('NUM_ROWS',to_char(l_count));

1269: END IF;
1270: END LOOP;
1271:
1272: arp_message.set_name('AR','AR_ROWS_UPDATED');
1273: arp_message.set_token('NUM_ROWS',to_char(l_count));
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: arp_message.set_line( 'merge_fund_utilization');

Line 1277: arp_message.set_line( 'merge_fund_utilization');

1273: arp_message.set_token('NUM_ROWS',to_char(l_count));
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: arp_message.set_line( 'merge_fund_utilization');
1278: RAISE;
1279: END merge_fund_utilization;
1280:
1281:

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

1341: BEGIN
1342: IF process_mode='LOCK' THEN
1343: NULL;
1344: ELSE
1345: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);
1347: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1348: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1349:

Line 1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);

1342: IF process_mode='LOCK' THEN
1343: NULL;
1344: ELSE
1345: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);
1347: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1348: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1349:
1350: open merged_records;

Line 1423: arp_message.set_name('AR','AR_ROWS_UPDATED');

1419: EXIT;
1420: END IF;
1421: END LOOP;
1422:
1423: arp_message.set_name('AR','AR_ROWS_UPDATED');
1424: arp_message.set_token('NUM_ROWS',to_char(l_count));
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN

Line 1424: arp_message.set_token('NUM_ROWS',to_char(l_count));

1420: END IF;
1421: END LOOP;
1422:
1423: arp_message.set_name('AR','AR_ROWS_UPDATED');
1424: arp_message.set_token('NUM_ROWS',to_char(l_count));
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: arp_message.set_line( 'merge_offer_denorm');

Line 1428: arp_message.set_line( 'merge_offer_denorm');

1424: arp_message.set_token('NUM_ROWS',to_char(l_count));
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: arp_message.set_line( 'merge_offer_denorm');
1429: RAISE;
1430: END merge_offer_denorm;
1431:
1432:

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

1478: BEGIN
1479: IF process_mode='LOCK' THEN
1480: NULL;
1481: ELSE
1482: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);
1484: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1485: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1486:

Line 1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);

1479: IF process_mode='LOCK' THEN
1480: NULL;
1481: ELSE
1482: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);
1484: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1485: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1486:
1487: open merged_records;

Line 1549: arp_message.set_name('AR','AR_ROWS_UPDATED');

1545: EXIT;
1546: END IF;
1547: END LOOP;
1548:
1549: arp_message.set_name('AR','AR_ROWS_UPDATED');
1550: arp_message.set_token('NUM_ROWS',to_char(l_count));
1551: END IF;
1552: EXCEPTION
1553: WHEN OTHERS THEN

Line 1550: arp_message.set_token('NUM_ROWS',to_char(l_count));

1546: END IF;
1547: END LOOP;
1548:
1549: arp_message.set_name('AR','AR_ROWS_UPDATED');
1550: arp_message.set_token('NUM_ROWS',to_char(l_count));
1551: END IF;
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: arp_message.set_line( 'merge_offer_header');

Line 1554: arp_message.set_line( 'merge_offer_header');

1550: arp_message.set_token('NUM_ROWS',to_char(l_count));
1551: END IF;
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: arp_message.set_line( 'merge_offer_header');
1555: RAISE;
1556: END merge_offer_header;
1557:
1558:

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

1620: BEGIN
1621: IF process_mode='LOCK' THEN
1622: NULL;
1623: ELSE
1624: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);
1626: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1627: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1628:

Line 1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);

1621: IF process_mode='LOCK' THEN
1622: NULL;
1623: ELSE
1624: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);
1626: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1627: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1628:
1629: open merged_records;

Line 1708: arp_message.set_name('AR','AR_ROWS_UPDATED');

1704: EXIT;
1705: END IF;
1706: END LOOP;
1707:
1708: arp_message.set_name('AR','AR_ROWS_UPDATED');
1709: arp_message.set_token('NUM_ROWS',to_char(l_count));
1710: END IF;
1711: EXCEPTION
1712: WHEN OTHERS THEN

Line 1709: arp_message.set_token('NUM_ROWS',to_char(l_count));

1705: END IF;
1706: END LOOP;
1707:
1708: arp_message.set_name('AR','AR_ROWS_UPDATED');
1709: arp_message.set_token('NUM_ROWS',to_char(l_count));
1710: END IF;
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: arp_message.set_line( 'merge_request_header');

Line 1713: arp_message.set_line( 'merge_request_header');

1709: arp_message.set_token('NUM_ROWS',to_char(l_count));
1710: END IF;
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: arp_message.set_line( 'merge_request_header');
1714: RAISE;
1715: END merge_request_header;
1716:
1717:

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

1771: BEGIN
1772: IF process_mode='LOCK' THEN
1773: NULL;
1774: ELSE
1775: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);
1777: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1778: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1779:

Line 1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);

1772: IF process_mode='LOCK' THEN
1773: NULL;
1774: ELSE
1775: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);
1777: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1778: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1779:
1780: open merged_records;

Line 1849: arp_message.set_name('AR','AR_ROWS_UPDATED');

1845: EXIT;
1846: END IF;
1847: END LOOP;
1848:
1849: arp_message.set_name('AR','AR_ROWS_UPDATED');
1850: arp_message.set_token('NUM_ROWS',to_char(l_count));
1851: END IF;
1852: EXCEPTION
1853: WHEN OTHERS THEN

Line 1850: arp_message.set_token('NUM_ROWS',to_char(l_count));

1846: END IF;
1847: END LOOP;
1848:
1849: arp_message.set_name('AR','AR_ROWS_UPDATED');
1850: arp_message.set_token('NUM_ROWS',to_char(l_count));
1851: END IF;
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: arp_message.set_line( 'merge_retail_price_points');

Line 1854: arp_message.set_line( 'merge_retail_price_points');

1850: arp_message.set_token('NUM_ROWS',to_char(l_count));
1851: END IF;
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: arp_message.set_line( 'merge_retail_price_points');
1855: RAISE;
1856: END merge_retail_price_points;
1857:
1858:

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

1912: BEGIN
1913: IF process_mode='LOCK' THEN
1914: NULL;
1915: ELSE
1916: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);
1918: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1919: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1920:

Line 1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);

1913: IF process_mode='LOCK' THEN
1914: NULL;
1915: ELSE
1916: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);
1918: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1919: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1920:
1921: open merged_records;

Line 1993: arp_message.set_name('AR','AR_ROWS_UPDATED');

1989: EXIT;
1990: END IF;
1991: END LOOP;
1992:
1993: arp_message.set_name('AR','AR_ROWS_UPDATED');
1994: arp_message.set_token('NUM_ROWS',to_char(l_count));
1995: END IF;
1996: EXCEPTION
1997: WHEN OTHERS THEN

Line 1994: arp_message.set_token('NUM_ROWS',to_char(l_count));

1990: END IF;
1991: END LOOP;
1992:
1993: arp_message.set_name('AR','AR_ROWS_UPDATED');
1994: arp_message.set_token('NUM_ROWS',to_char(l_count));
1995: END IF;
1996: EXCEPTION
1997: WHEN OTHERS THEN
1998: arp_message.set_line( 'merge_trade_profiles');

Line 1998: arp_message.set_line( 'merge_trade_profiles');

1994: arp_message.set_token('NUM_ROWS',to_char(l_count));
1995: END IF;
1996: EXCEPTION
1997: WHEN OTHERS THEN
1998: arp_message.set_line( 'merge_trade_profiles');
1999: RAISE;
2000: END merge_trade_profiles;
2001:
2002: END OZF_ACCOUNT_MERGE_PKG;