553:
554: BEGIN
555: SELECT location_id
556: INTO l_location_id
557: FROM rcv_supply
558: WHERE lpn_id = p_lpn
559: AND ROWNUM<2;
560: EXCEPTION
561: WHEN OTHERS THEN
559: AND ROWNUM<2;
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF (l_debug = 1) THEN
563: mydebug('Failed to get location_id from rcv_supply. ' );
564: END IF;
565:
566: END;
567: