905: l_locator_id number;
906: begin
907: select inventory_location_id
908: into l_locator_id
909: from mtl_item_locations_kfv
910: where organization_id = p_org_id
911: and concatenated_segments = p_locator_segments;
912: return l_locator_id;
913: exception
1030: end if;
1031: elsif l_flm_kanban_demand_intf(l_counter).locator_id is not null then
1032: begin
1033: select 1 into l_temp
1034: FROM mtl_item_locations_kfv
1035: WHERE inventory_location_id = l_flm_kanban_demand_intf(l_counter).locator_id
1036: AND organization_id = l_flm_kanban_demand_intf(l_counter).organization_id;
1037: exception
1038: when others then