1532: IF(p_st_lpn_id_tbl(i) IS NOT NULL) THEN
1533: BEGIN
1534: SELECT lpn_context
1535: INTO l_lpn_context
1536: FROM wms_license_plate_numbers
1537: WHERE lpn_id = p_st_lpn_id_tbl(i);
1538: EXCEPTION
1539: WHEN OTHERS THEN
1540: l_validation_status := 'N';
1563: INTO l_lpn_context
1564: ,l_sub_code
1565: ,l_locator_id
1566: ,l_org_id
1567: FROM wms_license_plate_numbers
1568: WHERE lpn_id = p_rs_lpn_id_tbl(i);
1569: EXCEPTION
1570: WHEN OTHERS THEN
1571: l_validation_status := 'N';