eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PARTY_MERGE_PUB dependencies on FND_FILE

Line 777: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE');

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

Line 830: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 832: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 863: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_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

Line 915: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 917: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 948: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_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

Line 1000: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1002: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 1033: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_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

Line 1084: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1086: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 1162: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1164: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 1195: FND_FILE.put_line(fnd_file.log, 'OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_PAC_ID');

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

Line 1242: FND_FILE.put_line(FND_FILE.log,

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;

Line 1244: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 1273: FND_FILE.put_line(fnd_file.log, 'OKL_AM_SHIPPING_INSTR_PVT.PARTY_MERGE_IST_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

Line 1321: FND_FILE.put_line(FND_FILE.log,

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;

Line 1323: FND_FILE.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 1344: fnd_file.put_line(fnd_file.log, 'okl_cnr_pvt.okl_cnr_party_merge');

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

Line 1355: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1357: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 (

Line 1374: fnd_file.put_line(fnd_file.log, 'Okl_Xsi_Pvt.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

Line 1385: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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 ;

Line 1387: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 (

Line 1404: fnd_file.put_line(fnd_file.log, 'Okl_Tai_Pvt.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

Line 1415: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1417: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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

Line 1439: fnd_file.put_line(fnd_file.log, 'OKL_LLA_UTIL_PVT.INSTALL_AT_SITE_MERGE');

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

Line 1489: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1491: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 1523: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 1524: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 1525: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 1526: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 1527: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 1528: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 1529: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 1530: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
1534:

Line 1585: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1587: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

Line 1607: fnd_file.put_line(fnd_file.log, 'OKL_RCA_PVT.OKL_RCA_PARTY_MERGE');

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

Line 1618: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1620: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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: ----------------------------------------------------------------------------------------------------------

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

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

Line 1651: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 1652: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 1653: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 1654: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 1655: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 1656: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 1657: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_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;

Line 1658: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
1662:

Line 1712: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1714: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 1748: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 1749: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 1750: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 1751: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 1752: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 1753: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 1754: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_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:

Line 1755: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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:
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1821: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1823: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 1857: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 1858: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 1859: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 1860: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 1861: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 1862: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 1863: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 1864: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
1868:

Line 1940: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 1942: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 1976: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 1977: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 1978: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 1979: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 1980: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 1981: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 1982: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 1983: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
1987:

Line 2039: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2041: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2075: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2076: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2077: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2078: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2079: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2080: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2081: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2082: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2086:

Line 2146: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2148: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2182: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2183: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2184: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2185: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2186: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2187: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2188: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2189: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2193:

Line 2255: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2257: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2292: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2293: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2294: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2295: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2296: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2297: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2298: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2299: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2303:

Line 2365: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2367: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2401: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2402: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2403: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2404: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2405: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2406: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2407: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2408: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2412:

Line 2474: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2476: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2510: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2511: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2512: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2513: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2514: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2515: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2516: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2517: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2521:

Line 2574: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2576: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2610: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2611: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2612: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2613: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2614: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2615: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2616: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2617: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2621:

Line 2670: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2672: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2706: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2707: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2708: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2709: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2710: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2711: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2712: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2713: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2717:

Line 2766: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2768: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2802: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2803: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2804: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2805: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2806: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2807: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2808: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 2809: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
2813:

Line 2861: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 2863: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 2988: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 2989: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 2990: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 2991: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 2992: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 2993: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 2994: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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:

Line 2995: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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:
2999: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 3212: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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

Line 3214: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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;

Line 3237: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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

Line 3239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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;

Line 3262: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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

Line 3264: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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;

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

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

Line 3313: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 3314: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 3315: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 3316: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 3317: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 3318: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 3319: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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:

Line 3320: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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:
3324: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3379: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 3381: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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;

Line 3896: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

Line 3908: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

Line 3920: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

Line 4215: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

Line 4227: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

Line 4239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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',

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

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

Line 5871: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 5872: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 5873: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 5874: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 5875: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 5876: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 5877: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 5878: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
5882:

Line 5935: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 5937: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 5970: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 5971: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 5972: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 5973: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 5974: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 5975: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 5976: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 5977: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
5981:

Line 6034: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 6036: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 6069: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 6070: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 6071: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 6072: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 6073: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 6074: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 6075: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 6076: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
6080:

Line 6133: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 6135: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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 ;

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

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

Line 6168: fnd_file.put_line(fnd_file.log, ' PARAMETERS ');

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);

Line 6169: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

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);

Line 6170: fnd_file.put_line(fnd_file.log, 'p_from_id : '||p_from_id);

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);

Line 6171: fnd_file.put_line(fnd_file.log, 'p_from_fk_id : '||p_from_fk_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);

Line 6172: fnd_file.put_line(fnd_file.log, 'p_to_fk_id : '||p_to_fk_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:

Line 6173: fnd_file.put_line(fnd_file.log, 'p_parent_entity_name : '||p_parent_entity_name);

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()+');

Line 6174: fnd_file.put_line(fnd_file.log, 'p_batch_id : '||p_batch_id);

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;

Line 6175: fnd_file.put_line(fnd_file.log, 'p_batch_party_id : '||p_batch_party_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;
6179:

Line 6233: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

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;

Line 6235: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

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;