1306: THEN
1307:
1308: SELECT concatenated_segments
1309: INTO l_item_number
1310: FROM MTL_SYSTEM_ITEMS_VL
1311: WHERE organization_id = p_oem_organization_id
1312: AND inventory_item_id = p_item_id;
1313:
1314: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1327: THEN
1328:
1329: SELECT concatenated_segments
1330: INTO l_item_number
1331: FROM MTL_SYSTEM_ITEMS_VL
1332: WHERE organization_id = p_oem_organization_id
1333: AND inventory_item_id = p_item_id;
1334:
1335: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1348: THEN
1349:
1350: SELECT concatenated_segments
1351: INTO l_item_number
1352: FROM MTL_SYSTEM_ITEMS_VL
1353: WHERE organization_id = p_oem_organization_id
1354: AND inventory_item_id = p_item_id;
1355:
1356: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION