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 ARP_MESSAGE

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

91:
92: IF process_mode='LOCK' THEN
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:

Line 96: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);

92: IF process_mode='LOCK' THEN
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' */

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

182: goto iex_score_account_site;
183: END IF;
184: END LOOP;
185:
186: arp_message.set_name('AR','AR_ROWS_UPDATED');
187: arp_message.set_token('NUM_ROWS',to_char(l_count));
188:
189: <>
190: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT_SITE' */

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

183: END IF;
184: END LOOP;
185:
186: arp_message.set_name('AR','AR_ROWS_UPDATED');
187: arp_message.set_token('NUM_ROWS',to_char(l_count));
188:
189: <>
190: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT_SITE' */
191: MERGE_HEADER_ID_LIST.delete;

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

364: EXIT;
365: END IF;
366: END LOOP;
367:
368: arp_message.set_name('AR','AR_ROWS_UPDATED');
369: arp_message.set_token('NUM_ROWS',to_char(l_count));
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN

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

365: END IF;
366: END LOOP;
367:
368: arp_message.set_name('AR','AR_ROWS_UPDATED');
369: arp_message.set_token('NUM_ROWS',to_char(l_count));
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_message.set_line('SCORE_HISTORY_MERGE');

Line 373: arp_message.set_line('SCORE_HISTORY_MERGE');

369: arp_message.set_token('NUM_ROWS',to_char(l_count));
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_message.set_line('SCORE_HISTORY_MERGE');
374: RAISE;
375: END SCORE_HISTORY_MERGE;
376:
377: /*-------------------------------------------------------------

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

452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
453:
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);

Line 457: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);

453:
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 */

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

562: END LOOP;
563:
564:
565: <>
566: arp_message.set_name('AR','AR_ROWS_UPDATED');
567: arp_message.set_token('NUM_ROWS',to_char(l_count));
568:
569:
570: /* process IEX_DUNNINGS.DUNNING_OBJECT_ID where DUNNING_LEVEL = 'BILLTO' */

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

563:
564:
565: <>
566: arp_message.set_name('AR','AR_ROWS_UPDATED');
567: arp_message.set_token('NUM_ROWS',to_char(l_count));
568:
569:
570: /* process IEX_DUNNINGS.DUNNING_OBJECT_ID where DUNNING_LEVEL = 'BILLTO' */
571: MERGE_HEADER_ID_LIST.delete;

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

665: EXIT;
666: END IF;
667: END LOOP;
668:
669: arp_message.set_name('AR','AR_ROWS_UPDATED');
670: arp_message.set_token('NUM_ROWS',to_char(l_count));
671: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
672:
673: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');

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

666: END IF;
667: END LOOP;
668:
669: arp_message.set_name('AR','AR_ROWS_UPDATED');
670: arp_message.set_token('NUM_ROWS',to_char(l_count));
671: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
672:
673: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');
674: END IF;

Line 682: arp_message.set_line( 'DUNNNING_MERGE');

678: EXCEPTION
679: WHEN OTHERS THEN
680: FND_FILE.put_line( FND_FILE.LOG,'IEX_MERGE_PVT.DUNNNING_MERGE EXCEPTION');
681: FND_FILE.PUT_LINE(FND_FILE.LOG,'DUNNNING_MERGE : ' || SQLERRM);
682: arp_message.set_line( 'DUNNNING_MERGE');
683: RAISE;
684: END DUNNING_MERGE;
685:
686: /*-------------------------------------------------------------

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

790: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
791: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
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:

Line 795: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);

791: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
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 */

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

883: goto iex_account;
884: END IF;
885: END LOOP;
886:
887: arp_message.set_name('AR','AR_ROWS_UPDATED');
888: arp_message.set_token('NUM_ROWS',to_char(l_count));
889:
890: <>
891: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT' */

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

884: END IF;
885: END LOOP;
886:
887: arp_message.set_name('AR','AR_ROWS_UPDATED');
888: arp_message.set_token('NUM_ROWS',to_char(l_count));
889:
890: <>
891: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT' */
892: MERGE_HEADER_ID_LIST.delete;

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

994: goto iex_billto;
995: END IF;
996: END LOOP;
997:
998: arp_message.set_name('AR','AR_ROWS_UPDATED');
999: arp_message.set_token('NUM_ROWS',to_char(l_count));
1000:
1001: <>
1002:

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

995: END IF;
996: END LOOP;
997:
998: arp_message.set_name('AR','AR_ROWS_UPDATED');
999: arp_message.set_token('NUM_ROWS',to_char(l_count));
1000:
1001: <>
1002:
1003: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_BILLTO' */

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

1102: EXIT;
1103: END IF;
1104: END LOOP;
1105:
1106: arp_message.set_name('AR','AR_ROWS_UPDATED');
1107: arp_message.set_token('NUM_ROWS',to_char(l_count));
1108:
1109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1110: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');

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

1103: END IF;
1104: END LOOP;
1105:
1106: arp_message.set_name('AR','AR_ROWS_UPDATED');
1107: arp_message.set_token('NUM_ROWS',to_char(l_count));
1108:
1109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1110: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');
1111: END IF;

Line 1116: arp_message.set_line( 'STRATEGY_MERGE');

1112:
1113: END IF;
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: arp_message.set_line( 'STRATEGY_MERGE');
1117: RAISE;
1118: END STRATEGY_MERGE;
1119:
1120:

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

1159: BEGIN
1160: IF process_mode='LOCK' THEN
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:

Line 1164: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);

1160: IF process_mode='LOCK' THEN
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;

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

1233: EXIT;
1234: END IF;
1235: END LOOP;
1236:
1237: arp_message.set_name('AR','AR_ROWS_UPDATED');
1238: arp_message.set_token('NUM_ROWS',to_char(l_count));
1239: END IF;
1240: EXCEPTION
1241: WHEN OTHERS THEN

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

1234: END IF;
1235: END LOOP;
1236:
1237: arp_message.set_name('AR','AR_ROWS_UPDATED');
1238: arp_message.set_token('NUM_ROWS',to_char(l_count));
1239: END IF;
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: arp_message.set_line( 'PROMISE_MERGE');

Line 1242: arp_message.set_line( 'PROMISE_MERGE');

1238: arp_message.set_token('NUM_ROWS',to_char(l_count));
1239: END IF;
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: arp_message.set_line( 'PROMISE_MERGE');
1243: RAISE;
1244: END PROMISE_MERGE;
1245:
1246: PROCEDURE DELINQUENCY_MERGE (

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

1337:
1338: IF process_mode='LOCK' THEN
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:

Line 1342: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DELINQUENCIES',FALSE);

1338: IF process_mode='LOCK' THEN
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

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

1449: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1450: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' ACCOUNT records');
1451: END IF;
1452:
1453: arp_message.set_name('AR','AR_ROWS_UPDATED');
1454: arp_message.set_token('NUM_ROWS',to_char(l_count));
1455:
1456: <>
1457: /* merging CUSTOMER_SITE_USE_ID */

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

1450: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' ACCOUNT records');
1451: END IF;
1452:
1453: arp_message.set_name('AR','AR_ROWS_UPDATED');
1454: arp_message.set_token('NUM_ROWS',to_char(l_count));
1455:
1456: <>
1457: /* merging CUSTOMER_SITE_USE_ID */
1458:

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

1561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1562: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' CUSTOMER_SITE_USE_ID records');
1563: END IF;
1564:
1565: arp_message.set_name('AR','AR_ROWS_UPDATED');
1566: arp_message.set_token('NUM_ROWS',to_char(l_count));
1567:
1568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1569: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');

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

1562: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' CUSTOMER_SITE_USE_ID records');
1563: END IF;
1564:
1565: arp_message.set_name('AR','AR_ROWS_UPDATED');
1566: arp_message.set_token('NUM_ROWS',to_char(l_count));
1567:
1568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1569: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');
1570: END IF;

Line 1578: arp_message.set_line('DELINQUENCY_MERGE');

1574: WHEN OTHERS THEN
1575: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1576: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');
1577: END IF;
1578: arp_message.set_line('DELINQUENCY_MERGE');
1579: RAISE;
1580: END DELINQUENCY_MERGE;
1581:
1582: PROCEDURE MERGE_DELINQUENCY_PARTIES(p_entity_name IN VARCHAR2,

Line 2036: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);

2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
2034: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2035: END IF;
2036: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: raise;
2039: END;
2040: END IF;