DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on INV_CONVERT

Line 2477: INV_CONVERT.inv_um_conversion(

2473: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);
2474:
2475:
2476: IF p_mtl_trx_tbl(1).transaction_uom <> l_primary_uom THEN
2477: INV_CONVERT.inv_um_conversion(
2478: from_unit => l_primary_uom
2479: , to_unit => p_mtl_trx_tbl(1).transaction_uom
2480: , item_id => l_mtl_trx_tbl(1).inventory_item_id
2481: , uom_rate => l_uom_rate

Line 2486: print_debug('Calling inv_convert.inv_um_convert....', 9);

2482: );
2483:
2484: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2485: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2486: print_debug('Calling inv_convert.inv_um_convert....', 9);
2487: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2488: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2489: ,p_mtl_trx_tbl(1).transaction_uom
2490: ,l_primary_uom

Line 2487: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6

2483:
2484: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2485: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2486: print_debug('Calling inv_convert.inv_um_convert....', 9);
2487: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2488: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2489: ,p_mtl_trx_tbl(1).transaction_uom
2490: ,l_primary_uom
2491: ,'','');

Line 2664: INV_CONVERT.inv_um_conversion(

2660:
2661: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);
2662:
2663: IF p_mtl_trx_tbl(1).transaction_uom <> l_primary_uom THEN
2664: INV_CONVERT.inv_um_conversion(
2665: from_unit => l_primary_uom
2666: , to_unit => p_mtl_trx_tbl(1).transaction_uom
2667: , item_id => l_mtl_trx_tbl(1).inventory_item_id
2668: , uom_rate => l_uom_rate

Line 2673: print_debug('Calling inv_convert.inv_um_convert....', 9);

2669: );
2670:
2671: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2672: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2673: print_debug('Calling inv_convert.inv_um_convert....', 9);
2674: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2675: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2676: ,p_mtl_trx_tbl(1).transaction_uom
2677: ,l_primary_uom

Line 2674: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6

2670:
2671: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2672: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2673: print_debug('Calling inv_convert.inv_um_convert....', 9);
2674: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2675: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2676: ,p_mtl_trx_tbl(1).transaction_uom
2677: ,l_primary_uom
2678: ,'','');

Line 4615: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '

4611: IF (l_transaction_uom <> l_owner_pri_uom)
4612: THEN
4613:
4614: IF (l_debug = 1) THEN
4615: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '
4616: || 'converting from txnUOM: ' || l_transaction_uom || ' to primaryUOM: ' || l_owner_pri_uom, 9);
4617: END IF;
4618:
4619: l_stmt_num := 130;

Line 4620: l_pri_qty := INV_CONVERT.INV_UM_CONVERT

4616: || 'converting from txnUOM: ' || l_transaction_uom || ' to primaryUOM: ' || l_owner_pri_uom, 9);
4617: END IF;
4618:
4619: l_stmt_num := 130;
4620: l_pri_qty := INV_CONVERT.INV_UM_CONVERT
4621: ( item_id => l_item_id
4622: , lot_number => NULL
4623: , organization_id => l_owner_org_id
4624: , precision => 5

Line 4647: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '

4643: AND (l_owner_pri_uom <> l_sec_uom)
4644: THEN
4645:
4646: IF (l_debug = 1) THEN
4647: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '
4648: || 'converting from primaryUOM: ' || l_owner_pri_uom|| ' to secUOM: ' || l_sec_uom, 9);
4649: END IF;
4650:
4651: l_stmt_num := 140;

Line 4652: l_sec_qty := INV_CONVERT.INV_UM_CONVERT

4648: || 'converting from primaryUOM: ' || l_owner_pri_uom|| ' to secUOM: ' || l_sec_uom, 9);
4649: END IF;
4650:
4651: l_stmt_num := 140;
4652: l_sec_qty := INV_CONVERT.INV_UM_CONVERT
4653: ( item_id => l_item_id
4654: , lot_number => NULL
4655: , organization_id => l_owner_org_id
4656: , precision => 5

Line 4670: print_debug(l_procedure_name || ': calling INV_CONVERT.WITHIN_DEVIATION', 9);

4666: RAISE e_uom_conversion_error;
4667: END IF;
4668:
4669: IF (l_debug = 1) THEN
4670: print_debug(l_procedure_name || ': calling INV_CONVERT.WITHIN_DEVIATION', 9);
4671: END IF;
4672:
4673: -- Validate the quantitioes within deviation :
4674: l_stmt_num := 150;

Line 4675: l_are_qties_valid := INV_CONVERT.within_deviation(

4671: END IF;
4672:
4673: -- Validate the quantitioes within deviation :
4674: l_stmt_num := 150;
4675: l_are_qties_valid := INV_CONVERT.within_deviation(
4676: p_organization_id => l_owner_org_id
4677: , p_inventory_item_id => l_item_id
4678: , p_lot_number => NULL
4679: , p_precision => 5

Line 4688: -- dbms_output.put_line('INV_CONVERT.within_deviation (ERROR) '|| l_error_exp );

4684: ;
4685:
4686: IF (l_are_qties_valid = 0)
4687: THEN
4688: -- dbms_output.put_line('INV_CONVERT.within_deviation (ERROR) '|| l_error_exp );
4689: IF (l_debug = 1) THEN
4690: print_debug(l_procedure_name || ': INV_CONVERT.within_deviation (ERROR)', 9);
4691: print_debug(' l_pri_qty: ' || l_pri_qty || ' l_owner_pri_uom: ' || l_owner_pri_uom, 9);
4692: print_debug(' l_sec_qty: ' || l_sec_qty || ' l_sec_uom: ' || l_sec_uom, 9);

Line 4690: print_debug(l_procedure_name || ': INV_CONVERT.within_deviation (ERROR)', 9);

4686: IF (l_are_qties_valid = 0)
4687: THEN
4688: -- dbms_output.put_line('INV_CONVERT.within_deviation (ERROR) '|| l_error_exp );
4689: IF (l_debug = 1) THEN
4690: print_debug(l_procedure_name || ': INV_CONVERT.within_deviation (ERROR)', 9);
4691: print_debug(' l_pri_qty: ' || l_pri_qty || ' l_owner_pri_uom: ' || l_owner_pri_uom, 9);
4692: print_debug(' l_sec_qty: ' || l_sec_qty || ' l_sec_uom: ' || l_sec_uom, 9);
4693: print_debug(' l_item_id: ' || l_item_id || ' l_owner_org_id: ' || l_owner_org_id, 9);
4694: END IF;

Line 4698: -- dbms_output.put_line('INV_CONVERT.within_deviation (PASS) ');

4694: END IF;
4695: RAISE FND_API.G_EXC_ERROR;
4696: END IF;
4697:
4698: -- dbms_output.put_line('INV_CONVERT.within_deviation (PASS) ');
4699: IF (l_debug = 1) THEN
4700: inv_log_util.trace(l_procedure_name || ': INV_CONVERT.within_deviation (PASS)' , 9);
4701: END IF;
4702:

Line 4700: inv_log_util.trace(l_procedure_name || ': INV_CONVERT.within_deviation (PASS)' , 9);

4696: END IF;
4697:
4698: -- dbms_output.put_line('INV_CONVERT.within_deviation (PASS) ');
4699: IF (l_debug = 1) THEN
4700: inv_log_util.trace(l_procedure_name || ': INV_CONVERT.within_deviation (PASS)' , 9);
4701: END IF;
4702:
4703: ELSE
4704: l_sec_qty := NULL;

Line 4836: INV_CONVERT.inv_um_conversion(

4832: ': First, doing UOM conv. from/to: ' || l_pri_uom ||'/'|| l_owner_pri_uom ||
4833: ' tp/trp: ' || l_transfer_price ||'/'|| l_transportation_cost);
4834: END IF;
4835:
4836: INV_CONVERT.inv_um_conversion(
4837: from_unit => l_pri_uom
4838: , to_unit => l_owner_pri_uom
4839: , item_id => l_item_id
4840: , uom_rate => l_pri_uom_rate