DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on INV_CONVERT

Line 9979: l_lot_qty := INV_CONVERT.inv_um_convert(

9975: l_progress := '008';
9976:
9977: /* Convert transaction qty in p_transaction_unit_of_measure to l_pmy_unit_of_meas */
9978:
9979: l_lot_qty := INV_CONVERT.inv_um_convert(
9980: item_id => l_item_id ,
9981: lot_number => p_lot_number ,
9982: organization_id => l_to_organization_id ,
9983: precision => 5 ,

Line 9994: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);

9990: l_progress := '009';
9991:
9992: IF l_lot_qty = -99999 THEN
9993: IF g_debug = 1 THEN
9994: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
9995: END IF;
9996:
9997: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
9998: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

Line 9998: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

9994: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
9995: END IF;
9996:
9997: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
9998: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
9999: fnd_msg_pub.ADD;
10000: RAISE g_exc_unexpected_error;
10001: END IF;
10002:

Line 10320: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT

10316: END IF;
10317: --{
10318: IF (p_secondary_quantity IS NULL) THEN
10319: -- Set the Qty2 from Qty1 if missing:
10320: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT
10321: ( item_id => p_inventory_item_id
10322: , lot_number => p_lot_number
10323: , organization_id => p_organization_id
10324: , precision => 5

Line 10333: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);

10329: , to_name => NULL);
10330:
10331: IF (l_secondary_qty = -99999) THEN
10332: IF (l_debug = 1) THEN
10333: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10334: END IF;
10335: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10336: FND_MSG_PUB.ADD;
10337: RAISE FND_API.G_EXC_ERROR;

Line 10345: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT

10341: inv_log_util.trace('validate_quantities: new secondary qty is: '|| l_secondary_qty , g_pkg_name, 9);
10342: END IF;
10343: ELSIF (p_transaction_quantity IS NULL) THEN
10344: -- Set the Qty1 from Qty2 if missing:
10345: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT
10346: ( item_id => p_inventory_item_id
10347: , lot_number => p_lot_number
10348: , organization_id => p_organization_id
10349: , precision => 5

Line 10358: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);

10354: , to_name => NULL);
10355:
10356: IF (l_transaction_quantity = -99999) THEN
10357: IF (l_debug = 1) THEN
10358: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);
10359: END IF;
10360: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10361: FND_MSG_PUB.ADD;
10362: RAISE FND_API.G_EXC_ERROR;

Line 10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);

10366: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10367: END IF;
10368: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10369: IF (l_debug = 1) THEN
10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10371: END IF;
10372: -- Validate the quantitioes within deviation :
10373: l_are_qties_valid := INV_CONVERT.within_deviation(
10374: p_organization_id => p_organization_id

Line 10373: l_are_qties_valid := INV_CONVERT.within_deviation(

10369: IF (l_debug = 1) THEN
10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10371: END IF;
10372: -- Validate the quantitioes within deviation :
10373: l_are_qties_valid := INV_CONVERT.within_deviation(
10374: p_organization_id => p_organization_id
10375: , p_inventory_item_id => p_inventory_item_id
10376: , p_lot_number => p_lot_number
10377: , p_precision => 5

Line 10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);

10381: , p_uom_code2 => p_secondary_uom_code);
10382:
10383: IF (l_are_qties_valid = 0) THEN
10384: IF (l_debug = 1) THEN
10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10387: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10389: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);

Line 10396: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);

10392: END IF;
10393: RAISE FND_API.G_EXC_ERROR;
10394: END IF;
10395: IF (l_debug = 1) THEN
10396: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);
10397: END IF;
10398: END IF;--}
10399: END IF;--} -- l_tracking_quantity_ind != 'P'
10400: -- Set the prim Qty from transaction Qty if missing:

Line 10403: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT

10399: END IF;--} -- l_tracking_quantity_ind != 'P'
10400: -- Set the prim Qty from transaction Qty if missing:
10401: --{
10402: IF (p_primary_quantity IS NULL) THEN
10403: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT
10404: ( item_id => p_inventory_item_id
10405: , lot_number => p_lot_number
10406: , organization_id => p_organization_id
10407: , precision => 5

Line 10416: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);

10412: , to_name => NULL);
10413:
10414: IF (l_primary_quantity = -99999) THEN
10415: IF (l_debug = 1) THEN
10416: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10417: END IF;
10418: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10419: FND_MSG_PUB.ADD;
10420: RAISE FND_API.G_EXC_ERROR;