943: begin
944: X_Progress := '010';
945: select mum.unit_of_measure_tl
946: into x_unit_meas_lookup_code_tl
947: from mtl_units_of_measure mum
948: where mum.unit_of_measure = x_unit_meas_lookup_code;
949:
950: exception
951: when others then
973: begin
974: X_Progress := '010';
975: select mum.unit_of_measure_tl
976: into x_unit_meas_lookup_code_tl
977: from mtl_units_of_measure mum
978: where mum.uom_code = rtrim(x_uom_code);
979:
980: exception
981: when others then