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

Line 75: -- arp_message.set_line(g_api_name||'.'||l_proc_name);

71: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_CUST_REG_MERGE ';
72: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
73:
74: BEGIN
75: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
76: --------------------------------------------------------------------------------
77: -- Logging Infra: Setting up runtime level
78: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
79:

Line 99: arp_message.set_line('Updating zx_party_tax_profile...');

95:
96: if p_from_fk_id <> p_to_fk_id then
97: BEGIN
98:
99: arp_message.set_line('Updating zx_party_tax_profile...');
100:
101: OPEN registration_number(p_from_fk_id);
102: FETCH registration_number INTO from_registration_rec;
103: IF registration_number%FOUND THEN

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

188: object_version_number = object_version_number+1
189: where registration_id = l_registration_id_to;
190:
191: l_count := sql%rowcount;
192: arp_message.set_name('AR','AR_ROWS_UPDATED');
193: arp_message.set_token('NUM_ROWS',to_char(l_count));
194:
195: end if; -- (l_registration_from = l_registration_to)
196:

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

189: where registration_id = l_registration_id_to;
190:
191: l_count := sql%rowcount;
192: arp_message.set_name('AR','AR_ROWS_UPDATED');
193: arp_message.set_token('NUM_ROWS',to_char(l_count));
194:
195: end if; -- (l_registration_from = l_registration_to)
196:
197: EXCEPTION

Line 270: -- arp_message.set_line(g_api_name||'.'||l_proc_name);

266: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_PTP_MERGE ';
267: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
268:
269: BEGIN
270: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
271: --------------------------------------------------------------------------------------
272: -- Logging Infra: Setting up runtime level
273: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:

Line 294: arp_message.set_line('Updating zx_party_tax_profile...');

290:
291: if p_from_fk_id <> p_to_fk_id then
292:
293: BEGIN
294: arp_message.set_line('Updating zx_party_tax_profile...');
295:
296: OPEN Party_Tax_Profile(p_from_fk_id);
297: FETCH Party_Tax_Profile INTO from_ptp_rec;
298: IF Party_Tax_Profile%FOUND THEN

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

316: object_version_number = object_version_number+1
317: where Party_Tax_Profile_id = l_ptp_id_from;
318:
319: l_count := sql%rowcount;
320: arp_message.set_name('AR','AR_ROWS_UPDATED');
321: arp_message.set_token('NUM_ROWS',to_char(l_count));
322:
323: For code_assig IN Class_Categories_From (l_ptp_id_from) LOOP
324: OPEN Class_Codes_To(l_ptp_id_to

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

317: where Party_Tax_Profile_id = l_ptp_id_from;
318:
319: l_count := sql%rowcount;
320: arp_message.set_name('AR','AR_ROWS_UPDATED');
321: arp_message.set_token('NUM_ROWS',to_char(l_count));
322:
323: For code_assig IN Class_Categories_From (l_ptp_id_from) LOOP
324: OPEN Class_Codes_To(l_ptp_id_to
325: ,code_assig.class_category

Line 380: --arp_message.set_line(g_api_name||'.'||l_proc_name);

376: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_TAX_AUTH_MERGE ';
377: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
378:
379: BEGIN
380: --arp_message.set_line(g_api_name||'.'||l_proc_name);
381: --------------------------------------------------------------------------------------
382: -- Logging Infra: Setting up runtime level
383: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
384:

Line 404: arp_message.set_line('Updating zx_registrations for tax Authorities...');

400:
401: if p_from_fk_id <> p_to_fk_id then
402: BEGIN
403:
404: arp_message.set_line('Updating zx_registrations for tax Authorities...');
405:
406: update zx_registrations
407: set TAX_AUTHORITY_ID = p_ptp_id_to,
408: last_update_date = sysdate,

Line 431: arp_message.set_line('Updating zx_taxes_b for tax Authorities...');

427: object_version_number = object_version_number+1
428: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
429:
430:
431: arp_message.set_line('Updating zx_taxes_b for tax Authorities...');
432:
433: update zx_taxes_b
434: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
435: last_update_date = sysdate,

Line 450: arp_message.set_line('Updating zx_regimes_b for tax Authorities...');

446: object_version_number = object_version_number+1
447: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
448:
449:
450: arp_message.set_line('Updating zx_regimes_b for tax Authorities...');
451:
452: update zx_regimes_b
453: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
454: last_update_date = sysdate,

Line 468: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');

464: last_update_login = g_login_id,
465: object_version_number = object_version_number+1
466: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
467:
468: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
469:
470: update zx_jurisdictions_b
471: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
472: last_update_date = sysdate,

Line 486: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');

482: last_update_login = g_login_id,
483: object_version_number = object_version_number+1
484: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
485:
486: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
487:
488: update zx_exemptions
489: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
490: last_update_date = sysdate,

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

493: object_version_number = object_version_number+1
494: where ISSUING_TAX_AUTHORITY_ID = p_ptp_id_from;
495:
496: l_count := sql%rowcount;
497: arp_message.set_name('AR','AR_ROWS_UPDATED');
498: arp_message.set_token('NUM_ROWS',to_char(l_count));
499:
500: EXCEPTION
501: WHEN NO_DATA_FOUND THEN

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

494: where ISSUING_TAX_AUTHORITY_ID = p_ptp_id_from;
495:
496: l_count := sql%rowcount;
497: arp_message.set_name('AR','AR_ROWS_UPDATED');
498: arp_message.set_token('NUM_ROWS',to_char(l_count));
499:
500: EXCEPTION
501: WHEN NO_DATA_FOUND THEN
502: NULL;

Line 570: -- arp_message.set_line(g_api_name||'.'||l_proc_name);

566: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_EXEMPTIONS_P ';
567: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
568:
569: BEGIN
570: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
571: --------------------------------------------------------------------------------------
572: -- Logging Infra: Setting up runtime level
573: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
574:

Line 594: arp_message.set_line('Updating exemptions...');

590:
591: if p_from_fk_id <> p_to_fk_id then
592: BEGIN
593:
594: arp_message.set_line('Updating exemptions...');
595: For rec_exe IN exe_number(p_from_fk_id) Loop
596: OPEN to_exemption(rec_exe.exempt_certificate_number
597: ,rec_exe.effective_from
598: ,rec_exe.effective_to

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

612: End IF;
613: CLOSE to_exemption;
614: END Loop;
615: l_count := sql%rowcount;
616: arp_message.set_name('AR','AR_ROWS_UPDATED');
617: arp_message.set_token('NUM_ROWS',to_char(l_count));
618:
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN

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

613: CLOSE to_exemption;
614: END Loop;
615: l_count := sql%rowcount;
616: arp_message.set_name('AR','AR_ROWS_UPDATED');
617: arp_message.set_token('NUM_ROWS',to_char(l_count));
618:
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: NULL;

Line 686: --arp_message.set_line(g_api_name||'.'||l_proc_name);

682: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
683:
684:
685: BEGIN
686: --arp_message.set_line(g_api_name||'.'||l_proc_name);
687: --------------------------------------------------------------------------------------
688: -- Logging Infra: Setting up runtime level
689: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
690:

Line 718: arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||' cannot be merged

714: CLOSE Calculate_Tax_Flag;
715:
716:
717: if(l_calculate_tax_from <> l_calculate_tax_to) THEN
718: arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||' cannot be merged
719: as Calculate Tax Flag has different Values');
720: x_merge_yn := 'N';
721: end if;
722: */

Line 740: arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||' cannot

736:
737: if(l_reg_attr_tbl_to.exists(l_hash_key)) THEN
738: x_merge_yn := 'Y';
739: ELSE
740: arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||' cannot
741: be merged as Registration Attributes have different Values');
742: x_merge_yn := 'N';
743: END IF;
744:

Line 802: -- arp_message.set_line(g_api_name||'.'||l_proc_name);

798: l_procedure_name CONSTANT VARCHAR2(30) := '.ZX_MERGE ';
799: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
800:
801: BEGIN
802: -- arp_message.set_line(g_api_name||'.'||l_proc_name);
803: --------------------------------------------------------------------------------------
804: -- Logging Infra: Setting up runtime level
805: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
806:

Line 827: arp_message.set_line('Identifying Party Type...');

823:
824: if p_from_fk_id <> p_to_fk_id then
825: BEGIN
826:
827: arp_message.set_line('Identifying Party Type...');
828:
829: OPEN Party_Tax_Profile(p_from_fk_id);
830: FETCH Party_Tax_Profile INTO from_ptp_rec;
831: IF Party_Tax_Profile%FOUND THEN

Line 846: arp_message.set_line('Cannot Merge Parties, Party Types are different...');

842: END IF;
843: CLOSE Party_Tax_Profile;
844:
845: if(l_party_type_from <> l_party_type_to) THEN
846: arp_message.set_line('Cannot Merge Parties, Party Types are different...');
847: x_return_status := 'E';
848: return;
849: else
850: if(l_party_type_from = 'THIRD_PARTY') THEN