[Home] [Help]
10956: WHERE inventory_item_id = p_item_id
10957: AND organization_id = p_organization_id;
10958:
10959: -- compute conversion rate between transaction UOM and item primary UOM
10960: inv_convert.inv_um_conversion(from_unit => p_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => p_item_id
10961: , uom_rate => l_txn_pri_uom_ratio);
10962:
10963: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
10964: IF (l_debug = 1) THEN
10993: , l_item_w_uom;
10994: l_progress := '50';
10995: EXIT WHEN l_capcity_cur%NOTFOUND;
10996: -- get the conversion ratio between equipment and item volume UOM
10997: 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);
10998:
10999: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
11000: IF (l_debug = 1) THEN
11001: print_debug('is_equipment_cap_exceeded 40 - eqp/item volume uom ratio calculation failed'
11004: END IF;
11005: END IF;
11006:
11007: -- get the conversion ratio between equipment and item weight UOM
11008: 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);
11009:
11010: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
11011: IF (l_debug = 1) THEN
11012: print_debug('is_equipment_cap_exceeded 50 - eqp/item weight uom ratio calculation failed'
12703: END IF;
12704:
12705: -- call UOM conversion API to compute the ratio between
12706: -- locator UOM and transcation UOM for given item
12707: inv_convert.inv_um_conversion(from_unit => l_loc_uom_code, to_unit => l_txn_uom_code, item_id => l_item_id
12708: , uom_rate => l_loc_txn_uom_ratio);
12709:
12710: IF l_loc_txn_uom_ratio = -99999 THEN -- uom conversion failure
12711: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12718: RAISE fnd_api.g_exc_error;
12719: END IF;
12720:
12721: -- compute conversion rate between transaction UOM and item primary UOM
12722: inv_convert.inv_um_conversion(from_unit => l_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => l_item_id
12723: , uom_rate => l_txn_pri_uom_ratio);
12724:
12725: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
12726: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12773: EXIT WHEN l_capcity_cur%NOTFOUND;
12774: end if;
12775: l_progress := '80';
12776: -- get the conversion ratio between equipment and item volume UOM
12777: 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);
12778: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
12779: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12780: fnd_msg_pub.ADD;
12781:
12783: print_debug('split_task 70 - eqp/item volume uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12784: END IF;
12785: END IF;
12786: -- get the conversion ratio between equipment and item weight UOM
12787: 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);
12788: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
12789: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12790: fnd_msg_pub.ADD;
12791: