DBA Data[Home] [Help]

APPS.INV_ROI_INTEGRATION_GRP dependencies on MTL_LOT_UOM_CONV_PUB

Line 1474: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type ;

1470: l_source NUMBER ;
1471: l_permission_value NUMBER ;
1472: l_conv_info_exists NUMBER ;
1473: l_grade_controlled_flag VARCHAR2(1) ;
1474: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type ;
1475: l_primary_uom_class VARCHAR2(10) ;
1476: l_secondary_uom_class VARCHAR2(10) ;
1477: l_api_name VARCHAR2(30) := 'INV_New_lot' ;
1478: l_api_version CONSTANT NUMBER := 1.0 ;

Line 1972: starting MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion */

1968: --SAVEPOINT inv_new_lot_save6;
1969:
1970: /* Populate p_lot_uom_conv_rec record type variable as follows:-
1971: All these parameters are to be used in the series of API calls
1972: starting MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion */
1973:
1974: p_lot_uom_conv_rec.LOT_NUMBER := P_LOT_NUMBER ;
1975: p_lot_uom_conv_rec.ORGANIZATION_ID := P_TO_ORGANIZATION_ID ;
1976: p_lot_uom_conv_rec.INVENTORY_ITEM_ID := P_item_id ;

Line 2026: print_debug('Before calling MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion:'||l_progress, 1);

2022: print_debug('uom_rate:'||p_lot_uom_conv_rec.CONVERSION_RATE, 1);
2023: END IF;
2024:
2025: IF g_debug = 1 THEN
2026: print_debug('Before calling MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion:'||l_progress, 1);
2027: print_debug('p_lot_uom_conv_rec.LOT_NUMBER:'||p_lot_uom_conv_rec.LOT_NUMBER, 1);
2028: print_debug('p_lot_uom_conv_rec.ORGANIZATION_ID:'||p_lot_uom_conv_rec.ORGANIZATION_ID, 1);
2029: print_debug('p_lot_uom_conv_rec.INVENTORY_ITEM_ID:'||p_lot_uom_conv_rec.INVENTORY_ITEM_ID, 1);
2030: print_debug('p_lot_uom_conv_rec.FROM_UNIT_OF_MEASURE:'||p_lot_uom_conv_rec.FROM_UNIT_OF_MEASURE, 1);

Line 2054: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(

2050: --------print_debug('l_qty_update_tbl:'||l_qty_update_tbl, 1);
2051: END IF;
2052:
2053:
2054: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2055: p_api_version =>1.0 ,
2056: p_init_msg_list =>FND_API.G_FALSE ,
2057: p_commit =>FND_API.G_TRUE ,
2058: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,

Line 2085: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion return :' ||l_progress ||':'|| l_return_status, 1);

2081:
2082: l_progress := '035';
2083:
2084: IF g_debug = 1 THEN
2085: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion return :' ||l_progress ||':'|| l_return_status, 1);
2086: print_debug('x_return_status:'||l_return_status, 1);
2087: print_debug('x_msg_count:'||l_msg_count, 1);
2088: END IF;
2089:

Line 2092: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);

2088: END IF;
2089:
2090: IF l_return_status = fnd_api.g_ret_sts_error THEN
2091: IF g_debug = 1 THEN
2092: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2093: END IF;
2094: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2095: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2096: fnd_msg_pub.ADD;

Line 2095: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');

2091: IF g_debug = 1 THEN
2092: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2093: END IF;
2094: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2095: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2096: fnd_msg_pub.ADD;
2097: RAISE g_exc_error;
2098:
2099: l_progress := '036';

Line 2103: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);

2099: l_progress := '036';
2100:
2101: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2102: IF g_debug = 1 THEN
2103: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2104: END IF;
2105: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2106: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2107: fnd_msg_pub.ADD;

Line 2106: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');

2102: IF g_debug = 1 THEN
2103: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2104: END IF;
2105: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2106: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2107: fnd_msg_pub.ADD;
2108: RAISE g_exc_unexpected_error;
2109: END IF;
2110: