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.AMS_PARTY_MERGE_PVT dependencies on FND_API

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: BEGIN
22:
23: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.REG_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
24:
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: select merge_reason_code into l_merge_reason_code
28: from HZ_MERGE_BATCH
29: where batch_id = p_batch_id;

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: END IF;
122: EXCEPTION
123: WHEN OTHERS THEN
124: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: raise;
127: END;
128: END IF;
129:

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: BEGIN
150:
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.ATN_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: select merge_reason_code into l_merge_reason_code
156: from HZ_MERGE_BATCH
157: where batch_id = p_batch_id;

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: END IF;
249: EXCEPTION
250: WHEN OTHERS THEN
251: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: raise;
254: END;
255: END IF;
256:

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: BEGIN
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
286:
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: select merge_reason_code into l_merge_reason_code
290: from HZ_MERGE_BATCH
291: where batch_id = p_batch_id;

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: raise;
362: END;
363: END IF;
364:

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: BEGIN
392:
393: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
394:
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: select merge_reason_code into l_merge_reason_code
398: from HZ_MERGE_BATCH
399: where batch_id = p_batch_id;

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: END IF;
465: EXCEPTION
466: WHEN OTHERS THEN
467: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: raise;
470: END;
471: END IF;
472:

Line 503: x_return_status := FND_API.G_RET_STS_SUCCESS;

499: BEGIN
500:
501: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.SEGMENT_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
502:
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: select merge_reason_code into l_merge_reason_code
506: from HZ_MERGE_BATCH
507: where batch_id = p_batch_id;

Line 576: x_return_status := FND_API.G_RET_STS_ERROR;

572: END IF;
573: EXCEPTION
574: WHEN OTHERS THEN
575: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: raise;
578: END;
579: END IF;
580:

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

607: BEGIN
608:
609: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_CUST_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: select merge_reason_code into l_merge_reason_code
614: from HZ_MERGE_BATCH
615: where batch_id = p_batch_id;

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: raise;
686: END;
687: END IF;
688:

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: BEGIN
716:
717: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_AFFL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: select merge_reason_code into l_merge_reason_code
722: from HZ_MERGE_BATCH
723: where batch_id = p_batch_id;

Line 792: x_return_status := FND_API.G_RET_STS_ERROR;

788: END IF;
789: EXCEPTION
790: WHEN OTHERS THEN
791: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: raise;
794: END;
795: END IF;
796:

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

824: BEGIN
825:
826: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_PARTNER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
827:
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: select merge_reason_code into l_merge_reason_code
831: from HZ_MERGE_BATCH
832: where batch_id = p_batch_id;

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: END IF;
859: EXCEPTION
860: WHEN OTHERS THEN
861: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;
864: END;
865: END IF;
866:

Line 897: x_return_status := FND_API.G_RET_STS_SUCCESS;

893: BEGIN
894:
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_VAD_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
896:
897: x_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: select merge_reason_code into l_merge_reason_code
900: from HZ_MERGE_BATCH
901: where batch_id = p_batch_id;

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: END IF;
928: EXCEPTION
929: WHEN OTHERS THEN
930: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: raise;
933: END;
934: END IF;
935:

Line 966: x_return_status := FND_API.G_RET_STS_SUCCESS;

962: BEGIN
963:
964: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
965:
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:
968: select merge_reason_code into l_merge_reason_code
969: from HZ_MERGE_BATCH
970: where batch_id = p_batch_id;

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: END IF;
997: EXCEPTION
998: WHEN OTHERS THEN
999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: raise;
1002: END;
1003: END IF;
1004:

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: BEGIN
1059: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1060: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TRADE_PROFILE_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: select merge_reason_code into l_merge_reason_code
1065: from HZ_MERGE_BATCH
1066: where batch_id = p_batch_id;

Line 1106: x_return_status := FND_API.G_RET_STS_ERROR;

1102: END IF;
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: raise;
1108: END;
1109: END IF;
1110:

Line 1142: x_return_status := FND_API.G_RET_STS_SUCCESS;

1138: BEGIN
1139: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1140: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143:
1144: select merge_reason_code into l_merge_reason_code
1145: from HZ_MERGE_BATCH
1146: where batch_id = p_batch_id;

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR;

1172: END IF;
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: raise;
1178: END;
1179: END IF;
1180:

Line 1212: x_return_status := FND_API.G_RET_STS_SUCCESS;

1208: BEGIN
1209: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1210: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1211:
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;
1213:
1214: select merge_reason_code into l_merge_reason_code
1215: from HZ_MERGE_BATCH
1216: where batch_id = p_batch_id;

Line 1246: x_return_status := FND_API.G_RET_STS_ERROR;

1242: END IF;
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: raise;
1248: END;
1249: END IF;
1250:

Line 1283: x_return_status := FND_API.G_RET_STS_SUCCESS;

1279: BEGIN
1280: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1281: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_HISTORY_BROKER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1282:
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;
1284:
1285: select merge_reason_code into l_merge_reason_code
1286: from HZ_MERGE_BATCH
1287: where batch_id = p_batch_id;

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313: END IF;
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: raise;
1319: END;
1320: END IF;
1321:

Line 1354: x_return_status := FND_API.G_RET_STS_SUCCESS;

1350: BEGIN
1351: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_HISTORY_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355:
1356: select merge_reason_code into l_merge_reason_code
1357: from HZ_MERGE_BATCH
1358: where batch_id = p_batch_id;

Line 1388: x_return_status := FND_API.G_RET_STS_ERROR;

1384: END IF;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1388: x_return_status := FND_API.G_RET_STS_ERROR;
1389: raise;
1390: END;
1391: END IF;
1392:

Line 1424: x_return_status := FND_API.G_RET_STS_SUCCESS;

1420: BEGIN
1421: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1422: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1423:
1424: x_return_status := FND_API.G_RET_STS_SUCCESS;
1425:
1426: select merge_reason_code into l_merge_reason_code
1427: from HZ_MERGE_BATCH
1428: where batch_id = p_batch_id;

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR;

1455: END IF;
1456: EXCEPTION
1457: WHEN OTHERS THEN
1458: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: raise;
1461: END;
1462: END IF;
1463:

Line 1495: x_return_status := FND_API.G_RET_STS_SUCCESS;

1491: BEGIN
1492: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1493: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1494:
1495: x_return_status := FND_API.G_RET_STS_SUCCESS;
1496:
1497: select merge_reason_code into l_merge_reason_code
1498: from HZ_MERGE_BATCH
1499: where batch_id = p_batch_id;

Line 1529: x_return_status := FND_API.G_RET_STS_ERROR;

1525: END IF;
1526: EXCEPTION
1527: WHEN OTHERS THEN
1528: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: raise;
1531: END;
1532: END IF;
1533:

Line 1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

1554: BEGIN
1555: /* julou 08-APR-2004 migrated to ozfvprmb.pls
1556: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.OFFER_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1557:
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559:
1560: select merge_reason_code into l_merge_reason_code
1561: from HZ_MERGE_BATCH
1562: where batch_id = p_batch_id;

Line 1589: x_return_status := FND_API.G_RET_STS_ERROR;

1585: END IF;
1586: EXCEPTION
1587: WHEN OTHERS THEN
1588: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: raise;
1591: END;
1592: END IF;
1593:

Line 1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

1622: BEGIN
1623:
1624: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.Product_Comp_Party_Merge start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1625:
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: select merge_reason_code into l_merge_reason_code
1629: from HZ_MERGE_BATCH
1630: where batch_id = p_batch_id;

Line 1657: x_return_status := FND_API.G_RET_STS_ERROR;

1653: END IF;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1657: x_return_status := FND_API.G_RET_STS_ERROR;
1658: raise;
1659: END;
1660: END IF;
1661:

Line 1692: x_return_status := FND_API.G_RET_STS_SUCCESS;

1688: BEGIN
1689:
1690: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.PLACEMENT_SITE_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1691:
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694: select merge_reason_code into l_merge_reason_code
1695: from HZ_MERGE_BATCH
1696: where batch_id = p_batch_id;

Line 1724: x_return_status := FND_API.G_RET_STS_ERROR;

1720: END IF;
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: raise;
1726: END;
1727: END IF;
1728:

Line 1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

1755: BEGIN
1756:
1757: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1758:
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760:
1761: select merge_reason_code into l_merge_reason_code
1762: from HZ_MERGE_BATCH
1763: where batch_id = p_batch_id;

Line 1829: x_return_status := FND_API.G_RET_STS_ERROR;

1825: END IF;
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1829: x_return_status := FND_API.G_RET_STS_ERROR;
1830: raise;
1831: END;
1832: END IF;
1833:

Line 1864: x_return_status := FND_API.G_RET_STS_SUCCESS;

1860: BEGIN
1861:
1862: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1863:
1864: x_return_status := FND_API.G_RET_STS_SUCCESS;
1865:
1866: select merge_reason_code into l_merge_reason_code
1867: from HZ_MERGE_BATCH
1868: where batch_id = p_batch_id;

Line 1934: x_return_status := FND_API.G_RET_STS_ERROR;

1930: END IF;
1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935: raise;
1936: END;
1937: END IF;
1938:

Line 1969: x_return_status := FND_API.G_RET_STS_SUCCESS;

1965: BEGIN
1966:
1967: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1968:
1969: x_return_status := FND_API.G_RET_STS_SUCCESS;
1970:
1971: select merge_reason_code into l_merge_reason_code
1972: from HZ_MERGE_BATCH
1973: where batch_id = p_batch_id;

Line 2039: x_return_status := FND_API.G_RET_STS_ERROR;

2035: END IF;
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2039: x_return_status := FND_API.G_RET_STS_ERROR;
2040: raise;
2041: END;
2042: END IF;
2043:

Line 2074: x_return_status := FND_API.G_RET_STS_SUCCESS;

2070: BEGIN
2071:
2072: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.VENUES_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2073:
2074: x_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: select merge_reason_code into l_merge_reason_code
2077: from HZ_MERGE_BATCH
2078: where batch_id = p_batch_id;

Line 2145: x_return_status := FND_API.G_RET_STS_ERROR;

2141: END IF;
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146: raise;
2147: END;
2148: END IF;
2149:

Line 2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

2189: BEGIN
2190: /* julou 08-APR-2004 migrated to ozfvprmb.pls
2191: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.OFFER_DENORM_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2192:
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: SELECT merge_reason_code INTO l_merge_reason_code
2196: FROM HZ_MERGE_BATCH
2197: WHERE batch_id = p_batch_id;

Line 2276: x_return_status := FND_API.G_RET_STS_ERROR;

2272: END IF;
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: raise;
2278: END;
2279: END IF;
2280:

Line 2317: x_return_status := FND_API.G_RET_STS_SUCCESS;

2313:
2314:
2315: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.RESOURCES_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2316:
2317: x_return_status := FND_API.G_RET_STS_SUCCESS;
2318:
2319: select merge_reason_code into l_merge_reason_code
2320: from HZ_MERGE_BATCH
2321: where batch_id = p_batch_id;

Line 2390: x_return_status := FND_API.G_RET_STS_ERROR;

2386: END IF;
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: raise;
2392: END;
2393: END IF;
2394:

Line 2428: x_return_status := FND_API.G_RET_STS_SUCCESS;

2424:
2425:
2426: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.AGENDAS_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2427:
2428: x_return_status := FND_API.G_RET_STS_SUCCESS;
2429:
2430: select merge_reason_code into l_merge_reason_code
2431: from HZ_MERGE_BATCH
2432: where batch_id = p_batch_id;

Line 2500: x_return_status := FND_API.G_RET_STS_ERROR;

2496: END IF;
2497: EXCEPTION
2498: WHEN OTHERS THEN
2499: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: raise;
2502: END;
2503: END IF;
2504:

Line 2540: x_return_status := FND_API.G_RET_STS_SUCCESS;

2536:
2537:
2538: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2539:
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;
2541:
2542: select merge_reason_code into l_merge_reason_code
2543: from HZ_MERGE_BATCH
2544: where batch_id = p_batch_id;

Line 2627: x_return_status := FND_API.G_RET_STS_ERROR;

2623: EXCEPTION
2624: WHEN OTHERS THEN
2625:
2626: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: raise;
2629: END;
2630: END IF;
2631:

Line 2669: x_return_status := FND_API.G_RET_STS_SUCCESS;

2665:
2666:
2667: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2668:
2669: x_return_status := FND_API.G_RET_STS_SUCCESS;
2670:
2671: select merge_reason_code into l_merge_reason_code
2672: from HZ_MERGE_BATCH
2673: where batch_id = p_batch_id;

Line 2755: x_return_status := FND_API.G_RET_STS_ERROR;

2751: EXCEPTION
2752: WHEN OTHERS THEN
2753:
2754: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2755: x_return_status := FND_API.G_RET_STS_ERROR;
2756: raise;
2757: END;
2758: END IF;
2759:

Line 2802: x_return_status := FND_API.G_RET_STS_SUCCESS;

2798:
2799:
2800: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_SUMM_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2801:
2802: x_return_status := FND_API.G_RET_STS_SUCCESS;
2803:
2804: select merge_reason_code into l_merge_reason_code
2805: from HZ_MERGE_BATCH
2806: where batch_id = p_batch_id;

Line 2889: x_return_status := FND_API.G_RET_STS_ERROR;

2885: END IF;
2886: EXCEPTION
2887: WHEN OTHERS THEN
2888: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: raise;
2891: END;
2892: END IF;
2893:

Line 2929: x_return_status := FND_API.G_RET_STS_SUCCESS;

2925:
2926:
2927: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_CONTACT_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2928:
2929: x_return_status := FND_API.G_RET_STS_SUCCESS;
2930:
2931: select merge_reason_code into l_merge_reason_code
2932: from HZ_MERGE_BATCH
2933: where batch_id = p_batch_id;

Line 3000: x_return_status := FND_API.G_RET_STS_ERROR;

2996: END IF;
2997: EXCEPTION
2998: WHEN OTHERS THEN
2999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
3000: x_return_status := FND_API.G_RET_STS_ERROR;
3001: raise;
3002: END;
3003: END IF;
3004:

Line 3040: x_return_status := FND_API.G_RET_STS_SUCCESS;

3036:
3037:
3038: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_FTG_DTL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
3039:
3040: x_return_status := FND_API.G_RET_STS_SUCCESS;
3041:
3042: select merge_reason_code into l_merge_reason_code
3043: from HZ_MERGE_BATCH
3044: where batch_id = p_batch_id;

Line 3123: x_return_status := FND_API.G_RET_STS_ERROR;

3119: END IF;
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
3123: x_return_status := FND_API.G_RET_STS_ERROR;
3124: raise;
3125: END;
3126: END IF;
3127: