DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on INV_CONVERT

Line 1643: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT

1639: END IF;
1640: -- Set the Qty2 from Qty1 if missing:
1641: --{
1642: IF (p_secondary_quantity IS NULL) THEN
1643: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT
1644: ( item_id => p_inventory_item_id
1645: ,lot_number => p_lot_number
1646: ,organization_id => p_organization_id
1647: ,precision => 5

Line 1656: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating sec qty', 'INV_TXN_MANAGER_GRP', 9);

1652: ,to_name => NULL);
1653:
1654: IF (l_secondary_qty = -99999) THEN
1655: IF (l_debug = 1) THEN
1656: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating sec qty', 'INV_TXN_MANAGER_GRP', 9);
1657: END IF;
1658: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1659: errupdate(p_rowid, p_lot_rowid);
1660: return false;

Line 1671: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT

1667:
1668: -- Set the Qty1 from Qty2 if missing:
1669: --{
1670: IF (p_transaction_quantity IS NULL) THEN
1671: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT
1672: ( item_id => p_inventory_item_id
1673: , lot_number => p_lot_number
1674: , organization_id => p_organization_id
1675: , precision => 5

Line 1684: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR while calculating transaction quantity', 'INV_TXN_MANAGER_GRP', 9);

1680: , to_name => NULL);
1681:
1682: IF (l_transaction_quantity = -99999) THEN
1683: IF (l_debug = 1) THEN
1684: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR while calculating transaction quantity', 'INV_TXN_MANAGER_GRP', 9);
1685: END IF;
1686: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1687: errupdate(p_rowid, p_lot_rowid);
1688: return false;

Line 1715: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT

1711: --Jalaj Srivastava Bug 5446542
1712: --if txn uom is not same as the primary uom then
1713: --convert txn qty to prim qty.
1714: IF (l_primary_uom_code <> p_transaction_uom) THEN
1715: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT
1716: ( item_id => p_inventory_item_id
1717: ,lot_number => p_lot_number
1718: ,organization_id => p_organization_id
1719: ,precision => 5

Line 1728: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);

1724: ,to_name => NULL);
1725:
1726: IF (l_primary_quantity = -99999) THEN
1727: IF (l_debug = 1) THEN
1728: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);
1729: END IF;
1730: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1731: errupdate(p_rowid, p_lot_rowid);
1732: return false;

Line 4759: --bug 8497953 kbanddyo added lot number and org id as in parameters for invoking inv_convert

4755: '{{ parent object details should happen here}}' , 'INV_TXN_MANAGER_GRP', 9);
4756: END IF;
4757: END IF;
4758: -- R12 Genealogy Enhancement : End
4759: --bug 8497953 kbanddyo added lot number and org id as in parameters for invoking inv_convert
4760: -- this is done to cater to lot specific uom conversions.
4761: IF (p_srctype =5) then
4762: --ADM bug 9959125, converting only for discrete orgs.
4763: If l_process_enabled_flag = 'N' Then

Line 4764: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,6,l_lotqty,p_trxuom,p_priuom,'','');

4760: -- this is done to cater to lot specific uom conversions.
4761: IF (p_srctype =5) then
4762: --ADM bug 9959125, converting only for discrete orgs.
4763: If l_process_enabled_flag = 'N' Then
4764: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,6,l_lotqty,p_trxuom,p_priuom,'','');
4765: End If;
4766: ELSE
4767: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,5,l_lotqty,p_trxuom,p_priuom,'','');
4768: END IF;

Line 4767: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,5,l_lotqty,p_trxuom,p_priuom,'','');

4763: If l_process_enabled_flag = 'N' Then
4764: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,6,l_lotqty,p_trxuom,p_priuom,'','');
4765: End If;
4766: ELSE
4767: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,l_lotnum,p_orgid,5,l_lotqty,p_trxuom,p_priuom,'','');
4768: END IF;
4769:
4770:
4771: EXCEPTION

Line 7528: l_priqty := inv_convert.inv_um_convert(l_itemid,6,l_trxqty,

7524:
7525:
7526: BEGIN
7527: IF (l_srctype = 5) then
7528: l_priqty := inv_convert.inv_um_convert(l_itemid,6,l_trxqty,
7529: l_trxuom,l_priuom,'','');
7530: ELSE
7531: l_priqty := inv_convert.inv_um_convert(l_itemid,5,l_trxqty,
7532: l_trxuom,l_priuom,'','');

Line 7531: l_priqty := inv_convert.inv_um_convert(l_itemid,5,l_trxqty,

7527: IF (l_srctype = 5) then
7528: l_priqty := inv_convert.inv_um_convert(l_itemid,6,l_trxqty,
7529: l_trxuom,l_priuom,'','');
7530: ELSE
7531: l_priqty := inv_convert.inv_um_convert(l_itemid,5,l_trxqty,
7532: l_trxuom,l_priuom,'','');
7533: END IF;
7534: EXCEPTION
7535: WHEN OTHERS THEN

Line 8044: AND ABS(nvl(mtli.primary_quantity, inv_convert.inv_um_convert

8040: SELECT NVL(SUM(ABS(NVL(mtli.transaction_quantity,0))), 0)
8041: INTO l_lot_ser_qty
8042: FROM mtl_transaction_lots_interface mtli
8043: WHERE mtli.transaction_interface_id =l_intid
8044: AND ABS(nvl(mtli.primary_quantity, inv_convert.inv_um_convert
8045: (l_itemid,5,mtli.transaction_quantity,l_trxuom,l_priuom,'','')))
8046: = (SELECT SUM(get_serial_diff_wrp
8047: (msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)))
8048: FROM mtl_serial_numbers_interface msni

Line 8407: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,6,l_overcomp_txn_qty,

8403:
8404: IF (l_overcomp_txn_qty IS NOT NULL) THEN /* Overcompletion Transactions */
8405: BEGIN
8406: IF (l_srctype=5)then
8407: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,6,l_overcomp_txn_qty,
8408: l_trxuom,l_priuom,'','');
8409: ELSE
8410: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,5,l_overcomp_txn_qty,
8411: l_trxuom,l_priuom,'','');

Line 8410: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,5,l_overcomp_txn_qty,

8406: IF (l_srctype=5)then
8407: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,6,l_overcomp_txn_qty,
8408: l_trxuom,l_priuom,'','');
8409: ELSE
8410: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,5,l_overcomp_txn_qty,
8411: l_trxuom,l_priuom,'','');
8412: END IF;
8413: EXCEPTION
8414: WHEN OTHERS THEN