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

Line 84: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()+');

80: )
81: FOR UPDATE NOWAIT;
82:
83: BEGIN
84: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()+');
85:
86: -- billing profiles
87: arp_message.set_name('AR','AR_LOCKING_TABLE');
88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

Line 87: arp_message.set_name('AR','AR_LOCKING_TABLE');

83: BEGIN
84: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()+');
85:
86: -- billing profiles
87: arp_message.set_name('AR','AR_LOCKING_TABLE');
88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
89: open c_lock_bpe;
90: close c_lock_bpe;
91:

Line 88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

84: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()+');
85:
86: -- billing profiles
87: arp_message.set_name('AR','AR_LOCKING_TABLE');
88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
89: open c_lock_bpe;
90: close c_lock_bpe;
91:
92: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()-');

Line 92: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()-');

88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
89: open c_lock_bpe;
90: close c_lock_bpe;
91:
92: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()-');
93:
94: END; -- lock_tables
95:
96: --

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

143: --
144:
145: BEGIN
146: --CK new code with logging
147: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
149: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
150: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
151:

Line 148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

144:
145: BEGIN
146: --CK new code with logging
147: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
149: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
150: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
151:
152: open merged_records;

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

216: EXIT;
217: END IF;
218: END LOOP;
219:
220: arp_message.set_name('AR','AR_ROWS_UPDATED');
221: arp_message.set_token('NUM_ROWS',to_char(l_count));
222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');

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

217: END IF;
218: END LOOP;
219:
220: arp_message.set_name('AR','AR_ROWS_UPDATED');
221: arp_message.set_token('NUM_ROWS',to_char(l_count));
222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');
225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

Line 224: arp_message.set_name('AR','AR_UPDATING_TABLE');

220: arp_message.set_name('AR','AR_ROWS_UPDATED');
221: arp_message.set_token('NUM_ROWS',to_char(l_count));
222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');
225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
227: MERGE_LOG_ID,
228: MERGE_HEADER_ID,

Line 225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

221: arp_message.set_token('NUM_ROWS',to_char(l_count));
222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');
225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
227: MERGE_LOG_ID,
228: MERGE_HEADER_ID,
229: TABLE_NAME,

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

271: AND l1.REQUEST_ID = req_id
272: AND h.set_number = set_number);
273: l_count := SQL%ROWCOUNT;
274:
275: arp_message.set_name('AR','AR_ROWS_UPDATED');
276: arp_message.set_token('NUM_ROWS',to_char(l_count));
277: arp_message.set_line('OKS_HZ_MERGE_PUB.ACCOUNT_MERGE()-');CK old code*/
278: END; -- account_merge
279:

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

272: AND h.set_number = set_number);
273: l_count := SQL%ROWCOUNT;
274:
275: arp_message.set_name('AR','AR_ROWS_UPDATED');
276: arp_message.set_token('NUM_ROWS',to_char(l_count));
277: arp_message.set_line('OKS_HZ_MERGE_PUB.ACCOUNT_MERGE()-');CK old code*/
278: END; -- account_merge
279:
280: --

Line 277: arp_message.set_line('OKS_HZ_MERGE_PUB.ACCOUNT_MERGE()-');CK old code*/

273: l_count := SQL%ROWCOUNT;
274:
275: arp_message.set_name('AR','AR_ROWS_UPDATED');
276: arp_message.set_token('NUM_ROWS',to_char(l_count));
277: arp_message.set_line('OKS_HZ_MERGE_PUB.ACCOUNT_MERGE()-');CK old code*/
278: END; -- account_merge
279:
280: --
281: -- sub routine to merge account sites and site uses

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

353: --CK
354:
355: BEGIN
356: --ck new code with logging
357: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
359: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
360: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
361: open merged_records;

Line 358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

354:
355: BEGIN
356: --ck new code with logging
357: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
359: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
360: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
361: open merged_records;
362: LOOP

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

427: IF l_last_fetch THEN
428: EXIT;
429: END IF;
430: END LOOP;
431: arp_message.set_name('AR','AR_ROWS_UPDATED');
432: arp_message.set_token('NUM_ROWS',to_char(l_count));
433:
434: --03/15/2004 added code to update quote_to_site_id
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

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

428: EXIT;
429: END IF;
430: END LOOP;
431: arp_message.set_name('AR','AR_ROWS_UPDATED');
432: arp_message.set_token('NUM_ROWS',to_char(l_count));
433:
434: --03/15/2004 added code to update quote_to_site_id
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);

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

431: arp_message.set_name('AR','AR_ROWS_UPDATED');
432: arp_message.set_token('NUM_ROWS',to_char(l_count));
433:
434: --03/15/2004 added code to update quote_to_site_id
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);
437: open merged_records_quote;
438: LOOP
439: FETCH merged_records_quote BULK COLLECT INTO

Line 436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);

432: arp_message.set_token('NUM_ROWS',to_char(l_count));
433:
434: --03/15/2004 added code to update quote_to_site_id
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);
437: open merged_records_quote;
438: LOOP
439: FETCH merged_records_quote BULK COLLECT INTO
440: MERGE_HEADER_ID_LIST_QUOTE

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

499: , last_update_login=arp_standard.profile.last_update_login
500: WHERE ID=PRIMARY_KEY_ID1_LIST_QUOTE(I);
501:
502: l_count := SQL%ROWCOUNT;
503: arp_message.set_name('AR','AR_ROWS_UPDATED');
504: arp_message.set_token('NUM_ROWS',to_char(l_count));
505:
506: IF l_last_fetch THEN
507: EXIT;

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

500: WHERE ID=PRIMARY_KEY_ID1_LIST_QUOTE(I);
501:
502: l_count := SQL%ROWCOUNT;
503: arp_message.set_name('AR','AR_ROWS_UPDATED');
504: arp_message.set_token('NUM_ROWS',to_char(l_count));
505:
506: IF l_last_fetch THEN
507: EXIT;
508: END IF;

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

508: END IF;
509: END LOOP;
510:
511: --Added for updating OKS_QUALIFIERS table during account merge
512: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
513: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_QUALIFIERS',FALSE);
514:
515: OKS_QP_INT_PVT.QUALIFIER_ACCOUNT_MERGE
516: (req_id =>req_id,

Line 513: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_QUALIFIERS',FALSE);

509: END LOOP;
510:
511: --Added for updating OKS_QUALIFIERS table during account merge
512: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
513: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_QUALIFIERS',FALSE);
514:
515: OKS_QP_INT_PVT.QUALIFIER_ACCOUNT_MERGE
516: (req_id =>req_id,
517: set_num =>set_number);

Line 587: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()+');

583: l_no_data_found_excp EXCEPTION;
584: l_lock_excp EXCEPTION;
585:
586: BEGIN
587: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()+');
588:
589: --
590: -- check process mode. If LOCK, then just lock the tables
591: --

Line 658: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

654: account_site_merge(req_id => req_id
655: ,set_number => set_number);
656: END IF; -- if customer ids the same
657:
658: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
659:
660: EXCEPTION
661: WHEN l_merge_disallowed_excp THEN
662: -- arp_message.set_line('Billing Profile exists for duplicate party, merge cannot proceed');

Line 662: -- arp_message.set_line('Billing Profile exists for duplicate party, merge cannot proceed');

658: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
659:
660: EXCEPTION
661: WHEN l_merge_disallowed_excp THEN
662: -- arp_message.set_line('Billing Profile exists for duplicate party, merge cannot proceed');
663: arp_message.set_line('Cannot Merge Customer Accounts owned by different parties. Please run Party Merge first and then run Customer Merge');
664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
665: RAISE;
666: WHEN l_no_data_found_excp THEN

Line 663: arp_message.set_line('Cannot Merge Customer Accounts owned by different parties. Please run Party Merge first and then run Customer Merge');

659:
660: EXCEPTION
661: WHEN l_merge_disallowed_excp THEN
662: -- arp_message.set_line('Billing Profile exists for duplicate party, merge cannot proceed');
663: arp_message.set_line('Cannot Merge Customer Accounts owned by different parties. Please run Party Merge first and then run Customer Merge');
664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
665: RAISE;
666: WHEN l_no_data_found_excp THEN
667: arp_message.set_line('No data found for merge information');

Line 664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');

660: EXCEPTION
661: WHEN l_merge_disallowed_excp THEN
662: -- arp_message.set_line('Billing Profile exists for duplicate party, merge cannot proceed');
663: arp_message.set_line('Cannot Merge Customer Accounts owned by different parties. Please run Party Merge first and then run Customer Merge');
664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
665: RAISE;
666: WHEN l_no_data_found_excp THEN
667: arp_message.set_line('No data found for merge information');
668: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');

Line 667: arp_message.set_line('No data found for merge information');

663: arp_message.set_line('Cannot Merge Customer Accounts owned by different parties. Please run Party Merge first and then run Customer Merge');
664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
665: RAISE;
666: WHEN l_no_data_found_excp THEN
667: arp_message.set_line('No data found for merge information');
668: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
669: RAISE;
670: WHEN l_lock_excp THEN -- normal exit after locking
671: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

Line 668: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');

664: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
665: RAISE;
666: WHEN l_no_data_found_excp THEN
667: arp_message.set_line('No data found for merge information');
668: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
669: RAISE;
670: WHEN l_lock_excp THEN -- normal exit after locking
671: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
672: WHEN others THEN

Line 671: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

667: arp_message.set_line('No data found for merge information');
668: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT');
669: RAISE;
670: WHEN l_lock_excp THEN -- normal exit after locking
671: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
672: WHEN others THEN
673: l_error_msg := substr(SQLERRM,1,70);
674: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);
675: RAISE;

Line 674: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);

670: WHEN l_lock_excp THEN -- normal exit after locking
671: arp_message.set_line('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
672: WHEN others THEN
673: l_error_msg := substr(SQLERRM,1,70);
674: arp_message.set_error('OKS_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);
675: RAISE;
676: END; -- merge_account
677:
678: END; -- Package Body OKS_HZ_MERGE_PUB