DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on INV_CONVERT

Line 2494: INV_CONVERT.inv_um_conversion(

2490: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);
2491:
2492:
2493: IF p_mtl_trx_tbl(1).transaction_uom <> l_primary_uom THEN
2494: INV_CONVERT.inv_um_conversion(
2495: from_unit => l_primary_uom
2496: , to_unit => p_mtl_trx_tbl(1).transaction_uom
2497: , item_id => l_mtl_trx_tbl(1).inventory_item_id
2498: , uom_rate => l_uom_rate

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

2499: );
2500:
2501: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2502: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2503: print_debug('Calling inv_convert.inv_um_convert....', 9);
2504: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2505: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2506: ,p_mtl_trx_tbl(1).transaction_uom
2507: ,l_primary_uom

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

2500:
2501: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2502: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2503: print_debug('Calling inv_convert.inv_um_convert....', 9);
2504: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2505: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2506: ,p_mtl_trx_tbl(1).transaction_uom
2507: ,l_primary_uom
2508: ,'','');

Line 2694: INV_CONVERT.inv_um_conversion(

2690:
2691: print_debug('Transaction UOM is: '||p_mtl_trx_tbl(1).transaction_uom, 9);
2692:
2693: IF p_mtl_trx_tbl(1).transaction_uom <> l_primary_uom THEN
2694: INV_CONVERT.inv_um_conversion(
2695: from_unit => l_primary_uom
2696: , to_unit => p_mtl_trx_tbl(1).transaction_uom
2697: , item_id => l_mtl_trx_tbl(1).inventory_item_id
2698: , uom_rate => l_uom_rate

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

2699: );
2700:
2701: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2702: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2703: print_debug('Calling inv_convert.inv_um_convert....', 9);
2704: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2705: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2706: ,p_mtl_trx_tbl(1).transaction_uom
2707: ,l_primary_uom

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

2700:
2701: -- Converting the transaction quantity to primary UOMs quantity when transaction UOM is not same as Primary UOM.
2702: print_debug('Transaction UOM is NOT same as Primary UOM.', 9);
2703: print_debug('Calling inv_convert.inv_um_convert....', 9);
2704: l_mtl_trx_tbl(l_index).primary_quantity := -1*inv_convert.inv_um_convert(l_mtl_trx_tbl(1).inventory_item_id,6
2705: ,l_mtl_trx_tbl(l_index-1).transaction_quantity
2706: ,p_mtl_trx_tbl(1).transaction_uom
2707: ,l_primary_uom
2708: ,'','');

Line 3225: INV_CONVERT.inv_um_conversion(

3221:
3222: IF ( (l_mtl_trx_tbl(i).transaction_uom <> l_primary_uom) AND p_exploded_flag = G_NOT_EXPLODED) THEN
3223: print_debug('transaction_uom diff than primary UOM, Calling uom_conversion', 9);
3224:
3225: INV_CONVERT.inv_um_conversion(
3226: from_unit => l_mtl_trx_tbl(i).transaction_uom
3227: , to_unit => l_primary_uom
3228: , item_id => l_mtl_trx_tbl(i).inventory_item_id
3229: , uom_rate => l_uom_rate

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

4698: IF (l_transaction_uom <> l_owner_pri_uom)
4699: THEN
4700:
4701: IF (l_debug = 1) THEN
4702: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '
4703: || 'converting from txnUOM: ' || l_transaction_uom || ' to primaryUOM: ' || l_owner_pri_uom, 9);
4704: END IF;
4705:
4706: l_stmt_num := 130;

Line 4707: l_pri_qty := INV_CONVERT.INV_UM_CONVERT

4703: || 'converting from txnUOM: ' || l_transaction_uom || ' to primaryUOM: ' || l_owner_pri_uom, 9);
4704: END IF;
4705:
4706: l_stmt_num := 130;
4707: l_pri_qty := INV_CONVERT.INV_UM_CONVERT
4708: ( item_id => l_item_id
4709: , lot_number => NULL
4710: , organization_id => l_owner_org_id
4711: , precision => 5

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

4730: AND (l_owner_pri_uom <> l_sec_uom)
4731: THEN
4732:
4733: IF (l_debug = 1) THEN
4734: print_debug(l_procedure_name || ': calling INV_CONVERT.inv_um_convert (' || l_stmt_num || '): '
4735: || 'converting from primaryUOM: ' || l_owner_pri_uom|| ' to secUOM: ' || l_sec_uom, 9);
4736: END IF;
4737:
4738: l_stmt_num := 140;

Line 4739: l_sec_qty := INV_CONVERT.INV_UM_CONVERT

4735: || 'converting from primaryUOM: ' || l_owner_pri_uom|| ' to secUOM: ' || l_sec_uom, 9);
4736: END IF;
4737:
4738: l_stmt_num := 140;
4739: l_sec_qty := INV_CONVERT.INV_UM_CONVERT
4740: ( item_id => l_item_id
4741: , lot_number => NULL
4742: , organization_id => l_owner_org_id
4743: , precision => 5

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

4753: RAISE e_uom_conversion_error;
4754: END IF;
4755:
4756: IF (l_debug = 1) THEN
4757: print_debug(l_procedure_name || ': calling INV_CONVERT.WITHIN_DEVIATION', 9);
4758: END IF;
4759:
4760: -- Validate the quantitioes within deviation :
4761: l_stmt_num := 150;

Line 4762: l_are_qties_valid := INV_CONVERT.within_deviation(

4758: END IF;
4759:
4760: -- Validate the quantitioes within deviation :
4761: l_stmt_num := 150;
4762: l_are_qties_valid := INV_CONVERT.within_deviation(
4763: p_organization_id => l_owner_org_id
4764: , p_inventory_item_id => l_item_id
4765: , p_lot_number => NULL
4766: , p_precision => 5

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

4771: ;
4772:
4773: IF (l_are_qties_valid = 0)
4774: THEN
4775: -- dbms_output.put_line('INV_CONVERT.within_deviation (ERROR) '|| l_error_exp );
4776: IF (l_debug = 1) THEN
4777: print_debug(l_procedure_name || ': INV_CONVERT.within_deviation (ERROR)', 9);
4778: print_debug(' l_pri_qty: ' || l_pri_qty || ' l_owner_pri_uom: ' || l_owner_pri_uom, 9);
4779: print_debug(' l_sec_qty: ' || l_sec_qty || ' l_sec_uom: ' || l_sec_uom, 9);

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

4773: IF (l_are_qties_valid = 0)
4774: THEN
4775: -- dbms_output.put_line('INV_CONVERT.within_deviation (ERROR) '|| l_error_exp );
4776: IF (l_debug = 1) THEN
4777: print_debug(l_procedure_name || ': INV_CONVERT.within_deviation (ERROR)', 9);
4778: print_debug(' l_pri_qty: ' || l_pri_qty || ' l_owner_pri_uom: ' || l_owner_pri_uom, 9);
4779: print_debug(' l_sec_qty: ' || l_sec_qty || ' l_sec_uom: ' || l_sec_uom, 9);
4780: print_debug(' l_item_id: ' || l_item_id || ' l_owner_org_id: ' || l_owner_org_id, 9);
4781: END IF;

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

4781: END IF;
4782: RAISE FND_API.G_EXC_ERROR;
4783: END IF;
4784:
4785: -- dbms_output.put_line('INV_CONVERT.within_deviation (PASS) ');
4786: IF (l_debug = 1) THEN
4787: inv_log_util.trace(l_procedure_name || ': INV_CONVERT.within_deviation (PASS)' , 9);
4788: END IF;
4789:

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

4783: END IF;
4784:
4785: -- dbms_output.put_line('INV_CONVERT.within_deviation (PASS) ');
4786: IF (l_debug = 1) THEN
4787: inv_log_util.trace(l_procedure_name || ': INV_CONVERT.within_deviation (PASS)' , 9);
4788: END IF;
4789:
4790: ELSE
4791: l_sec_qty := NULL;

Line 4924: INV_CONVERT.inv_um_conversion(

4920: ': First, doing UOM conv. from/to: ' || l_pri_uom ||'/'|| l_owner_pri_uom ||
4921: ' tp/trp: ' || l_transfer_price ||'/'|| l_transportation_cost);
4922: END IF;
4923:
4924: INV_CONVERT.inv_um_conversion(
4925: from_unit => l_pri_uom
4926: , to_unit => l_owner_pri_uom
4927: , item_id => l_item_id
4928: , uom_rate => l_pri_uom_rate