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 525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');

521: EXCEPTION
522: WHEN OTHERS THEN
523: LOG_MESSAGE('Error while creating new companies');
524: LOG_MESSAGE('========================================');
525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
528: LOG_MESSAGE(FND_MESSAGE.GET);
529:

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

522: WHEN OTHERS THEN
523: LOG_MESSAGE('Error while creating new companies');
524: LOG_MESSAGE('========================================');
525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
528: LOG_MESSAGE(FND_MESSAGE.GET);
529:
530: LOG_MESSAGE(SQLERRM);

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

523: LOG_MESSAGE('Error while creating new companies');
524: LOG_MESSAGE('========================================');
525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
528: LOG_MESSAGE(FND_MESSAGE.GET);
529:
530: LOG_MESSAGE(SQLERRM);
531: END;

Line 528: LOG_MESSAGE(FND_MESSAGE.GET);

524: LOG_MESSAGE('========================================');
525: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_NEW_COMP_ERR');
526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANIES');
527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANIES');
528: LOG_MESSAGE(FND_MESSAGE.GET);
529:
530: LOG_MESSAGE(SQLERRM);
531: END;
532: COMMIT;

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

598: EXCEPTION WHEN OTHERS THEN
599: LOG_MESSAGE('Error while uploading msc_company_id_lid table');
600:
601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
605: LOG_MESSAGE(FND_MESSAGE.GET);
606:

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

599: LOG_MESSAGE('Error while uploading msc_company_id_lid table');
600:
601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
605: LOG_MESSAGE(FND_MESSAGE.GET);
606:
607: LOG_MESSAGE(SQLERRM);

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

600:
601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
605: LOG_MESSAGE(FND_MESSAGE.GET);
606:
607: LOG_MESSAGE(SQLERRM);
608:

Line 605: LOG_MESSAGE(FND_MESSAGE.GET);

601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
605: LOG_MESSAGE(FND_MESSAGE.GET);
606:
607: LOG_MESSAGE(SQLERRM);
608:
609: ROLLBACK;

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

684: WHEN OTHERS THEN
685: LOG_MESSAGE('Error while creating new relationships');
686:
687: LOG_MESSAGE('========================================');
688: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
689: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
690: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
691: LOG_MESSAGE(FND_MESSAGE.GET);
692:

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

685: LOG_MESSAGE('Error while creating new relationships');
686:
687: LOG_MESSAGE('========================================');
688: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
689: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
690: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
691: LOG_MESSAGE(FND_MESSAGE.GET);
692:
693: LOG_MESSAGE(SQLERRM);

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

686:
687: LOG_MESSAGE('========================================');
688: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
689: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
690: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
691: LOG_MESSAGE(FND_MESSAGE.GET);
692:
693: LOG_MESSAGE(SQLERRM);
694: ROLLBACK;

Line 691: LOG_MESSAGE(FND_MESSAGE.GET);

687: LOG_MESSAGE('========================================');
688: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
689: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
690: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
691: LOG_MESSAGE(FND_MESSAGE.GET);
692:
693: LOG_MESSAGE(SQLERRM);
694: ROLLBACK;
695: END;

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

802: WHEN OTHERS THEN
803: LOG_MESSAGE('Error while creating new Sites');
804:
805: LOG_MESSAGE('========================================');
806: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
807: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
809: LOG_MESSAGE(FND_MESSAGE.GET);
810:

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

803: LOG_MESSAGE('Error while creating new Sites');
804:
805: LOG_MESSAGE('========================================');
806: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
807: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
809: LOG_MESSAGE(FND_MESSAGE.GET);
810:
811: LOG_MESSAGE(SQLERRM);

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

804:
805: LOG_MESSAGE('========================================');
806: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
807: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
809: LOG_MESSAGE(FND_MESSAGE.GET);
810:
811: LOG_MESSAGE(SQLERRM);
812: ROLLBACK;

Line 809: LOG_MESSAGE(FND_MESSAGE.GET);

805: LOG_MESSAGE('========================================');
806: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
807: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
809: LOG_MESSAGE(FND_MESSAGE.GET);
810:
811: LOG_MESSAGE(SQLERRM);
812: ROLLBACK;
813: END;

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

881: EXCEPTION
882: WHEN OTHERS THEN
883: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
884: LOG_MESSAGE('========================================');
885: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
886: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
887: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
888: LOG_MESSAGE(FND_MESSAGE.GET);
889: LOG_MESSAGE(SQLERRM);

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

882: WHEN OTHERS THEN
883: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
884: LOG_MESSAGE('========================================');
885: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
886: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
887: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
888: LOG_MESSAGE(FND_MESSAGE.GET);
889: LOG_MESSAGE(SQLERRM);
890:

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

883: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
884: LOG_MESSAGE('========================================');
885: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
886: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
887: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
888: LOG_MESSAGE(FND_MESSAGE.GET);
889: LOG_MESSAGE(SQLERRM);
890:
891: END;

Line 888: LOG_MESSAGE(FND_MESSAGE.GET);

884: LOG_MESSAGE('========================================');
885: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
886: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
887: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
888: LOG_MESSAGE(FND_MESSAGE.GET);
889: LOG_MESSAGE(SQLERRM);
890:
891: END;
892: COMMIT;

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

1019:
1020: IF (c_non_my_company > 0) THEN
1021:
1022: LOG_MESSAGE('========================================');
1023: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
1024: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1026: LOG_MESSAGE(FND_MESSAGE.GET);
1027:

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

1020: IF (c_non_my_company > 0) THEN
1021:
1022: LOG_MESSAGE('========================================');
1023: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
1024: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1026: LOG_MESSAGE(FND_MESSAGE.GET);
1027:
1028:

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

1021:
1022: LOG_MESSAGE('========================================');
1023: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
1024: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1026: LOG_MESSAGE(FND_MESSAGE.GET);
1027:
1028:
1029: RETURN FALSE;

Line 1026: LOG_MESSAGE(FND_MESSAGE.GET);

1022: LOG_MESSAGE('========================================');
1023: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
1024: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1026: LOG_MESSAGE(FND_MESSAGE.GET);
1027:
1028:
1029: RETURN FALSE;
1030: END IF;

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

1032: EXCEPTION WHEN OTHERS THEN
1033:
1034: LOG_MESSAGE('========================================');
1035:
1036: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:

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

1033:
1034: LOG_MESSAGE('========================================');
1035:
1036: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:

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

1034: LOG_MESSAGE('========================================');
1035:
1036: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:
1042: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');

Line 1039: LOG_MESSAGE(FND_MESSAGE.GET);

1035:
1036: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:
1042: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
1043: LOG_MESSAGE(FND_MESSAGE.GET);

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

1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:
1042: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
1043: LOG_MESSAGE(FND_MESSAGE.GET);
1044:
1045: LOG_MESSAGE(SQLERRM);
1046:

Line 1043: LOG_MESSAGE(FND_MESSAGE.GET);

1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:
1042: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');
1043: LOG_MESSAGE(FND_MESSAGE.GET);
1044:
1045: LOG_MESSAGE(SQLERRM);
1046:
1047: RETURN FALSE;

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

1063:
1064: IF (a_instance_type = 3) THEN
1065:
1066: LOG_MESSAGE('========================================');
1067: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MPX_COLL_ERR');
1068: LOG_MESSAGE(FND_MESSAGE.GET);
1069:
1070: RETURN FALSE;
1071: END IF;

Line 1068: LOG_MESSAGE(FND_MESSAGE.GET);

1064: IF (a_instance_type = 3) THEN
1065:
1066: LOG_MESSAGE('========================================');
1067: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MPX_COLL_ERR');
1068: LOG_MESSAGE(FND_MESSAGE.GET);
1069:
1070: RETURN FALSE;
1071: END IF;
1072:

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

1110:
1111: --==== Put this information into LOG file ====
1112: LOG_MESSAGE('========================================');
1113: LOG_MESSAGE('Supplier Item is being cross referenced with multiple Master Items');
1114: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1115: LOG_MESSAGE(FND_MESSAGE.GET);
1116:
1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');

Line 1115: LOG_MESSAGE(FND_MESSAGE.GET);

1111: --==== Put this information into LOG file ====
1112: LOG_MESSAGE('========================================');
1113: LOG_MESSAGE('Supplier Item is being cross referenced with multiple Master Items');
1114: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1115: LOG_MESSAGE(FND_MESSAGE.GET);
1116:
1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));

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

1114: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_1');
1115: LOG_MESSAGE(FND_MESSAGE.GET);
1116:
1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1120: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1121: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1122: LOG_MESSAGE(FND_MESSAGE.GET);

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

1115: LOG_MESSAGE(FND_MESSAGE.GET);
1116:
1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1120: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1121: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1122: LOG_MESSAGE(FND_MESSAGE.GET);
1123: END LOOP;

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

1116:
1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1120: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1121: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1122: LOG_MESSAGE(FND_MESSAGE.GET);
1123: END LOOP;
1124:

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

1117: FOR i in 1..a_organization_id.COUNT LOOP
1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1120: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1121: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1122: LOG_MESSAGE(FND_MESSAGE.GET);
1123: END LOOP;
1124:
1125:

Line 1122: LOG_MESSAGE(FND_MESSAGE.GET);

1118: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_SUPP_2');
1119: FND_MESSAGE.SET_TOKEN('SUPPLIER_ID', a_supplier_id(i));
1120: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_supplier_site_id(i));
1121: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a_item_name(i));
1122: LOG_MESSAGE(FND_MESSAGE.GET);
1123: END LOOP;
1124:
1125:
1126:

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

1171:
1172: --==== Put this information into LOG file ====
1173: LOG_MESSAGE('========================================');
1174:
1175: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_1');
1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: FOR i in 1..a_company_id.COUNT LOOP
1179:

Line 1176: LOG_MESSAGE(FND_MESSAGE.GET);

1172: --==== Put this information into LOG file ====
1173: LOG_MESSAGE('========================================');
1174:
1175: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_1');
1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: FOR i in 1..a_company_id.COUNT LOOP
1179:
1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');

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

1176: LOG_MESSAGE(FND_MESSAGE.GET);
1177:
1178: FOR i in 1..a_company_id.COUNT LOOP
1179:
1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1181: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1182: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1183: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1184: LOG_MESSAGE(FND_MESSAGE.GET);

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

1177:
1178: FOR i in 1..a_company_id.COUNT LOOP
1179:
1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1181: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1182: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1183: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1184: LOG_MESSAGE(FND_MESSAGE.GET);
1185:

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

1178: FOR i in 1..a_company_id.COUNT LOOP
1179:
1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1181: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1182: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1183: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1184: LOG_MESSAGE(FND_MESSAGE.GET);
1185:
1186: END LOOP;

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

1179:
1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1181: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1182: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1183: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1184: LOG_MESSAGE(FND_MESSAGE.GET);
1185:
1186: END LOOP;
1187:

Line 1184: LOG_MESSAGE(FND_MESSAGE.GET);

1180: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_ITEM_CUST_2');
1181: FND_MESSAGE.SET_TOKEN('CUSTOMER_ID', a_customer_id(i));
1182: FND_MESSAGE.SET_TOKEN('SUPPLIER_SITE_ID', a_customer_site_id(i));
1183: FND_MESSAGE.SET_TOKEN('SUPPLIER_ITEM_NAME', a1_item_name(i));
1184: LOG_MESSAGE(FND_MESSAGE.GET);
1185:
1186: END LOOP;
1187:
1188: FORALL i IN 1..a_company_id.COUNT

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

1253: WHEN OTHERS THEN
1254: LOG_MESSAGE('Error while creating Bi-Directional records');
1255:
1256: LOG_MESSAGE('========================================');
1257: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1258: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1259: LOG_MESSAGE(FND_MESSAGE.GET);
1260:
1261: LOG_MESSAGE(SQLERRM);

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

1254: LOG_MESSAGE('Error while creating Bi-Directional records');
1255:
1256: LOG_MESSAGE('========================================');
1257: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1258: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1259: LOG_MESSAGE(FND_MESSAGE.GET);
1260:
1261: LOG_MESSAGE(SQLERRM);
1262: return FALSE;

Line 1259: LOG_MESSAGE(FND_MESSAGE.GET);

1255:
1256: LOG_MESSAGE('========================================');
1257: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1258: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1259: LOG_MESSAGE(FND_MESSAGE.GET);
1260:
1261: LOG_MESSAGE(SQLERRM);
1262: return FALSE;
1263: END;

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

1359: where mis.rowid = CHARTOROWID(a_rowid(i));
1360: EXCEPTION WHEN OTHERS THEN
1361: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1362: LOG_MESSAGE('========================================');
1363: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1364: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1365: LOG_MESSAGE(FND_MESSAGE.GET);
1366: END;
1367: END IF;

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

1360: EXCEPTION WHEN OTHERS THEN
1361: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1362: LOG_MESSAGE('========================================');
1363: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1364: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1365: LOG_MESSAGE(FND_MESSAGE.GET);
1366: END;
1367: END IF;
1368: */

Line 1365: LOG_MESSAGE(FND_MESSAGE.GET);

1361: LOG_MESSAGE('Error while updating msc_item_suppliers with company_id and company_site_id');
1362: LOG_MESSAGE('========================================');
1363: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1364: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1365: LOG_MESSAGE(FND_MESSAGE.GET);
1366: END;
1367: END IF;
1368: */
1369:

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

1389: where msic.rowid = CHARTOROWID(a_rowid(i));
1390: EXCEPTION WHEN OTHERS THEN
1391: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1392: LOG_MESSAGE('========================================');
1393: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1394: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1395: LOG_MESSAGE(FND_MESSAGE.GET);
1396: END;
1397: END IF;

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

1390: EXCEPTION WHEN OTHERS THEN
1391: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1392: LOG_MESSAGE('========================================');
1393: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1394: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1395: LOG_MESSAGE(FND_MESSAGE.GET);
1396: END;
1397: END IF;
1398:

Line 1395: LOG_MESSAGE(FND_MESSAGE.GET);

1391: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1392: LOG_MESSAGE('========================================');
1393: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1394: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1395: LOG_MESSAGE(FND_MESSAGE.GET);
1396: END;
1397: END IF;
1398:
1399: