773: l_merge_reason_code VARCHAR2(30);
774: l_api_name VARCHAR2(30) := 'OKL_INSURANCE_PARTY_MERGE';
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
826:
827: exception
828: when others then
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;
828: when others then
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 ;
859: l_merge_reason_code VARCHAR2(30);
860: l_api_name VARCHAR2(30) := 'OKL_INSURANCE_PARTY_SITE_MERGE';
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
911:
912: exception
913: when others then
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;
913: when others then
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 ;
944: l_merge_reason_code VARCHAR2(30);
945: l_api_name VARCHAR2(30) := 'OKL_INSURANCE_AGENT_MERGE';
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
996:
997: exception
998: when others then
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;
998: when others then
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 ;
1029: l_merge_reason_code VARCHAR2(30);
1030: l_api_name VARCHAR2(30) := 'OKL_INSURANCE_AGENT_SITE_MERGE';
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
1080:
1081: exception
1082: when others then
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;
1082: when others then
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 ;
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
1158:
1159: exception
1160: when others then
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;
1160: when others then
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 ;
1191: l_merge_reason_code VARCHAR2(30);
1192: l_count NUMBER(10) := 0;
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
1238: ARP_MESSAGE.set_token('NUM_ROWS',to_char(l_count));
1239: EXCEPTION
1240: WHEN OTHERS THEN
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;
1240: WHEN OTHERS THEN
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 ;
1269: l_merge_reason_code VARCHAR2(30);
1270: l_count NUMBER(10) := 0;
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
1317: ARP_MESSAGE.set_token('NUM_ROWS',to_char(l_count));
1318: EXCEPTION
1319: WHEN OTHERS THEN
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;
1319: WHEN OTHERS THEN
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 ;
1340: x_return_status OUT NOCOPY VARCHAR2)
1341: IS
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
1351:
1352: exception
1353: when others then
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;
1353: when others then
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 (
1370: x_return_status OUT NOCOPY VARCHAR2)
1371: IS
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
1381:
1382: exception
1383: when others then
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 ;
1383: when others then
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 (
1400: x_return_status OUT NOCOPY VARCHAR2)
1401: IS
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
1411:
1412: exception
1413: when others then
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;
1413: when others then
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
1435: l_merge_reason_code VARCHAR2(30);
1436: l_api_name VARCHAR2(30) := 'OKL_INSTALL_SITE_MERGE';
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
1485: arp_message.set_token('NUM_ROWS',to_char(l_count));
1486: exception
1487: when others then
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;
1487: when others then
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 ;
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);
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
1528: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
1526: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
1581: EXCEPTION
1582: when others
1583: then
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;
1583: then
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 ;
1603: x_return_status OUT NOCOPY VARCHAR2)
1604: IS
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
1614:
1615: exception
1616: when others then
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;
1616: when others then
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: ----------------------------------------------------------------------------------------------------------
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);
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
1656: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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);
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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);
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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()+');
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);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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;
1654: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:
1708:
1709: exception
1710: when others then
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;
1710: when others then
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 ;
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);
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
1753: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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);
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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);
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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()+');
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);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:
1751: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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;
1817: EXCEPTION
1818: when others
1819: then
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;
1819: then
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 ;
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);
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
1862: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
1860: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
1936: exception
1937: when others
1938: then
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;
1938: then
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 ;
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);
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
1981: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
1979: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2035: exception
2036: when others
2037: then
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;
2037: then
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 ;
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);
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2080: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2078: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2142:
2143: exception
2144: when others then
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;
2144: when others then
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 ;
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);
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2187: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2185: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2251:
2252: exception
2253: when others then
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;
2253: when others then
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 ;
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);
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2297: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2295: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2361:
2362: exception
2363: when others then
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;
2363: when others then
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 ;
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);
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2406: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2404: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2470:
2471: exception
2472: when others then
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;
2472: when others then
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 ;
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);
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2515: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2513: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2570:
2571: exception
2572: when others then
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;
2572: when others then
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 ;
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);
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2615: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2613: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2666:
2667: exception
2668: when others then
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;
2668: when others then
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 ;
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);
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2711: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2709: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2762:
2763: exception
2764: when others then
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;
2764: when others then
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 ;
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);
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2807: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
2805: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2857:
2858: exception
2859: when others then
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;
2859: when others then
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 ;
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);
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
2993: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
2991: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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
3208: EXCEPTION
3209: WHEN OKL_API.G_EXCEPTION_ERROR
3210: THEN
3211: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3212: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3213: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3214: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3215: IF chk_vendor_chr_csr%ISOPEN
3216: THEN
3210: THEN
3211: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3212: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3213: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3214: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3215: IF chk_vendor_chr_csr%ISOPEN
3216: THEN
3217: CLOSE chk_vendor_chr_csr;
3218: END IF;
3233: p_api_type => G_API_TYPE);
3234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
3235: THEN
3236: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3237: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3238: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3240: IF chk_vendor_chr_csr%ISOPEN
3241: THEN
3235: THEN
3236: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3237: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3238: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3240: IF chk_vendor_chr_csr%ISOPEN
3241: THEN
3242: CLOSE chk_vendor_chr_csr;
3243: END IF;
3258: p_api_type => G_API_TYPE);
3259: WHEN OTHERS
3260: THEN
3261: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3262: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3263: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3264: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3265: IF chk_vendor_chr_csr%ISOPEN
3266: THEN
3260: THEN
3261: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3262: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3263: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3264: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3265: IF chk_vendor_chr_csr%ISOPEN
3266: THEN
3267: CLOSE chk_vendor_chr_csr;
3268: END IF;
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);
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
3318: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
3316: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
3375: EXCEPTION
3376: when others
3377: then
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;
3377: then
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;
3892: EXCEPTION
3893: WHEN OKL_API.G_EXCEPTION_ERROR
3894: THEN
3895: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3896: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3897: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3898: p_api_name => l_api_name,
3899: p_pkg_name => G_PKG_NAME,
3900: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3904: RAISE;
3905: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
3906: THEN
3907: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3908: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3909: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3910: p_api_name => l_api_name,
3911: p_pkg_name => G_PKG_NAME,
3912: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3916: RAISE;
3917: WHEN OTHERS
3918: THEN
3919: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3920: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3921: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
3922: p_api_name => l_api_name,
3923: p_pkg_name => G_PKG_NAME,
3924: p_exc_name => 'OTHERS',
4211: EXCEPTION
4212: WHEN OKL_API.G_EXCEPTION_ERROR
4213: THEN
4214: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
4215: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
4216: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
4217: p_api_name => l_api_name,
4218: p_pkg_name => G_PKG_NAME,
4219: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4223: RAISE;
4224: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
4225: THEN
4226: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
4227: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
4228: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
4229: p_api_name => l_api_name,
4230: p_pkg_name => G_PKG_NAME,
4231: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4235: RAISE;
4236: WHEN OTHERS
4237: THEN
4238: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
4239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
4240: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
4241: p_api_name => l_api_name,
4242: p_pkg_name => G_PKG_NAME,
4243: p_exc_name => 'OTHERS',
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);
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
5876: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
5874: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
5931:
5932: exception
5933: when others then
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;
5933: when others then
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 ;
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);
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
5975: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
5973: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
6030:
6031: exception
6032: when others then
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;
6032: when others then
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 ;
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);
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
6074: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
6072: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
6129:
6130: exception
6131: when others then
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;
6131: when others then
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 ;
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);
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
6173: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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);
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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()+');
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);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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;
6171: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_id);
6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_id);
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:
6229: EXCEPTION
6230: when others
6231: then
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;
6231: then
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;