DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on INV_CONVERT

Line 634: -- When calling the API inv_convert.inv_um_convert, note that it returns -99999 if the UOM conversion is not possible.

630: -- Added p_ignore_quant_vald parameter to allow the quantity checks to be ignored when called from Production.
631: -- Additionally, as non-serialized item instances with partial quantities can be assigned to MC positions now,
632: -- their quantity check with position/associated-item quantity should be relaxed from '=' to '<='.
633: --
634: -- When calling the API inv_convert.inv_um_convert, note that it returns -99999 if the UOM conversion is not possible.
635: -- We should not be considering this as item match found.
636: ------------------------------------------------------------------------------
637: PROCEDURE Validate_for_Position(p_mc_relationship_id IN NUMBER,
638: p_Inventory_id IN NUMBER,

Line 737: l_quantity := inv_convert.inv_um_convert

733: RETURN;
734: END IF;
735: ELSE
736: -- convert quantity to position uom.
737: l_quantity := inv_convert.inv_um_convert
738: (item_id => p_Inventory_id,
739: precision => 6,
740: from_quantity => p_quantity,
741: from_unit => p_uom_code,

Line 747: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

743: from_name => NULL,
744: to_name => NULL );
745:
746: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
748: END IF;
749:
750: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
751: l_assoc_rec_found := TRUE;

Line 766: l_quantity := inv_convert.inv_um_convert

762: RETURN;
763: END IF;
764: ELSE
765: -- convert quantity to Item uom.
766: l_quantity := inv_convert.inv_um_convert
767: (item_id => p_Inventory_id,
768: precision => 6,
769: from_quantity => p_quantity,
770: from_unit => p_uom_code,

Line 776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

772: from_name => NULL,
773: to_name => NULL );
774:
775: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
777: END IF;
778:
779: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y' )) THEN
780: l_assoc_rec_found := TRUE;

Line 813: l_quantity := inv_convert.inv_um_convert

809: RETURN;
810: END IF;
811: ELSE
812: -- convert quantity to position uom.
813: l_quantity := inv_convert.inv_um_convert
814: (item_id => p_Inventory_id,
815: precision => 6,
816: from_quantity => p_quantity,
817: from_unit => p_uom_code,

Line 823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

819: from_name => NULL,
820: to_name => NULL );
821:
822: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
824: END IF;
825:
826: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
827: l_assoc_rec_found := TRUE;

Line 842: l_quantity := inv_convert.inv_um_convert

838: RETURN;
839: END IF;
840: ELSE
841: -- convert quantity to Item uom.
842: l_quantity := inv_convert.inv_um_convert
843: (item_id => p_Inventory_id,
844: precision => 6,
845: from_quantity => p_quantity,
846: from_unit => p_uom_code,

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

848: from_name => NULL,
849: to_name => NULL );
850:
851: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
853: END IF;
854:
855: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
856: l_assoc_rec_found := TRUE;

Line 2164: -- When calling the API inv_convert.inv_um_convert, note that it returns -99999 if the UOM conversion is not possible.

2160: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
2161: -- As non-serialized item instances with partial quantities can be assigned to MC positions now,
2162: -- their quantity check with position/associated-item quantity should be relaxed from '=' to '<='.
2163: --
2164: -- When calling the API inv_convert.inv_um_convert, note that it returns -99999 if the UOM conversion is not possible.
2165: -- We should not be considering this as item match found.
2166: FUNCTION item_match(p_mc_relationship_id IN NUMBER,
2167: p_inventory_item_id IN NUMBER,
2168: p_organization_id IN NUMBER,

Line 2211: l_quantity := inv_convert.inv_um_convert

2207: l_return_value := TRUE;
2208: END IF;
2209: ELSE
2210: --Convert quantity to position uom.
2211: l_quantity := inv_convert.inv_um_convert
2212: (item_id => p_inventory_item_id,
2213: precision => 6,
2214: from_quantity => p_quantity,
2215: from_unit => p_uom_code,

Line 2231: l_quantity := inv_convert.inv_um_convert

2227: l_return_value := TRUE;
2228: END IF;
2229: ELSE
2230: --Convert quantity to item uom
2231: l_quantity := inv_convert.inv_um_convert
2232: (item_id => p_inventory_item_id,
2233: precision => 6,
2234: from_quantity => p_quantity,
2235: from_unit => p_uom_code,