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.OKL_PARTY_MERGE_PUB dependencies on OKL_PARTY_MERGE_PUB

Line 1: PACKAGE BODY OKL_PARTY_MERGE_PUB AS

1: PACKAGE BODY OKL_PARTY_MERGE_PUB AS
2: /* $Header: OKLPPMGB.pls 120.8.12010000.3 2008/10/21 22:47:54 apaul ship $ */
3:
4: L_MODULE FND_LOG_MESSAGES.MODULE%TYPE;
5: L_DEBUG_ENABLED VARCHAR2(10);

Line 43: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE';

39: p_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
40: l_prof_value VARCHAR2(1);
41: BEGIN
42: l_return_status := OKL_API.G_RET_STS_SUCCESS;
43: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE';
44:
45: -- check for logging on PROCEDURE level
46: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
47: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 212: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE_USE';

208:
209: p_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
210: BEGIN
211: l_return_status := OKL_API.G_RET_STS_SUCCESS;
212: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE_USE';
213:
214: -- check for logging on PROCEDURE level
215: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
216: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 531: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.UPDATE_ASSET_LOCATION';

527: AND HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
528: AND LOP.ID = l_lop_id;
529: BEGIN
530: l_return_status := OKL_API.G_RET_STS_SUCCESS;
531: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.UPDATE_ASSET_LOCATION';
532:
533: -- check for logging on PROCEDURE level
534: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
535: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 1111: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE');

1107: l_merge_reason_code VARCHAR2(30);
1108: l_api_name VARCHAR2(30) := 'OKL_OPEN_INT_PARTY_MERGE';
1109: l_count NUMBER(10) := 0;
1110: BEGIN
1111: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE');
1112: arp_message.set_line('OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE()+');
1113: x_return_status := FND_API.G_RET_STS_SUCCESS;
1114:
1115: select merge_reason_code

Line 1112: arp_message.set_line('OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE()+');

1108: l_api_name VARCHAR2(30) := 'OKL_OPEN_INT_PARTY_MERGE';
1109: l_count NUMBER(10) := 0;
1110: BEGIN
1111: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE');
1112: arp_message.set_line('OKL_PARTY_MERGE_PUB.OKL_OPEN_INT_PARTY_MERGE()+');
1113: x_return_status := FND_API.G_RET_STS_SUCCESS;
1114:
1115: select merge_reason_code
1116: into l_merge_reason_code

Line 1522: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.ITI_OBJECT_ID1_NEW');

1518: l_api_name VARCHAR2(30) := 'ITI_OBJECT_ID1_NEW';
1519: l_count NUMBER(10) := 0;
1520: BEGIN
1521: --Log statements for all input parameters and the procedure name
1522: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.ITI_OBJECT_ID1_NEW');
1523: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
1524: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
1525: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
1526: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 1532: arp_message.set_line('OKL_PARTY_MERGE_PUB.ITI_OBJECT_ID1_NEW()+');

1528: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
1529: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
1530: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
1531:
1532: arp_message.set_line('OKL_PARTY_MERGE_PUB.ITI_OBJECT_ID1_NEW()+');
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534:
1535: select merge_reason_code into l_merge_reason_code
1536: from hz_merge_batch

Line 1650: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.ASS_INSTALL_SITE_ID');

1646: l_api_name VARCHAR2(30) := 'ASS_INSTALL_SITE_ID';
1647: l_count NUMBER(10) := 0;
1648: BEGIN
1649: --Log statements for all input parameters and the procedure name
1650: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.ASS_INSTALL_SITE_ID');
1651: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
1652: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
1653: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
1654: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 1660: arp_message.set_line('OKL_PARTY_MERGE_PUB.ASS_INSTALL_SITE_ID()+');

1656: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
1657: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
1658: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
1659:
1660: arp_message.set_line('OKL_PARTY_MERGE_PUB.ASS_INSTALL_SITE_ID()+');
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: select merge_reason_code
1664: into l_merge_reason_code

Line 1747: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LAP_PARTY_MERGE');

1743: l_api_name VARCHAR2(30) := 'LAP_PARTY_MERGE';
1744: l_count NUMBER(10) := 0;
1745: BEGIN
1746: --Log statements for all input parameters and the procedure name
1747: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LAP_PARTY_MERGE');
1748: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
1749: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
1750: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
1751: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 1757: arp_message.set_line('OKL_PARTY_MERGE_PUB.LAP_PROSPECT_ID()+');

1753: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
1754: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
1755: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
1756:
1757: arp_message.set_line('OKL_PARTY_MERGE_PUB.LAP_PROSPECT_ID()+');
1758:
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760:
1761: select merge_reason_code into l_merge_reason_code

Line 1856: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LOP_PARTY_MERGE');

1852: l_api_name VARCHAR2(30) := 'LOP_PARTY_MERGE';
1853: l_count NUMBER(10) := 0;
1854: BEGIN
1855: --Log statements for all input parameters and the procedure name
1856: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LOP_PARTY_MERGE');
1857: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
1858: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
1859: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
1860: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 1866: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_PARTY_MERGE()+');

1862: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
1863: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
1864: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
1865:
1866: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_PARTY_MERGE()+');
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: select merge_reason_code into l_merge_reason_code
1870: from hz_merge_batch

Line 1975: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LOP_USAGE_LOCATION');

1971: l_api_name VARCHAR2(30) := 'LOP_USAGE_LOCATION';
1972: l_count NUMBER(10) := 0;
1973: BEGIN
1974: --Log statements for all input parameters and the procedure name
1975: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.LOP_USAGE_LOCATION');
1976: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
1977: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
1978: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
1979: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 1985: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_USAGE_LOCATION()+');

1981: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
1982: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
1983: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
1984:
1985: arp_message.set_line('OKL_PARTY_MERGE_PUB.LOP_USAGE_LOCATION()+');
1986: x_return_status := FND_API.G_RET_STS_SUCCESS;
1987:
1988: select merge_reason_code into l_merge_reason_code
1989: from hz_merge_batch

Line 2074: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXS_BILL_TO_PARTY_MERGE');

2070: l_api_name VARCHAR2(30) := 'TXS_BILL_TO_PARTY_MERGE';
2071: l_count NUMBER(10) := 0;
2072: BEGIN
2073: --Log statements for all input parameters and the procedure name
2074: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXS_BILL_TO_PARTY_MERGE');
2075: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2076: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2077: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2078: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2084: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXS_BILL_TO_PARTY_MERGE()+');

2080: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2081: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2082: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2083:
2084: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXS_BILL_TO_PARTY_MERGE()+');
2085: x_return_status := FND_API.G_RET_STS_SUCCESS;
2086:
2087: select merge_reason_code
2088: into l_merge_reason_code

Line 2181: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXS_SHIP_TO_PARTY_MERGE');

2177: l_api_name VARCHAR2(30) := 'TXS_SHIP_TO_PARTY_MERGE';
2178: l_count NUMBER(10) := 0;
2179: BEGIN
2180: --Log statements for all input parameters and the procedure name
2181: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXS_SHIP_TO_PARTY_MERGE');
2182: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2183: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2184: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2185: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2191: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXS_SHIP_TO_PARTY_MERGE()+');

2187: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2188: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2189: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2190:
2191: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXS_SHIP_TO_PARTY_MERGE()+');
2192: x_return_status := FND_API.G_RET_STS_SUCCESS;
2193:
2194: select merge_reason_code
2195: into l_merge_reason_code

Line 2291: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXST_BILL_TO_PARTY_MERGE');

2287: l_api_name VARCHAR2(30) := 'TXST_BILL_TO_PARTY_MERGE';
2288: l_count NUMBER(10) := 0;
2289: BEGIN
2290: --Log statements for all input parameters and the procedure name
2291: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXST_BILL_TO_PARTY_MERGE');
2292: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2293: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2294: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2295: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2301: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXST_BILL_TO_PARTY_MERGE()+');

2297: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2298: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2299: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2300:
2301: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXST_BILL_TO_PARTY_MERGE()+');
2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303:
2304: select merge_reason_code
2305: into l_merge_reason_code

Line 2400: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXST_SHIP_TO_PARTY_MERGE');

2396: l_api_name VARCHAR2(30) := 'TXST_SHIP_TO_PARTY_MERGE';
2397: l_count NUMBER(10) := 0;
2398: BEGIN
2399: --Log statements for all input parameters and the procedure name
2400: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TXST_SHIP_TO_PARTY_MERGE');
2401: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2402: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2403: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2404: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2410: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXST_SHIP_TO_PARTY_MERGE()+');

2406: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2407: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2408: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2409:
2410: arp_message.set_line('OKL_PARTY_MERGE_PUB.TXST_SHIP_TO_PARTY_MERGE()+');
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412:
2413: select merge_reason_code
2414: into l_merge_reason_code

Line 2509: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_NEW');

2505: l_api_name VARCHAR2(30) := 'TCN_PARTY_REL_ID2_NEW';
2506: l_count NUMBER(10) := 0;
2507: BEGIN
2508: --Log statements for all input parameters and the procedure name
2509: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_NEW');
2510: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2511: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2512: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2513: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2519: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_NEW()+');

2515: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2516: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2517: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2518:
2519: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_NEW()+');
2520: x_return_status := FND_API.G_RET_STS_SUCCESS;
2521:
2522: select merge_reason_code
2523: into l_merge_reason_code

Line 2609: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.QPY_PARTY_OBJECT1_ID1');

2605: l_api_name VARCHAR2(30) := 'QPY_PARTY_OBJECT1_ID1';
2606: l_count NUMBER(10) := 0;
2607: BEGIN
2608: --Log statements for all input parameters and the procedure name
2609: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.QPY_PARTY_OBJECT1_ID1');
2610: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2611: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2612: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2613: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2619: arp_message.set_line('OKL_PARTY_MERGE_PUB.QPY_PARTY_OBJECT1_ID1()+');

2615: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2616: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2617: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2618:
2619: arp_message.set_line('OKL_PARTY_MERGE_PUB.QPY_PARTY_OBJECT1_ID1()+');
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: select merge_reason_code
2623: into l_merge_reason_code

Line 2705: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.QPY_CONTACT_OBJECT1_ID1');

2701: l_api_name VARCHAR2(30) := 'QPY_CONTACT_OBJECT1_ID1';
2702: l_count NUMBER(10) := 0;
2703: BEGIN
2704: --Log statements for all input parameters and the procedure name
2705: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.QPY_CONTACT_OBJECT1_ID1');
2706: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2707: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2708: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2709: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2715: arp_message.set_line('OKL_PARTY_MERGE_PUB.QPY_CONTACT_OBJECT1_ID1()+');

2711: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2712: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2713: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2714:
2715: arp_message.set_line('OKL_PARTY_MERGE_PUB.QPY_CONTACT_OBJECT1_ID1()+');
2716: x_return_status := FND_API.G_RET_STS_SUCCESS;
2717:
2718: select merge_reason_code
2719: into l_merge_reason_code

Line 2801: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TIN_PARTY_OBJECT_ID1');

2797: l_api_name VARCHAR2(30) := 'TIN_PARTY_OBJECT_ID1';
2798: l_count NUMBER(10) := 0;
2799: BEGIN
2800: --Log statements for all input parameters and the procedure name
2801: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TIN_PARTY_OBJECT_ID1');
2802: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2803: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2804: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2805: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2811: arp_message.set_line('OKL_PARTY_MERGE_PUB.TIN_PARTY_OBJECT_ID1()+');

2807: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2808: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2809: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2810:
2811: arp_message.set_line('OKL_PARTY_MERGE_PUB.TIN_PARTY_OBJECT_ID1()+');
2812: x_return_status := FND_API.G_RET_STS_SUCCESS;
2813:
2814: select merge_reason_code
2815: into l_merge_reason_code

Line 2987: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE');

2983: l_debug_enabled := okl_debug_pub.check_log_enabled;
2984: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2985: ,fnd_log.level_procedure);
2986: --Log statements for all input parameters and the procedure name
2987: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE');
2988: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2989: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
2990: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
2991: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 2997: arp_message.set_line('OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE()+');

2993: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
2994: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
2995: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
2996:
2997: arp_message.set_line('OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE()+');
2998:
2999: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3000: okl_debug_pub.log_debug(fnd_log.level_procedure
3001: ,l_module

Line 3312: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.CPL_PARTY_SITE_MERGE');

3308: l_api_name VARCHAR2(30) := 'CPL_PARTY_SITE_MERGE';
3309: l_count NUMBER(10) := 0;
3310: BEGIN
3311: --Log statements for all input parameters and the procedure name
3312: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.CPL_PARTY_SITE_MERGE');
3313: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
3314: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
3315: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
3316: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 3322: arp_message.set_line('OKL_PARTY_MERGE_PUB.CPL_PARTY_SITE_MERGE()+');

3318: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
3319: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
3320: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
3321:
3322: arp_message.set_line('OKL_PARTY_MERGE_PUB.CPL_PARTY_SITE_MERGE()+');
3323:
3324: x_return_status := FND_API.G_RET_STS_SUCCESS;
3325:
3326: select merge_reason_code into l_merge_reason_code

Line 3458: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LOP_ACCOUNT_MERGE';

3454: l_last_fetch BOOLEAN := FALSE;
3455: l_count NUMBER;
3456: BEGIN
3457: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3458: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LOP_ACCOUNT_MERGE';
3459:
3460: -- check for logging on PROCEDURE level
3461: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3462: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 3988: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LAP_ACCOUNT_MERGE';

3984: l_last_fetch BOOLEAN := FALSE;
3985: l_count NUMBER;
3986: BEGIN
3987: l_return_status := OKL_API.G_RET_STS_SUCCESS;
3988: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LAP_ACCOUNT_MERGE';
3989:
3990: -- check for logging on PROCEDURE level
3991: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3992: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

Line 5870: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_NEW');

5866: l_api_name VARCHAR2(30) := 'TCN_PARTY_REL_ID1_NEW';
5867: l_count NUMBER(10) := 0;
5868: BEGIN
5869: --Log statements for all input parameters and the procedure name
5870: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_NEW');
5871: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
5872: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
5873: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
5874: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 5880: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_NEW()+');

5876: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
5877: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
5878: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
5879:
5880: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_NEW()+');
5881: x_return_status := FND_API.G_RET_STS_SUCCESS;
5882:
5883: select merge_reason_code
5884: into l_merge_reason_code

Line 5969: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_OLD');

5965: l_api_name VARCHAR2(30) := 'TCN_PARTY_REL_ID1_OLD';
5966: l_count NUMBER(10) := 0;
5967: BEGIN
5968: --Log statements for all input parameters and the procedure name
5969: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_OLD');
5970: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
5971: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
5972: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
5973: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 5979: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_OLD()+');

5975: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
5976: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
5977: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
5978:
5979: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID1_OLD()+');
5980: x_return_status := FND_API.G_RET_STS_SUCCESS;
5981:
5982: select merge_reason_code
5983: into l_merge_reason_code

Line 6068: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_OLD');

6064: l_api_name VARCHAR2(30) := 'TCN_PARTY_REL_ID2_OLD';
6065: l_count NUMBER(10) := 0;
6066: BEGIN
6067: --Log statements for all input parameters and the procedure name
6068: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_OLD');
6069: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
6070: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
6071: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
6072: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 6078: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_OLD()+');

6074: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
6075: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
6076: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
6077:
6078: arp_message.set_line('OKL_PARTY_MERGE_PUB.TCN_PARTY_REL_ID2_OLD()+');
6079: x_return_status := FND_API.G_RET_STS_SUCCESS;
6080:
6081: select merge_reason_code
6082: into l_merge_reason_code

Line 6167: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.RUL_PARTY_SITE_MERGE');

6163: l_api_name VARCHAR2(30) := 'RUL_PARTY_SITE_MERGE';
6164: l_count NUMBER(10) := 0;
6165: BEGIN
6166: --Log statements for all input parameters and the procedure name
6167: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.RUL_PARTY_SITE_MERGE');
6168: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
6169: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);
6170: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);
6171: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);

Line 6177: arp_message.set_line('OKL_PARTY_MERGE_PUB.RUL_PARTY_SITE_MERGE()+');

6173: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
6174: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);
6175: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_id);
6176:
6177: arp_message.set_line('OKL_PARTY_MERGE_PUB.RUL_PARTY_SITE_MERGE()+');
6178: x_return_status := FND_API.G_RET_STS_SUCCESS;
6179:
6180: select merge_reason_code into l_merge_reason_code
6181: from hz_merge_batch

Line 6396: END OKL_PARTY_MERGE_PUB;

6392: arp_message.set_line('RUL_ACCOUNT_MERGE');
6393: RAISE;
6394: END RUL_ACCOUNT_MERGE;
6395:
6396: END OKL_PARTY_MERGE_PUB;