215: ELSE
216: BEGIN
217: SELECT inventory_item_id
218: INTO l_inventory_item_id
219: FROM mtl_system_items_kfv
220: WHERE organization_id = l_organization_id
221: AND concatenated_segments = p_inventory_item;
222: EXCEPTION
223: WHEN OTHERS THEN