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 53: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT

49: -- Package global variable that stores the package name
50: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Rule_PVT';
51: --
52: -- API versions used within this API
53: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT
54: --
55: -- Caching locator record in DoProjectCheck
56: g_locator_id NUMBER;
57: g_locator INV_VALIDATE.locator;

Line 5590: inv_quantity_tree_pvt.query_tree(

5586: log_statement(l_api_name, 'l_to_subinventory_code', 'l_to_subinventory_code: ' || l_to_subinventory_code);
5587: END IF;
5588: -- Added for Bug 8570601 end
5589:
5590: inv_quantity_tree_pvt.query_tree(
5591: p_api_version_number => g_qty_tree_api_version
5592: , p_init_msg_lst => fnd_api.g_false
5593: , x_return_status => x_return_status
5594: , x_msg_count => x_msg_count

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

5615: , p_lpn_id => g_locs(p_record_id).lpn_id
5616: );
5617: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5618: IF l_debug = 1 THEN
5619: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
5620: END IF;
5621: RAISE fnd_api.g_exc_unexpected_error;
5622: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5623: IF l_debug = 1 THEN

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

5620: END IF;
5621: RAISE fnd_api.g_exc_unexpected_error;
5622: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5623: IF l_debug = 1 THEN
5624: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
5625: END IF;
5626: RAISE fnd_api.g_exc_error;
5627: END IF;
5628:

Line 6214: inv_quantity_tree_pvt.update_quantities(

6210: IF l_debug = 1 THEN
6211: log_statement(l_api_name, 'update_tree', 'Updating qty tree');
6212: END IF;
6213:
6214: inv_quantity_tree_pvt.update_quantities(
6215: p_api_version_number => g_qty_tree_api_version
6216: , p_init_msg_lst => fnd_api.g_false
6217: , x_return_status => x_return_status
6218: , x_msg_count => x_msg_count

Line 6227: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn

6223: , p_subinventory_code => g_locs(p_record_id).subinventory_code
6224: , p_locator_id => g_locs(p_record_id).locator_id
6225: , p_primary_quantity => l_allocation_quantity
6226: , p_secondary_quantity => l_sallocation_quantity -- INVCONV
6227: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn
6228: , x_qoh => l_qoh
6229: , x_rqoh => l_rqoh
6230: , x_qr => l_qr
6231: , x_qs => l_qs

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

6243: );
6244:
6245: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6246: IF l_debug = 1 THEN
6247: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
6248: END IF;
6249:
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

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

6249:
6250: RAISE fnd_api.g_exc_unexpected_error;
6251: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6252: IF l_debug = 1 THEN
6253: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
6254: END IF;
6255: RAISE fnd_api.g_exc_error;
6256: END IF;
6257:

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

6841:
6842:
6843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6844: IF l_debug = 1 THEN
6845: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
6846: END IF;
6847: RAISE fnd_api.g_exc_unexpected_error;
6848: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6849: IF l_debug = 1 THEN

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

6846: END IF;
6847: RAISE fnd_api.g_exc_unexpected_error;
6848: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6849: IF l_debug = 1 THEN
6850: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
6851: END IF;
6852: RAISE fnd_api.g_exc_error;
6853: END IF;
6854:

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

7163: -- rollback the changes we've made
7164: log_statement(l_api_name, 'consist_not_enough_qty', 'Not enough quantity in this consistency group. ' || 'Rolling back suggestions');
7165: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
7166: END IF;
7167: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
7168:
7169: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7170: IF l_debug = 1 THEN
7171: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');

Line 8437: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

8433: -- Rule record has to exist in WMS_RULES_B uniquely
8434: -- identified by parameter p_rule_id;
8435: -- Package WMS_RULE_(RULEID) must exist;
8436: -- If picking, quantity tree has to exist, created through
8437: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
8438: -- by parameter p_tree_id
8439: -- Parameters :
8440: -- p_api_version Standard Input Parameter
8441: -- p_init_msg_list Standard Input Parameter

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

8464: --
8465: -- Version
8466: -- Currently version is 1.0
8467: --
8468: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
8469: -- This API must be called internally by
8470: -- WMS_Strategy_PVT.Apply only !
8471: --APPLY
8472: PROCEDURE apply(

Line 8916: 'Calling inv_quantity_tree_pvt.backup_tree');

8912: IF p_type_code = 2 THEN
8913: IF l_debug = 1 THEN
8914: log_statement(l_api_name, 'PICK','PICK');
8915: log_statement(l_api_name, 'backup_tree',
8916: 'Calling inv_quantity_tree_pvt.backup_tree');
8917: END IF;
8918: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
8919: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8920: IF l_debug = 1 THEN

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

8914: log_statement(l_api_name, 'PICK','PICK');
8915: log_statement(l_api_name, 'backup_tree',
8916: 'Calling inv_quantity_tree_pvt.backup_tree');
8917: END IF;
8918: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
8919: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8920: IF l_debug = 1 THEN
8921: log_statement(l_api_name, 'backup_tree_unexp_err',
8922: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');

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

8918: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
8919: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8920: IF l_debug = 1 THEN
8921: log_statement(l_api_name, 'backup_tree_unexp_err',
8922: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
8923: END IF;
8924: RAISE fnd_api.g_exc_unexpected_error;
8925: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8926: IF l_debug = 1 THEN

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

8924: RAISE fnd_api.g_exc_unexpected_error;
8925: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8926: IF l_debug = 1 THEN
8927: log_statement(l_api_name, 'backup_tree_err',
8928: 'Error from inv_quantity_tree_pvt.backup_tree');
8929: END IF;
8930: RAISE fnd_api.g_exc_error;
8931: END IF;
8932: -- does the rule have any consistency restrictions?

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

9997: || 'invalidating LPN');
9998: -- rollback quantity tree
9999: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
10000: END IF;
10001: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
10002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10003: IF l_debug = 1 THEN
10004: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
10005: END IF;

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

10279: -- rollback quantity tree
10280: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
10281: END IF;
10282:
10283: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
10284:
10285: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10286: IF l_debug = 1 THEN
10287: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');

Line 10677: inv_quantity_tree_pvt.query_tree(

10673: -- BUG 3609380
10674: -- Allocation was being treated as a subinventory transfer, and hence not honoring
10675: -- reservations alredy made on any level higher than SUB. Changes to treat as Issue
10676: -- by removing l_to_subinevntory_code.
10677: inv_quantity_tree_pvt.query_tree(
10678: p_api_version_number => g_qty_tree_api_version
10679: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
10680: , x_return_status => x_return_status
10681: , x_msg_count => x_msg_count

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

10704: );
10705:
10706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10707: IF l_debug = 1 THEN
10708: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
10709: END IF;
10710: RAISE fnd_api.g_exc_unexpected_error;
10711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10712: IF l_debug = 1 THEN

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

10709: END IF;
10710: RAISE fnd_api.g_exc_unexpected_error;
10711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10712: IF l_debug = 1 THEN
10713: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
10714: END if;
10715: RAISE fnd_api.g_exc_error;
10716: END IF;
10717:

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

10995: IF l_debug = 1 THEN
10996: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
10997: END IF;
10998:
10999: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
11000:
11001: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
11002: IF l_debug = 1 THEN
11003: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');

Line 12071: inv_quantity_tree_pvt.query_tree(

12067: || ' to find availability for consist record');
12068: END IF;
12069: -- BUG 3609380 : Removing l_to_subinevntory_code.
12070: -- Validate available quantity
12071: inv_quantity_tree_pvt.query_tree(
12072: p_api_version_number => g_qty_tree_api_version
12073: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
12074: , x_return_status => x_return_status
12075: , x_msg_count => x_msg_count

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

12097: );
12098:
12099: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12100: IF l_debug = 1 THEN
12101: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
12102: END IF;
12103: RAISE fnd_api.g_exc_unexpected_error;
12104: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12105: IF l_debug = 1 THEN

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

12102: END IF;
12103: RAISE fnd_api.g_exc_unexpected_error;
12104: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12105: IF l_debug = 1 THEN
12106: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
12107: END IF;
12108: RAISE fnd_api.g_exc_error;
12109: END IF;
12110:

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

13164: IF p_type_code = 2 THEN --{
13165: IF l_debug = 1 THEN
13166: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
13167: END IF;
13168: inv_quantity_tree_pvt.restore_tree(x_return_status, p_tree_id);
13169:
13170: /*Start of fix for Bug 5251221 */
13171:
13172: OPEN l_get_serial;

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

13947: --
13948: -- Version
13949: -- Currently version is 1.0
13950: --
13951: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
13952: -- This API must be called internally by
13953: -- WMS_Strategy_PVT.Apply only !
13954: --APPLY
13955: PROCEDURE applydefloc(

Line 17894: 'Calling inv_quantity_tree_pvt.backup_tree');

17890: If p_tree_id IS NOT NULL THEN -- Added for bug # 4006426
17891:
17892: IF l_debug = 1 THEN
17893: log_statement(l_api_name, 'backup_tree',
17894: 'Calling inv_quantity_tree_pvt.backup_tree');
17895: END IF;
17896:
17897: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
17898:

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

17893: log_statement(l_api_name, 'backup_tree',
17894: 'Calling inv_quantity_tree_pvt.backup_tree');
17895: END IF;
17896:
17897: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
17898:
17899: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
17900: IF l_debug = 1 THEN
17901: log_statement(l_api_name, 'backup_tree_unexp_err',

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

17898:
17899: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
17900: IF l_debug = 1 THEN
17901: log_statement(l_api_name, 'backup_tree_unexp_err',
17902: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
17903: END IF;
17904: RAISE fnd_api.g_exc_unexpected_error;
17905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
17906: IF l_debug = 1 THEN

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

17904: RAISE fnd_api.g_exc_unexpected_error;
17905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
17906: IF l_debug = 1 THEN
17907: log_statement(l_api_name, 'backup_tree_err',
17908: 'Error from inv_quantity_tree_pvt.backup_tree');
17909: END IF;
17910: RAISE fnd_api.g_exc_error;
17911: END IF;
17912: END IF; --- Added for bug # 4006426

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

18220: IF l_debug = 1 THEN
18221: log_statement(l_api_name, 'insert_failed', 'Record failed to allocation. Rolling back and ' || 'invalidating LPN');
18222: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
18223: END IF;
18224: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
18225: END IF; -- Bug # 4006426
18226:
18227: IF l_debug = 1 THEN --13965992
18228: log_statement(l_api_name, 'insert_failed', 'Rolling back');

Line 18327: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

18323: -- Rule record has to exist in WMS_RULES_B uniquely
18324: -- identified by parameter p_rule_id;
18325: -- Package WMS_RULE_(RULEID) must exist;
18326: -- If picking, quantity tree has to exist, created through
18327: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
18328: -- by parameter p_tree_id
18329: -- Parameters :
18330: -- p_api_version Standard Input Parameter
18331: -- p_init_msg_list Standard Input Parameter

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

18354: --
18355: -- Version
18356: -- Currently version is 1.0
18357: --
18358: -- Notes : Calls API's of WMS_Common_PVT and INV_Quantity_Tree_PVT
18359: -- This API must be called internally by
18360: -- WMS_Strategy_PVT.Apply only !
18361: --APPLY
18362: PROCEDURE get_available_inventory(

Line 18748: 'Calling inv_quantity_tree_pvt.backup_tree');

18744: -- backup qty tree
18745: IF p_type_code = 2 THEN
18746: IF l_debug = 1 THEN
18747: log_statement(l_api_name, 'backup_tree',
18748: 'Calling inv_quantity_tree_pvt.backup_tree');
18749: END IF;
18750: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
18751:
18752: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

18746: IF l_debug = 1 THEN
18747: log_statement(l_api_name, 'backup_tree',
18748: 'Calling inv_quantity_tree_pvt.backup_tree');
18749: END IF;
18750: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
18751:
18752: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
18753: IF l_debug = 1 THEN
18754: log_statement(l_api_name, 'backup_tree_unexp_err',

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

18751:
18752: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
18753: IF l_debug = 1 THEN
18754: log_statement(l_api_name, 'backup_tree_unexp_err',
18755: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
18756: END IF;
18757:
18758: RAISE fnd_api.g_exc_unexpected_error;
18759: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

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

18758: RAISE fnd_api.g_exc_unexpected_error;
18759: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
18760: IF l_debug = 1 THEN
18761: log_statement(l_api_name, 'backup_tree_err',
18762: 'Error from inv_quantity_tree_pvt.backup_tree');
18763: END IF;
18764: RAISE fnd_api.g_exc_error;
18765: END IF;
18766: