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_RESERVATION_VALIDATE_PVT dependencies on INV_RESERVATION_UTIL_PVT

Line 42: inv_reservation_util_pvt.search_organization_cache

38: fnd_msg_pub.add;
39: RAISE fnd_api.g_exc_error;
40: END IF;
41: --
42: inv_reservation_util_pvt.search_organization_cache
43: (
44: x_return_status => l_return_status
45: , p_organization_id => p_organization_id
46: , x_index => l_index

Line 86: inv_reservation_util_pvt.add_organization_cache

82: RAISE fnd_api.g_exc_error;
83: END IF;
84:
85: --
86: inv_reservation_util_pvt.add_organization_cache
87: (
88: x_return_status => l_return_status
89: , p_organization_record => l_rec
90: , x_index => l_index

Line 154: inv_reservation_util_pvt.search_item_cache

150: fnd_msg_pub.add;
151: RAISE fnd_api.g_exc_error;
152: END IF;
153: --
154: inv_reservation_util_pvt.search_item_cache
155: (
156: x_return_status => l_return_status
157: , p_inventory_item_id => p_inventory_item_id
158: , p_organization_id => p_organization_id

Line 213: inv_reservation_util_pvt.add_item_cache

209: fnd_msg_pub.add;
210: RAISE fnd_api.g_exc_error;
211: END IF;
212: --
213: inv_reservation_util_pvt.add_item_cache
214: (
215: x_return_status => l_return_status
216: , p_item_record => l_rec
217: , x_index => l_index

Line 2203: inv_reservation_util_pvt.search_sub_cache

2199: --
2200: --
2201: -- validate sub if the input is not null
2202: IF p_subinventory_code IS NOT NULL THEN
2203: inv_reservation_util_pvt.search_sub_cache
2204: (
2205: x_return_status => l_return_status
2206: , p_subinventory_code => p_subinventory_code
2207: , p_organization_id => p_organization_id

Line 2274: inv_reservation_util_pvt.add_sub_cache

2270: END IF;
2271: END IF;
2272: -- End of changes for Bug 6870416
2273:
2274: inv_reservation_util_pvt.add_sub_cache
2275: (
2276: x_return_status => l_return_status
2277: , p_sub_record => l_rec
2278: , x_index => l_sub_cache_index

Line 2294: inv_reservation_util_pvt.locator_control

2290: END IF;
2291: --
2292: -- check lcator control based on settings at org, sub, item levels
2293: l_resultant_locator_control :=
2294: inv_reservation_util_pvt.locator_control
2295: (
2296: p_org_control
2297: => inv_reservation_global.g_organization_record_cache
2298: (p_org_cache_index)

Line 2707: inv_reservation_util_pvt.search_supply_cache

2703: debug_print('Before calling suppy cache. return status :' ||
2704: l_return_status);
2705: END IF;
2706: -- search for the supply source in the cache first
2707: inv_reservation_util_pvt.search_supply_cache
2708: (
2709: x_return_status => l_return_status
2710: , p_supply_source_type_id => p_supply_source_type_id
2711: , p_supply_source_header_id => p_supply_source_header_id

Line 2870: inv_reservation_util_pvt.get_wip_cache

2866: END IF;
2867:
2868: ELSIF (p_supply_source_type_id = inv_reservation_global.g_source_type_wip) THEN
2869: -- get wip entity id from wip_record_cache
2870: inv_reservation_util_pvt.get_wip_cache
2871: (
2872: x_return_status => l_return_status
2873: , p_wip_entity_id => p_supply_source_header_id
2874: );

Line 3026: inv_reservation_util_pvt.add_supply_cache

3022: l_rec.supply_source_line_id := p_supply_source_line_id;
3023: l_rec.supply_source_name := p_supply_source_name;
3024: l_rec.is_valid := 1; -- 1 = true
3025: --
3026: inv_reservation_util_pvt.add_supply_cache
3027: (
3028: x_return_status => l_return_status
3029: , p_supply_record => l_rec
3030: , x_index => l_supply_cache_index

Line 3626: inv_reservation_util_pvt.search_demand_cache

3622: END IF;
3623: END IF;
3624: --
3625: -- search for the demand source in the cache first
3626: inv_reservation_util_pvt.search_demand_cache
3627: (
3628: x_return_status => x_return_status
3629: , p_demand_source_type_id => p_demand_source_type_id
3630: , p_demand_source_header_id => p_demand_source_header_id

Line 3720: inv_reservation_util_pvt.get_wip_cache

3716:
3717: /*** {{ R12 Enhanced reservations code changes ***/
3718: IF (p_demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
3719: -- get wip entity id from wip_record_cache
3720: inv_reservation_util_pvt.get_wip_cache
3721: (
3722: x_return_status => l_return_status
3723: , p_wip_entity_id => p_demand_source_header_id
3724: );

Line 3861: inv_reservation_util_pvt.add_demand_cache

3857: l_rec.demand_source_line_id := p_demand_source_line_id;
3858: l_rec.demand_source_name := p_demand_source_name;
3859: l_rec.is_valid := 1; -- 1 = true
3860: --
3861: inv_reservation_util_pvt.add_demand_cache
3862: (
3863: x_return_status => l_return_status
3864: , p_demand_record => l_rec
3865: , x_index => l_index

Line 4509: inv_reservation_util_pvt.get_wip_cache

4505: END IF;
4506: ELSIF (p_supply_source_type_id = inv_reservation_global.g_source_type_wip) THEN
4507:
4508: -- get wip entity id from wip_record_cache
4509: inv_reservation_util_pvt.get_wip_cache
4510: (
4511: x_return_status => l_return_status
4512: , p_wip_entity_id => p_supply_source_header_id
4513: );

Line 4678: inv_reservation_util_pvt.search_organization_cache

4674: fnd_msg_pub.ADD;
4675: RAISE fnd_api.g_exc_error;
4676: END IF;
4677:
4678: inv_reservation_util_pvt.search_organization_cache
4679: (
4680: x_return_status => l_return_status
4681: , p_organization_id => p_orig_rsv_rec.organization_id
4682: , x_index => l_org_cache_index

Line 4704: inv_reservation_util_pvt.add_organization_cache

4700: RAISE fnd_api.g_exc_error;
4701: END IF;
4702:
4703: --
4704: inv_reservation_util_pvt.add_organization_cache
4705: (
4706: x_return_status => l_return_status
4707: , p_organization_record => l_org_rec
4708: , x_index => l_org_cache_index

Line 4738: inv_reservation_util_pvt.get_wip_cache

4734: END IF;
4735: -- validate the demand source for serial reservation of original reservation record
4736: IF (p_orig_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
4737: -- get wip entity id from wip_record_cache
4738: inv_reservation_util_pvt.get_wip_cache
4739: (
4740: x_return_status => l_return_status
4741: , p_wip_entity_id => p_orig_rsv_rec.demand_source_header_id
4742: );

Line 4788: inv_reservation_util_pvt.search_item_cache

4784: debug_print('After convert missing to null');
4785: END IF;
4786:
4787: -- get the revision control from item cache, first see if the item cache exists
4788: inv_reservation_util_pvt.search_item_cache
4789: (
4790: x_return_status => l_return_status
4791: ,p_inventory_item_id => l_orig_rsv_rec.inventory_item_id
4792: ,p_organization_id => l_orig_rsv_rec.organization_id

Line 4810: inv_reservation_util_pvt.add_item_cache

4806: OPEN c_item(l_orig_rsv_rec.inventory_item_id);
4807: FETCH c_item into l_item_rec;
4808: CLOSE c_item;
4809:
4810: inv_reservation_util_pvt.add_item_cache
4811: (
4812: x_return_status => l_return_status
4813: ,p_item_record => l_item_rec
4814: ,x_index => l_item_cache_index

Line 4871: inv_reservation_util_pvt.search_sub_cache

4867:
4868: IF (l_debug = 1) THEN
4869: debug_print('Before sub cache search');
4870: END IF;
4871: inv_reservation_util_pvt.search_sub_cache
4872: (
4873: x_return_status => l_return_status
4874: , p_subinventory_code => l_orig_rsv_rec.subinventory_code
4875: , p_organization_id => l_orig_rsv_rec.organization_id

Line 4899: inv_reservation_util_pvt.add_sub_cache

4895: RAISE fnd_api.g_exc_error;
4896: END IF;
4897:
4898: --
4899: inv_reservation_util_pvt.add_sub_cache
4900: (
4901: x_return_status => l_return_status
4902: , p_sub_record => l_sub_rec
4903: , x_index => l_sub_cache_index

Line 4933: l_result_locator_control := inv_reservation_util_pvt.locator_control

4929: debug_print('item control' || inv_reservation_global.g_item_record_cache
4930: (l_orig_rsv_rec.inventory_item_id).location_control_code);
4931: END IF;
4932:
4933: l_result_locator_control := inv_reservation_util_pvt.locator_control
4934: ( p_org_control => inv_reservation_global.g_organization_record_cache
4935: (l_orig_rsv_rec.organization_id).stock_locator_control_code
4936: , p_sub_control => inv_reservation_global.g_sub_record_cache
4937: (l_sub_cache_index).locator_type

Line 5117: inv_reservation_util_pvt.search_organization_cache

5113: fnd_msg_pub.ADD;
5114: RAISE fnd_api.g_exc_error;
5115: END IF;
5116:
5117: inv_reservation_util_pvt.search_organization_cache
5118: (
5119: x_return_status => l_return_status
5120: , p_organization_id => p_to_rsv_rec.organization_id
5121: , x_index => l_org_cache_index

Line 5143: inv_reservation_util_pvt.add_organization_cache

5139: RAISE fnd_api.g_exc_error;
5140: END IF;
5141:
5142: --
5143: inv_reservation_util_pvt.add_organization_cache
5144: (
5145: x_return_status => l_return_status
5146: , p_organization_record => l_org_rec
5147: , x_index => l_org_cache_index

Line 5178: inv_reservation_util_pvt.get_wip_cache

5174:
5175: -- validate the demand source for serial reservation of to reservation record
5176: IF (p_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
5177: -- get wip entity id from wip_record_cache
5178: inv_reservation_util_pvt.get_wip_cache
5179: (
5180: x_return_status => l_return_status
5181: , p_wip_entity_id => p_to_rsv_rec.demand_source_header_id
5182: );

Line 5228: inv_reservation_util_pvt.search_item_cache

5224: debug_print('After convert missing to null');
5225: END IF;
5226:
5227: -- get the revision control from item cache, first see if the item cache exists
5228: inv_reservation_util_pvt.search_item_cache
5229: (
5230: x_return_status => l_return_status
5231: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
5232: ,p_organization_id => l_to_rsv_rec.organization_id

Line 5250: inv_reservation_util_pvt.add_item_cache

5246: OPEN c_item(l_to_rsv_rec.inventory_item_id);
5247: FETCH c_item into l_item_rec;
5248: CLOSE c_item;
5249:
5250: inv_reservation_util_pvt.add_item_cache
5251: (
5252: x_return_status => l_return_status
5253: ,p_item_record => l_item_rec
5254: ,x_index => l_item_cache_index

Line 5298: inv_reservation_util_pvt.search_sub_cache

5294: fnd_message.set_name('INV', 'INV_RSV_SR_DETAIL');
5295: fnd_msg_pub.ADD;
5296: ELSE
5297: -- if subinventory is locator controlled and locator is null, returns error
5298: inv_reservation_util_pvt.search_sub_cache
5299: (
5300: x_return_status => l_return_status
5301: , p_subinventory_code => l_to_rsv_rec.subinventory_code
5302: , p_organization_id => l_to_rsv_rec.organization_id

Line 5333: inv_reservation_util_pvt.add_sub_cache

5329: RAISE fnd_api.g_exc_error;
5330: END IF;
5331:
5332: --
5333: inv_reservation_util_pvt.add_sub_cache
5334: (
5335: x_return_status => l_return_status
5336: , p_sub_record => l_sub_rec
5337: , x_index => l_sub_cache_index

Line 5370: l_result_locator_control := inv_reservation_util_pvt.locator_control

5366: debug_print('item control' || inv_reservation_global.g_item_record_cache
5367: (l_to_rsv_rec.inventory_item_id).location_control_code);
5368: END IF;
5369:
5370: l_result_locator_control := inv_reservation_util_pvt.locator_control
5371: ( p_org_control
5372: => inv_reservation_global.g_organization_record_cache
5373: (l_to_rsv_rec.organization_id).stock_locator_control_code
5374: , p_sub_control

Line 5805: inv_reservation_util_pvt.get_wip_cache

5801: END IF;
5802:
5803: /*** Get the wip entity type ***/
5804: -- get wip entity id from wip_record_cache
5805: inv_reservation_util_pvt.get_wip_cache
5806: (
5807: x_return_status => l_return_status
5808: , p_wip_entity_id => p_orig_rsv_rec.supply_source_header_id
5809: );

Line 5865: inv_reservation_util_pvt.search_item_cache

5861: END IF;
5862: --
5863: ELSE -- if we don't do validation, still need to populate item cache
5864: --the item cache info is used to created the quantity tree
5865: inv_reservation_util_pvt.search_item_cache
5866: (
5867: x_return_status => l_return_status
5868: ,p_inventory_item_id => p_orig_rsv_rec.inventory_item_id
5869: ,p_organization_id => p_orig_rsv_rec.organization_id

Line 5887: inv_reservation_util_pvt.add_item_cache

5883: OPEN c_item;
5884: FETCH c_item into l_item_rec;
5885: CLOSE c_item;
5886:
5887: inv_reservation_util_pvt.add_item_cache
5888: (
5889: x_return_status => l_return_status
5890: ,p_item_record => l_item_rec
5891: ,x_index => l_orig_item_cache_index

Line 6189: inv_reservation_util_pvt.get_wip_cache

6185: IF (p_to_rsv_rec.supply_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP) THEN
6186: -- Bug 4608452: Get the wip entity type to check for existing reservations
6187: /*** Get the wip entity type ***/
6188: -- get wip entity id from wip_record_cache
6189: inv_reservation_util_pvt.get_wip_cache
6190: (
6191: x_return_status => l_return_status
6192: , p_wip_entity_id => p_to_rsv_rec.supply_source_header_id
6193: );