DBA Data[Home] [Help]

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.3.12010000.2 2008/08/14 13:37:03 schekuri 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 87: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');

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

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

414: IF process_mode='LOCK' THEN
415: NULL;
416: ELSE
417: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
418: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
419: END IF;
420:
421: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
422: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);

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

592:
593: arp_message.set_name('AR','AR_ROWS_UPDATED');
594: arp_message.set_token('NUM_ROWS',to_char(l_count));
595: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
596: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');
597: END IF;
598:
599: END IF;
600: EXCEPTION

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

706: IF process_mode='LOCK' THEN
707: NULL;
708: ELSE
709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
710: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
711: END IF;
712:
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);

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

994: arp_message.set_name('AR','AR_ROWS_UPDATED');
995: arp_message.set_token('NUM_ROWS',to_char(l_count));
996:
997: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
998: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');
999: END IF;
1000:
1001: END IF;
1002: EXCEPTION

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

1205: l_count NUMBER;
1206: BEGIN
1207:
1208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

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

1443: arp_message.set_name('AR','AR_ROWS_UPDATED');
1444: arp_message.set_token('NUM_ROWS',to_char(l_count));
1445:
1446: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1447: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');
1448: END IF;
1449:
1450: END IF;
1451: EXCEPTION

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

1450: END IF;
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1454: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');
1455: END IF;
1456: arp_message.set_line('DELINQUENCY_MERGE');
1457: RAISE;
1458: END DELINQUENCY_MERGE;

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

1823: l_api_version_number CONSTANT NUMBER := 1.0;
1824: l_merge_reason_code VARCHAR2(30);
1825: BEGIN
1826: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1827: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');
1828: END IF;
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830:
1831: select merge_reason_code into l_merge_reason_code

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

1907: END IF;
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1913: END IF;
1914: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1915: x_return_status := FND_API.G_RET_STS_ERROR;

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

1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1913: END IF;
1914: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: raise;

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

1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1913: END IF;
1914: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: raise;
1917: END;
1918: END IF;

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

1917: END;
1918: END IF;
1919:
1920: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1921: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');
1922: END IF;
1923:
1924: END CASE_CONTACT_MERGE;
1925:

Line 1929: END IEX_MERGE_PVT;

1925:
1926: /* End - Andre Araujo - 05/04/03 - Add Contact points and Address Merge */
1927:
1928:
1929: END IEX_MERGE_PVT;