797: l_inv_item_id IS NULL AND
798: l_cont_flag = 'Y'
799: THEN
800: -- This is a LPN record from WMS and a locator controlled -
801: IF l_subinv IS NULL -- fetch the subinv from wms_license_plate_numbers
802: THEN
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching subinventory name from wms_license_plate_numbers');
805: END IF;
800: -- This is a LPN record from WMS and a locator controlled -
801: IF l_subinv IS NULL -- fetch the subinv from wms_license_plate_numbers
802: THEN
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching subinventory name from wms_license_plate_numbers');
805: END IF;
806:
807: BEGIN
808: SELECT subinventory_code
806:
807: BEGIN
808: SELECT subinventory_code
809: INTO l_subinv
810: FROM wms_license_plate_numbers
811: WHERE lpn_id= l_lpn_id
812: AND organization_id= l_org_id;
813: EXCEPTION
814: WHEN No_Data_Found THEN
812: AND organization_id= l_org_id;
813: EXCEPTION
814: WHEN No_Data_Found THEN
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.logmsg(l_module_name,'No_Data_Found while Fetching the subinventory name from wms_license_plate_numbers');
817: END IF;
818: END;
819: END IF;
820: IF l_subinv IS NOT NULL