152:
153: BEGIN
154: SELECT location_id
155: INTO p_ship_to_location_id
156: FROM hr_locations
157: WHERE ECE_TP_LOCATION_CODE = p_ship_to_edi_location_code;
158: EXCEPTION
159: WHEN no_data_found then
160: IF (l_Debug_Level <= 1) THEN
157: WHERE ECE_TP_LOCATION_CODE = p_ship_to_edi_location_code;
158: EXCEPTION
159: WHEN no_data_found then
160: IF (l_Debug_Level <= 1) THEN
161: cln_debug_pub.Add('No Data Found in the hr_locations table for p_ship_to_edi_location_code :'||p_ship_to_location_id, 1);
162: END IF;
163: END;
164:
165: IF (l_Debug_Level <= 1) THEN