DBA Data[Home] [Help]

APPS.INV_ROI_INTEGRATION_GRP dependencies on MTL_LOT_UOM_CONV_PUB

Line 1511: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type ;

1507: l_source NUMBER ;
1508: l_permission_value NUMBER ;
1509: l_conv_info_exists NUMBER ;
1510: l_grade_controlled_flag VARCHAR2(1) ;
1511: l_qty_update_tbl MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type ;
1512: l_primary_uom_class VARCHAR2(10) ;
1513: l_secondary_uom_class VARCHAR2(10) ;
1514: l_api_name VARCHAR2(30) := 'INV_New_lot' ;
1515: l_api_version CONSTANT NUMBER := 1.0 ;

Line 2077: starting MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion */

2073: --SAVEPOINT inv_new_lot_save6;
2074:
2075: /* Populate p_lot_uom_conv_rec record type variable as follows:-
2076: All these parameters are to be used in the series of API calls
2077: starting MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion */
2078:
2079: p_lot_uom_conv_rec.LOT_NUMBER := P_LOT_NUMBER ;
2080: p_lot_uom_conv_rec.ORGANIZATION_ID := P_TO_ORGANIZATION_ID ;
2081: p_lot_uom_conv_rec.INVENTORY_ITEM_ID := P_item_id ;

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

2127: print_debug('uom_rate:'||p_lot_uom_conv_rec.CONVERSION_RATE, 1);
2128: END IF;
2129:
2130: IF g_debug = 1 THEN
2131: print_debug('Before calling MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion:'||l_progress, 1);
2132: print_debug('p_lot_uom_conv_rec.LOT_NUMBER:'||p_lot_uom_conv_rec.LOT_NUMBER, 1);
2133: print_debug('p_lot_uom_conv_rec.ORGANIZATION_ID:'||p_lot_uom_conv_rec.ORGANIZATION_ID, 1);
2134: print_debug('p_lot_uom_conv_rec.INVENTORY_ITEM_ID:'||p_lot_uom_conv_rec.INVENTORY_ITEM_ID, 1);
2135: print_debug('p_lot_uom_conv_rec.FROM_UNIT_OF_MEASURE:'||p_lot_uom_conv_rec.FROM_UNIT_OF_MEASURE, 1);

Line 2159: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(

2155: --------print_debug('l_qty_update_tbl:'||l_qty_update_tbl, 1);
2156: END IF;
2157:
2158:
2159: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2160: p_api_version =>1.0 ,
2161: p_init_msg_list =>FND_API.G_FALSE ,
2162: p_commit =>FND_API.G_TRUE ,
2163: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,

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

2186:
2187: l_progress := '035';
2188:
2189: IF g_debug = 1 THEN
2190: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion return :' ||l_progress ||':'|| l_return_status, 1);
2191: print_debug('x_return_status:'||l_return_status, 1);
2192: print_debug('x_msg_count:'||l_msg_count, 1);
2193: END IF;
2194:

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

2193: END IF;
2194:
2195: IF l_return_status = fnd_api.g_ret_sts_error THEN
2196: IF g_debug = 1 THEN
2197: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2198: END IF;
2199: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2200: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2201: fnd_msg_pub.ADD;

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

2196: IF g_debug = 1 THEN
2197: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2198: END IF;
2199: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2200: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2201: fnd_msg_pub.ADD;
2202: RAISE g_exc_error;
2203:
2204: l_progress := '036';

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

2204: l_progress := '036';
2205:
2206: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2207: IF g_debug = 1 THEN
2208: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2211: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2212: fnd_msg_pub.ADD;

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

2207: IF g_debug = 1 THEN
2208: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2211: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2212: fnd_msg_pub.ADD;
2213: RAISE g_exc_unexpected_error;
2214: END IF;
2215: