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:
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);
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;
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;
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:
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);
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:
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;
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:
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);
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;
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;
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:
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);
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;
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;
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);
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:
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;
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;
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:
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:
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;
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;
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:
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:
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');
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);
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:
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;
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;
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:
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');
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));
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);
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;
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:
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:
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:
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:
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');
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);
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:
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;
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:
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
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);
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;
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;
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;
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: */
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:
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;
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:
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: