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.MSC_CL_SCE_COLLECTION dependencies on FND_MESSAGE

Line 442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');

438: EXCEPTION
439: WHEN OTHERS THEN
440: LOG_MESSAGE('Error while creating new companies');
441: LOG_MESSAGE('========================================');
442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
445: LOG_MESSAGE(FND_MESSAGE.GET);
446:

Line 443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');

439: WHEN OTHERS THEN
440: LOG_MESSAGE('Error while creating new companies');
441: LOG_MESSAGE('========================================');
442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
445: LOG_MESSAGE(FND_MESSAGE.GET);
446:
447: LOG_MESSAGE(SQLERRM);

Line 444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');

440: LOG_MESSAGE('Error while creating new companies');
441: LOG_MESSAGE('========================================');
442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
445: LOG_MESSAGE(FND_MESSAGE.GET);
446:
447: LOG_MESSAGE(SQLERRM);
448: END;

Line 445: LOG_MESSAGE(FND_MESSAGE.GET);

441: LOG_MESSAGE('========================================');
442: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
443: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
444: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
445: LOG_MESSAGE(FND_MESSAGE.GET);
446:
447: LOG_MESSAGE(SQLERRM);
448: END;
449: COMMIT;

Line 519: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');

515: EXCEPTION WHEN OTHERS THEN
516: LOG_MESSAGE('Error while uploading msc_company_id_lid table');
517:
518: LOG_MESSAGE('========================================');
519: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
520: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
521: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
522: LOG_MESSAGE(FND_MESSAGE.GET);
523:

Line 520: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');

516: LOG_MESSAGE('Error while uploading msc_company_id_lid table');
517:
518: LOG_MESSAGE('========================================');
519: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
520: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
521: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
522: LOG_MESSAGE(FND_MESSAGE.GET);
523:
524: LOG_MESSAGE(SQLERRM);

Line 521: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');

517:
518: LOG_MESSAGE('========================================');
519: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
520: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
521: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
522: LOG_MESSAGE(FND_MESSAGE.GET);
523:
524: LOG_MESSAGE(SQLERRM);
525:

Line 522: LOG_MESSAGE(FND_MESSAGE.GET);

518: LOG_MESSAGE('========================================');
519: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
520: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
521: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
522: LOG_MESSAGE(FND_MESSAGE.GET);
523:
524: LOG_MESSAGE(SQLERRM);
525:
526: ROLLBACK;

Line 605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');

601: WHEN OTHERS THEN
602: LOG_MESSAGE('Error while creating new relationships');
603:
604: LOG_MESSAGE('========================================');
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
608: LOG_MESSAGE(FND_MESSAGE.GET);
609:

Line 606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');

602: LOG_MESSAGE('Error while creating new relationships');
603:
604: LOG_MESSAGE('========================================');
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
608: LOG_MESSAGE(FND_MESSAGE.GET);
609:
610: LOG_MESSAGE(SQLERRM);

Line 607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');

603:
604: LOG_MESSAGE('========================================');
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
608: LOG_MESSAGE(FND_MESSAGE.GET);
609:
610: LOG_MESSAGE(SQLERRM);
611: ROLLBACK;

Line 608: LOG_MESSAGE(FND_MESSAGE.GET);

604: LOG_MESSAGE('========================================');
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
608: LOG_MESSAGE(FND_MESSAGE.GET);
609:
610: LOG_MESSAGE(SQLERRM);
611: ROLLBACK;
612: END;

Line 723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');

719: WHEN OTHERS THEN
720: LOG_MESSAGE('Error while creating new Sites');
721:
722: LOG_MESSAGE('========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
726: LOG_MESSAGE(FND_MESSAGE.GET);
727:

Line 724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');

720: LOG_MESSAGE('Error while creating new Sites');
721:
722: LOG_MESSAGE('========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
726: LOG_MESSAGE(FND_MESSAGE.GET);
727:
728: LOG_MESSAGE(SQLERRM);

Line 725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');

721:
722: LOG_MESSAGE('========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
726: LOG_MESSAGE(FND_MESSAGE.GET);
727:
728: LOG_MESSAGE(SQLERRM);
729: ROLLBACK;

Line 726: LOG_MESSAGE(FND_MESSAGE.GET);

722: LOG_MESSAGE('========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
726: LOG_MESSAGE(FND_MESSAGE.GET);
727:
728: LOG_MESSAGE(SQLERRM);
729: ROLLBACK;
730: END;

Line 802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');

798: EXCEPTION
799: WHEN OTHERS THEN
800: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
801: LOG_MESSAGE('========================================');
802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
805: LOG_MESSAGE(FND_MESSAGE.GET);
806: LOG_MESSAGE(SQLERRM);

Line 803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');

799: WHEN OTHERS THEN
800: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
801: LOG_MESSAGE('========================================');
802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
805: LOG_MESSAGE(FND_MESSAGE.GET);
806: LOG_MESSAGE(SQLERRM);
807:

Line 804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');

800: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
801: LOG_MESSAGE('========================================');
802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
805: LOG_MESSAGE(FND_MESSAGE.GET);
806: LOG_MESSAGE(SQLERRM);
807:
808: END;

Line 805: LOG_MESSAGE(FND_MESSAGE.GET);

801: LOG_MESSAGE('========================================');
802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
805: LOG_MESSAGE(FND_MESSAGE.GET);
806: LOG_MESSAGE(SQLERRM);
807:
808: END;
809: COMMIT;

Line 940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');

936:
937: IF (c_non_my_company > 0) THEN
938:
939: LOG_MESSAGE('========================================');
940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
943: LOG_MESSAGE(FND_MESSAGE.GET);
944:

Line 941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');

937: IF (c_non_my_company > 0) THEN
938:
939: LOG_MESSAGE('========================================');
940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
943: LOG_MESSAGE(FND_MESSAGE.GET);
944:
945:

Line 942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');

938:
939: LOG_MESSAGE('========================================');
940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
943: LOG_MESSAGE(FND_MESSAGE.GET);
944:
945:
946: RETURN FALSE;

Line 943: LOG_MESSAGE(FND_MESSAGE.GET);

939: LOG_MESSAGE('========================================');
940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
943: LOG_MESSAGE(FND_MESSAGE.GET);
944:
945:
946: RETURN FALSE;
947: END IF;

Line 953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

949: EXCEPTION WHEN OTHERS THEN
950:
951: LOG_MESSAGE('========================================');
952:
953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:

Line 954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');

950:
951: LOG_MESSAGE('========================================');
952:
953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:

Line 955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');

951: LOG_MESSAGE('========================================');
952:
953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:
959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');

Line 956: LOG_MESSAGE(FND_MESSAGE.GET);

952:
953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:
959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
960: LOG_MESSAGE(FND_MESSAGE.GET);

Line 959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');

955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:
959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
960: LOG_MESSAGE(FND_MESSAGE.GET);
961:
962: LOG_MESSAGE(SQLERRM);
963:

Line 960: LOG_MESSAGE(FND_MESSAGE.GET);

956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:
959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
960: LOG_MESSAGE(FND_MESSAGE.GET);
961:
962: LOG_MESSAGE(SQLERRM);
963:
964: RETURN FALSE;

Line 984: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MPX_COLL_ERR');

980:
981: IF (a_instance_type = 3) THEN
982:
983: LOG_MESSAGE('========================================');
984: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MPX_COLL_ERR');
985: LOG_MESSAGE(FND_MESSAGE.GET);
986:
987: RETURN FALSE;
988: END IF;

Line 985: LOG_MESSAGE(FND_MESSAGE.GET);

981: IF (a_instance_type = 3) THEN
982:
983: LOG_MESSAGE('========================================');
984: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MPX_COLL_ERR');
985: LOG_MESSAGE(FND_MESSAGE.GET);
986:
987: RETURN FALSE;
988: END IF;
989:

Line 1031: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');

1027:
1028: --==== Put this information into LOG file ====
1029: LOG_MESSAGE('========================================');
1030: LOG_MESSAGE('Supplier Item is being cross referenced with multiple Master Items');
1031: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1032: LOG_MESSAGE(FND_MESSAGE.GET);
1033:
1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');

Line 1032: LOG_MESSAGE(FND_MESSAGE.GET);

1028: --==== Put this information into LOG file ====
1029: LOG_MESSAGE('========================================');
1030: LOG_MESSAGE('Supplier Item is being cross referenced with multiple Master Items');
1031: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1032: LOG_MESSAGE(FND_MESSAGE.GET);
1033:
1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));

Line 1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');

1031: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1032: LOG_MESSAGE(FND_MESSAGE.GET);
1033:
1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1039: LOG_MESSAGE(FND_MESSAGE.GET);

Line 1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));

1032: LOG_MESSAGE(FND_MESSAGE.GET);
1033:
1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040: END LOOP;

Line 1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));

1033:
1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040: END LOOP;
1041:

Line 1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));

1034: FOR i in 1..a_organization_id.COUNT LOOP
1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040: END LOOP;
1041:
1042:

Line 1039: LOG_MESSAGE(FND_MESSAGE.GET);

1035: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1036: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1037: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1038: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040: END LOOP;
1041:
1042:
1043:

Line 1092: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_1');

1088:
1089: --==== Put this information into LOG file ====
1090: LOG_MESSAGE('========================================');
1091:
1092: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_1');
1093: LOG_MESSAGE(FND_MESSAGE.GET);
1094:
1095: FOR i in 1..a_company_id.COUNT LOOP
1096:

Line 1093: LOG_MESSAGE(FND_MESSAGE.GET);

1089: --==== Put this information into LOG file ====
1090: LOG_MESSAGE('========================================');
1091:
1092: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_1');
1093: LOG_MESSAGE(FND_MESSAGE.GET);
1094:
1095: FOR i in 1..a_company_id.COUNT LOOP
1096:
1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');

Line 1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');

1093: LOG_MESSAGE(FND_MESSAGE.GET);
1094:
1095: FOR i in 1..a_company_id.COUNT LOOP
1096:
1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1101: LOG_MESSAGE(FND_MESSAGE.GET);

Line 1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));

1094:
1095: FOR i in 1..a_company_id.COUNT LOOP
1096:
1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1101: LOG_MESSAGE(FND_MESSAGE.GET);
1102:

Line 1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));

1095: FOR i in 1..a_company_id.COUNT LOOP
1096:
1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1101: LOG_MESSAGE(FND_MESSAGE.GET);
1102:
1103: END LOOP;

Line 1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));

1096:
1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1101: LOG_MESSAGE(FND_MESSAGE.GET);
1102:
1103: END LOOP;
1104:

Line 1101: LOG_MESSAGE(FND_MESSAGE.GET);

1097: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1098: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1099: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1100: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1101: LOG_MESSAGE(FND_MESSAGE.GET);
1102:
1103: END LOOP;
1104:
1105: FORALL i IN 1..a_company_id.COUNT

Line 1174: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1170: WHEN OTHERS THEN
1171: LOG_MESSAGE('Error while creating Bi-Directional records');
1172:
1173: LOG_MESSAGE('========================================');
1174: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1175: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: LOG_MESSAGE(SQLERRM);

Line 1175: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');

1171: LOG_MESSAGE('Error while creating Bi-Directional records');
1172:
1173: LOG_MESSAGE('========================================');
1174: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1175: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: LOG_MESSAGE(SQLERRM);
1179: return FALSE;

Line 1176: LOG_MESSAGE(FND_MESSAGE.GET);

1172:
1173: LOG_MESSAGE('========================================');
1174: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1175: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: LOG_MESSAGE(SQLERRM);
1179: return FALSE;
1180: END;

Line 1280: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');

1276: where mis.rowid = CHARTOROWID(a_rowid(i));
1277: EXCEPTION WHEN OTHERS THEN
1278: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1279: LOG_MESSAGE('========================================');
1280: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1281: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1282: LOG_MESSAGE(FND_MESSAGE.GET);
1283: END;
1284: END IF;

Line 1281: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');

1277: EXCEPTION WHEN OTHERS THEN
1278: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1279: LOG_MESSAGE('========================================');
1280: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1281: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1282: LOG_MESSAGE(FND_MESSAGE.GET);
1283: END;
1284: END IF;
1285: */

Line 1282: LOG_MESSAGE(FND_MESSAGE.GET);

1278: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1279: LOG_MESSAGE('========================================');
1280: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1281: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1282: LOG_MESSAGE(FND_MESSAGE.GET);
1283: END;
1284: END IF;
1285: */
1286:

Line 1310: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');

1306: where msic.rowid = CHARTOROWID(a_rowid(i));
1307: EXCEPTION WHEN OTHERS THEN
1308: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1309: LOG_MESSAGE('========================================');
1310: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1311: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1312: LOG_MESSAGE(FND_MESSAGE.GET);
1313: END;
1314: END IF;

Line 1311: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');

1307: EXCEPTION WHEN OTHERS THEN
1308: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1309: LOG_MESSAGE('========================================');
1310: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1311: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1312: LOG_MESSAGE(FND_MESSAGE.GET);
1313: END;
1314: END IF;
1315:

Line 1312: LOG_MESSAGE(FND_MESSAGE.GET);

1308: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1309: LOG_MESSAGE('========================================');
1310: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1311: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1312: LOG_MESSAGE(FND_MESSAGE.GET);
1313: END;
1314: END IF;
1315:
1316: