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 IEX_MERGE_PVT

Line 1: PACKAGE BODY IEX_MERGE_PVT as

1: PACKAGE BODY IEX_MERGE_PVT as
2: /* $Header: iexvmrgb.pls 120.9.12020000.2 2012/08/30 05:18:26 snuthala ship $ */
3:
4: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 89: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');

85:
86: BEGIN
87:
88: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
89: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');
90: END IF;
91:
92: IF process_mode='LOCK' THEN
93: NULL;

Line 446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');

442: BEGIN
443: IF process_mode='LOCK' THEN
444: NULL;
445: ELSE
446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);

Line 448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');

444: NULL;
445: ELSE
446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

Line 487: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 old : '||NUM_COL1_ORIG_LIST(I)||' new : '||NUM_COL1_NEW_LIST(I));

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));
490:
491:

Line 489: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 dunning id : '||PRIMARY_KEY_ID_LIST(I));

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));
490:
491:
492: END LOOP;
493:

Line 599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));

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));
602:
603: END LOOP;

Line 601: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 dunning id : '||PRIMARY_KEY_ID_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));
602:
603: END LOOP;
604: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
605: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 673: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');

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;
675:
676: END IF;
677:

Line 680: FND_FILE.put_line( FND_FILE.LOG,'IEX_MERGE_PVT.DUNNNING_MERGE EXCEPTION');

676: END IF;
677:
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;

Line 791: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');

787: IF process_mode='LOCK' THEN
788: NULL;
789: ELSE
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);

Line 1110: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');

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;
1112:
1113: END IF;
1114: EXCEPTION

Line 1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');

1327: l_count NUMBER;
1328: BEGIN
1329:
1330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

Line 1569: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');

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;
1571:
1572: END IF;
1573: EXCEPTION

Line 1576: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');

1572: END IF;
1573: EXCEPTION
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;

Line 1949: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');

1945: l_api_version_number CONSTANT NUMBER := 1.0;
1946: l_merge_reason_code VARCHAR2(30);
1947: BEGIN
1948: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1949: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');
1950: END IF;
1951: x_return_status := FND_API.G_RET_STS_SUCCESS;
1952:
1953: select merge_reason_code into l_merge_reason_code

Line 2033: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');

2029: END IF;
2030: EXCEPTION
2031: WHEN OTHERS THEN
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;

Line 2034: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);

2030: EXCEPTION
2031: WHEN OTHERS THEN
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;

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;

Line 2043: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');

2039: END;
2040: END IF;
2041:
2042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2043: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');
2044: END IF;
2045:
2046: END CASE_CONTACT_MERGE;
2047:

Line 2051: END IEX_MERGE_PVT;

2047:
2048: /* End - Andre Araujo - 05/04/03 - Add Contact points and Address Merge */
2049:
2050:
2051: END IEX_MERGE_PVT;