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.IEX_MERGE_PVT dependencies on HZ_ACCT_MERGE_UTIL

Line 97: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

93: NULL;
94: ELSE
95: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
96: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);
97: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
98: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
99:
100: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 120: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

116: goto iex_score_account_site;
117: END IF;
118:
119: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
120: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
121: END LOOP;
122: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 213: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));

209: goto iex_score_account_site_use;
210: END IF;
211:
212: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
213: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
214: END LOOP;
215:
216: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
217: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 303: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

299: exit;
300: END IF;
301:
302: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
303: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
304: END LOOP;
305: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
306: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
307: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 458: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

454: END IF;
455:
456: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
457: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
458: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
459: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
460: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
461: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 485: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

481: goto iex_account;
482: END IF;
483:
484: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
485: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
486:
487: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 old : '||NUM_COL1_ORIG_LIST(I)||' new : '||NUM_COL1_NEW_LIST(I));
488:
489: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 dunning id : '||PRIMARY_KEY_ID_LIST(I));

Line 596: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));

592: EXIT;
593: END IF;
594:
595: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
596: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
597: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
598:
599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));
600:

Line 597: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007

593: END IF;
594:
595: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
596: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
597: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
598:
599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));
600:
601: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 dunning id : '||PRIMARY_KEY_ID_LIST(I));

Line 796: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

792: END IF;
793:
794: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
795: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
796: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
797: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
798:
799: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 822: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

818: goto iex_account;
819: END IF;
820:
821: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
822: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
823: END LOOP;
824:
825: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
826: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 918: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));

914: goto iex_billto;
915: END IF;
916:
917: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
918: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
919: END LOOP;
920: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
921: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
922: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1029: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

1025: exit;
1026: END IF;
1027:
1028: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1029: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1030: END LOOP;
1031: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1032: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1033: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1165: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

1161: NULL;
1162: ELSE
1163: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1164: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1165: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1166: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1167:
1168: open merged_records;
1169: LOOP

Line 1185: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

1181: exit;
1182: END IF;
1183:
1184: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1185: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1186: END LOOP;
1187:
1188: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1343: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

1339: NULL;
1340: ELSE
1341: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1342: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DELINQUENCIES',FALSE);
1343: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1344: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1345:
1346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1347: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);

Line 1381: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

1377: goto iex_delinquency_acc_site_use;
1378: END IF;
1379:
1380: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1381: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1382: END LOOP;
1383:
1384: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1491: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));

1487: exit;
1488: END IF;
1489:
1490: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1491: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1492: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1493: END LOOP;
1494:
1495: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 1492: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

1488: END IF;
1489:
1490: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1491: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
1492: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1493: END LOOP;
1494:
1495: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1496: