109: ELSE
110: BEGIN
111: -- validate whether the inventory_item_is exists in the given oranization_id
112: select inventory_item_id into l_check_existence
113: from mtl_system_items_kfv
114: where inventory_item_id = p_inventory_item_id
115: and organization_id = P_organization_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
343: IF p_inventory_item_id IS NULL THEN
344: RAISE EXCP_NO_REQ_PARAMETERS;
345: ELSE -- verify whether the item is assigned to the given organization_id
346: select count(organization_id) into l_count_qty
347: from mtl_system_items_kfv
348: where organization_id = p_organization_id
349: and inventory_item_id = p_inventory_item_id;
350:
351: IF l_count_qty = 0 THEN