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 2080: inv_reservation_util_pvt.search_sub_cache

2076: --
2077: --
2078: -- validate sub if the input is not null
2079: IF p_subinventory_code IS NOT NULL THEN
2080: inv_reservation_util_pvt.search_sub_cache
2081: (
2082: x_return_status => l_return_status
2083: , p_subinventory_code => p_subinventory_code
2084: , p_organization_id => p_organization_id

Line 2151: inv_reservation_util_pvt.add_sub_cache

2147: END IF;
2148: END IF;
2149: -- End of changes for Bug 6870416
2150:
2151: inv_reservation_util_pvt.add_sub_cache
2152: (
2153: x_return_status => l_return_status
2154: , p_sub_record => l_rec
2155: , x_index => l_sub_cache_index

Line 2171: inv_reservation_util_pvt.locator_control

2167: END IF;
2168: --
2169: -- check lcator control based on settings at org, sub, item levels
2170: l_resultant_locator_control :=
2171: inv_reservation_util_pvt.locator_control
2172: (
2173: p_org_control
2174: => inv_reservation_global.g_organization_record_cache
2175: (p_org_cache_index)

Line 2576: inv_reservation_util_pvt.search_supply_cache

2572: debug_print('Before calling suppy cache. return status :' ||
2573: l_return_status);
2574: END IF;
2575: -- search for the supply source in the cache first
2576: inv_reservation_util_pvt.search_supply_cache
2577: (
2578: x_return_status => l_return_status
2579: , p_supply_source_type_id => p_supply_source_type_id
2580: , p_supply_source_header_id => p_supply_source_header_id

Line 2739: inv_reservation_util_pvt.get_wip_cache

2735: END IF;
2736:
2737: ELSIF (p_supply_source_type_id = inv_reservation_global.g_source_type_wip) THEN
2738: -- get wip entity id from wip_record_cache
2739: inv_reservation_util_pvt.get_wip_cache
2740: (
2741: x_return_status => l_return_status
2742: , p_wip_entity_id => p_supply_source_header_id
2743: );

Line 2871: inv_reservation_util_pvt.add_supply_cache

2867: l_rec.supply_source_line_id := p_supply_source_line_id;
2868: l_rec.supply_source_name := p_supply_source_name;
2869: l_rec.is_valid := 1; -- 1 = true
2870: --
2871: inv_reservation_util_pvt.add_supply_cache
2872: (
2873: x_return_status => l_return_status
2874: , p_supply_record => l_rec
2875: , x_index => l_supply_cache_index

Line 3462: inv_reservation_util_pvt.search_demand_cache

3458: END IF;
3459: END IF;
3460: --
3461: -- search for the demand source in the cache first
3462: inv_reservation_util_pvt.search_demand_cache
3463: (
3464: x_return_status => x_return_status
3465: , p_demand_source_type_id => p_demand_source_type_id
3466: , p_demand_source_header_id => p_demand_source_header_id

Line 3556: inv_reservation_util_pvt.get_wip_cache

3552:
3553: /*** {{ R12 Enhanced reservations code changes ***/
3554: IF (p_demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
3555: -- get wip entity id from wip_record_cache
3556: inv_reservation_util_pvt.get_wip_cache
3557: (
3558: x_return_status => l_return_status
3559: , p_wip_entity_id => p_demand_source_header_id
3560: );

Line 3697: inv_reservation_util_pvt.add_demand_cache

3693: l_rec.demand_source_line_id := p_demand_source_line_id;
3694: l_rec.demand_source_name := p_demand_source_name;
3695: l_rec.is_valid := 1; -- 1 = true
3696: --
3697: inv_reservation_util_pvt.add_demand_cache
3698: (
3699: x_return_status => l_return_status
3700: , p_demand_record => l_rec
3701: , x_index => l_index

Line 4345: inv_reservation_util_pvt.get_wip_cache

4341: END IF;
4342: ELSIF (p_supply_source_type_id = inv_reservation_global.g_source_type_wip) THEN
4343:
4344: -- get wip entity id from wip_record_cache
4345: inv_reservation_util_pvt.get_wip_cache
4346: (
4347: x_return_status => l_return_status
4348: , p_wip_entity_id => p_supply_source_header_id
4349: );

Line 4514: inv_reservation_util_pvt.search_organization_cache

4510: fnd_msg_pub.ADD;
4511: RAISE fnd_api.g_exc_error;
4512: END IF;
4513:
4514: inv_reservation_util_pvt.search_organization_cache
4515: (
4516: x_return_status => l_return_status
4517: , p_organization_id => p_orig_rsv_rec.organization_id
4518: , x_index => l_org_cache_index

Line 4540: inv_reservation_util_pvt.add_organization_cache

4536: RAISE fnd_api.g_exc_error;
4537: END IF;
4538:
4539: --
4540: inv_reservation_util_pvt.add_organization_cache
4541: (
4542: x_return_status => l_return_status
4543: , p_organization_record => l_org_rec
4544: , x_index => l_org_cache_index

Line 4574: inv_reservation_util_pvt.get_wip_cache

4570: END IF;
4571: -- validate the demand source for serial reservation of original reservation record
4572: IF (p_orig_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
4573: -- get wip entity id from wip_record_cache
4574: inv_reservation_util_pvt.get_wip_cache
4575: (
4576: x_return_status => l_return_status
4577: , p_wip_entity_id => p_orig_rsv_rec.demand_source_header_id
4578: );

Line 4624: inv_reservation_util_pvt.search_item_cache

4620: debug_print('After convert missing to null');
4621: END IF;
4622:
4623: -- get the revision control from item cache, first see if the item cache exists
4624: inv_reservation_util_pvt.search_item_cache
4625: (
4626: x_return_status => l_return_status
4627: ,p_inventory_item_id => l_orig_rsv_rec.inventory_item_id
4628: ,p_organization_id => l_orig_rsv_rec.organization_id

Line 4646: inv_reservation_util_pvt.add_item_cache

4642: OPEN c_item(l_orig_rsv_rec.inventory_item_id);
4643: FETCH c_item into l_item_rec;
4644: CLOSE c_item;
4645:
4646: inv_reservation_util_pvt.add_item_cache
4647: (
4648: x_return_status => l_return_status
4649: ,p_item_record => l_item_rec
4650: ,x_index => l_item_cache_index

Line 4707: inv_reservation_util_pvt.search_sub_cache

4703:
4704: IF (l_debug = 1) THEN
4705: debug_print('Before sub cache search');
4706: END IF;
4707: inv_reservation_util_pvt.search_sub_cache
4708: (
4709: x_return_status => l_return_status
4710: , p_subinventory_code => l_orig_rsv_rec.subinventory_code
4711: , p_organization_id => l_orig_rsv_rec.organization_id

Line 4735: inv_reservation_util_pvt.add_sub_cache

4731: RAISE fnd_api.g_exc_error;
4732: END IF;
4733:
4734: --
4735: inv_reservation_util_pvt.add_sub_cache
4736: (
4737: x_return_status => l_return_status
4738: , p_sub_record => l_sub_rec
4739: , x_index => l_sub_cache_index

Line 4769: l_result_locator_control := inv_reservation_util_pvt.locator_control

4765: debug_print('item control' || inv_reservation_global.g_item_record_cache
4766: (l_orig_rsv_rec.inventory_item_id).location_control_code);
4767: END IF;
4768:
4769: l_result_locator_control := inv_reservation_util_pvt.locator_control
4770: ( p_org_control => inv_reservation_global.g_organization_record_cache
4771: (l_orig_rsv_rec.organization_id).stock_locator_control_code
4772: , p_sub_control => inv_reservation_global.g_sub_record_cache
4773: (l_sub_cache_index).locator_type

Line 4953: inv_reservation_util_pvt.search_organization_cache

4949: fnd_msg_pub.ADD;
4950: RAISE fnd_api.g_exc_error;
4951: END IF;
4952:
4953: inv_reservation_util_pvt.search_organization_cache
4954: (
4955: x_return_status => l_return_status
4956: , p_organization_id => p_to_rsv_rec.organization_id
4957: , x_index => l_org_cache_index

Line 4979: inv_reservation_util_pvt.add_organization_cache

4975: RAISE fnd_api.g_exc_error;
4976: END IF;
4977:
4978: --
4979: inv_reservation_util_pvt.add_organization_cache
4980: (
4981: x_return_status => l_return_status
4982: , p_organization_record => l_org_rec
4983: , x_index => l_org_cache_index

Line 5014: inv_reservation_util_pvt.get_wip_cache

5010:
5011: -- validate the demand source for serial reservation of to reservation record
5012: IF (p_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) THEN
5013: -- get wip entity id from wip_record_cache
5014: inv_reservation_util_pvt.get_wip_cache
5015: (
5016: x_return_status => l_return_status
5017: , p_wip_entity_id => p_to_rsv_rec.demand_source_header_id
5018: );

Line 5064: inv_reservation_util_pvt.search_item_cache

5060: debug_print('After convert missing to null');
5061: END IF;
5062:
5063: -- get the revision control from item cache, first see if the item cache exists
5064: inv_reservation_util_pvt.search_item_cache
5065: (
5066: x_return_status => l_return_status
5067: ,p_inventory_item_id => l_to_rsv_rec.inventory_item_id
5068: ,p_organization_id => l_to_rsv_rec.organization_id

Line 5086: inv_reservation_util_pvt.add_item_cache

5082: OPEN c_item(l_to_rsv_rec.inventory_item_id);
5083: FETCH c_item into l_item_rec;
5084: CLOSE c_item;
5085:
5086: inv_reservation_util_pvt.add_item_cache
5087: (
5088: x_return_status => l_return_status
5089: ,p_item_record => l_item_rec
5090: ,x_index => l_item_cache_index

Line 5134: inv_reservation_util_pvt.search_sub_cache

5130: fnd_message.set_name('INV', 'INV_RSV_SR_DETAIL');
5131: fnd_msg_pub.ADD;
5132: ELSE
5133: -- if subinventory is locator controlled and locator is null, returns error
5134: inv_reservation_util_pvt.search_sub_cache
5135: (
5136: x_return_status => l_return_status
5137: , p_subinventory_code => l_to_rsv_rec.subinventory_code
5138: , p_organization_id => l_to_rsv_rec.organization_id

Line 5169: inv_reservation_util_pvt.add_sub_cache

5165: RAISE fnd_api.g_exc_error;
5166: END IF;
5167:
5168: --
5169: inv_reservation_util_pvt.add_sub_cache
5170: (
5171: x_return_status => l_return_status
5172: , p_sub_record => l_sub_rec
5173: , x_index => l_sub_cache_index

Line 5206: l_result_locator_control := inv_reservation_util_pvt.locator_control

5202: debug_print('item control' || inv_reservation_global.g_item_record_cache
5203: (l_to_rsv_rec.inventory_item_id).location_control_code);
5204: END IF;
5205:
5206: l_result_locator_control := inv_reservation_util_pvt.locator_control
5207: ( p_org_control
5208: => inv_reservation_global.g_organization_record_cache
5209: (l_to_rsv_rec.organization_id).stock_locator_control_code
5210: , p_sub_control

Line 5641: inv_reservation_util_pvt.get_wip_cache

5637: END IF;
5638:
5639: /*** Get the wip entity type ***/
5640: -- get wip entity id from wip_record_cache
5641: inv_reservation_util_pvt.get_wip_cache
5642: (
5643: x_return_status => l_return_status
5644: , p_wip_entity_id => p_orig_rsv_rec.supply_source_header_id
5645: );

Line 5700: inv_reservation_util_pvt.search_item_cache

5696: END IF;
5697: --
5698: ELSE -- if we don't do validation, still need to populate item cache
5699: --the item cache info is used to created the quantity tree
5700: inv_reservation_util_pvt.search_item_cache
5701: (
5702: x_return_status => l_return_status
5703: ,p_inventory_item_id => p_orig_rsv_rec.inventory_item_id
5704: ,p_organization_id => p_orig_rsv_rec.organization_id

Line 5722: inv_reservation_util_pvt.add_item_cache

5718: OPEN c_item;
5719: FETCH c_item into l_item_rec;
5720: CLOSE c_item;
5721:
5722: inv_reservation_util_pvt.add_item_cache
5723: (
5724: x_return_status => l_return_status
5725: ,p_item_record => l_item_rec
5726: ,x_index => l_orig_item_cache_index

Line 6024: inv_reservation_util_pvt.get_wip_cache

6020: IF (p_to_rsv_rec.supply_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP) THEN
6021: -- Bug 4608452: Get the wip entity type to check for existing reservations
6022: /*** Get the wip entity type ***/
6023: -- get wip entity id from wip_record_cache
6024: inv_reservation_util_pvt.get_wip_cache
6025: (
6026: x_return_status => l_return_status
6027: , p_wip_entity_id => p_to_rsv_rec.supply_source_header_id
6028: );