[Home] [Help]
11295: WHERE inventory_item_id = p_item_id
11296: AND organization_id = p_organization_id;
11297:
11298: -- compute conversion rate between transaction UOM and item primary UOM
11299: inv_convert.inv_um_conversion(from_unit => p_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => p_item_id
11300: , uom_rate => l_txn_pri_uom_ratio);
11301:
11302: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
11303: IF (l_debug = 1) THEN
11332: , l_item_w_uom;
11333: l_progress := '50';
11334: EXIT WHEN l_capcity_cur%NOTFOUND;
11335: -- get the conversion ratio between equipment and item volume UOM
11336: inv_convert.inv_um_conversion(from_unit => l_equip_v_uom, to_unit => l_item_v_uom, item_id => 0, uom_rate => l_eq_it_v_uom_ratio);
11337:
11338: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
11339: IF (l_debug = 1) THEN
11340: print_debug('is_equipment_cap_exceeded 40 - eqp/item volume uom ratio calculation failed'
11343: END IF;
11344: END IF;
11345:
11346: -- get the conversion ratio between equipment and item weight UOM
11347: inv_convert.inv_um_conversion(from_unit => l_equip_w_uom, to_unit => l_item_w_uom, item_id => 0, uom_rate => l_eq_it_w_uom_ratio);
11348:
11349: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
11350: IF (l_debug = 1) THEN
11351: print_debug('is_equipment_cap_exceeded 50 - eqp/item weight uom ratio calculation failed'
13245: END IF;
13246:
13247: -- call UOM conversion API to compute the ratio between
13248: -- locator UOM and transcation UOM for given item
13249: inv_convert.inv_um_conversion(from_unit => l_loc_uom_code, to_unit => l_txn_uom_code, item_id => l_item_id
13250: , uom_rate => l_loc_txn_uom_ratio);
13251:
13252: IF l_loc_txn_uom_ratio = -99999 THEN -- uom conversion failure
13253: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13260: RAISE fnd_api.g_exc_error;
13261: END IF;
13262:
13263: -- compute conversion rate between transaction UOM and item primary UOM
13264: inv_convert.inv_um_conversion(from_unit => l_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => l_item_id
13265: , uom_rate => l_txn_pri_uom_ratio);
13266:
13267: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
13268: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13326: print_debug('split_task 70 - l_item_v_uom ' || l_item_v_uom, 4);
13327: print_debug('split_task 70 - l_item_w_uom ' || l_item_w_uom, 4);
13328: END IF;
13329: -- get the conversion ratio between equipment and item volume UOM
13330: inv_convert.inv_um_conversion(from_unit => l_equip_v_uom, to_unit => l_item_v_uom, item_id => 0, uom_rate => l_eq_it_v_uom_ratio);
13331: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
13332: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13333: fnd_msg_pub.ADD;
13334:
13336: print_debug('split_task 70 - eqp/item volume uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13337: END IF;
13338: END IF;
13339: -- get the conversion ratio between equipment and item weight UOM
13340: inv_convert.inv_um_conversion(from_unit => l_equip_w_uom, to_unit => l_item_w_uom, item_id => 0, uom_rate => l_eq_it_w_uom_ratio);
13341: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
13342: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13343: fnd_msg_pub.ADD;
13344: