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_FILE

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

55:
56: l_to_party_exists varchar2(20);
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

Line 110: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.TRADE_PROFILE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

106: raise;
107: END;
108: END IF;
109:
110: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.TRADE_PROFILE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
111:
112: END Trade_Profile_Party_Merge;
113:
114: -----------------------------------------------------------------------

Line 138: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

134: l_merge_reason_code VARCHAR2(30);
135:
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

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

175: raise;
176: END;
177: END IF;
178:
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
180:
181: END Claim_Broker_Merge;
182:
183: -----------------------------------------------------------------------

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

203: l_merge_reason_code VARCHAR2(30);
204:
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

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

244: raise;
245: END;
246: END IF;
247:
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
249:
250: END Claim_Contact_Merge;
251:
252:

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

273: l_merge_reason_code VARCHAR2(30);
274:
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

Line 318: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

314: raise;
315: END;
316: END IF;
317:
318: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
319:
320: END Claim_History_Broker_Merge;
321:
322:

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

343: l_merge_reason_code VARCHAR2(30);
344:
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

Line 388: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

384: raise;
385: END;
386: END IF;
387:
388: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_HISTORY_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
389:
390: END Claim_History_Contact_Merge;
391:
392: -----------------------------------------------------------------------

Line 416: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

412: l_merge_reason_code VARCHAR2(30);
413:
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

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

454: raise;
455: END;
456: END IF;
457:
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
459:
460: END Budget_Party_Merge;
461:
462: -----------------------------------------------------------------------

Line 486: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

482: l_merge_reason_code VARCHAR2(30);
483:
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

Line 527: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

523: raise;
524: END;
525: END IF;
526:
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
528:
529: END Budget_Vendor_Merge;
530:
531: PROCEDURE Offer_Buy_Group_Party_Merge

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

544: l_merge_reason_code VARCHAR2(30);
545:
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

Line 586: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

582: raise;
583: END;
584: END IF;
585:
586: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
587:
588: END Offer_Buy_Group_Party_Merge;
589:
590:

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

626: l_is_duplicate VARCHAR2(10);
627: */
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

Line 719: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_DENORM_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

715: raise;
716: END;
717: END IF;
718:
719: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_DENORM_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
720:
721: END Offer_Denorm_Party_Merge;
722:
723:

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

744: l_merge_reason_code VARCHAR2(30);
745:
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

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

785: raise;
786: END;
787: END IF;
788:
789: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
790:
791: END Claim_Line_Party_Merge;
792:
793: -----------------------------------------------------------------------

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

813: l_merge_reason_code VARCHAR2(30);
814:
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

Line 858: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_HIST_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

854: raise;
855: END;
856: END IF;
857:
858: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CLAIM_LINE_HIST_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
859:
860: END Claim_Line_Hist_Party_Merge;
861:
862: -----------------------------------------------------------------------

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

882: l_merge_reason_code VARCHAR2(30);
883:
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

Line 924: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CODE_CONVERSION_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

920: END;
921: END IF;
922:
923:
924: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.CODE_CONVERSION_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
925:
926: END Code_Conversion_Party_Merge;
927:
928: -----------------------------------------------------------------------

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

948: l_merge_reason_code VARCHAR2(30);
949:
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

Line 993: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

989: END;
990: END IF;
991:
992:
993: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
994:
995: END Resale_Batch_Prtn_Merge;
996:
997: -----------------------------------------------------------------------

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

1017: l_merge_reason_code VARCHAR2(30);
1018:
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

Line 1062: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_CNT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1058: END;
1059: END IF;
1060:
1061:
1062: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_BATCH_PRTN_CNT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1063:
1064: END Resale_Batch_Prtn_Cnt_Merge;
1065:
1066: -----------------------------------------------------------------------

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

1086: l_merge_reason_code VARCHAR2(30);
1087:
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

Line 1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1127: END;
1128: END IF;
1129:
1130:
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1132:
1133: END Resale_Int_Ship_Frm_Cnt_Mge;
1134:
1135: -----------------------------------------------------------------------

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

1155: l_merge_reason_code VARCHAR2(30);
1156:
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

Line 1200: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SOLD_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1196: END;
1197: END IF;
1198:
1199:
1200: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SOLD_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1201:
1202: END Resale_Int_Sold_Frm_Cnt_Mge;
1203:
1204:

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

1225: l_merge_reason_code VARCHAR2(30);
1226:
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

Line 1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1266: END;
1267: END IF;
1268:
1269:
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1271:
1272: END Resale_Int_Bill_To_Merge;
1273:
1274:

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

1295: l_merge_reason_code VARCHAR2(30);
1296:
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

Line 1340: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1336: END;
1337: END IF;
1338:
1339:
1340: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1341:
1342: END Resale_Int_Bill_To_Cnt_Mge;
1343:
1344: -----------------------------------------------------------------------

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

1364: l_merge_reason_code VARCHAR2(30);
1365:
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

Line 1409: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1405: END;
1406: END IF;
1407:
1408:
1409: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1410:
1411: END Resale_Int_Ship_To_Merge;
1412:
1413:

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

1434: l_merge_reason_code VARCHAR2(30);
1435:
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

Line 1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1475: END;
1476: END IF;
1477:
1478:
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1480:
1481: END Resale_Int_Ship_To_Cnt_Mge;
1482:
1483: -----------------------------------------------------------------------

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

1503: l_merge_reason_code VARCHAR2(30);
1504:
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

Line 1548: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1544: END;
1545: END IF;
1546:
1547:
1548: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1549:
1550: END Resale_Int_End_Cust_Merge;
1551:
1552: -----------------------------------------------------------------------

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

1572: l_merge_reason_code VARCHAR2(30);
1573:
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

Line 1617: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_END_CUST_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1613: END;
1614: END IF;
1615:
1616:
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_INT_END_CUST_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1618:
1619: END Resale_Int_End_Cust_Cnt_Mge;
1620:
1621: -----------------------------------------------------------------------

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

1641: l_merge_reason_code VARCHAR2(30);
1642:
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

Line 1686: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1682: END;
1683: END IF;
1684:
1685:
1686: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1687:
1688: END Resale_Head_Bill_To_Merge;
1689:
1690: -----------------------------------------------------------------------

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

1710: l_merge_reason_code VARCHAR2(30);
1711:
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

Line 1755: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1751: END;
1752: END IF;
1753:
1754:
1755: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1756:
1757: END Resale_Head_Bill_To_Cnt_Mge;
1758:
1759: -----------------------------------------------------------------------

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

1779: l_merge_reason_code VARCHAR2(30);
1780:
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

Line 1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1820: END;
1821: END IF;
1822:
1823:
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1825:
1826: END Resale_Head_Ship_To_Merge;
1827:
1828: -----------------------------------------------------------------------

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

1848: l_merge_reason_code VARCHAR2(30);
1849:
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

Line 1893: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1889: END;
1890: END IF;
1891:
1892:
1893: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_HEAD_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1894:
1895: END Resale_Head_Ship_To_Cnt_Mge;
1896:
1897: -----------------------------------------------------------------------

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

1917: l_merge_reason_code VARCHAR2(30);
1918:
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

Line 1962: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1958: END;
1959: END IF;
1960:
1961:
1962: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1963:
1964: END Resale_Line_Ship_Frm_Cnt_Mge;
1965:
1966: -----------------------------------------------------------------------

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

1986: l_merge_reason_code VARCHAR2(30);
1987:
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

Line 2031: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SOLD_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2027: END;
2028: END IF;
2029:
2030:
2031: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SOLD_FRM_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2032:
2033: END Resale_Line_Sold_Frm_Cnt_Mge;
2034:
2035: -----------------------------------------------------------------------

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

2055: l_merge_reason_code VARCHAR2(30);
2056:
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

Line 2100: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2096: END;
2097: END IF;
2098:
2099:
2100: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2101:
2102: END Resale_Line_Bill_To_Merge;
2103:
2104:

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

2125: l_merge_reason_code VARCHAR2(30);
2126:
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

Line 2170: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2166: END;
2167: END IF;
2168:
2169:
2170: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_BILL_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2171:
2172: END Resale_Line_Bill_To_Cnt_Mge;
2173:
2174:

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

2195: l_merge_reason_code VARCHAR2(30);
2196:
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

Line 2240: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2236: END;
2237: END IF;
2238:
2239:
2240: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2241:
2242: END Resale_Line_Ship_To_Merge;
2243:
2244:

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

2265: l_merge_reason_code VARCHAR2(30);
2266:
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

Line 2310: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2306: END;
2307: END IF;
2308:
2309:
2310: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_SHIP_TO_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2311:
2312: END Resale_Line_Ship_To_Cnt_Mge;
2313:
2314: -----------------------------------------------------------------------

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

2334: l_merge_reason_code VARCHAR2(30);
2335:
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

Line 2379: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2375: END;
2376: END IF;
2377:
2378:
2379: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2380:
2381: END Resale_Line_End_Cust_Merge;
2382: -----------------------------------------------------------------------
2383: -- PROCEDURE

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

2402: l_merge_reason_code VARCHAR2(30);
2403:
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

Line 2447: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2443: END;
2444: END IF;
2445:
2446:
2447: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.RESALE_LINE_END_CUST_CNT_MGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2448:
2449: END Resale_Line_End_Cust_Cnt_Mge;
2450:
2451: -----------------------------------------------------------------------

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

2471: l_merge_reason_code VARCHAR2(30);
2472:
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

Line 2516: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2512: END;
2513: END IF;
2514:
2515:
2516: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_END_CUST_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2517:
2518: END Request_Head_End_Cust_Merge;
2519:
2520: -----------------------------------------------------------------------

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

2540: l_merge_reason_code VARCHAR2(30);
2541:
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

Line 2585: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_RESELLER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2581: END;
2582: END IF;
2583:
2584:
2585: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_RESELLER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2586:
2587: END Request_Head_Reseller_Merge;
2588:
2589: -----------------------------------------------------------------------

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

2609: l_merge_reason_code VARCHAR2(30);
2610:
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

Line 2651: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_PARENT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2647: END;
2648: END IF;
2649:
2650:
2651: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_PARENT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2652:
2653: END Acct_Alloc_Parent_Party_Merge;
2654:
2655: -----------------------------------------------------------------------

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

2675: l_merge_reason_code VARCHAR2(30);
2676:
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

Line 2717: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_ROLLUP_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2713: END;
2714: END IF;
2715:
2716:
2717: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.ACCT_ALLOC_ROLLUP_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2718:
2719: END Acct_Alloc_Rollup_Party_Merge;
2720:
2721: -----------------------------------------------------------------------

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

2742: l_merge_reason_code VARCHAR2(30);
2743:
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

Line 2784: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_AUTOPAY_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2780: raise;
2781: END;
2782: END IF;
2783:
2784: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.OFFER_AUTOPAY_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2785:
2786: END Offer_Autopay_Party_Merge;
2787:
2788:

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

2809: l_merge_reason_code VARCHAR2(30);
2810:
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

Line 2854: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_PARTNER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2850: END;
2851: END IF;
2852:
2853:
2854: FND_FILE.PUT_LINE(FND_FILE.LOG,'OZF_PARTY_MERGE_PKG.REQUEST_HEAD_PARTNER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2855:
2856: END Request_Head_Partner_Merge;
2857:
2858: