1: PACKAGE BODY INV_TXN_VALIDATIONS AS
2: /* $Header: INVMWAVB.pls 120.8.12010000.2 2008/07/29 13:42:07 ptkumar ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Txn_Validations';
1: PACKAGE BODY INV_TXN_VALIDATIONS AS
2: /* $Header: INVMWAVB.pls 120.8.12010000.2 2008/07/29 13:42:07 ptkumar ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Txn_Validations';
6:
7:
8: PROCEDURE mdebug(msg in varchar2)
9: IS
17:
18: IF (l_debug = 1) THEN
19: inv_mobile_helper_functions.tracelog
20: (p_err_msg => l_msg,
21: p_module => 'inv_txn_validations',
22: p_level => 4);
23: END IF;
24: null;
25: END;
1553: end if;
1554: end if;
1555:
1556:
1557: inv_txn_validations.get_available_quantity
1558: (x_return_status => l_return_status,
1559: p_tree_mode => INV_Quantity_Tree_PUB.g_loose_only_mode,
1560: p_organization_id => p_organization_id,
1561: p_inventory_item_id => p_inventory_item_id,
4228: IF (l_debug = 1) THEN
4229: mdebug ('Transaction qty in primary units: '||l_txn_qty);
4230: END IF;
4231:
4232: inv_txn_validations.get_available_quantity
4233: (x_return_status => l_return_status,
4234: p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode,
4235: p_organization_id => p_organization_id,
4236: p_inventory_item_id => p_inventory_item_id,
4583: x_return_msg := 'OTHER ERROR';
4584: RETURN x_return;
4585: END check_lpn_pending_txns; --End of fix for bug#4446248
4586:
4587: END INV_TXN_VALIDATIONS;