DBA Data[Home] [Help]

APPS.M4R_3B2IN_PKG dependencies on HR_LOCATIONS

Line 156: FROM hr_locations

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

Line 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);

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