DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on INV_CONVERT

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

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

Line 732: l_quantity := inv_convert.inv_um_convert

728: RETURN;
729: END IF;
730: ELSE
731: -- convert quantity to position uom.
732: l_quantity := inv_convert.inv_um_convert
733: (item_id => p_Inventory_id,
734: precision => 6,
735: from_quantity => p_quantity,
736: from_unit => p_uom_code,

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

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

Line 761: l_quantity := inv_convert.inv_um_convert

757: RETURN;
758: END IF;
759: ELSE
760: -- convert quantity to Item uom.
761: l_quantity := inv_convert.inv_um_convert
762: (item_id => p_Inventory_id,
763: precision => 6,
764: from_quantity => p_quantity,
765: from_unit => p_uom_code,

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

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

Line 808: l_quantity := inv_convert.inv_um_convert

804: RETURN;
805: END IF;
806: ELSE
807: -- convert quantity to position uom.
808: l_quantity := inv_convert.inv_um_convert
809: (item_id => p_Inventory_id,
810: precision => 6,
811: from_quantity => p_quantity,
812: from_unit => p_uom_code,

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

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

Line 837: l_quantity := inv_convert.inv_um_convert

833: RETURN;
834: END IF;
835: ELSE
836: -- convert quantity to Item uom.
837: l_quantity := inv_convert.inv_um_convert
838: (item_id => p_Inventory_id,
839: precision => 6,
840: from_quantity => p_quantity,
841: from_unit => p_uom_code,

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

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

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

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

Line 2206: l_quantity := inv_convert.inv_um_convert

2202: l_return_value := TRUE;
2203: END IF;
2204: ELSE
2205: --Convert quantity to position uom.
2206: l_quantity := inv_convert.inv_um_convert
2207: (item_id => p_inventory_item_id,
2208: precision => 6,
2209: from_quantity => p_quantity,
2210: from_unit => p_uom_code,

Line 2226: l_quantity := inv_convert.inv_um_convert

2222: l_return_value := TRUE;
2223: END IF;
2224: ELSE
2225: --Convert quantity to item uom
2226: l_quantity := inv_convert.inv_um_convert
2227: (item_id => p_inventory_item_id,
2228: precision => 6,
2229: from_quantity => p_quantity,
2230: from_unit => p_uom_code,