[Home] [Help]
10452: l_progress := '008';
10453:
10454: /* Convert transaction qty in p_transaction_unit_of_measure to l_pmy_unit_of_meas */
10455:
10456: l_lot_qty := INV_CONVERT.inv_um_convert(
10457: item_id => l_item_id ,
10458: lot_number => p_lot_number ,
10459: organization_id => l_to_organization_id ,
10460: precision => 5 ,
10467: l_progress := '009';
10468:
10469: IF l_lot_qty = -99999 THEN
10470: IF g_debug = 1 THEN
10471: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
10472: END IF;
10473:
10474: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10475: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
10471: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
10472: END IF;
10473:
10474: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10475: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
10476: fnd_msg_pub.ADD;
10477: RAISE g_exc_unexpected_error;
10478: END IF;
10479:
10793: END IF;
10794: --{
10795: IF (p_secondary_quantity IS NULL) THEN
10796: -- Set the Qty2 from Qty1 if missing:
10797: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT
10798: ( item_id => p_inventory_item_id
10799: , lot_number => p_lot_number
10800: , organization_id => p_organization_id
10801: , precision => 5
10806: , to_name => NULL);
10807:
10808: IF (l_secondary_qty = -99999) THEN
10809: IF (l_debug = 1) THEN
10810: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10811: END IF;
10812: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10813: FND_MSG_PUB.ADD;
10814: RAISE FND_API.G_EXC_ERROR;
10818: inv_log_util.trace('validate_quantities: new secondary qty is: '|| l_secondary_qty , g_pkg_name, 9);
10819: END IF;
10820: ELSIF (p_transaction_quantity IS NULL) THEN
10821: -- Set the Qty1 from Qty2 if missing:
10822: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT
10823: ( item_id => p_inventory_item_id
10824: , lot_number => p_lot_number
10825: , organization_id => p_organization_id
10826: , precision => 5
10831: , to_name => NULL);
10832:
10833: IF (l_transaction_quantity = -99999) THEN
10834: IF (l_debug = 1) THEN
10835: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);
10836: END IF;
10837: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10838: FND_MSG_PUB.ADD;
10839: RAISE FND_API.G_EXC_ERROR;
10843: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10844: END IF;
10845: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10846: IF (l_debug = 1) THEN
10847: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10848: END IF;
10849: -- Validate the quantitioes within deviation :
10850: l_are_qties_valid := INV_CONVERT.within_deviation(
10851: p_organization_id => p_organization_id
10846: IF (l_debug = 1) THEN
10847: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10848: END IF;
10849: -- Validate the quantitioes within deviation :
10850: l_are_qties_valid := INV_CONVERT.within_deviation(
10851: p_organization_id => p_organization_id
10852: , p_inventory_item_id => p_inventory_item_id
10853: , p_lot_number => p_lot_number
10854: , p_precision => 5
10858: , p_uom_code2 => p_secondary_uom_code);
10859:
10860: IF (l_are_qties_valid = 0) THEN
10861: IF (l_debug = 1) THEN
10862: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10863: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10864: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10865: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10866: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10869: END IF;
10870: RAISE FND_API.G_EXC_ERROR;
10871: END IF;
10872: IF (l_debug = 1) THEN
10873: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);
10874: END IF;
10875: END IF;--}
10876: END IF;--} -- l_tracking_quantity_ind != 'P'
10877: -- Set the prim Qty from transaction Qty if missing:
10876: END IF;--} -- l_tracking_quantity_ind != 'P'
10877: -- Set the prim Qty from transaction Qty if missing:
10878: --{
10879: IF (p_primary_quantity IS NULL) THEN
10880: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT
10881: ( item_id => p_inventory_item_id
10882: , lot_number => p_lot_number
10883: , organization_id => p_organization_id
10884: , precision => 5
10889: , to_name => NULL);
10890:
10891: IF (l_primary_quantity = -99999) THEN
10892: IF (l_debug = 1) THEN
10893: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10894: END IF;
10895: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10896: FND_MSG_PUB.ADD;
10897: RAISE FND_API.G_EXC_ERROR;