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.WMS_RULE_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 36: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT

32: -- Package global variable that stores the package name
33: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Rule_PVT';
34: --
35: -- API versions used within this API
36: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT
37: --
38: -- Caching locator record in DoProjectCheck
39: g_locator_id NUMBER;
40: g_locator INV_VALIDATE.locator;

Line 4402: inv_quantity_tree_pvt.query_tree

4398: log_statement(l_api_name, 'tree_id', 'tree_id: ' || p_tree_id);
4399:
4400: END IF;
4401:
4402: inv_quantity_tree_pvt.query_tree
4403: (
4404: p_api_version_number => g_qty_tree_api_version
4405: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
4406: , x_return_status => x_return_status

Line 4432: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');

4428: , p_lpn_id => g_locs(p_record_id).lpn_id
4429: );
4430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4431: IF l_debug = 1 THEN
4432: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
4433: END IF;
4434: RAISE fnd_api.g_exc_unexpected_error;
4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4436: IF l_debug = 1 THEN

Line 4437: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');

4433: END IF;
4434: RAISE fnd_api.g_exc_unexpected_error;
4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4436: IF l_debug = 1 THEN
4437: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
4438: END IF;
4439: RAISE fnd_api.g_exc_error;
4440: END IF;
4441:

Line 4680: inv_quantity_tree_pvt.update_quantities

4676: IF l_debug = 1 THEN
4677: log_statement(l_api_name, 'update_tree', 'Updating qty tree');
4678: END IF;
4679:
4680: inv_quantity_tree_pvt.update_quantities
4681: (
4682: p_api_version_number => g_qty_tree_api_version
4683: , p_init_msg_lst => fnd_api.g_false
4684: , x_return_status => x_return_status

Line 4694: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn

4690: , p_subinventory_code => g_locs(p_record_id).subinventory_code
4691: , p_locator_id => g_locs(p_record_id).locator_id
4692: , p_primary_quantity => l_allocation_quantity
4693: , p_secondary_quantity => l_sallocation_quantity -- INVCONV
4694: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn
4695: , x_qoh => l_qoh
4696: , x_rqoh => l_rqoh
4697: , x_qr => l_qr
4698: , x_qs => l_qs

Line 4714: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');

4710: );
4711:
4712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4713: IF l_debug = 1 THEN
4714: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
4715: END IF;
4716:
4717: RAISE fnd_api.g_exc_unexpected_error;
4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 4720: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');

4716:
4717: RAISE fnd_api.g_exc_unexpected_error;
4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4719: IF l_debug = 1 THEN
4720: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
4721: END IF;
4722: RAISE fnd_api.g_exc_error;
4723: END IF;
4724:

Line 5114: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');

5110:
5111:
5112: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5113: IF l_debug = 1 THEN
5114: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
5115: END IF;
5116: RAISE fnd_api.g_exc_unexpected_error;
5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5118: IF l_debug = 1 THEN

Line 5119: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');

5115: END IF;
5116: RAISE fnd_api.g_exc_unexpected_error;
5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5118: IF l_debug = 1 THEN
5119: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
5120: END IF;
5121: RAISE fnd_api.g_exc_error;
5122: END IF;
5123:

Line 5436: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);

5432: -- rollback the changes we've made
5433: log_statement(l_api_name, 'consist_not_enough_qty', 'Not enough quantity in this consistency group. ' || 'Rolling back suggestions');
5434: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
5435: END IF;
5436: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
5437:
5438: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5439: IF l_debug = 1 THEN
5440: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');

Line 6474: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

6470: -- Rule record has to exist in WMS_RULES_B uniquely
6471: -- identified by parameter p_rule_id;
6472: -- Package WMS_RULE_(RULEID) must exist;
6473: -- If picking, quantity tree has to exist, created through
6474: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
6475: -- by parameter p_tree_id
6476: -- Parameters :
6477: -- p_api_version Standard Input Parameter
6478: -- p_init_msg_list Standard Input Parameter

Line 6505: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT

6501: --
6502: -- Version
6503: -- Currently version is 1.0
6504: --
6505: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
6506: -- This API must be called internally by
6507: -- WMS_Strategy_PVT.Apply only !
6508: --APPLY
6509: PROCEDURE apply(

Line 6975: 'Calling inv_quantity_tree_pvt.backup_tree');

6971: IF p_type_code = 2 THEN
6972: IF l_debug = 1 THEN
6973: log_statement(l_api_name, 'PICK','PICK');
6974: log_statement(l_api_name, 'backup_tree',
6975: 'Calling inv_quantity_tree_pvt.backup_tree');
6976: END IF;
6977: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
6978: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6979: IF l_debug = 1 THEN

Line 6977: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);

6973: log_statement(l_api_name, 'PICK','PICK');
6974: log_statement(l_api_name, 'backup_tree',
6975: 'Calling inv_quantity_tree_pvt.backup_tree');
6976: END IF;
6977: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
6978: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6979: IF l_debug = 1 THEN
6980: log_statement(l_api_name, 'backup_tree_unexp_err',
6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');

Line 6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');

6977: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
6978: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6979: IF l_debug = 1 THEN
6980: log_statement(l_api_name, 'backup_tree_unexp_err',
6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
6982: END IF;
6983: RAISE fnd_api.g_exc_unexpected_error;
6984: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6985: IF l_debug = 1 THEN

Line 6987: 'Error from inv_quantity_tree_pvt.backup_tree');

6983: RAISE fnd_api.g_exc_unexpected_error;
6984: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6985: IF l_debug = 1 THEN
6986: log_statement(l_api_name, 'backup_tree_err',
6987: 'Error from inv_quantity_tree_pvt.backup_tree');
6988: END IF;
6989: RAISE fnd_api.g_exc_error;
6990: END IF;
6991: --does the rule have any consistency restrictions?

Line 7943: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);

7939: log_statement(l_api_name, 'insert_failed', 'Record failed to allocation. Rolling back and ' || 'invalidating LPN');
7940: -- rollback quantity tree
7941: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
7942: END IF;
7943: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
7944: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7945: IF l_debug = 1 THEN
7946: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
7947: END IF;

Line 8139: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);

8135: -- rollback quantity tree
8136: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
8137: END IF;
8138:
8139: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
8140:
8141: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8142: IF l_debug = 1 THEN
8143: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');

Line 8486: inv_quantity_tree_pvt.query_tree

8482: -- BUG 3609380
8483: -- Allocation was being treated as a subinventory transfer, and hence not honoring
8484: -- reservations alredy made on any level higher than SUB. Changes to treat as Issue
8485: -- by removing l_to_subinevntory_code.
8486: inv_quantity_tree_pvt.query_tree
8487: (
8488: p_api_version_number => g_qty_tree_api_version
8489: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
8490: , x_return_status => x_return_status

Line 8517: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');

8513: );
8514:
8515: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8516: IF l_debug = 1 THEN
8517: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
8518: END IF;
8519: RAISE fnd_api.g_exc_unexpected_error;
8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8521: IF l_debug = 1 THEN

Line 8522: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');

8518: END IF;
8519: RAISE fnd_api.g_exc_unexpected_error;
8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8521: IF l_debug = 1 THEN
8522: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
8523: END if;
8524: RAISE fnd_api.g_exc_error;
8525: END IF;
8526:

Line 8782: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);

8778: IF l_debug = 1 THEN
8779: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
8780: END IF;
8781:
8782: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
8783:
8784: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8785:
8786: IF l_debug = 1 THEN

Line 9633: inv_quantity_tree_pvt.query_tree

9629: log_statement(l_api_name, 'query_tree', 'Querying the quantity tree' || ' to find availability for consist record');
9630: END IF;
9631: -- BUG 3609380 : Removing l_to_subinevntory_code.
9632: --Validate available quantity
9633: inv_quantity_tree_pvt.query_tree
9634: (
9635: p_api_version_number => g_qty_tree_api_version
9636: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
9637: , x_return_status => x_return_status

Line 9664: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');

9660: );
9661:
9662: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9663: IF l_debug = 1 THEN
9664: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
9665: END IF;
9666: RAISE fnd_api.g_exc_unexpected_error;
9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9668: IF l_debug = 1 THEN

Line 9669: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');

9665: END IF;
9666: RAISE fnd_api.g_exc_unexpected_error;
9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9668: IF l_debug = 1 THEN
9669: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
9670: END IF;
9671: RAISE fnd_api.g_exc_error;
9672: END IF;
9673:

Line 10641: inv_quantity_tree_pvt.restore_tree(x_return_status, p_tree_id);

10637: IF p_type_code = 2 THEN
10638: IF l_debug = 1 THEN
10639: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
10640: END IF;
10641: inv_quantity_tree_pvt.restore_tree(x_return_status, p_tree_id);
10642:
10643: /*Start of fix for Bug 5251221 */
10644:
10645: OPEN l_get_serial;

Line 11368: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT

11364: --
11365: -- Version
11366: -- Currently version is 1.0
11367: --
11368: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
11369: -- This API must be called internally by
11370: -- WMS_Strategy_PVT.Apply only !
11371: --APPLY
11372: PROCEDURE applydefloc(

Line 15236: 'Calling inv_quantity_tree_pvt.backup_tree');

15232: If p_tree_id IS NOT NULL THEN -- Added for bug # 4006426
15233:
15234: IF l_debug = 1 THEN
15235: log_statement(l_api_name, 'backup_tree',
15236: 'Calling inv_quantity_tree_pvt.backup_tree');
15237: END IF;
15238:
15239: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
15240:

Line 15239: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);

15235: log_statement(l_api_name, 'backup_tree',
15236: 'Calling inv_quantity_tree_pvt.backup_tree');
15237: END IF;
15238:
15239: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
15240:
15241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15242: IF l_debug = 1 THEN
15243: log_statement(l_api_name, 'backup_tree_unexp_err',

Line 15244: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');

15240:
15241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15242: IF l_debug = 1 THEN
15243: log_statement(l_api_name, 'backup_tree_unexp_err',
15244: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
15245: END IF;
15246: RAISE fnd_api.g_exc_unexpected_error;
15247: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15248: IF l_debug = 1 THEN

Line 15250: 'Error from inv_quantity_tree_pvt.backup_tree');

15246: RAISE fnd_api.g_exc_unexpected_error;
15247: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15248: IF l_debug = 1 THEN
15249: log_statement(l_api_name, 'backup_tree_err',
15250: 'Error from inv_quantity_tree_pvt.backup_tree');
15251: END IF;
15252: RAISE fnd_api.g_exc_error;
15253: END IF;
15254: END IF; --- Added for bug # 4006426

Line 15564: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);

15560: IF l_debug = 1 THEN
15561: log_statement(l_api_name, 'insert_failed', 'Record failed to allocation. Rolling back and ' || 'invalidating LPN');
15562: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
15563: END IF;
15564: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
15565: END IF; -- Bug # 4006426
15566: END IF;
15567:
15568: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 15662: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

15658: -- Rule record has to exist in WMS_RULES_B uniquely
15659: -- identified by parameter p_rule_id;
15660: -- Package WMS_RULE_(RULEID) must exist;
15661: -- If picking, quantity tree has to exist, created through
15662: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
15663: -- by parameter p_tree_id
15664: -- Parameters :
15665: -- p_api_version Standard Input Parameter
15666: -- p_init_msg_list Standard Input Parameter

Line 15693: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT

15689: --
15690: -- Version
15691: -- Currently version is 1.0
15692: --
15693: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
15694: -- This API must be called internally by
15695: -- WMS_Strategy_PVT.Apply only !
15696: --APPLY
15697: PROCEDURE get_available_inventory(

Line 16107: 'Calling inv_quantity_tree_pvt.backup_tree');

16103: -- backup qty tree
16104: IF p_type_code = 2 THEN
16105: IF l_debug = 1 THEN
16106: log_statement(l_api_name, 'backup_tree',
16107: 'Calling inv_quantity_tree_pvt.backup_tree');
16108: END IF;
16109: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
16110:
16111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 16109: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);

16105: IF l_debug = 1 THEN
16106: log_statement(l_api_name, 'backup_tree',
16107: 'Calling inv_quantity_tree_pvt.backup_tree');
16108: END IF;
16109: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
16110:
16111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
16112: IF l_debug = 1 THEN
16113: log_statement(l_api_name, 'backup_tree_unexp_err',

Line 16114: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');

16110:
16111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
16112: IF l_debug = 1 THEN
16113: log_statement(l_api_name, 'backup_tree_unexp_err',
16114: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
16115: END IF;
16116:
16117: RAISE fnd_api.g_exc_unexpected_error;
16118: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 16121: 'Error from inv_quantity_tree_pvt.backup_tree');

16117: RAISE fnd_api.g_exc_unexpected_error;
16118: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
16119: IF l_debug = 1 THEN
16120: log_statement(l_api_name, 'backup_tree_err',
16121: 'Error from inv_quantity_tree_pvt.backup_tree');
16122: END IF;
16123: RAISE fnd_api.g_exc_error;
16124: END IF;
16125: