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 FND_API

Line 261: p_init_msg_list => FND_API.G_TRUE,

257: ,'begin debug call HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE');
258: END IF;
259:
260: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE(
261: p_init_msg_list => FND_API.G_TRUE,
262: p_party_site_use_rec => p_party_site_use_rec,
263: x_party_site_use_id => x_new_party_site_use_id,
264: x_return_status => l_return_status,
265: x_msg_count => x_msg_count,

Line 779: x_return_status := FND_API.G_RET_STS_SUCCESS;

775: l_count NUMBER(10) := 0;
776: BEGIN
777: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE');
778: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: select merge_reason_code
782: into l_merge_reason_code
783: from hz_merge_batch

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
830: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
831: 'OKL_INS_POLICIES for = '|| p_from_id));
832: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: end;
835: end if;
836: END OKL_INSURANCE_PARTY_MERGE ;
837:

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861: l_count NUMBER(10) := 0;
862: BEGIN
863: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE');
864: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE()+');
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: select merge_reason_code
868: into l_merge_reason_code
869: from hz_merge_batch

Line 918: x_return_status := FND_API.G_RET_STS_ERROR;

914: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
915: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
916: 'OKL_INS_POLICIES for = '|| p_from_id));
917: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: end;
920: end if;
921: END OKL_INSURANCE_PARTY_SITE_MERGE ;
922:

Line 950: x_return_status := FND_API.G_RET_STS_SUCCESS;

946: l_count NUMBER(10) := 0;
947: BEGIN
948: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE');
949: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE()+');
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: select merge_reason_code
953: into l_merge_reason_code
954: from hz_merge_batch

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR;

999: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1000: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1001: 'OKL_INS_POLICIES for = '|| p_from_id));
1002: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004: end;
1005: end if;
1006: END OKL_INSURANCE_AGENT_MERGE ;
1007:

Line 1035: x_return_status := FND_API.G_RET_STS_SUCCESS;

1031: l_count NUMBER(10) := 0;
1032: BEGIN
1033: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE');
1034: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE()+');
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;
1036:
1037: select merge_reason_code
1038: into l_merge_reason_code
1039: from hz_merge_batch

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1084: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1085: 'OKL_INS_POLICIES for = '|| p_from_id));
1086: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: end;
1089: end if;
1090: END OKL_INSURANCE_AGENT_SITE_MERGE ;
1091:

Line 1113: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1117: from hz_merge_batch

Line 1165: x_return_status := FND_API.G_RET_STS_ERROR;

1161: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1162: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1163: 'OKL_OPEN_INT_ALL for = '|| p_from_id));
1164: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: end;
1167: end if;
1168: END OKL_OPEN_INT_PARTY_MERGE ;
1169:

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: l_api_name VARCHAR2(30) := 'PARTY_MERGE_PAC_ID';
1194: BEGIN
1195: FND_FILE.put_line(fnd_file.log, 'OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_PAC_ID');
1196: ARP_MESSAGE.set_line('OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_PAC_ID()+');
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: SELECT merge_reason_code
1200: INTO l_merge_reason_code
1201: FROM hz_merge_batch

Line 1245: x_return_status := FND_API.G_RET_STS_ERROR;

1241: ARP_MESSAGE.set_line(G_PKG_NAME|| '.' ||l_api_name||': '|| sqlerrm);
1242: FND_FILE.put_line(FND_FILE.log,
1243: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));
1244: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246: END;
1247: END IF;
1248: END party_merge_pac_id ;
1249:

Line 1275: x_return_status := FND_API.G_RET_STS_SUCCESS;

1271: l_api_name VARCHAR2(30) := 'PARTY_MERGE_IST_ID';
1272: BEGIN
1273: FND_FILE.put_line(fnd_file.log, 'OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_IST_ID');
1274: ARP_MESSAGE.set_line('OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_IST_ID()+');
1275: x_return_status := FND_API.G_RET_STS_SUCCESS;
1276:
1277: SELECT merge_reason_code
1278: INTO l_merge_reason_code
1279: FROM hz_merge_batch

Line 1324: x_return_status := FND_API.G_RET_STS_ERROR;

1320: ARP_MESSAGE.set_line(G_PKG_NAME|| '.' ||l_api_name||': '|| sqlerrm);
1321: FND_FILE.put_line(FND_FILE.log,
1322: (G_PKG_NAME|| '.'||l_api_name ||'OKL_RELOCATE_ASTS_ALL_B for = '|| p_from_id));
1323: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: END;
1326: END IF;
1327: END party_merge_ist_id ;
1328: -- End BAKUCHIB Bug#2892149

Line 1346: x_return_status := FND_API.G_RET_STS_SUCCESS;

1342: l_api_name VARCHAR2(30) := 'okl_cnr_party_merge';
1343: BEGIN
1344: fnd_file.put_line(fnd_file.log, 'okl_cnr_pvt.okl_cnr_party_merge');
1345: arp_message.set_line('okl_cnr_pvt.okl_cnr_party_merge()+');
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348: --OKL_CNSLD_AR_HDRS_ALL_B stores reference to Customer Account Site Usage in column IBT_ID
1349: --Account Merge logic is moved to CNR_ACCOUNT_MERGE API which is called during
1350: --Account Merge process

Line 1358: x_return_status := FND_API.G_RET_STS_ERROR;

1354: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1355: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1356: 'OKL_CNR_PVT for = '|| p_from_id));
1357: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: END okl_cnr_party_merge;
1360:
1361: PROCEDURE OKL_XSI_PARTY_MERGE (
1362: p_entity_name IN VARCHAR2,

Line 1376: x_return_status := FND_API.G_RET_STS_SUCCESS;

1372: l_api_name VARCHAR2(30) := 'OKL_XSI_PARTY_MERGE';
1373: BEGIN
1374: fnd_file.put_line(fnd_file.log, 'Okl_Xsi_Pvt.OKL_XSI_PARTY_MERGE');
1375: arp_message.set_line('Okl_Xsi_Pvt.OKL_XSI_PARTY_MERGE()+');
1376: x_return_status := FND_API.G_RET_STS_SUCCESS;
1377:
1378: --OKL_EXT_SELL_INVS_ALL_B stores reference to Customer Account in column CUSTOMER_ID
1379: --Account Merge logic is moved to XSI_ACCOUNT_MERGE API which is called during
1380: --Account Merge process

Line 1388: x_return_status := FND_API.G_RET_STS_ERROR;

1384: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1385: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1386: 'OKL_XSI_PARTY_MERGE for = '|| p_from_id));
1387: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1388: x_return_status := FND_API.G_RET_STS_ERROR;
1389: END OKL_XSI_PARTY_MERGE ;
1390:
1391: PROCEDURE OKL_TAI_PARTY_MERGE (
1392: p_entity_name IN VARCHAR2,

Line 1406: x_return_status := FND_API.G_RET_STS_SUCCESS;

1402: l_api_name VARCHAR2(30) := 'OKL_TAI_PARTY_MERGE';
1403: BEGIN
1404: fnd_file.put_line(fnd_file.log, 'Okl_Tai_Pvt.OKL_TAI_PARTY_MERGE');
1405: arp_message.set_line('Okl_Tai_Pvt.OKL_TAI_PARTY_MERGE()+');
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407:
1408: --OKL_TRX_AR_INVOICES_B stores reference to Customer Account Site Use in column IBT_ID
1409: --Account Merge logic is moved to TAI_ACCOUNT_MERGE API which is called during
1410: --Account Merge process

Line 1418: x_return_status := FND_API.G_RET_STS_ERROR;

1414: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1415: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1416: 'OKL_TAI_PARTY_MERGE for = '|| p_from_id));
1417: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END OKL_TAI_PARTY_MERGE;
1420:
1421: --start merge code pjgomes
1422: --procedure for install at site merge routine for party merge

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437: l_count NUMBER(10) := 0;
1438: BEGIN
1439: fnd_file.put_line(fnd_file.log, 'OKL_LLA_UTIL_PVT.INSTALL_AT_SITE_MERGE');
1440: arp_message.set_line('OKL_LLA_UTIL_PVT.INSTALL_AT_SITE_MERGE()+');
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: select merge_reason_code
1444: into l_merge_reason_code
1445: from hz_merge_batch

Line 1492: x_return_status := FND_API.G_RET_STS_ERROR;

1488: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1489: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1490: 'OKL_INSTALL_SITE_MERGE for = '|| p_from_id));
1491: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: end;
1494: end if;
1495: END OKL_INSTALL_SITE_MERGE ;
1496:

Line 1533: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1537: where batch_id = p_batch_id;

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR;

1584: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1585: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1586: 'OKL_TXL_ITM_INSTS for = '|| p_from_id));
1587: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END;
1590: END IF;
1591: END ITI_OBJECT_ID1_NEW ;
1592:

Line 1609: x_return_status := FND_API.G_RET_STS_SUCCESS;

1605: l_api_name VARCHAR2(30) := 'OKL_RCA_PARTY_MERGE';
1606: BEGIN
1607: fnd_file.put_line(fnd_file.log, 'OKL_RCA_PVT.OKL_RCA_PARTY_MERGE');
1608: arp_message.set_line('OKL_RCA_PVT.OKL_RCA_PARTY_MERGE()+');
1609: x_return_status := FND_API.G_RET_STS_SUCCESS;
1610:
1611: --OKL_TXL_RCPT_APPS_ALL_B stores reference to Customer Account in column ILE_ID
1612: --Account Merge logic is moved to RCA_ACCOUNT_MERGE API which is called during
1613: --Account Merge process

Line 1621: x_return_status := FND_API.G_RET_STS_ERROR;

1617: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1618: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1619: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
1620: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: END OKL_RCA_PARTY_MERGE;
1623:
1624: ----------------------------------------------------------------------------------------------------------
1625: -- Start of comments

Line 1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1665: from hz_merge_batch

Line 1715: x_return_status := FND_API.G_RET_STS_ERROR;

1711: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1712: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1713: 'OKL_ASSETS_B for INSTALL_SITE_ID = '|| p_from_id));
1714: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1715: x_return_status := FND_API.G_RET_STS_ERROR;
1716: end;
1717: end if;
1718: END ASS_INSTALL_SITE_ID ;
1719:

Line 1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1762: from hz_merge_batch
1763: where batch_id = p_batch_id;

Line 1824: x_return_status := FND_API.G_RET_STS_ERROR;

1820: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1821: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1822: 'OKL_LEASE_APPS_ALL_B for = '|| p_from_id));
1823: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: END;
1826: END IF;
1827: END LAP_PARTY_MERGE ;
1828:

Line 1867: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1871: where batch_id = p_batch_id;

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1940: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1941: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));
1942: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: END;
1945: END IF;
1946: END LOP_PARTY_MERGE ;
1947:

Line 1986: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1990: where batch_id = p_batch_id;

Line 2042: x_return_status := FND_API.G_RET_STS_ERROR;

2038: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2039: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2040: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));
2041: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: END;
2044: END IF;
2045: END LOP_USAGE_LOCATION ;
2046:

Line 2085: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2089: from hz_merge_batch

Line 2149: x_return_status := FND_API.G_RET_STS_ERROR;

2145: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2146: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2147: 'OKL_TAX_SOURCES for = '|| p_from_id));
2148: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2149: x_return_status := FND_API.G_RET_STS_ERROR;
2150: end;
2151: end if;
2152: END TXS_BILL_TO_PARTY_MERGE ;
2153:

Line 2192: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2196: from hz_merge_batch

Line 2258: x_return_status := FND_API.G_RET_STS_ERROR;

2254: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2255: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2256: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2257: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: end;
2260: end if;
2261: END TXS_SHIP_TO_PARTY_MERGE ;
2262:

Line 2302: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2306: from hz_merge_batch

Line 2368: x_return_status := FND_API.G_RET_STS_ERROR;

2364: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2365: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2366: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2367: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: end;
2370: end if;
2371: END TXST_BILL_TO_PARTY_MERGE ;
2372:

Line 2411: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2415: from hz_merge_batch

Line 2477: x_return_status := FND_API.G_RET_STS_ERROR;

2473: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2474: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2475: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2476: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: end;
2479: end if;
2480: END TXST_SHIP_TO_PARTY_MERGE ;
2481:

Line 2520: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2524: from hz_merge_batch

Line 2577: x_return_status := FND_API.G_RET_STS_ERROR;

2573: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2574: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2575: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2576: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2577: x_return_status := FND_API.G_RET_STS_ERROR;
2578: end;
2579: end if;
2580: END TCN_PARTY_REL_ID2_NEW ;
2581:

Line 2620: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2624: from hz_merge_batch

Line 2673: x_return_status := FND_API.G_RET_STS_ERROR;

2669: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2670: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2671: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2672: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: end;
2675: end if;
2676: END QPY_PARTY_OBJECT1_ID1 ;
2677:

Line 2716: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2720: from hz_merge_batch

Line 2769: x_return_status := FND_API.G_RET_STS_ERROR;

2765: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2766: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2767: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2768: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2769: x_return_status := FND_API.G_RET_STS_ERROR;
2770: end;
2771: end if;
2772: END QPY_CONTACT_OBJECT1_ID1 ;
2773:

Line 2812: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
2816: from hz_merge_batch

Line 2864: x_return_status := FND_API.G_RET_STS_ERROR;

2860: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2861: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2862: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2863: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2864: x_return_status := FND_API.G_RET_STS_ERROR;
2865: end;
2866: end if;
2867: END TIN_PARTY_OBJECT_ID1 ;
2868:

Line 2891: p_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;

2887: p_batch_party_id IN NUMBER,
2888: x_return_status OUT NOCOPY VARCHAR2)
2889: IS
2890: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2891: p_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;
2892: p_msg_count NUMBER;
2893: p_msg_data VARCHAR2(1000);
2894: l_return_status VARCHAR2(1);
2895: l_merge_reason_code VARCHAR2(30);

Line 3324: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
3327: from hz_merge_batch
3328: where batch_id = p_batch_id;

Line 3382: x_return_status := FND_API.G_RET_STS_ERROR;

3378: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3379: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3380: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3381: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3382: x_return_status := FND_API.G_RET_STS_ERROR;
3383: END;
3384: END IF;
3385: END CPL_PARTY_SITE_MERGE;
3386:

Line 3400: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;

3396: req_id NUMBER,
3397: set_num NUMBER,
3398: process_mode VARCHAR2)
3399: IS
3400: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;
3401: l_api_name VARCHAR2(30) := 'LOP_ACCOUNT_MERGE';
3402: l_return_status VARCHAR2(1);
3403: x_msg_count NUMBER;
3404: x_msg_data VARCHAR2(1000);

Line 3540: p_init_msg_list => FND_API.G_FALSE,

3536:
3537: --copy the party site id under new party and update the party site id with
3538: --the newly created party site id.
3539: CREATE_PARTY_SITE(
3540: p_init_msg_list => FND_API.G_FALSE,
3541: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
3542: p_old_party_site_id => PROSPECT_ADD_OLD_ID_LIST(I),
3543: x_new_party_site_id => PROSPECT_ADDRESS_ID_LIST(I),
3544: x_return_status => l_return_status,

Line 3596: p_init_msg_list => FND_API.G_FALSE,

3592: ,'begin debug call CREATE_PARTY_SITE');
3593: END IF;
3594:
3595: CREATE_PARTY_SITE(
3596: p_init_msg_list => FND_API.G_FALSE,
3597: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
3598: p_old_party_site_id => l_party_site_id,
3599: x_new_party_site_id => l_new_party_site_id,
3600: x_return_status => l_return_status,

Line 3638: p_init_msg_list => FND_API.G_FALSE,

3634: ,'begin debug call CREATE_PARTY_SITE_USE');
3635: END IF;
3636:
3637: CREATE_PARTY_SITE_USE(
3638: p_init_msg_list => FND_API.G_FALSE,
3639: p_party_site_id => l_new_party_site_id,
3640: p_old_party_site_use_id => IS_OLD_ID_LIST(I),
3641: x_new_party_site_use_id => IS_ID_LIST(I),
3642: x_return_status => l_return_status,

Line 3694: p_init_msg_list => FND_API.G_FALSE,

3690: ,'begin debug call CREATE_PARTY_SITE');
3691: END IF;
3692:
3693: CREATE_PARTY_SITE(
3694: p_init_msg_list => FND_API.G_FALSE,
3695: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
3696: p_old_party_site_id => l_party_site_id,
3697: x_new_party_site_id => l_new_party_site_id,
3698: x_return_status => l_return_status,

Line 3736: p_init_msg_list => FND_API.G_FALSE,

3732: ,'begin debug call CREATE_PARTY_SITE_USE');
3733: END IF;
3734:
3735: CREATE_PARTY_SITE_USE(
3736: p_init_msg_list => FND_API.G_FALSE,
3737: p_party_site_id => l_new_party_site_id,
3738: p_old_party_site_use_id => UL_OLD_ID_LIST(I),
3739: x_new_party_site_use_id => UL_ID_LIST(I),
3740: x_return_status => l_return_status,

Line 3783: p_init_msg_list => FND_API.G_FALSE,

3779:
3780: --Also update the install location id in okl_assets_b for all the lease quotes
3781: --undet this lease application.
3782: UPDATE_ASSET_LOCATION(
3783: p_init_msg_list => FND_API.G_FALSE,
3784: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
3785: p_parent_object_id => PRIMARY_KEY_ID_LIST(I),
3786: p_parent_object_code => 'LEASEOPP',
3787: p_merge_header_id => MERGE_HEADER_ID_LIST(I),

Line 3944: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;

3940: req_id NUMBER,
3941: set_num NUMBER,
3942: process_mode VARCHAR2)
3943: IS
3944: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_FALSE;
3945: l_api_name VARCHAR2(30) := 'LAP_ACCOUNT_MERGE';
3946: l_return_status VARCHAR2(1);
3947: x_msg_count NUMBER;
3948: x_msg_data VARCHAR2(1000);

Line 4066: p_init_msg_list => FND_API.G_FALSE,

4062:
4063: --copy the party site id under new party and update the party site id with
4064: --the newly created party site id.
4065: CREATE_PARTY_SITE(
4066: p_init_msg_list => FND_API.G_FALSE,
4067: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
4068: p_old_party_site_id => PROSPECT_ADD_OLD_ID_LIST(I),
4069: x_new_party_site_id => PROSPECT_ADDRESS_ID_LIST(I),
4070: x_return_status => l_return_status,

Line 4113: p_init_msg_list => FND_API.G_FALSE,

4109:
4110: --Also update the install location id in okl_assets_b for all the lease quotes
4111: --undet this lease application.
4112: UPDATE_ASSET_LOCATION(
4113: p_init_msg_list => FND_API.G_FALSE,
4114: p_cust_acct_id => NUM_COL1_NEW_LIST(I),
4115: p_parent_object_id => PRIMARY_KEY_ID_LIST(I),
4116: p_parent_object_code => 'LEASEAPP',
4117: p_merge_header_id => MERGE_HEADER_ID_LIST(I),

Line 5881: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
5885: from hz_merge_batch

Line 5938: x_return_status := FND_API.G_RET_STS_ERROR;

5934: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
5935: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
5936: 'TCN_PARTY_REL_ID1_NEW for = '|| p_from_id));
5937: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
5938: x_return_status := FND_API.G_RET_STS_ERROR;
5939: end;
5940: end if;
5941: END TCN_PARTY_REL_ID1_NEW ;
5942:

Line 5980: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
5984: from hz_merge_batch

Line 6037: x_return_status := FND_API.G_RET_STS_ERROR;

6033: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
6034: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
6035: 'TCN_PARTY_REL_ID1_OLD for = '|| p_from_id));
6036: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
6037: x_return_status := FND_API.G_RET_STS_ERROR;
6038: end;
6039: end if;
6040: END TCN_PARTY_REL_ID1_OLD ;
6041:

Line 6079: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
6083: from hz_merge_batch

Line 6136: x_return_status := FND_API.G_RET_STS_ERROR;

6132: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
6133: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
6134: 'TCN_PARTY_REL_ID2_OLD for = '|| p_from_id));
6135: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
6136: x_return_status := FND_API.G_RET_STS_ERROR;
6137: end;
6138: end if;
6139: END TCN_PARTY_REL_ID2_OLD ;
6140:

Line 6178: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
6182: where batch_id = p_batch_id;

Line 6236: x_return_status := FND_API.G_RET_STS_ERROR;

6232: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
6233: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
6234: 'OKC_RULES_B for = '|| p_from_id));
6235: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
6236: x_return_status := FND_API.G_RET_STS_ERROR;
6237: END;
6238: END IF;
6239: END RUL_PARTY_SITE_MERGE;
6240: