DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on MTL_LOT_UOM_CONV_PVT

Line 10047: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */

10043: END IF ;
10044:
10045:
10046: /* Check to see if Copy Lot UOM Conversions is required.
10047: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
10048:
10049: IF l_copy_lot_attribute_flag = 'Y' AND l_parent_exists_flag = 'Y' THEN
10050: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (
10051: p_from_organization_id => p_lot_rec.organization_id

Line 10050: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (

10046: /* Check to see if Copy Lot UOM Conversions is required.
10047: Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
10048:
10049: IF l_copy_lot_attribute_flag = 'Y' AND l_parent_exists_flag = 'Y' THEN
10050: Mtl_Lot_Uom_Conv_Pvt.Copy_Lot_Uom_Conversions (
10051: p_from_organization_id => p_lot_rec.organization_id
10052: , p_to_organization_id => p_lot_rec.organization_id
10053: , p_inventory_item_id => p_lot_rec.inventory_item_id
10054: , p_from_lot_number => p_lot_rec.parent_lot_number

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

10061: , x_msg_data => l_msg_data
10062: ) ;
10063:
10064: IF g_debug = 1 THEN
10065: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM return ' || l_return_status, 9);
10066: END IF;
10067: IF l_return_status = g_ret_sts_error THEN
10068: IF g_debug = 1 THEN
10069: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a user defined exception', 9);

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

10065: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM return ' || l_return_status, 9);
10066: END IF;
10067: IF l_return_status = g_ret_sts_error THEN
10068: IF g_debug = 1 THEN
10069: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a user defined exception', 9);
10070: END IF;
10071: RAISE g_exc_error;
10072: ELSIF l_return_status = g_ret_sts_unexp_error THEN
10073: IF g_debug = 1 THEN

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

10070: END IF;
10071: RAISE g_exc_error;
10072: ELSIF l_return_status = g_ret_sts_unexp_error THEN
10073: IF g_debug = 1 THEN
10074: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a Unexpected exception', 9);
10075: END IF;
10076: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10077: FND_MESSAGE.SET_TOKEN('PROG_NAME','MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM');
10078: FND_MSG_PUB.ADD;

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

10073: IF g_debug = 1 THEN
10074: print_debug('Program MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM has failed with a Unexpected exception', 9);
10075: END IF;
10076: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10077: FND_MESSAGE.SET_TOKEN('PROG_NAME','MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM');
10078: FND_MSG_PUB.ADD;
10079: RAISE g_exc_unexpected_error;
10080: END IF;
10081:

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

10078: FND_MSG_PUB.ADD;
10079: RAISE g_exc_unexpected_error;
10080: END IF;
10081:
10082: END IF; /* Call MTL_LOT_UOM_CONV_PVT.COPY_LOT_UOM_CONVERSIONS */
10083:
10084:
10085: OPEN c_get_obj_id (p_lot_rec.lot_number,p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
10086: FETCH c_get_obj_id INTO l_get_obj_id_rec;