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

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: BEGIN
58:
59: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.TRADE_PROFILE_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
60:
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: select merge_reason_code into l_merge_reason_code
64: from HZ_MERGE_BATCH
65: where batch_id = p_batch_id;

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: END IF;
102: EXCEPTION
103: WHEN OTHERS THEN
104: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: raise;
107: END;
108: END IF;
109:

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: BEGIN
137:
138: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
139:
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:
142: select merge_reason_code into l_merge_reason_code
143: from HZ_MERGE_BATCH
144: where batch_id = p_batch_id;

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

170: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
173: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: raise;
176: END;
177: END IF;
178:

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: BEGIN
206:
207: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: select merge_reason_code into l_merge_reason_code
212: from HZ_MERGE_BATCH
213: where batch_id = p_batch_id;

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: raise;
245: END;
246: END IF;
247:

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: BEGIN
276:
277: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_BROKER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281: select merge_reason_code into l_merge_reason_code
282: from HZ_MERGE_BATCH
283: where batch_id = p_batch_id;

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: END IF;
310: EXCEPTION
311: WHEN OTHERS THEN
312: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: raise;
315: END;
316: END IF;
317:

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: BEGIN
346:
347: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: select merge_reason_code into l_merge_reason_code
352: from HZ_MERGE_BATCH
353: where batch_id = p_batch_id;

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: END IF;
380: EXCEPTION
381: WHEN OTHERS THEN
382: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: raise;
385: END;
386: END IF;
387:

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414: BEGIN
415:
416: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
417:
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: select merge_reason_code into l_merge_reason_code
421: from HZ_MERGE_BATCH
422: where batch_id = p_batch_id;

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449: END IF;
450: EXCEPTION
451: WHEN OTHERS THEN
452: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: raise;
455: END;
456: END IF;
457:

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484: BEGIN
485:
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
487:
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: select merge_reason_code into l_merge_reason_code
491: from HZ_MERGE_BATCH
492: where batch_id = p_batch_id;

Line 522: x_return_status := FND_API.G_RET_STS_ERROR;

518: END IF;
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: raise;
524: END;
525: END IF;
526:

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: BEGIN
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: select merge_reason_code into l_merge_reason_code
553: from HZ_MERGE_BATCH
554: where batch_id = p_batch_id;

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577: END IF;
578: EXCEPTION
579: WHEN OTHERS THEN
580: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: raise;
583: END;
584: END IF;
585:

Line 632: x_return_status := FND_API.G_RET_STS_SUCCESS;

628: BEGIN
629:
630: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_DENORM_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
631:
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633:
634: SELECT merge_reason_code INTO l_merge_reason_code
635: FROM HZ_MERGE_BATCH
636: WHERE batch_id = p_batch_id;

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710: END IF;
711: EXCEPTION
712: WHEN OTHERS THEN
713: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: raise;
716: END;
717: END IF;
718:

Line 750: x_return_status := FND_API.G_RET_STS_SUCCESS;

746: BEGIN
747:
748: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
749:
750: x_return_status := FND_API.G_RET_STS_SUCCESS;
751:
752: select merge_reason_code into l_merge_reason_code
753: from HZ_MERGE_BATCH
754: where batch_id = p_batch_id;

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780: END IF;
781: EXCEPTION
782: WHEN OTHERS THEN
783: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: raise;
786: END;
787: END IF;
788:

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: BEGIN
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_HIST_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: SELECT merge_reason_code INTO l_merge_reason_code
822: FROM HZ_MERGE_BATCH
823: WHERE batch_id = p_batch_id;

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: END IF;
850: EXCEPTION
851: WHEN OTHERS THEN
852: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: raise;
855: END;
856: END IF;
857:

Line 888: x_return_status := FND_API.G_RET_STS_SUCCESS;

884: BEGIN
885:
886: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CODE_CONVERSION_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889:
890: SELECT merge_reason_code INTO l_merge_reason_code
891: FROM HZ_MERGE_BATCH
892: WHERE batch_id = p_batch_id;

Line 918: x_return_status := FND_API.G_RET_STS_ERROR;

914: END IF;
915: EXCEPTION
916: WHEN OTHERS THEN
917: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: raise;
920: END;
921: END IF;
922:

Line 954: x_return_status := FND_API.G_RET_STS_SUCCESS;

950: BEGIN
951:
952: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
953:
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955:
956: SELECT merge_reason_code INTO l_merge_reason_code
957: FROM HZ_MERGE_BATCH
958: WHERE batch_id = p_batch_id;

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983: END IF;
984: EXCEPTION
985: WHEN OTHERS THEN
986: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: raise;
989: END;
990: END IF;
991:

Line 1023: x_return_status := FND_API.G_RET_STS_SUCCESS;

1019: BEGIN
1020:
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_CNT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1022:
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024:
1025: SELECT merge_reason_code INTO l_merge_reason_code
1026: FROM HZ_MERGE_BATCH
1027: WHERE batch_id = p_batch_id;

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: END IF;
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: raise;
1058: END;
1059: END IF;
1060:

Line 1092: x_return_status := FND_API.G_RET_STS_SUCCESS;

1088: BEGIN
1089:
1090: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_FRM_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1091:
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: SELECT merge_reason_code INTO l_merge_reason_code
1095: FROM HZ_MERGE_BATCH
1096: WHERE batch_id = p_batch_id;

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR;

1121: END IF;
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: raise;
1127: END;
1128: END IF;
1129:

Line 1161: x_return_status := FND_API.G_RET_STS_SUCCESS;

1157: BEGIN
1158:
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SOLD_FRM_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1160:
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162:
1163: SELECT merge_reason_code INTO l_merge_reason_code
1164: FROM HZ_MERGE_BATCH
1165: WHERE batch_id = p_batch_id;

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: END IF;
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: raise;
1196: END;
1197: END IF;
1198:

Line 1231: x_return_status := FND_API.G_RET_STS_SUCCESS;

1227: BEGIN
1228:
1229: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1230:
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233: SELECT merge_reason_code INTO l_merge_reason_code
1234: FROM HZ_MERGE_BATCH
1235: WHERE batch_id = p_batch_id;

Line 1264: x_return_status := FND_API.G_RET_STS_ERROR;

1260: END IF;
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1264: x_return_status := FND_API.G_RET_STS_ERROR;
1265: raise;
1266: END;
1267: END IF;
1268:

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: BEGIN
1298:
1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1300:
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: SELECT merge_reason_code INTO l_merge_reason_code
1304: FROM HZ_MERGE_BATCH
1305: WHERE batch_id = p_batch_id;

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR;

1330: END IF;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: raise;
1336: END;
1337: END IF;
1338:

Line 1370: x_return_status := FND_API.G_RET_STS_SUCCESS;

1366: BEGIN
1367:
1368: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1369:
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: SELECT merge_reason_code INTO l_merge_reason_code
1373: FROM HZ_MERGE_BATCH
1374: WHERE batch_id = p_batch_id;

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399: END IF;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: raise;
1405: END;
1406: END IF;
1407:

Line 1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

1436: BEGIN
1437:
1438: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441:
1442: SELECT merge_reason_code INTO l_merge_reason_code
1443: FROM HZ_MERGE_BATCH
1444: WHERE batch_id = p_batch_id;

Line 1473: x_return_status := FND_API.G_RET_STS_ERROR;

1469: END IF;
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: raise;
1475: END;
1476: END IF;
1477:

Line 1509: x_return_status := FND_API.G_RET_STS_SUCCESS;

1505: BEGIN
1506:
1507: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1508:
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: SELECT merge_reason_code INTO l_merge_reason_code
1512: FROM HZ_MERGE_BATCH
1513: WHERE batch_id = p_batch_id;

Line 1542: x_return_status := FND_API.G_RET_STS_ERROR;

1538: END IF;
1539: EXCEPTION
1540: WHEN OTHERS THEN
1541: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: raise;
1544: END;
1545: END IF;
1546:

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574: BEGIN
1575:
1576: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1577:
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: SELECT merge_reason_code INTO l_merge_reason_code
1581: FROM HZ_MERGE_BATCH
1582: WHERE batch_id = p_batch_id;

Line 1611: x_return_status := FND_API.G_RET_STS_ERROR;

1607: END IF;
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1611: x_return_status := FND_API.G_RET_STS_ERROR;
1612: raise;
1613: END;
1614: END IF;
1615:

Line 1647: x_return_status := FND_API.G_RET_STS_SUCCESS;

1643: BEGIN
1644:
1645: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1646:
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;
1648:
1649: SELECT merge_reason_code INTO l_merge_reason_code
1650: FROM HZ_MERGE_BATCH
1651: WHERE batch_id = p_batch_id;

Line 1680: x_return_status := FND_API.G_RET_STS_ERROR;

1676: END IF;
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: raise;
1682: END;
1683: END IF;
1684:

Line 1716: x_return_status := FND_API.G_RET_STS_SUCCESS;

1712: BEGIN
1713:
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1715:
1716: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717:
1718: SELECT merge_reason_code INTO l_merge_reason_code
1719: FROM HZ_MERGE_BATCH
1720: WHERE batch_id = p_batch_id;

Line 1749: x_return_status := FND_API.G_RET_STS_ERROR;

1745: END IF;
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1749: x_return_status := FND_API.G_RET_STS_ERROR;
1750: raise;
1751: END;
1752: END IF;
1753:

Line 1785: x_return_status := FND_API.G_RET_STS_SUCCESS;

1781: BEGIN
1782:
1783: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1784:
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786:
1787: SELECT merge_reason_code INTO l_merge_reason_code
1788: FROM HZ_MERGE_BATCH
1789: WHERE batch_id = p_batch_id;

Line 1818: x_return_status := FND_API.G_RET_STS_ERROR;

1814: END IF;
1815: EXCEPTION
1816: WHEN OTHERS THEN
1817: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: raise;
1820: END;
1821: END IF;
1822:

Line 1854: x_return_status := FND_API.G_RET_STS_SUCCESS;

1850: BEGIN
1851:
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1853:
1854: x_return_status := FND_API.G_RET_STS_SUCCESS;
1855:
1856: SELECT merge_reason_code INTO l_merge_reason_code
1857: FROM HZ_MERGE_BATCH
1858: WHERE batch_id = p_batch_id;

Line 1887: x_return_status := FND_API.G_RET_STS_ERROR;

1883: END IF;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: raise;
1889: END;
1890: END IF;
1891:

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: BEGIN
1920:
1921: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_FRM_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: SELECT merge_reason_code INTO l_merge_reason_code
1926: FROM HZ_MERGE_BATCH
1927: WHERE batch_id = p_batch_id;

Line 1956: x_return_status := FND_API.G_RET_STS_ERROR;

1952: END IF;
1953: EXCEPTION
1954: WHEN OTHERS THEN
1955: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: raise;
1958: END;
1959: END IF;
1960:

Line 1992: x_return_status := FND_API.G_RET_STS_SUCCESS;

1988: BEGIN
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SOLD_FRM_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1991:
1992: x_return_status := FND_API.G_RET_STS_SUCCESS;
1993:
1994: SELECT merge_reason_code INTO l_merge_reason_code
1995: FROM HZ_MERGE_BATCH
1996: WHERE batch_id = p_batch_id;

Line 2025: x_return_status := FND_API.G_RET_STS_ERROR;

2021: END IF;
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2025: x_return_status := FND_API.G_RET_STS_ERROR;
2026: raise;
2027: END;
2028: END IF;
2029:

Line 2061: x_return_status := FND_API.G_RET_STS_SUCCESS;

2057: BEGIN
2058:
2059: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2060:
2061: x_return_status := FND_API.G_RET_STS_SUCCESS;
2062:
2063: SELECT merge_reason_code INTO l_merge_reason_code
2064: FROM HZ_MERGE_BATCH
2065: WHERE batch_id = p_batch_id;

Line 2094: x_return_status := FND_API.G_RET_STS_ERROR;

2090: END IF;
2091: EXCEPTION
2092: WHEN OTHERS THEN
2093: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095: raise;
2096: END;
2097: END IF;
2098:

Line 2131: x_return_status := FND_API.G_RET_STS_SUCCESS;

2127: BEGIN
2128:
2129: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132:
2133: SELECT merge_reason_code INTO l_merge_reason_code
2134: FROM HZ_MERGE_BATCH
2135: WHERE batch_id = p_batch_id;

Line 2164: x_return_status := FND_API.G_RET_STS_ERROR;

2160: END IF;
2161: EXCEPTION
2162: WHEN OTHERS THEN
2163: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2164: x_return_status := FND_API.G_RET_STS_ERROR;
2165: raise;
2166: END;
2167: END IF;
2168:

Line 2201: x_return_status := FND_API.G_RET_STS_SUCCESS;

2197: BEGIN
2198:
2199: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2200:
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: SELECT merge_reason_code INTO l_merge_reason_code
2204: FROM HZ_MERGE_BATCH
2205: WHERE batch_id = p_batch_id;

Line 2234: x_return_status := FND_API.G_RET_STS_ERROR;

2230: END IF;
2231: EXCEPTION
2232: WHEN OTHERS THEN
2233: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2234: x_return_status := FND_API.G_RET_STS_ERROR;
2235: raise;
2236: END;
2237: END IF;
2238:

Line 2271: x_return_status := FND_API.G_RET_STS_SUCCESS;

2267: BEGIN
2268:
2269: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2270:
2271: x_return_status := FND_API.G_RET_STS_SUCCESS;
2272:
2273: SELECT merge_reason_code INTO l_merge_reason_code
2274: FROM HZ_MERGE_BATCH
2275: WHERE batch_id = p_batch_id;

Line 2304: x_return_status := FND_API.G_RET_STS_ERROR;

2300: END IF;
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: raise;
2306: END;
2307: END IF;
2308:

Line 2340: x_return_status := FND_API.G_RET_STS_SUCCESS;

2336: BEGIN
2337:
2338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2339:
2340: x_return_status := FND_API.G_RET_STS_SUCCESS;
2341:
2342: SELECT merge_reason_code INTO l_merge_reason_code
2343: FROM HZ_MERGE_BATCH
2344: WHERE batch_id = p_batch_id;

Line 2373: x_return_status := FND_API.G_RET_STS_ERROR;

2369: END IF;
2370: EXCEPTION
2371: WHEN OTHERS THEN
2372: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2373: x_return_status := FND_API.G_RET_STS_ERROR;
2374: raise;
2375: END;
2376: END IF;
2377:

Line 2408: x_return_status := FND_API.G_RET_STS_SUCCESS;

2404: BEGIN
2405:
2406: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_CNT_MGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2407:
2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:
2410: SELECT merge_reason_code INTO l_merge_reason_code
2411: FROM HZ_MERGE_BATCH
2412: WHERE batch_id = p_batch_id;

Line 2441: x_return_status := FND_API.G_RET_STS_ERROR;

2437: END IF;
2438: EXCEPTION
2439: WHEN OTHERS THEN
2440: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: raise;
2443: END;
2444: END IF;
2445:

Line 2477: x_return_status := FND_API.G_RET_STS_SUCCESS;

2473: BEGIN
2474:
2475: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_END_CUST_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2476:
2477: x_return_status := FND_API.G_RET_STS_SUCCESS;
2478:
2479: SELECT merge_reason_code INTO l_merge_reason_code
2480: FROM HZ_MERGE_BATCH
2481: WHERE batch_id = p_batch_id;

Line 2510: x_return_status := FND_API.G_RET_STS_ERROR;

2506: END IF;
2507: EXCEPTION
2508: WHEN OTHERS THEN
2509: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2510: x_return_status := FND_API.G_RET_STS_ERROR;
2511: raise;
2512: END;
2513: END IF;
2514:

Line 2546: x_return_status := FND_API.G_RET_STS_SUCCESS;

2542: BEGIN
2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_RESELLER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2545:
2546: x_return_status := FND_API.G_RET_STS_SUCCESS;
2547:
2548: SELECT merge_reason_code INTO l_merge_reason_code
2549: FROM HZ_MERGE_BATCH
2550: WHERE batch_id = p_batch_id;

Line 2579: x_return_status := FND_API.G_RET_STS_ERROR;

2575: END IF;
2576: EXCEPTION
2577: WHEN OTHERS THEN
2578: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580: raise;
2581: END;
2582: END IF;
2583:

Line 2615: x_return_status := FND_API.G_RET_STS_SUCCESS;

2611: BEGIN
2612:
2613: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_PARENT_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2614:
2615: x_return_status := FND_API.G_RET_STS_SUCCESS;
2616:
2617: SELECT merge_reason_code INTO l_merge_reason_code
2618: FROM HZ_MERGE_BATCH
2619: WHERE batch_id = p_batch_id;

Line 2645: x_return_status := FND_API.G_RET_STS_ERROR;

2641: END IF;
2642: EXCEPTION
2643: WHEN OTHERS THEN
2644: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2645: x_return_status := FND_API.G_RET_STS_ERROR;
2646: raise;
2647: END;
2648: END IF;
2649:

Line 2681: x_return_status := FND_API.G_RET_STS_SUCCESS;

2677: BEGIN
2678:
2679: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_ROLLUP_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2680:
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;
2682:
2683: SELECT merge_reason_code INTO l_merge_reason_code
2684: FROM HZ_MERGE_BATCH
2685: WHERE batch_id = p_batch_id;

Line 2711: x_return_status := FND_API.G_RET_STS_ERROR;

2707: END IF;
2708: EXCEPTION
2709: WHEN OTHERS THEN
2710: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2711: x_return_status := FND_API.G_RET_STS_ERROR;
2712: raise;
2713: END;
2714: END IF;
2715:

Line 2748: x_return_status := FND_API.G_RET_STS_SUCCESS;

2744: BEGIN
2745:
2746: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_AUTOPAY_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2747:
2748: x_return_status := FND_API.G_RET_STS_SUCCESS;
2749:
2750: select merge_reason_code into l_merge_reason_code
2751: from HZ_MERGE_BATCH
2752: where batch_id = p_batch_id;

Line 2779: x_return_status := FND_API.G_RET_STS_ERROR;

2775: END IF;
2776: EXCEPTION
2777: WHEN OTHERS THEN
2778: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2779: x_return_status := FND_API.G_RET_STS_ERROR;
2780: raise;
2781: END;
2782: END IF;
2783:

Line 2815: x_return_status := FND_API.G_RET_STS_SUCCESS;

2811: BEGIN
2812:
2813: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_PARTNER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2814:
2815: x_return_status := FND_API.G_RET_STS_SUCCESS;
2816:
2817: SELECT merge_reason_code INTO l_merge_reason_code
2818: FROM HZ_MERGE_BATCH
2819: WHERE batch_id = p_batch_id;

Line 2848: x_return_status := FND_API.G_RET_STS_ERROR;

2844: END IF;
2845: EXCEPTION
2846: WHEN OTHERS THEN
2847: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2848: x_return_status := FND_API.G_RET_STS_ERROR;
2849: raise;
2850: END;
2851: END IF;
2852: