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

Line 192: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');

188: )
189: FOR UPDATE NOWAIT;
190:
191: BEGIN
192: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');
193:
194: -- party roles for accounts
195: arp_message.set_name('AR','AR_LOCKING_TABLE');
196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

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

191: BEGIN
192: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');
193:
194: -- party roles for accounts
195: arp_message.set_name('AR','AR_LOCKING_TABLE');
196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
197: arp_message.set_line('Locking for accounts');
198: open c_lock_kpr(c_account);
199: close c_lock_kpr;

Line 196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

192: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');
193:
194: -- party roles for accounts
195: arp_message.set_name('AR','AR_LOCKING_TABLE');
196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
197: arp_message.set_line('Locking for accounts');
198: open c_lock_kpr(c_account);
199: close c_lock_kpr;
200:

Line 197: arp_message.set_line('Locking for accounts');

193:
194: -- party roles for accounts
195: arp_message.set_name('AR','AR_LOCKING_TABLE');
196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
197: arp_message.set_line('Locking for accounts');
198: open c_lock_kpr(c_account);
199: close c_lock_kpr;
200:
201: arp_message.set_line('Locking for site uses');

Line 201: arp_message.set_line('Locking for site uses');

197: arp_message.set_line('Locking for accounts');
198: open c_lock_kpr(c_account);
199: close c_lock_kpr;
200:
201: arp_message.set_line('Locking for site uses');
202: open c_lock_kpr(c_c_site_use); -- added for bug 3950642
203: close c_lock_kpr;
204:
205: -- rules for accounts

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

202: open c_lock_kpr(c_c_site_use); -- added for bug 3950642
203: close c_lock_kpr;
204:
205: -- rules for accounts
206: arp_message.set_name('AR','AR_LOCKING_TABLE');
207: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
208: arp_message.set_line('Locking for accounts');
209: open c_lock_rle1(c_account);
210: close c_lock_rle1;

Line 207: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);

203: close c_lock_kpr;
204:
205: -- rules for accounts
206: arp_message.set_name('AR','AR_LOCKING_TABLE');
207: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
208: arp_message.set_line('Locking for accounts');
209: open c_lock_rle1(c_account);
210: close c_lock_rle1;
211: open c_lock_rle2(c_account);

Line 208: arp_message.set_line('Locking for accounts');

204:
205: -- rules for accounts
206: arp_message.set_name('AR','AR_LOCKING_TABLE');
207: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
208: arp_message.set_line('Locking for accounts');
209: open c_lock_rle1(c_account);
210: close c_lock_rle1;
211: open c_lock_rle2(c_account);
212: close c_lock_rle2;

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

213: open c_lock_rle3(c_account);
214: close c_lock_rle3;
215:
216: -- rules for sites
217: arp_message.set_name('AR','AR_LOCKING_TABLE');
218: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
219: arp_message.set_line('Locking for sites');
220: open c_lock_rle1(c_c_site);
221: close c_lock_rle1;

Line 218: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);

214: close c_lock_rle3;
215:
216: -- rules for sites
217: arp_message.set_name('AR','AR_LOCKING_TABLE');
218: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
219: arp_message.set_line('Locking for sites');
220: open c_lock_rle1(c_c_site);
221: close c_lock_rle1;
222: open c_lock_rle2(c_c_site);

Line 219: arp_message.set_line('Locking for sites');

215:
216: -- rules for sites
217: arp_message.set_name('AR','AR_LOCKING_TABLE');
218: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
219: arp_message.set_line('Locking for sites');
220: open c_lock_rle1(c_c_site);
221: close c_lock_rle1;
222: open c_lock_rle2(c_c_site);
223: close c_lock_rle2;

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

224: open c_lock_rle3(c_c_site);
225: close c_lock_rle3;
226:
227: -- rules for site uses
228: arp_message.set_name('AR','AR_LOCKING_TABLE');
229: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
230: arp_message.set_line('Locking for site uses');
231: open c_lock_rle1(c_c_site_use);
232: close c_lock_rle1;

Line 229: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

225: close c_lock_rle3;
226:
227: -- rules for site uses
228: arp_message.set_name('AR','AR_LOCKING_TABLE');
229: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
230: arp_message.set_line('Locking for site uses');
231: open c_lock_rle1(c_c_site_use);
232: close c_lock_rle1;
233: open c_lock_rle2(c_c_site_use);

Line 230: arp_message.set_line('Locking for site uses');

226:
227: -- rules for site uses
228: arp_message.set_name('AR','AR_LOCKING_TABLE');
229: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
230: arp_message.set_line('Locking for site uses');
231: open c_lock_rle1(c_c_site_use);
232: close c_lock_rle1;
233: open c_lock_rle2(c_c_site_use);
234: close c_lock_rle2;

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

235: open c_lock_rle3(c_c_site_use);
236: close c_lock_rle3;
237:
238: -- items for accounts (covered level in OKS)
239: arp_message.set_name('AR','AR_LOCKING_TABLE');
240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
241: arp_message.set_line('Locking for accounts');
242: open c_lock_cim(c_account);
243: close c_lock_cim;

Line 240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

236: close c_lock_rle3;
237:
238: -- items for accounts (covered level in OKS)
239: arp_message.set_name('AR','AR_LOCKING_TABLE');
240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
241: arp_message.set_line('Locking for accounts');
242: open c_lock_cim(c_account);
243: close c_lock_cim;
244:

Line 241: arp_message.set_line('Locking for accounts');

237:
238: -- items for accounts (covered level in OKS)
239: arp_message.set_name('AR','AR_LOCKING_TABLE');
240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
241: arp_message.set_line('Locking for accounts');
242: open c_lock_cim(c_account);
243: close c_lock_cim;
244:
245: -- items for sites

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

242: open c_lock_cim(c_account);
243: close c_lock_cim;
244:
245: -- items for sites
246: arp_message.set_name('AR','AR_LOCKING_TABLE');
247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
248: arp_message.set_line('Locking for sites');
249: open c_lock_cim(c_c_site);
250: close c_lock_cim;

Line 247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

243: close c_lock_cim;
244:
245: -- items for sites
246: arp_message.set_name('AR','AR_LOCKING_TABLE');
247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
248: arp_message.set_line('Locking for sites');
249: open c_lock_cim(c_c_site);
250: close c_lock_cim;
251:

Line 248: arp_message.set_line('Locking for sites');

244:
245: -- items for sites
246: arp_message.set_name('AR','AR_LOCKING_TABLE');
247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
248: arp_message.set_line('Locking for sites');
249: open c_lock_cim(c_c_site);
250: close c_lock_cim;
251:
252: -- items for site uses

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

249: open c_lock_cim(c_c_site);
250: close c_lock_cim;
251:
252: -- items for site uses
253: arp_message.set_name('AR','AR_LOCKING_TABLE');
254: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
255: arp_message.set_line('Locking for site uses');
256: open c_lock_cim(c_c_site_use);
257: close c_lock_cim;

Line 254: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

250: close c_lock_cim;
251:
252: -- items for site uses
253: arp_message.set_name('AR','AR_LOCKING_TABLE');
254: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
255: arp_message.set_line('Locking for site uses');
256: open c_lock_cim(c_c_site_use);
257: close c_lock_cim;
258:

Line 255: arp_message.set_line('Locking for site uses');

251:
252: -- items for site uses
253: arp_message.set_name('AR','AR_LOCKING_TABLE');
254: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
255: arp_message.set_line('Locking for site uses');
256: open c_lock_cim(c_c_site_use);
257: close c_lock_cim;
258:
259: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()-');

Line 259: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()-');

255: arp_message.set_line('Locking for site uses');
256: open c_lock_cim(c_c_site_use);
257: close c_lock_cim;
258:
259: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()-');
260: EXCEPTION
261: WHEN TIMEOUT_ON_RESOURCE THEN
262: arp_message.set_line('Could not obtain lock for records');
263: raise;

Line 262: arp_message.set_line('Could not obtain lock for records');

258:
259: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()-');
260: EXCEPTION
261: WHEN TIMEOUT_ON_RESOURCE THEN
262: arp_message.set_line('Could not obtain lock for records');
263: raise;
264: END; -- lock_tables
265:
266: --

Line 405: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()+');

401: l_log_party_id NUMBER;
402:
403: l_merge_not_allowed_excp EXCEPTION;
404: BEGIN
405: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()+');
406: arp_message.set_line('At the begining of Party Merge procedure');
407:
408: --
409: -- initialize the status to check whether any contract has more than one

Line 406: arp_message.set_line('At the begining of Party Merge procedure');

402:
403: l_merge_not_allowed_excp EXCEPTION;
404: BEGIN
405: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()+');
406: arp_message.set_line('At the begining of Party Merge procedure');
407:
408: --
409: -- initialize the status to check whether any contract has more than one
410: -- account for the source party and one of the accounts is merged acount.

Line 434: arp_message.set_line('Contract ' || l_contract_number || ' should be manually updated');

430: -- and one of the accounts is the merged account
431: OPEN c_header_info(l_chr_id);
432: FETCH c_header_info INTO l_contract_number, l_contract_number_modifier;
433: CLOSE c_header_info;
434: arp_message.set_line('Contract ' || l_contract_number || ' should be manually updated');
435:
436: EXIT;
437: END IF;
438: END LOOP; -- cursor c_rules

Line 482: arp_message.set_line('Contract ' || l_contract_number || ' is updated');

478: IF l_count > 0 THEN
479: OPEN c_header_info(l_chr_id);
480: FETCH c_header_info INTO l_contract_number, l_contract_number_modifier;
481: CLOSE c_header_info;
482: arp_message.set_line('Contract ' || l_contract_number || ' is updated');
483:
484: OPEN c_party_id_log(l_chr_id);
485: FETCH c_party_id_log INTO l_log_party_id;
486: CLOSE c_party_id_log;

Line 560: arp_message.set_line('At the end of Party Merge procedure');

556: CLOSE c_account_count;
557: END LOOP; -- cursor c_cpr
558: CLOSE c_cpr;
559:
560: arp_message.set_line('At the end of Party Merge procedure');
561: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()-');
562:
563: EXCEPTION
564: WHEN l_merge_not_allowed_excp THEN

Line 561: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()-');

557: END LOOP; -- cursor c_cpr
558: CLOSE c_cpr;
559:
560: arp_message.set_line('At the end of Party Merge procedure');
561: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()-');
562:
563: EXCEPTION
564: WHEN l_merge_not_allowed_excp THEN
565: arp_message.set_line('Contract exists for duplicate party with more than one account, merge cannot proceed');

Line 565: arp_message.set_line('Contract exists for duplicate party with more than one account, merge cannot proceed');

561: arp_message.set_line('OKC_HZ_MERGE_PUB.PARTY_MERGE()-');
562:
563: EXCEPTION
564: WHEN l_merge_not_allowed_excp THEN
565: arp_message.set_line('Contract exists for duplicate party with more than one account, merge cannot proceed');
566: arp_message.set_line('Please update the above mentioned contracts and run customer merge again');
567: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
568: RAISE;
569:

Line 566: arp_message.set_line('Please update the above mentioned contracts and run customer merge again');

562:
563: EXCEPTION
564: WHEN l_merge_not_allowed_excp THEN
565: arp_message.set_line('Contract exists for duplicate party with more than one account, merge cannot proceed');
566: arp_message.set_line('Please update the above mentioned contracts and run customer merge again');
567: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
568: RAISE;
569:
570: WHEN others THEN

Line 567: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');

563: EXCEPTION
564: WHEN l_merge_not_allowed_excp THEN
565: arp_message.set_line('Contract exists for duplicate party with more than one account, merge cannot proceed');
566: arp_message.set_line('Please update the above mentioned contracts and run customer merge again');
567: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
568: RAISE;
569:
570: WHEN others THEN
571: l_error_msg := substr(SQLERRM,1,70);

Line 572: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);

568: RAISE;
569:
570: WHEN others THEN
571: l_error_msg := substr(SQLERRM,1,70);
572: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);
573: RAISE;
574:
575: END; -- party_merge
576:

Line 602: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()+');

598: l_cum_count NUMBER := 0;
599: /*BUG9077092*/
600:
601: BEGIN
602: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()+');
603:
604: -- contract party roles
605: -- Insert into log table
606: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

648: WHERE ojt.object_code = oue.object_code
649: AND oue.object_user_code = c_account);
650: End If;
651:
652: arp_message.set_name('AR','AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
654: UPDATE okc_k_party_roles_b kpr
655: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
656: FROM ra_customer_merges rcm

Line 653: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);

649: AND oue.object_user_code = c_account);
650: End If;
651:
652: arp_message.set_name('AR','AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
654: UPDATE okc_k_party_roles_b kpr
655: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
656: FROM ra_customer_merges rcm
657: WHERE kpr.object1_id1 = rcm.duplicate_id

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

674: AND oue.object_user_code = c_account)
675: ;
676: l_count := sql%rowcount;
677: l_cum_count := l_cum_count + l_count; /*bug9077092*/
678: arp_message.set_name('AR','AR_ROWS_UPDATED');
679: arp_message.set_token('NUM_ROWS',to_char(l_count));
680:
681: -- Rules ID1
682: -- Insert into log table

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

675: ;
676: l_count := sql%rowcount;
677: l_cum_count := l_cum_count + l_count; /*bug9077092*/
678: arp_message.set_name('AR','AR_ROWS_UPDATED');
679: arp_message.set_token('NUM_ROWS',to_char(l_count));
680:
681: -- Rules ID1
682: -- Insert into log table
683: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

725: WHERE ojt.object_code = oue.object_code
726: AND oue.object_user_code = c_account);
727: End If;
728:
729: arp_message.set_name('AR','AR_UPDATING_TABLE');
730: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
731: UPDATE okc_rules_b rle
732: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
733: FROM ra_customer_merges rcm

Line 730: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

726: AND oue.object_user_code = c_account);
727: End If;
728:
729: arp_message.set_name('AR','AR_UPDATING_TABLE');
730: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
731: UPDATE okc_rules_b rle
732: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
733: FROM ra_customer_merges rcm
734: WHERE rle.object1_id1 = rcm.duplicate_id

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

750: WHERE ojt.object_code = oue.object_code
751: AND oue.object_user_code = c_account)
752: ;
753: l_count := sql%rowcount;
754: arp_message.set_name('AR','AR_ROWS_UPDATED');
755: arp_message.set_token('NUM_ROWS',to_char(l_count));
756:
757:
758: -- Rules ID2

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

751: AND oue.object_user_code = c_account)
752: ;
753: l_count := sql%rowcount;
754: arp_message.set_name('AR','AR_ROWS_UPDATED');
755: arp_message.set_token('NUM_ROWS',to_char(l_count));
756:
757:
758: -- Rules ID2
759: -- Insert into log table

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

802: WHERE ojt.object_code = oue.object_code
803: AND oue.object_user_code = c_account);
804: End If;
805:
806: arp_message.set_name('AR','AR_UPDATING_TABLE');
807: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
808: UPDATE okc_rules_b rle
809: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
810: FROM ra_customer_merges rcm

Line 807: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

803: AND oue.object_user_code = c_account);
804: End If;
805:
806: arp_message.set_name('AR','AR_UPDATING_TABLE');
807: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
808: UPDATE okc_rules_b rle
809: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
810: FROM ra_customer_merges rcm
811: WHERE rle.object2_id1 = rcm.duplicate_id

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

827: WHERE ojt.object_code = oue.object_code
828: AND oue.object_user_code = c_account)
829: ;
830: l_count := sql%rowcount;
831: arp_message.set_name('AR','AR_ROWS_UPDATED');
832: arp_message.set_token('NUM_ROWS',to_char(l_count));
833:
834:
835: -- Rules ID3

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

828: AND oue.object_user_code = c_account)
829: ;
830: l_count := sql%rowcount;
831: arp_message.set_name('AR','AR_ROWS_UPDATED');
832: arp_message.set_token('NUM_ROWS',to_char(l_count));
833:
834:
835: -- Rules ID3
836: -- Insert into log table

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

879: WHERE ojt.object_code = oue.object_code
880: AND oue.object_user_code = c_account);
881: End If;
882:
883: arp_message.set_name('AR','AR_UPDATING_TABLE');
884: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
885: UPDATE okc_rules_b rle
886: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
887: FROM ra_customer_merges rcm

Line 884: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

880: AND oue.object_user_code = c_account);
881: End If;
882:
883: arp_message.set_name('AR','AR_UPDATING_TABLE');
884: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
885: UPDATE okc_rules_b rle
886: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
887: FROM ra_customer_merges rcm
888: WHERE rle.object3_id1 = rcm.duplicate_id

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

904: WHERE ojt.object_code = oue.object_code
905: AND oue.object_user_code = c_account)
906: ;
907: l_count := sql%rowcount;
908: arp_message.set_name('AR','AR_ROWS_UPDATED');
909: arp_message.set_token('NUM_ROWS',to_char(l_count));
910:
911: -- Start:Code added for Bug 3555739
912: -- Updating okc_k_headers_b

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

905: AND oue.object_user_code = c_account)
906: ;
907: l_count := sql%rowcount;
908: arp_message.set_name('AR','AR_ROWS_UPDATED');
909: arp_message.set_token('NUM_ROWS',to_char(l_count));
910:
911: -- Start:Code added for Bug 3555739
912: -- Updating okc_k_headers_b
913: -- Cust_Acct_Id

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

953: AND rcm.set_number = set_number);
954:
955: End If;
956:
957: arp_message.set_name('AR','AR_UPDATING_TABLE');
958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
959:
960: UPDATE okc_k_headers_b okh
961: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)

Line 958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);

954:
955: End If;
956:
957: arp_message.set_name('AR','AR_UPDATING_TABLE');
958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
959:
960: UPDATE okc_k_headers_b okh
961: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
962: FROM ra_customer_merges rcm

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

975: AND rcm.set_number = set_number);
976:
977: l_count := sql%rowcount;
978: l_cum_count := l_cum_count + l_count; /*bug9077092*/
979: arp_message.set_name('AR','AR_ROWS_UPDATED');
980: arp_message.set_token('NUM_ROWS',to_char(l_count));
981:
982:
983:

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

976:
977: l_count := sql%rowcount;
978: l_cum_count := l_cum_count + l_count; /*bug9077092*/
979: arp_message.set_name('AR','AR_ROWS_UPDATED');
980: arp_message.set_token('NUM_ROWS',to_char(l_count));
981:
982:
983:
984: -- Updating okc_k_lines_b

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

1025: AND rcm.set_number = set_number);
1026:
1027: End If;
1028:
1029: arp_message.set_name('AR','AR_UPDATING_TABLE');
1030: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1031:
1032: /*bug9077092*/
1033: FOR j IN contract_id LOOP

Line 1030: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);

1026:
1027: End If;
1028:
1029: arp_message.set_name('AR','AR_UPDATING_TABLE');
1030: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1031:
1032: /*bug9077092*/
1033: FOR j IN contract_id LOOP
1034: l_chr_id(i) := j.chr_id;

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

1055: AND rcm.set_number = set_number);
1056:
1057: l_count := sql%rowcount;
1058: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1059: arp_message.set_name('AR','AR_ROWS_UPDATED');
1060: arp_message.set_token('NUM_ROWS',to_char(l_count));
1061:
1062: -- Updating okc_k_party_roles_b
1063: -- Cust_Acct_Id

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

1056:
1057: l_count := sql%rowcount;
1058: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1059: arp_message.set_name('AR','AR_ROWS_UPDATED');
1060: arp_message.set_token('NUM_ROWS',to_char(l_count));
1061:
1062: -- Updating okc_k_party_roles_b
1063: -- Cust_Acct_Id
1064: -- Insert into log table

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

1103: AND rcm.set_number = set_number);
1104:
1105: End If;
1106:
1107: arp_message.set_name('AR','AR_UPDATING_TABLE');
1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1109:
1110: UPDATE okc_k_party_roles_b okpr
1111: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)

Line 1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);

1104:
1105: End If;
1106:
1107: arp_message.set_name('AR','AR_UPDATING_TABLE');
1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1109:
1110: UPDATE okc_k_party_roles_b okpr
1111: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1112: FROM ra_customer_merges rcm

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

1125: AND rcm.set_number = set_number);
1126:
1127: l_count := sql%rowcount;
1128: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1129: arp_message.set_name('AR','AR_ROWS_UPDATED');
1130: arp_message.set_token('NUM_ROWS',to_char(l_count));
1131:
1132: -- End:Code added for Bug 3555739
1133:

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

1126:
1127: l_count := sql%rowcount;
1128: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1129: arp_message.set_name('AR','AR_ROWS_UPDATED');
1130: arp_message.set_token('NUM_ROWS',to_char(l_count));
1131:
1132: -- End:Code added for Bug 3555739
1133:
1134: -- contract items

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

1178: WHERE ojt.object_code = oue.object_code
1179: AND oue.object_user_code = c_account);
1180: End If;
1181:
1182: arp_message.set_name('AR','AR_UPDATING_TABLE');
1183: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1184: UPDATE okc_k_items cim
1185: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
1186: FROM ra_customer_merges rcm

Line 1183: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

1179: AND oue.object_user_code = c_account);
1180: End If;
1181:
1182: arp_message.set_name('AR','AR_UPDATING_TABLE');
1183: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1184: UPDATE okc_k_items cim
1185: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
1186: FROM ra_customer_merges rcm
1187: WHERE cim.object1_id1 = rcm.duplicate_id

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

1204: AND oue.object_user_code = c_account)
1205: ;
1206: l_count := sql%rowcount;
1207: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1208: arp_message.set_name('AR','AR_ROWS_UPDATED');
1209: arp_message.set_token('NUM_ROWS',to_char(l_count));
1210:
1211: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()-');
1212:

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

1205: ;
1206: l_count := sql%rowcount;
1207: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1208: arp_message.set_name('AR','AR_ROWS_UPDATED');
1209: arp_message.set_token('NUM_ROWS',to_char(l_count));
1210:
1211: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()-');
1212:
1213: /*bug9077092 - incrementing minor version even when account merge happens within the parties*/

Line 1211: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()-');

1207: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1208: arp_message.set_name('AR','AR_ROWS_UPDATED');
1209: arp_message.set_token('NUM_ROWS',to_char(l_count));
1210:
1211: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_MERGE()-');
1212:
1213: /*bug9077092 - incrementing minor version even when account merge happens within the parties*/
1214: IF l_cum_count > 0 AND g_minor_ver_upd_processed = 'N' THEN
1215:

Line 1289: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()+');

1285: l_cum_count NUMBER := 0;
1286: /*BUG9077092*/
1287:
1288: BEGIN
1289: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()+');
1290: arp_message.set_line('Updating account sites');
1291: --
1292: -- Account Sites come first, then site uses
1293: --

Line 1290: arp_message.set_line('Updating account sites');

1286: /*BUG9077092*/
1287:
1288: BEGIN
1289: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()+');
1290: arp_message.set_line('Updating account sites');
1291: --
1292: -- Account Sites come first, then site uses
1293: --
1294: -- Account Sites in Rules. There are three ids in rules that could hold the site id

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

1341: WHERE ojt.object_code = oue.object_code
1342: AND oue.object_user_code = c_c_site);
1343: End If;
1344:
1345: arp_message.set_name('AR','AR_UPDATING_TABLE');
1346: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1347: UPDATE okc_rules_b rle
1348: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1349: FROM ra_customer_merges rcm

Line 1346: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

1342: AND oue.object_user_code = c_c_site);
1343: End If;
1344:
1345: arp_message.set_name('AR','AR_UPDATING_TABLE');
1346: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1347: UPDATE okc_rules_b rle
1348: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1349: FROM ra_customer_merges rcm
1350: WHERE rle.object1_id1 = rcm.duplicate_address_id

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

1367: WHERE ojt.object_code = oue.object_code
1368: AND oue.object_user_code = c_c_site)
1369: ;
1370: l_count := sql%rowcount;
1371: arp_message.set_name('AR','AR_ROWS_UPDATED');
1372: arp_message.set_token('NUM_ROWS',to_char(l_count));
1373:
1374:
1375: -- Rules ID2

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

1368: AND oue.object_user_code = c_c_site)
1369: ;
1370: l_count := sql%rowcount;
1371: arp_message.set_name('AR','AR_ROWS_UPDATED');
1372: arp_message.set_token('NUM_ROWS',to_char(l_count));
1373:
1374:
1375: -- Rules ID2
1376: -- Insert into log table

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

1419: WHERE ojt.object_code = oue.object_code
1420: AND oue.object_user_code = c_c_site);
1421: End If;
1422:
1423: arp_message.set_name('AR','AR_UPDATING_TABLE');
1424: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1425: UPDATE okc_rules_b rle
1426: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1427: FROM ra_customer_merges rcm

Line 1424: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

1420: AND oue.object_user_code = c_c_site);
1421: End If;
1422:
1423: arp_message.set_name('AR','AR_UPDATING_TABLE');
1424: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1425: UPDATE okc_rules_b rle
1426: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1427: FROM ra_customer_merges rcm
1428: WHERE rle.object2_id1 = rcm.duplicate_address_id

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

1445: WHERE ojt.object_code = oue.object_code
1446: AND oue.object_user_code = c_c_site)
1447: ;
1448: l_count := sql%rowcount;
1449: arp_message.set_name('AR','AR_ROWS_UPDATED');
1450: arp_message.set_token('NUM_ROWS',to_char(l_count));
1451:
1452: -- Rules ID3
1453: -- Insert into log table

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

1446: AND oue.object_user_code = c_c_site)
1447: ;
1448: l_count := sql%rowcount;
1449: arp_message.set_name('AR','AR_ROWS_UPDATED');
1450: arp_message.set_token('NUM_ROWS',to_char(l_count));
1451:
1452: -- Rules ID3
1453: -- Insert into log table
1454: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1496: WHERE ojt.object_code = oue.object_code
1497: AND oue.object_user_code = c_c_site);
1498: End If;
1499:
1500: arp_message.set_name('AR','AR_UPDATING_TABLE');
1501: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1502: UPDATE okc_rules_b rle
1503: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1504: FROM ra_customer_merges rcm

Line 1501: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

1497: AND oue.object_user_code = c_c_site);
1498: End If;
1499:
1500: arp_message.set_name('AR','AR_UPDATING_TABLE');
1501: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1502: UPDATE okc_rules_b rle
1503: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1504: FROM ra_customer_merges rcm
1505: WHERE rle.object3_id1 = rcm.duplicate_address_id

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

1522: WHERE ojt.object_code = oue.object_code
1523: AND oue.object_user_code = c_c_site)
1524: ;
1525: l_count := sql%rowcount;
1526: arp_message.set_name('AR','AR_ROWS_UPDATED');
1527: arp_message.set_token('NUM_ROWS',to_char(l_count));
1528:
1529:
1530: --

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

1523: AND oue.object_user_code = c_c_site)
1524: ;
1525: l_count := sql%rowcount;
1526: arp_message.set_name('AR','AR_ROWS_UPDATED');
1527: arp_message.set_token('NUM_ROWS',to_char(l_count));
1528:
1529:
1530: --
1531: -- Account Sites in Items

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

1576: WHERE ojt.object_code = oue.object_code
1577: AND oue.object_user_code = c_c_site);
1578: End If;
1579:
1580: arp_message.set_name('AR','AR_UPDATING_TABLE');
1581: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1582: UPDATE okc_k_items cim
1583: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1584: FROM ra_customer_merges rcm

Line 1581: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

1577: AND oue.object_user_code = c_c_site);
1578: End If;
1579:
1580: arp_message.set_name('AR','AR_UPDATING_TABLE');
1581: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1582: UPDATE okc_k_items cim
1583: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1584: FROM ra_customer_merges rcm
1585: WHERE cim.object1_id1 = rcm.duplicate_address_id

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

1602: WHERE ojt.object_code = oue.object_code
1603: AND oue.object_user_code = c_c_site)
1604: ;
1605: l_count := sql%rowcount;
1606: arp_message.set_name('AR','AR_ROWS_UPDATED');
1607: arp_message.set_token('NUM_ROWS',to_char(l_count));
1608:
1609: --
1610: -- Account Site Uses

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

1603: AND oue.object_user_code = c_c_site)
1604: ;
1605: l_count := sql%rowcount;
1606: arp_message.set_name('AR','AR_ROWS_UPDATED');
1607: arp_message.set_token('NUM_ROWS',to_char(l_count));
1608:
1609: --
1610: -- Account Site Uses
1611: --

Line 1619: arp_message.set_line('Updating account site uses for OKE');

1615: -- Account Site Use in OKC_K_PARTY_ROLES_B (see Bug 3950642)
1616: -- OKE only uses the first object1_id1 to hold the site use id
1617: --
1618: --chkrishn 11/03/2004
1619: arp_message.set_line('Updating account site uses for OKE');
1620: -- Insert into log table
1621: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1622: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1623: MERGE_LOG_ID,

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

1665: End If;
1666:
1667: --chkrishn 11/03/2004
1668:
1669: arp_message.set_name('AR','AR_UPDATING_TABLE');
1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1671:
1672: UPDATE okc_k_party_roles_b rle
1673: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)

Line 1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

1666:
1667: --chkrishn 11/03/2004
1668:
1669: arp_message.set_name('AR','AR_UPDATING_TABLE');
1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1671:
1672: UPDATE okc_k_party_roles_b rle
1673: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1674: FROM ra_customer_merges rcm

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

1692: AND rle.dnz_chr_id in (select k_header_id from oke_k_headers);
1693:
1694: --chkrishn 11/03/2004
1695: l_count := sql%rowcount;
1696: arp_message.set_name('AR','AR_ROWS_UPDATED');
1697: arp_message.set_token('NUM_ROWS',to_char(l_count));
1698:
1699: --
1700: -- End of bug fix 3950642

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

1693:
1694: --chkrishn 11/03/2004
1695: l_count := sql%rowcount;
1696: arp_message.set_name('AR','AR_ROWS_UPDATED');
1697: arp_message.set_token('NUM_ROWS',to_char(l_count));
1698:
1699: --
1700: -- End of bug fix 3950642
1701: --

Line 1710: arp_message.set_line('Updating account site uses');

1706: -- could hold the site use id
1707: --
1708:
1709:
1710: arp_message.set_line('Updating account site uses');
1711:
1712: -- Rules ID1
1713: -- Insert into log table
1714: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1756: WHERE ojt.object_code = oue.object_code
1757: AND oue.object_user_code = c_c_site_use);
1758: End If;
1759:
1760: arp_message.set_name('AR','AR_UPDATING_TABLE');
1761: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1762: UPDATE okc_rules_b rle
1763: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1764: FROM ra_customer_merges rcm

Line 1761: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

1757: AND oue.object_user_code = c_c_site_use);
1758: End If;
1759:
1760: arp_message.set_name('AR','AR_UPDATING_TABLE');
1761: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1762: UPDATE okc_rules_b rle
1763: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1764: FROM ra_customer_merges rcm
1765: WHERE rle.object1_id1 = rcm.duplicate_site_id

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

1781: WHERE ojt.object_code = oue.object_code
1782: AND oue.object_user_code = c_c_site_use)
1783: ;
1784: l_count := sql%rowcount;
1785: arp_message.set_name('AR','AR_ROWS_UPDATED');
1786: arp_message.set_token('NUM_ROWS',to_char(l_count));
1787:
1788: -- Rules ID2
1789: -- Insert into log table

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

1782: AND oue.object_user_code = c_c_site_use)
1783: ;
1784: l_count := sql%rowcount;
1785: arp_message.set_name('AR','AR_ROWS_UPDATED');
1786: arp_message.set_token('NUM_ROWS',to_char(l_count));
1787:
1788: -- Rules ID2
1789: -- Insert into log table
1790: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1832: WHERE ojt.object_code = oue.object_code
1833: AND oue.object_user_code = c_c_site_use);
1834: End If;
1835:
1836: arp_message.set_name('AR','AR_UPDATING_TABLE');
1837: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1838: UPDATE okc_rules_b rle
1839: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1840: FROM ra_customer_merges rcm

Line 1837: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

1833: AND oue.object_user_code = c_c_site_use);
1834: End If;
1835:
1836: arp_message.set_name('AR','AR_UPDATING_TABLE');
1837: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1838: UPDATE okc_rules_b rle
1839: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1840: FROM ra_customer_merges rcm
1841: WHERE rle.object2_id1 = rcm.duplicate_site_id

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

1857: WHERE ojt.object_code = oue.object_code
1858: AND oue.object_user_code = c_c_site_use)
1859: ;
1860: l_count := sql%rowcount;
1861: arp_message.set_name('AR','AR_ROWS_UPDATED');
1862: arp_message.set_token('NUM_ROWS',to_char(l_count));
1863:
1864:
1865: -- Rules ID3

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

1858: AND oue.object_user_code = c_c_site_use)
1859: ;
1860: l_count := sql%rowcount;
1861: arp_message.set_name('AR','AR_ROWS_UPDATED');
1862: arp_message.set_token('NUM_ROWS',to_char(l_count));
1863:
1864:
1865: -- Rules ID3
1866: -- Insert into log table

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

1909: WHERE ojt.object_code = oue.object_code
1910: AND oue.object_user_code = c_c_site_use);
1911: End If;
1912:
1913: arp_message.set_name('AR','AR_UPDATING_TABLE');
1914: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1915: UPDATE okc_rules_b rle
1916: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1917: FROM ra_customer_merges rcm

Line 1914: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

1910: AND oue.object_user_code = c_c_site_use);
1911: End If;
1912:
1913: arp_message.set_name('AR','AR_UPDATING_TABLE');
1914: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1915: UPDATE okc_rules_b rle
1916: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1917: FROM ra_customer_merges rcm
1918: WHERE rle.object3_id1 = rcm.duplicate_site_id

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

1934: WHERE ojt.object_code = oue.object_code
1935: AND oue.object_user_code = c_c_site_use)
1936: ;
1937: l_count := sql%rowcount;
1938: arp_message.set_name('AR','AR_ROWS_UPDATED');
1939: arp_message.set_token('NUM_ROWS',to_char(l_count));
1940:
1941: -- Start:Code added for Bug 3555739
1942: -- Updating okc_k_headers_b

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

1935: AND oue.object_user_code = c_c_site_use)
1936: ;
1937: l_count := sql%rowcount;
1938: arp_message.set_name('AR','AR_ROWS_UPDATED');
1939: arp_message.set_token('NUM_ROWS',to_char(l_count));
1940:
1941: -- Start:Code added for Bug 3555739
1942: -- Updating okc_k_headers_b
1943: -- Ship_to_site_use_id

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

1983: AND rcm.set_number = set_number);
1984:
1985: End If;
1986:
1987: arp_message.set_name('AR','AR_UPDATING_TABLE');
1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1989:
1990: UPDATE okc_k_headers_b okh
1991: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)

Line 1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);

1984:
1985: End If;
1986:
1987: arp_message.set_name('AR','AR_UPDATING_TABLE');
1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1989:
1990: UPDATE okc_k_headers_b okh
1991: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1992: FROM ra_customer_merges rcm

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

2004: AND rcm.request_id = req_id
2005: AND rcm.set_number = set_number);
2006: l_count := sql%rowcount;
2007: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2008: arp_message.set_name('AR','AR_ROWS_UPDATED');
2009: arp_message.set_token('NUM_ROWS',to_char(l_count));
2010:
2011:
2012: -- Updating okc_k_headers_b

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

2005: AND rcm.set_number = set_number);
2006: l_count := sql%rowcount;
2007: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2008: arp_message.set_name('AR','AR_ROWS_UPDATED');
2009: arp_message.set_token('NUM_ROWS',to_char(l_count));
2010:
2011:
2012: -- Updating okc_k_headers_b
2013: -- Bill_to_site_use_id

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

2053: AND rcm.set_number = set_number);
2054:
2055: End If;
2056:
2057: arp_message.set_name('AR','AR_UPDATING_TABLE');
2058: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2059:
2060: UPDATE okc_k_headers_b okh
2061: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)

Line 2058: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);

2054:
2055: End If;
2056:
2057: arp_message.set_name('AR','AR_UPDATING_TABLE');
2058: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2059:
2060: UPDATE okc_k_headers_b okh
2061: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2062: FROM ra_customer_merges rcm

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

2074: AND rcm.request_id = req_id
2075: AND rcm.set_number = set_number);
2076: l_count := sql%rowcount;
2077: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2078: arp_message.set_name('AR','AR_ROWS_UPDATED');
2079: arp_message.set_token('NUM_ROWS',to_char(l_count));
2080:
2081: -- Updating okc_k_lines_b
2082: -- Ship_to_site_use_id

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

2075: AND rcm.set_number = set_number);
2076: l_count := sql%rowcount;
2077: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2078: arp_message.set_name('AR','AR_ROWS_UPDATED');
2079: arp_message.set_token('NUM_ROWS',to_char(l_count));
2080:
2081: -- Updating okc_k_lines_b
2082: -- Ship_to_site_use_id
2083: -- Insert into log table

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

2122: AND rcm.set_number = set_number);
2123:
2124: End If;
2125:
2126: arp_message.set_name('AR','AR_UPDATING_TABLE');
2127: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2128:
2129: /*bug9077092*/
2130: FOR j IN contract_id LOOP

Line 2127: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);

2123:
2124: End If;
2125:
2126: arp_message.set_name('AR','AR_UPDATING_TABLE');
2127: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2128:
2129: /*bug9077092*/
2130: FOR j IN contract_id LOOP
2131: l_chr_id(i) := j.chr_id;

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

2151: AND rcm.request_id = req_id
2152: AND rcm.set_number = set_number);
2153: l_count := sql%rowcount;
2154: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2155: arp_message.set_name('AR','AR_ROWS_UPDATED');
2156: arp_message.set_token('NUM_ROWS',to_char(l_count));
2157:
2158:
2159: -- Updating okc_k_lines_b

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

2152: AND rcm.set_number = set_number);
2153: l_count := sql%rowcount;
2154: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2155: arp_message.set_name('AR','AR_ROWS_UPDATED');
2156: arp_message.set_token('NUM_ROWS',to_char(l_count));
2157:
2158:
2159: -- Updating okc_k_lines_b
2160: -- Bill_to_site_use_id

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

2200: AND rcm.set_number = set_number);
2201:
2202: End If;
2203:
2204: arp_message.set_name('AR','AR_UPDATING_TABLE');
2205: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2206:
2207: UPDATE okc_k_lines_b okl
2208: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)

Line 2205: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);

2201:
2202: End If;
2203:
2204: arp_message.set_name('AR','AR_UPDATING_TABLE');
2205: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2206:
2207: UPDATE okc_k_lines_b okl
2208: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2209: FROM ra_customer_merges rcm

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

2221: AND rcm.request_id = req_id
2222: AND rcm.set_number = set_number);
2223: l_count := sql%rowcount;
2224: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2225: arp_message.set_name('AR','AR_ROWS_UPDATED');
2226: arp_message.set_token('NUM_ROWS',to_char(l_count));
2227:
2228:
2229: -- Updating okc_k_party_roles_b

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

2222: AND rcm.set_number = set_number);
2223: l_count := sql%rowcount;
2224: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2225: arp_message.set_name('AR','AR_ROWS_UPDATED');
2226: arp_message.set_token('NUM_ROWS',to_char(l_count));
2227:
2228:
2229: -- Updating okc_k_party_roles_b
2230: -- Bill_to_site_use_id

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

2270: AND rcm.set_number = set_number);
2271:
2272: End If;
2273:
2274: arp_message.set_name('AR','AR_UPDATING_TABLE');
2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2276:
2277: UPDATE okc_k_party_roles_b okpr
2278: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)

Line 2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);

2271:
2272: End If;
2273:
2274: arp_message.set_name('AR','AR_UPDATING_TABLE');
2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2276:
2277: UPDATE okc_k_party_roles_b okpr
2278: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2279: FROM ra_customer_merges rcm

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

2291: AND rcm.request_id = req_id
2292: AND rcm.set_number = set_number);
2293: l_count := sql%rowcount;
2294: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2295: arp_message.set_name('AR','AR_ROWS_UPDATED');
2296: arp_message.set_token('NUM_ROWS',to_char(l_count));
2297:
2298: -- End:Code added for Bug 3555739
2299:

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

2292: AND rcm.set_number = set_number);
2293: l_count := sql%rowcount;
2294: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2295: arp_message.set_name('AR','AR_ROWS_UPDATED');
2296: arp_message.set_token('NUM_ROWS',to_char(l_count));
2297:
2298: -- End:Code added for Bug 3555739
2299:
2300: --

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

2346: WHERE ojt.object_code = oue.object_code
2347: AND oue.object_user_code = c_c_site_use);
2348: End If;
2349:
2350: arp_message.set_name('AR','AR_UPDATING_TABLE');
2351: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
2352: UPDATE okc_k_items cim
2353: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
2354: FROM ra_customer_merges rcm

Line 2351: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

2347: AND oue.object_user_code = c_c_site_use);
2348: End If;
2349:
2350: arp_message.set_name('AR','AR_UPDATING_TABLE');
2351: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
2352: UPDATE okc_k_items cim
2353: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
2354: FROM ra_customer_merges rcm
2355: WHERE cim.object1_id1 = rcm.duplicate_site_id

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

2372: AND oue.object_user_code = c_c_site_use)
2373: ;
2374: l_count := sql%rowcount;
2375: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2376: arp_message.set_name('AR','AR_ROWS_UPDATED');
2377: arp_message.set_token('NUM_ROWS',to_char(l_count));
2378:
2379: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()-');
2380:

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

2373: ;
2374: l_count := sql%rowcount;
2375: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2376: arp_message.set_name('AR','AR_ROWS_UPDATED');
2377: arp_message.set_token('NUM_ROWS',to_char(l_count));
2378:
2379: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()-');
2380:
2381: /*bug9077092 - incrementing minor version even when account merge happens within the parties*/

Line 2379: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()-');

2375: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2376: arp_message.set_name('AR','AR_ROWS_UPDATED');
2377: arp_message.set_token('NUM_ROWS',to_char(l_count));
2378:
2379: arp_message.set_line('OKC_HZ_MERGE_PUB.ACCOUNT_SITE_MERGE()-');
2380:
2381: /*bug9077092 - incrementing minor version even when account merge happens within the parties*/
2382: IF l_cum_count > 0 AND g_minor_ver_upd_processed = 'N' THEN
2383:

Line 2512: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()+');

2508: l_lock_excp EXCEPTION;
2509: l_hook NUMBER;
2510:
2511: BEGIN
2512: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()+');
2513:
2514: --
2515: -- check process mode. If LOCK, then just lock the tables
2516: --

Line 2608: arp_message.set_line('OKS_CODE_HOOK.Update_Merge_Account()-');

2604: ,process_mode => process_mode
2605: ,x_hook =>l_hook);
2606:
2607: If l_hook =1 then
2608: arp_message.set_line('OKS_CODE_HOOK.Update_Merge_Account()-');
2609: elsif l_hook = -1 then
2610: arp_message.set_line(' Exception raised in OKS_CODE_HOOK.Update_Merge_Account()-');
2611: End If;
2612:

Line 2610: arp_message.set_line(' Exception raised in OKS_CODE_HOOK.Update_Merge_Account()-');

2606:
2607: If l_hook =1 then
2608: arp_message.set_line('OKS_CODE_HOOK.Update_Merge_Account()-');
2609: elsif l_hook = -1 then
2610: arp_message.set_line(' Exception raised in OKS_CODE_HOOK.Update_Merge_Account()-');
2611: End If;
2612:
2613: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2614:

Line 2613: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

2609: elsif l_hook = -1 then
2610: arp_message.set_line(' Exception raised in OKS_CODE_HOOK.Update_Merge_Account()-');
2611: End If;
2612:
2613: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2614:
2615: EXCEPTION
2616: WHEN l_merge_disallowed_excp THEN
2617: arp_message.set_line('Contract exists for duplicate party, merge cannot proceed');

Line 2617: arp_message.set_line('Contract exists for duplicate party, merge cannot proceed');

2613: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2614:
2615: EXCEPTION
2616: WHEN l_merge_disallowed_excp THEN
2617: arp_message.set_line('Contract exists for duplicate party, merge cannot proceed');
2618: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2619: RAISE;
2620: WHEN l_no_data_found_excp THEN
2621: arp_message.set_line('No data found for merge information');

Line 2618: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');

2614:
2615: EXCEPTION
2616: WHEN l_merge_disallowed_excp THEN
2617: arp_message.set_line('Contract exists for duplicate party, merge cannot proceed');
2618: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2619: RAISE;
2620: WHEN l_no_data_found_excp THEN
2621: arp_message.set_line('No data found for merge information');
2622: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');

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

2617: arp_message.set_line('Contract exists for duplicate party, merge cannot proceed');
2618: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2619: RAISE;
2620: WHEN l_no_data_found_excp THEN
2621: arp_message.set_line('No data found for merge information');
2622: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2623: RAISE;
2624: WHEN l_lock_excp THEN -- normal exit after locking
2625: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

Line 2622: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');

2618: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2619: RAISE;
2620: WHEN l_no_data_found_excp THEN
2621: arp_message.set_line('No data found for merge information');
2622: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2623: RAISE;
2624: WHEN l_lock_excp THEN -- normal exit after locking
2625: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2626: WHEN others THEN

Line 2625: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');

2621: arp_message.set_line('No data found for merge information');
2622: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT');
2623: RAISE;
2624: WHEN l_lock_excp THEN -- normal exit after locking
2625: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2626: WHEN others THEN
2627: l_error_msg := substr(SQLERRM,1,70);
2628: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);
2629: RAISE;

Line 2628: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);

2624: WHEN l_lock_excp THEN -- normal exit after locking
2625: arp_message.set_line('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT()-');
2626: WHEN others THEN
2627: l_error_msg := substr(SQLERRM,1,70);
2628: arp_message.set_error('OKC_HZ_MERGE_PUB.MERGE_ACCOUNT', l_error_msg);
2629: RAISE;
2630: END; -- merge_account
2631:
2632: END; -- Package Body OKC_HZ_MERGE_PUB