DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on MTL_LOT_UOM_CONV_PVT

Line 9577: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */

9573: END IF ;
9574:
9575:
9576: /* Check to see if Copy Lot UOM Conversions is required.
9577: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
9578:
9579: IF l_copy_lot_attribute_flag = 'Y' AND l_parent_exists_flag = 'Y' THEN
9580: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (
9581: p_from_organization_id => p_lot_rec.organization_id

Line 9580: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (

9576: /* Check to see if Copy Lot UOM Conversions is required.
9577: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
9578:
9579: IF l_copy_lot_attribute_flag = 'Y' AND l_parent_exists_flag = 'Y' THEN
9580: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (
9581: p_from_organization_id => p_lot_rec.organization_id
9582: , p_to_organization_id => p_lot_rec.organization_id
9583: , p_inventory_item_id => p_lot_rec.inventory_item_id
9584: , p_from_lot_number => p_lot_rec.parent_lot_number

Line 9595: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM return ' || l_return_status, 9);

9591: , x_msg_data => l_msg_data
9592: ) ;
9593:
9594: IF g_debug = 1 THEN
9595: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM return ' || l_return_status, 9);
9596: END IF;
9597: IF l_return_status = g_ret_sts_error THEN
9598: IF g_debug = 1 THEN
9599: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a user defined exception', 9);

Line 9599: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a user defined exception', 9);

9595: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM return ' || l_return_status, 9);
9596: END IF;
9597: IF l_return_status = g_ret_sts_error THEN
9598: IF g_debug = 1 THEN
9599: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a user defined exception', 9);
9600: END IF;
9601: RAISE g_exc_error;
9602: ELSIF l_return_status = g_ret_sts_unexp_error THEN
9603: IF g_debug = 1 THEN

Line 9604: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a Unexpected exception', 9);

9600: END IF;
9601: RAISE g_exc_error;
9602: ELSIF l_return_status = g_ret_sts_unexp_error THEN
9603: IF g_debug = 1 THEN
9604: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a Unexpected exception', 9);
9605: END IF;
9606: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
9607: FND_MESSAGE.SET_TOKEN('PROG_NAME','MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM');
9608: FND_MSG_PUB.ADD;

Line 9607: FND_MESSAGE.SET_TOKEN('PROG_NAME','MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM');

9603: IF g_debug = 1 THEN
9604: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a Unexpected exception', 9);
9605: END IF;
9606: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
9607: FND_MESSAGE.SET_TOKEN('PROG_NAME','MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM');
9608: FND_MSG_PUB.ADD;
9609: RAISE g_exc_unexpected_error;
9610: END IF;
9611:

Line 9612: END IF; /* Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */

9608: FND_MSG_PUB.ADD;
9609: RAISE g_exc_unexpected_error;
9610: END IF;
9611:
9612: END IF; /* Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
9613:
9614:
9615: OPEN c_get_obj_id (p_lot_rec.lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9616: FETCH c_get_obj_id INTO l_get_obj_id_rec;