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_FILE

Line 23: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.REG_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

19: l_merge_reason_code VARCHAR2(30);
20:
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

Line 130: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.REG_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

126: raise;
127: END;
128: END IF;
129:
130: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.REG_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
131:
132: END REG_PARTY_MERGE;
133:
134: PROCEDURE ATN_PARTY_MERGE

Line 151: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.ATN_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

147: l_merge_reason_code VARCHAR2(30);
148:
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

Line 257: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.ATN_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

253: raise;
254: END;
255: END IF;
256:
257: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.ATN_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
258:
259: END ATN_PARTY_MERGE;
260:
261: -----------------------------------------------------------------------

Line 285: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

281: l_merge_reason_code VARCHAR2(30);
282:
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

Line 365: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

361: raise;
362: END;
363: END IF;
364:
365: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
366:
367: END Channel_Party_Merge;
368:
369: -----------------------------------------------------------------------

Line 393: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

389: l_merge_reason_code VARCHAR2(30);
390:
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

Line 473: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

469: raise;
470: END;
471: END IF;
472:
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
474:
475: END Party_src_Party_Merge;
476:
477: -----------------------------------------------------------------------

Line 501: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.SEGMENT_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

497: l_merge_reason_code VARCHAR2(30);
498:
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

Line 581: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.SEGMENT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

577: raise;
578: END;
579: END IF;
580:
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.SEGMENT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
582:
583: END Segment_Party_Merge;
584:
585: -----------------------------------------------------------------------

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

605: l_merge_reason_code VARCHAR2(30);
606:
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

Line 689: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_CUST_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

685: raise;
686: END;
687: END IF;
688:
689: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_CUST_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
690:
691: END Post_Cust_Party_Merge;
692:
693: -----------------------------------------------------------------------

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

713: l_merge_reason_code VARCHAR2(30);
714:
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

Line 797: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_AFFL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

793: raise;
794: END;
795: END IF;
796:
797: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.POST_AFFL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
798:
799: END Post_Affl_Party_Merge;
800:
801:

Line 826: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_PARTNER_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

822: l_merge_reason_code VARCHAR2(30);
823:
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

Line 867: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_PARTNER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

863: raise;
864: END;
865: END IF;
866:
867: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_PARTNER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
868:
869: END Campaign_Partner_Merge;
870:
871: -----------------------------------------------------------------------

Line 895: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_VAD_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

891: l_merge_reason_code VARCHAR2(30);
892:
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

Line 936: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_VAD_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

932: raise;
933: END;
934: END IF;
935:
936: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_VAD_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
937:
938: END Campaign_VAD_Merge;
939:
940: -----------------------------------------------------------------------

Line 964: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_CONTACT_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

960: l_merge_reason_code VARCHAR2(30);
961:
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

Line 1005: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1001: raise;
1002: END;
1003: END IF;
1004:
1005: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CAMPAIGN_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1006:
1007: END Campaign_Contact_Merge;
1008: -----------------------------------------------------------------------
1009: FUNCTION check_party_exists(p_party_id IN number)

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

1056:
1057: l_to_party_exists varchar2(20);
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

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

1107: raise;
1108: END;
1109: END IF;
1110:
1111: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TRADE_PROFILE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1112: */
1113: NULL;
1114: END Trade_Profile_Party_Merge;
1115:

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

1136: l_merge_reason_code VARCHAR2(30);
1137:
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

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

1177: raise;
1178: END;
1179: END IF;
1180:
1181: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1182: */
1183: NULL;
1184: END Claim_Broker_Merge;
1185:

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

1206: l_merge_reason_code VARCHAR2(30);
1207:
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

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

1247: raise;
1248: END;
1249: END IF;
1250:
1251: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1252: */
1253: NULL;
1254: END Claim_Contact_Merge;
1255:

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

1277: l_merge_reason_code VARCHAR2(30);
1278:
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

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

1318: raise;
1319: END;
1320: END IF;
1321:
1322: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_HISTORY_BROKER_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1323: */
1324: NULL;
1325: END Claim_History_Broker_Merge;
1326:

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

1348: l_merge_reason_code VARCHAR2(30);
1349:
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

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

1389: raise;
1390: END;
1391: END IF;
1392:
1393: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CLAIM_HISTORY_CONTACT_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1394: */
1395: NULL;
1396: END Claim_History_Contact_Merge;
1397:

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

1418: l_merge_reason_code VARCHAR2(30);
1419:
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

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

1460: raise;
1461: END;
1462: END IF;
1463:
1464: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.BUDGET_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1465: */
1466: NULL;
1467: END Budget_Party_Merge;
1468:

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

1489: l_merge_reason_code VARCHAR2(30);
1490:
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

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

1530: raise;
1531: END;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.BUDGET_VENDOR_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1535: */
1536: NULL;
1537: END Budget_Vendor_Merge;
1538:

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

1552: l_merge_reason_code VARCHAR2(30);
1553:
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

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

1590: raise;
1591: END;
1592: END IF;
1593:
1594: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.OFFER_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1595: */
1596: NULL;
1597: END OFFER_PARTY_Merge;
1598:

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

1620: l_merge_reason_code VARCHAR2(30);
1621:
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

Line 1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.Product_Comp_Party_Merge end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1658: raise;
1659: END;
1660: END IF;
1661:
1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.Product_Comp_Party_Merge end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1663:
1664: END Product_Comp_Party_Merge;
1665:
1666: -----------------------------------------------------------------------

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

1686: l_merge_reason_code VARCHAR2(30);
1687:
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

Line 1729: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.PLACEMENT_SITE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1725: raise;
1726: END;
1727: END IF;
1728:
1729: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.PLACEMENT_SITE_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1730:
1731: END PLACEMENT_SITE_PARTY_MERGE;
1732:
1733: -----------------------------------------------------------------------

Line 1757: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1753: l_merge_reason_code VARCHAR2(30);
1754:
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

Line 1834: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1830: raise;
1831: END;
1832: END IF;
1833:
1834: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1835:
1836: END Src_lines_Party_Merge;
1837:
1838: -----------------------------------------------------------------------

Line 1862: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1858: l_merge_reason_code VARCHAR2(30);
1859:
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

Line 1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1935: raise;
1936: END;
1937: END IF;
1938:
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1940:
1941: END List_entries_Party_Merge;
1942:
1943: -----------------------------------------------------------------------

Line 1967: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1963: l_merge_reason_code VARCHAR2(30);
1964:
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

Line 2044: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2040: raise;
2041: END;
2042: END IF;
2043:
2044: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2045:
2046: END Listentries_Parent_Party_Merge;
2047:
2048: -----------------------------------------------------------------------

Line 2072: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.VENUES_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2068: l_merge_reason_code VARCHAR2(30);
2069:
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

Line 2150: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.VENUES_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2146: raise;
2147: END;
2148: END IF;
2149:
2150: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.VENUES_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2151:
2152: END Venues_Party_Merge;
2153:
2154: -----------------------------------------------------------------------

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

2187: l_is_duplicate VARCHAR2(10);
2188:
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

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

2277: raise;
2278: END;
2279: END IF;
2280:
2281: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.OFFER_DENORM_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2282: */
2283: NULL;
2284: END Offer_Denorm_Party_Merge;
2285:

Line 2315: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.RESOURCES_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2311:
2312: BEGIN
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

Line 2396: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.RESOURCES_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2392: END;
2393: END IF;
2394:
2395:
2396: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.RESOURCES_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2397:
2398: END Resources_Party_Merge;
2399:
2400: -----------------------------------------------------------------------

Line 2426: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.AGENDAS_PARTY_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2422:
2423: BEGIN
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

Line 2506: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.AGENDAS_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2502: END;
2503: END IF;
2504:
2505:
2506: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.AGENDAS_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2507:
2508: END Agendas_Party_Merge;
2509:
2510: -----------------------------------------------------------------------

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

2534:
2535: BEGIN
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

Line 2633: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2629: END;
2630: END IF;
2631:
2632:
2633: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CHANNEL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2634:
2635: END TCOP_CHANNEL_PARTY_MERGE;
2636:
2637:

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

2663:
2664: BEGIN
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

Line 2761: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2757: END;
2758: END IF;
2759:
2760:
2761: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2762:
2763: END TCOP_CONTACT_PARTY_MERGE;
2764:
2765:

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

2796:
2797: BEGIN
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

Line 2895: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_SUMM_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

2891: END;
2892: END IF;
2893:
2894:
2895: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_CONTACT_SUMM_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
2896:
2897: END TCOP_CONTACT_SUMM_PARTY_MERGE;
2898:
2899:

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

2923:
2924: BEGIN
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

Line 3006: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_CONTACT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

3002: END;
3003: END IF;
3004:
3005:
3006: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_CONTACT_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
3007:
3008: END TCOP_PRVW_CONTACT_PARTY_MERGE;
3009:
3010:

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

3034:
3035: BEGIN
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

Line 3129: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_FTG_DTL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

3125: END;
3126: END IF;
3127:
3128:
3129: FND_FILE.PUT_LINE(FND_FILE.LOG,'AMS_PARTY_MERGE_PKG.TCOP_PRVW_FTG_DTL_PARTY_MERGE end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
3130:
3131: END TCOP_PRVW_FTG_DTL_PARTY_MERGE;
3132:
3133: