100: item_id => p_inventory_item_id,
101: uom_rate => l_conversion_rate);
102:
103: IF (l_conversion_rate < 0) THEN
104: RAISE fnd_api.g_exc_error;
105: END IF;
106:
107: g_item_uom_conversion_tb(p_inventory_item_id)(p_from_uom_code)(p_to_uom_code) := l_conversion_rate;
108: g_item_uom_conversion_tb(p_inventory_item_id)(p_to_uom_code)(p_from_uom_code) := 1 / l_conversion_rate;
166: WHEN OTHERS THEN
167: IF (l_debug = 1) THEN
168: print_debug('Unable to query from db!',l_module_name,4);
169: END IF;
170: RAISE fnd_api.g_exc_error;
171: END;
172:
173: IF (l_debug = 1) THEN
174: print_debug(' x_prim_uom_code (DB) => '||
227: WHEN OTHERS THEN
228: IF (l_debug = 1) THEN
229: print_debug('Unable to query from db!',l_module_name,4);
230: END IF;
231: RAISE fnd_api.g_exc_error;
232: END;
233:
234: IF (l_debug = 1) THEN
235: print_debug(' x_prim_uom_code (DB) => '||
288: WHEN OTHERS THEN
289: IF (l_debug = 1) THEN
290: print_debug('Unable to query from db!',l_module_name,4);
291: END IF;
292: RAISE fnd_api.g_exc_error;
293: END;
294:
295: IF (l_debug = 1) THEN
296: print_debug(' x_sn_ctrl_code (DB) => '||
349: WHEN OTHERS THEN
350: IF (l_debug = 1) THEN
351: print_debug('Unable to query from db!',l_module_name,4);
352: END IF;
353: RAISE fnd_api.g_exc_error;
354: END;
355:
356: IF (l_debug = 1) THEN
357: print_debug(' x_lot_control_code (DB) => '||
403: item_id => p_inventory_item_id,
404: uom_rate => l_conversion_rate);
405:
406: IF (l_conversion_rate < 0) THEN
407: RAISE fnd_api.g_exc_error;
408: END IF;
409:
410: g_item_uom_conversion_tb(p_inventory_item_id)(p_from_uom_code)(p_to_uom_code) := l_conversion_rate;
411: g_item_uom_conversion_tb(p_inventory_item_id)(p_to_uom_code)(p_from_uom_code) := 1 / l_conversion_rate;