437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN
439:
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
441: FND_MESSAGE.SET_NAME('MSC', 'MSC_CONFIG_BOM_ORG_ERR');
442: FND_MESSAGE.SET_TOKEN('ITEM_ID', to_char(lv_item_id));
443: FND_MESSAGE.SET_TOKEN('ORG_ID', to_char(p_get_oe_record.Source_Organization_Id(i)));
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, FND_MESSAGE.GET);
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
438: WHEN NO_DATA_FOUND THEN
439:
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
441: FND_MESSAGE.SET_NAME('MSC', 'MSC_CONFIG_BOM_ORG_ERR');
442: FND_MESSAGE.SET_TOKEN('ITEM_ID', to_char(lv_item_id));
443: FND_MESSAGE.SET_TOKEN('ORG_ID', to_char(p_get_oe_record.Source_Organization_Id(i)));
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, FND_MESSAGE.GET);
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
446: RAISE CTO_BOM_NOT_FOUND;
439:
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
441: FND_MESSAGE.SET_NAME('MSC', 'MSC_CONFIG_BOM_ORG_ERR');
442: FND_MESSAGE.SET_TOKEN('ITEM_ID', to_char(lv_item_id));
443: FND_MESSAGE.SET_TOKEN('ORG_ID', to_char(p_get_oe_record.Source_Organization_Id(i)));
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, FND_MESSAGE.GET);
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
446: RAISE CTO_BOM_NOT_FOUND;
447:
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
441: FND_MESSAGE.SET_NAME('MSC', 'MSC_CONFIG_BOM_ORG_ERR');
442: FND_MESSAGE.SET_TOKEN('ITEM_ID', to_char(lv_item_id));
443: FND_MESSAGE.SET_TOKEN('ORG_ID', to_char(p_get_oe_record.Source_Organization_Id(i)));
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, FND_MESSAGE.GET);
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '========================================');
446: RAISE CTO_BOM_NOT_FOUND;
447:
448: WHEN OTHERS THEN