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 140: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations...');

136:
137: IF p_from_fk_id <> p_to_fk_id THEN
138: BEGIN
139:
140: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations...');
141:
142: FOR registration_rec IN registration_number(p_from_fk_id,p_to_fk_id)
143: LOOP
144: UPDATE zx_registrations

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

167: l_count := l_count + sql%rowcount;
168:
169: END LOOP;
170:
171: arp_message.set_name('AR','AR_ROWS_UPDATED');
172: arp_message.set_token('NUM_ROWS',to_char(l_count));
173:
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN

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

168:
169: END LOOP;
170:
171: arp_message.set_name('AR','AR_ROWS_UPDATED');
172: arp_message.set_token('NUM_ROWS',to_char(l_count));
173:
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: NULL;

Line 268: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_party_tax_profile...');

264:
265: IF p_from_fk_id <> p_to_fk_id THEN
266:
267: BEGIN
268: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_party_tax_profile...');
269:
270: OPEN Party_Tax_Profile(p_from_fk_id);
271: FETCH Party_Tax_Profile INTO from_ptp_rec;
272: IF Party_Tax_Profile%FOUND THEN

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

290: object_version_number = object_version_number+1
291: WHERE Party_Tax_Profile_id = l_ptp_id_from;
292:
293: l_count := sql%rowcount;
294: arp_message.set_name('AR','AR_ROWS_UPDATED');
295: arp_message.set_token('NUM_ROWS',to_char(l_count));
296:
297: FOR code_assig IN Class_Categories_From (l_ptp_id_from) LOOP
298: OPEN Class_Codes_To(l_ptp_id_to

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

291: WHERE Party_Tax_Profile_id = l_ptp_id_from;
292:
293: l_count := sql%rowcount;
294: arp_message.set_name('AR','AR_ROWS_UPDATED');
295: arp_message.set_token('NUM_ROWS',to_char(l_count));
296:
297: FOR code_assig IN Class_Categories_From (l_ptp_id_from) LOOP
298: OPEN Class_Codes_To(l_ptp_id_to
299: ,code_assig.class_category

Line 374: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations for tax Authorities...');

370:
371: if p_from_fk_id <> p_to_fk_id THEN
372: BEGIN
373:
374: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations for tax Authorities...');
375:
376: UPDATE zx_registrations
377: set TAX_AUTHORITY_ID = p_ptp_id_to,
378: last_update_date = SYSDATE,

Line 400: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_taxes_b for tax Authorities...');

396: last_update_login = G_LOGIN_ID,
397: object_version_number = object_version_number+1
398: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
399:
400: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_taxes_b for tax Authorities...');
401:
402: UPDATE zx_taxes_b
403: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
404: last_update_date = SYSDATE,

Line 418: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_regimes_b for tax Authorities...');

414: last_update_login = G_LOGIN_ID,
415: object_version_number = object_version_number+1
416: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
417:
418: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_regimes_b for tax Authorities...');
419:
420: UPDATE zx_regimes_b
421: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
422: last_update_date = SYSDATE,

Line 436: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');

432: last_update_login = G_LOGIN_ID,
433: object_version_number = object_version_number+1
434: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
435:
436: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
437:
438: UPDATE zx_jurisdictions_b
439: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
440: last_update_date = SYSDATE,

Line 454: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');

450: last_update_login = G_LOGIN_ID,
451: object_version_number = object_version_number+1
452: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
453:
454: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
455:
456: UPDATE zx_exemptions
457: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
458: last_update_date = SYSDATE,

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

461: object_version_number = object_version_number+1
462: WHERE ISSUING_TAX_AUTHORITY_ID = p_ptp_id_from;
463:
464: l_count := sql%rowcount;
465: arp_message.set_name('AR','AR_ROWS_UPDATED');
466: arp_message.set_token('NUM_ROWS',to_char(l_count));
467:
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN

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

462: WHERE ISSUING_TAX_AUTHORITY_ID = p_ptp_id_from;
463:
464: l_count := sql%rowcount;
465: arp_message.set_name('AR','AR_ROWS_UPDATED');
466: arp_message.set_token('NUM_ROWS',to_char(l_count));
467:
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: NULL;

Line 588: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating exemptions...');

584:
585: if p_from_fk_id <> p_to_fk_id THEN
586: BEGIN
587:
588: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating exemptions...');
589: FOR rec_exe IN exe_number(p_from_fk_id)
590: Loop
591: OPEN to_exemption(rec_exe.exempt_certificate_number
592: ,rec_exe.effective_from

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

621: CLOSE to_exemption;
622:
623: End Loop;
624:
625: arp_message.set_name('AR','AR_ROWS_UPDATED');
626: arp_message.set_token('NUM_ROWS',to_char(l_count));
627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN

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

622:
623: End Loop;
624:
625: arp_message.set_name('AR','AR_ROWS_UPDATED');
626: arp_message.set_token('NUM_ROWS',to_char(l_count));
627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: NULL;

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

763: -- END IF;
764: -- CLOSE Calculate_Tax_Flag;
765: --
766: -- if(l_calculate_tax_from <> l_calculate_tax_to) THEN
767: -- arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||' cannot be merged
768: -- as Calculate Tax Flag has different Values');
769: -- x_merge_yn := 'N';
770: -- end if;
771: --

Line 783: -- arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||

779: -- l_hash_key := DBMS_UTILITY.get_hash_value(REC.REGISTRATION_TYPE_CODE||REC.REGISTRATION_NUMBER||REC.ROUNDING_RULE_CODE||REC.SELF_ASSESS_FLAG||REC.INCLUSIVE_TAX_FLAG,1,TABLE_SIZE);
780: -- if(l_reg_attr_tbl_to.exists(l_hash_key)) THEN
781: -- x_merge_yn := 'Y';
782: -- ELSE
783: -- arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||
784: -- ' cannot be merged as Registration Attributes have different Values');
785: -- x_merge_yn := 'N';
786: -- END IF;
787:

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

797: 'Parties '||p_ptp_id_from||' and '||p_ptp_id_to||
798: ' cannot be merged as Registration Attributes have different Values (A-B)'
799: );
800: END IF;
801: arp_message.set_line('Parties '||p_from_fk_id||' and '||p_to_fk_id||
802: ' cannot be merged as Registration Attributes have different Values (A-B)');
803: x_merge_yn := 'N';
804: CLOSE Registration_Attributes;
805: return;

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

819: 'Parties '||p_ptp_id_to||' and '||p_ptp_id_from||
820: ' cannot be merged as Registration Attributes have different Values (B-A)'
821: );
822: END IF;
823: arp_message.set_line('Parties '||p_to_fk_id ||' and '||p_from_fk_id||
824: ' cannot be merged as Registration Attributes have different Values (B-A)');
825: x_merge_yn := 'N';
826: CLOSE Registration_Attributes_Exist;
827: return;

Line 909: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Identifying Party Type...');

905:
906: if p_from_fk_id <> p_to_fk_id THEN
907: BEGIN
908:
909: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Identifying Party Type...');
910:
911: OPEN Party_Tax_Profile(p_from_fk_id);
912: FETCH Party_Tax_Profile INTO from_ptp_rec;
913: IF Party_Tax_Profile%FOUND THEN

Line 928: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Cannot Merge Parties, Party Types are different...');

924: END IF;
925: CLOSE Party_Tax_Profile;
926:
927: if(l_party_type_from <> l_party_type_to) THEN
928: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Cannot Merge Parties, Party Types are different...');
929: x_return_status := 'E';
930: return;
931: else
932: if(l_party_type_from = 'THIRD_PARTY') THEN

Line 1041: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Begin with param request id: '||request_id);

1037: l_tbl_to_acct_site_id bulk_number_type;
1038:
1039:
1040: BEGIN
1041: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Begin with param request id: '||request_id);
1042: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1043: -- Logging Infra: Procedure level
1044: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 1089: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'from party id - to party id - ptp id');

1085: AND ptp.party_type_code = 'THIRD_PARTY_SITE'
1086: )
1087: WHERE party_site_num = 1;
1088:
1089: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'from party id - to party id - ptp id');
1090: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1091: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,'from party id - to party id - ptp id');
1092: END IF;
1093:

Line 1099: arp_message.set_line(G_MODULE_NAME||l_procedure_name||l_tbl_from_party_site_id(i)||' - '|| l_tbl_to_party_site_id(i)||' - '||l_tbl_to_ptp_id(i));

1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1096: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1097: l_tbl_from_party_site_id(i)||' - '|| l_tbl_to_party_site_id(i)||' - '||l_tbl_to_ptp_id(i));
1098: END IF;
1099: arp_message.set_line(G_MODULE_NAME||l_procedure_name||l_tbl_from_party_site_id(i)||' - '|| l_tbl_to_party_site_id(i)||' - '||l_tbl_to_ptp_id(i));
1100: END LOOP;
1101:
1102: IF l_tbl_from_ptp_id.count > 0 THEN
1103: --

Line 1110: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting party tax profile records');

1106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1107: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1108: 'Inserting party tax profile records');
1109: END IF;
1110: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting party tax profile records');
1111: FORALL i IN 1..l_tbl_to_ptp_id.count
1112: INSERT INTO ZX_PARTY_TAX_PROFILE
1113: (party_type_code
1114: ,supplier_flag

Line 1238: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting registration records');

1234: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1235: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1236: 'Inserting registration records');
1237: END IF;
1238: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting registration records');
1239: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1240: FORALL i in 1..l_tbl_from_ptp_id.count
1241: INSERT INTO ZX_REGISTRATIONS
1242: (registration_type_code

Line 1386: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting exemption records');

1382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1383: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1384: 'Inserting exemption records');
1385: END IF;
1386: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting exemption records');
1387: FORALL i in 1..l_tbl_from_ptp_id.count
1388: INSERT INTO zx_exemptions
1389: (tax_exemption_id
1390: ,exemption_type_code

Line 1501: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'end');

1497:
1498: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1499: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'end');
1500: END IF;
1501: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'end');
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1508: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Exception - '||SQLERRM);

1504: WHEN OTHERS THEN
1505: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1506: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,'Exception - '||SQLERRM);
1507: END IF;
1508: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Exception - '||SQLERRM);
1509: END MERGE_PTP_BULK;
1510:
1511: ---------------------------------
1512: -- Merge Party Site Registrations