600: WHEN OTHERS THEN
601:
602: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
601:
602: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
609: RAISE;
602: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
609: RAISE;
610: END;
603:
604: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
605: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IRO_DEMAND');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
609: RAISE;
610: END;
611:
1193:
1194: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1195:
1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1194: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1195:
1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1195:
1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1197: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1198: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
1199: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1203: RAISE;
1204:
1206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1207:
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1207:
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1209:
1210: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1211: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1212: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1214:
1215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1217: FND_MESSAGE.SET_TOKEN('VALUE',
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1218: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1219: MSC_CL_COLLECTION.v_instance_id));
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1221:
1222: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1223: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1224: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1233:
1228: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1229: FND_MESSAGE.SET_TOKEN('VALUE',
1230: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1231: lv_ORIGINATION_TYPE));
1232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1233:
1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1235: END IF;
1236: END;