324:
325: BEGIN
326: SELECT location_id
327: INTO l_location_id
328: FROM rcv_supply
329: WHERE lpn_id = p_lpn
330: AND ROWNUM<2;
331: EXCEPTION
332: WHEN OTHERS THEN
330: AND ROWNUM<2;
331: EXCEPTION
332: WHEN OTHERS THEN
333: IF (l_debug = 1) THEN
334: mydebug('Failed to get location_id from rcv_supply. ' );
335: END IF;
336:
337: END;
338: