eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_MANAGER_GRP dependencies on INV_CONVERT

Line 1596: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT

1592: END IF;
1593: -- Set the Qty2 from Qty1 if missing:
1594: --{
1595: IF (p_secondary_quantity IS NULL) THEN
1596: l_secondary_qty := INV_CONVERT.INV_UM_CONVERT
1597: ( item_id => p_inventory_item_id
1598: ,lot_number => p_lot_number
1599: ,organization_id => p_organization_id
1600: ,precision => 5

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

1605: ,to_name => NULL);
1606:
1607: IF (l_secondary_qty = -99999) THEN
1608: IF (l_debug = 1) THEN
1609: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating sec qty', 'INV_TXN_MANAGER_GRP', 9);
1610: END IF;
1611: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1612: errupdate(p_rowid, p_lot_rowid);
1613: return false;

Line 1624: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT

1620:
1621: -- Set the Qty1 from Qty2 if missing:
1622: --{
1623: IF (p_transaction_quantity IS NULL) THEN
1624: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT
1625: ( item_id => p_inventory_item_id
1626: , lot_number => p_lot_number
1627: , organization_id => p_organization_id
1628: , precision => 5

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

1633: , to_name => NULL);
1634:
1635: IF (l_transaction_quantity = -99999) THEN
1636: IF (l_debug = 1) THEN
1637: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR while calculating transaction quantity', 'INV_TXN_MANAGER_GRP', 9);
1638: END IF;
1639: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1640: errupdate(p_rowid, p_lot_rowid);
1641: return false;

Line 1668: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT

1664: --Jalaj Srivastava Bug 5446542
1665: --if txn uom is not same as the primary uom then
1666: --convert txn qty to prim qty.
1667: IF (l_primary_uom_code <> p_transaction_uom) THEN
1668: l_primary_quantity := INV_CONVERT.INV_UM_CONVERT
1669: ( item_id => p_inventory_item_id
1670: ,lot_number => p_lot_number
1671: ,organization_id => p_organization_id
1672: ,precision => 5

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

1677: ,to_name => NULL);
1678:
1679: IF (l_primary_quantity = -99999) THEN
1680: IF (l_debug = 1) THEN
1681: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);
1682: END IF;
1683: loaderrmsg('INV_NO_CONVERSION_ERR','INV_NO_CONVERSION_ERR');
1684: errupdate(p_rowid, p_lot_rowid);
1685: return false;

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

4462: END IF;
4463: -- R12 Genealogy Enhancement : End
4464:
4465: IF (p_srctype =5) then
4466: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,6,l_lotqty,p_trxuom,p_priuom,'','');
4467: ELSE
4468: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,5,l_lotqty,p_trxuom,p_priuom,'','');
4469: END IF;
4470:

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

4464:
4465: IF (p_srctype =5) then
4466: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,6,l_lotqty,p_trxuom,p_priuom,'','');
4467: ELSE
4468: l_lotpriqty := inv_convert.inv_um_convert(p_itemid,5,l_lotqty,p_trxuom,p_priuom,'','');
4469: END IF;
4470:
4471:
4472: EXCEPTION

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

7009:
7010:
7011: BEGIN
7012: IF (l_srctype = 5) then
7013: l_priqty := inv_convert.inv_um_convert(l_itemid,6,l_trxqty,
7014: l_trxuom,l_priuom,'','');
7015: ELSE
7016: l_priqty := inv_convert.inv_um_convert(l_itemid,5,l_trxqty,
7017: l_trxuom,l_priuom,'','');

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

7012: IF (l_srctype = 5) then
7013: l_priqty := inv_convert.inv_um_convert(l_itemid,6,l_trxqty,
7014: l_trxuom,l_priuom,'','');
7015: ELSE
7016: l_priqty := inv_convert.inv_um_convert(l_itemid,5,l_trxqty,
7017: l_trxuom,l_priuom,'','');
7018: END IF;
7019: EXCEPTION
7020: WHEN OTHERS THEN

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

7599: SELECT NVL(SUM(ABS(NVL(mtli.transaction_quantity,0))), 0)
7600: INTO l_lot_ser_qty
7601: FROM mtl_transaction_lots_interface mtli
7602: WHERE mtli.transaction_interface_id =l_intid
7603: AND ABS(nvl(mtli.primary_quantity, inv_convert.inv_um_convert
7604: (l_itemid,5,mtli.transaction_quantity,l_trxuom,l_priuom,'','')))
7605: = (SELECT SUM(get_serial_diff_wrp
7606: (msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)))
7607: FROM mtl_serial_numbers_interface msni

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

7906:
7907: IF (l_overcomp_txn_qty IS NOT NULL) THEN /* Overcompletion Transactions */
7908: BEGIN
7909: IF (l_srctype=5)then
7910: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,6,l_overcomp_txn_qty,
7911: l_trxuom,l_priuom,'','');
7912: ELSE
7913: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,5,l_overcomp_txn_qty,
7914: l_trxuom,l_priuom,'','');

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

7909: IF (l_srctype=5)then
7910: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,6,l_overcomp_txn_qty,
7911: l_trxuom,l_priuom,'','');
7912: ELSE
7913: l_overcomp_primary_qty := inv_convert.inv_um_convert(l_itemid,5,l_overcomp_txn_qty,
7914: l_trxuom,l_priuom,'','');
7915: END IF;
7916: EXCEPTION
7917: WHEN OTHERS THEN