2248: END IF;
2249:
2250: -- Get the primary quantity
2251: l_primary_quantity :=
2252: inv_convert.inv_um_convert(
2253: p_mold_table(i).inventory_item_id
2254: , 5
2255: , p_mold_table(i).transaction_quantity
2256: , p_mold_table(i).transaction_uom
2711: ELSE
2712: l_new_lot_quantity := l_lot_quantity - l_lot_qty_to_delete;
2713: --convert quantity
2714: l_new_lot_prim_quantity :=
2715: inv_convert.inv_um_convert(l_inventory_item_id, 5, l_new_lot_quantity, l_transaction_uom_code
2716: , l_primary_uom_code, NULL, NULL);
2717:
2718: IF l_new_prim_quantity = -99999 THEN
2719: RAISE fnd_api.g_exc_error;
2729: CLOSE c_lot_allocations;
2730: l_new_quantity := l_transaction_quantity - p_quantity;
2731: --convert quantity
2732: l_new_prim_quantity :=
2733: inv_convert.inv_um_convert(l_inventory_item_id, 5, l_new_quantity, l_transaction_uom_code, l_primary_uom_code
2734: , NULL, NULL);
2735:
2736: IF l_new_prim_quantity = -99999 THEN
2737: RAISE fnd_api.g_exc_error;