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_PVT dependencies on INV_CACHE

Line 41: IF INV_CACHE.is_pickrelease THEN

37: -- correctly even if it is g_miss_char.
38: -- Use cache to get value for l_debug
39: IF g_is_pickrelease_set IS NULL THEN
40: g_is_pickrelease_set := 2;
41: IF INV_CACHE.is_pickrelease THEN
42: g_is_pickrelease_set := 1;
43: END IF;
44: END IF;
45: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 252: l_return_value := inv_cache.set_item_rec( p_rsv_rec.organization_id, p_rsv_rec.inventory_item_id);

248: p_reservation_qty_lot := p_rsv_rec.primary_reservation_quantity;
249: END IF;
250: -- MUOM fulfillment Project
251:
252: l_return_value := inv_cache.set_item_rec( p_rsv_rec.organization_id, p_rsv_rec.inventory_item_id);
253: IF NOT l_return_value THEN
254: IF (l_debug = 1) THEN
255: debug_print('error occurred while setting inv_cache.set_item_rec');
256: END IF;

Line 255: debug_print('error occurred while setting inv_cache.set_item_rec');

251:
252: l_return_value := inv_cache.set_item_rec( p_rsv_rec.organization_id, p_rsv_rec.inventory_item_id);
253: IF NOT l_return_value THEN
254: IF (l_debug = 1) THEN
255: debug_print('error occurred while setting inv_cache.set_item_rec');
256: END IF;
257: RAISE fnd_api.g_exc_unexpected_error;
258: End IF;
259:

Line 262: inv_cache.item_rec.lot_control_code <> 2 OR

258: End IF;
259:
260:
261: IF p_rsv_rec.lot_number is NULL OR
262: inv_cache.item_rec.lot_control_code <> 2 OR
263: inv_cache.item_rec.primary_uom_code = p_rsv_rec.reservation_uom_code THEN
264: IF (l_debug = 1) THEN
265: debug_print('either item is not lot controlled or or lot num is null or rsv uom is same as prim uom. return');
266: END IF;

Line 263: inv_cache.item_rec.primary_uom_code = p_rsv_rec.reservation_uom_code THEN

259:
260:
261: IF p_rsv_rec.lot_number is NULL OR
262: inv_cache.item_rec.lot_control_code <> 2 OR
263: inv_cache.item_rec.primary_uom_code = p_rsv_rec.reservation_uom_code THEN
264: IF (l_debug = 1) THEN
265: debug_print('either item is not lot controlled or or lot num is null or rsv uom is same as prim uom. return');
266: END IF;
267:

Line 274: debug_print('inv_cache.item_rec.primary_uom_code :' || inv_cache.item_rec.primary_uom_code);

270:
271: IF (l_debug = 1) THEN
272: debug_print('p_rsv_rec.inventory_item_id :' || p_rsv_rec.inventory_item_id);
273: debug_print('p_rsv_rec.organization_id :' || p_rsv_rec.organization_id);
274: debug_print('inv_cache.item_rec.primary_uom_code :' || inv_cache.item_rec.primary_uom_code);
275: debug_print('p_rsv_rec.reservation_uom_code :' ||p_rsv_rec.reservation_uom_code);
276: debug_print('p_rsv_rec.lot_number :' ||p_rsv_rec.lot_number);
277: END IF;
278:

Line 295: , from_unit => inv_cache.item_rec.secondary_uom_code

291: , lot_number => p_rsv_rec.lot_number
292: , organization_id => p_rsv_rec.organization_id
293: , precision => null
294: , from_quantity => p_rsv_rec.secondary_reservation_quantity
295: , from_unit => inv_cache.item_rec.secondary_uom_code
296: , to_unit => p_rsv_rec.reservation_uom_code
297: , from_name => null
298: , to_name => null
299: );

Line 311: , to_unit => inv_cache.item_rec.secondary_uom_code

307: , organization_id => p_rsv_rec.organization_id
308: , precision => null
309: , from_quantity => l_lot_rsv_qty_order_uom
310: , from_unit => p_rsv_rec.reservation_uom_code
311: , to_unit => inv_cache.item_rec.secondary_uom_code
312: , from_name => null
313: , to_name => null
314: );
315:

Line 328: , from_unit => inv_cache.item_rec.primary_uom_code

324: , lot_number => p_rsv_rec.lot_number
325: , organization_id => p_rsv_rec.organization_id
326: , precision => null
327: , from_quantity => p_rsv_rec.primary_reservation_quantity
328: , from_unit => inv_cache.item_rec.primary_uom_code
329: , to_unit => p_rsv_rec.reservation_uom_code
330: , from_name => null
331: , to_name => null
332: );

Line 344: , to_unit => inv_cache.item_rec.primary_uom_code

340: , organization_id => p_rsv_rec.organization_id
341: , precision => null
342: , from_quantity => l_lot_rsv_qty_order_uom
343: , from_unit => p_rsv_rec.reservation_uom_code
344: , to_unit => inv_cache.item_rec.primary_uom_code
345: , from_name => null
346: , to_name => null
347: );
348:

Line 3016: IF INV_CACHE.is_pickrelease THEN

3012: BEGIN
3013: -- Use cache to get value for l_debug
3014: IF g_is_pickrelease_set IS NULL THEN
3015: g_is_pickrelease_set := 2;
3016: IF INV_CACHE.is_pickrelease THEN
3017: g_is_pickrelease_set := 1;
3018: END IF;
3019: END IF;
3020: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 3321: IF INV_CACHE.is_pickrelease THEN

3317: BEGIN
3318: -- Use cache to get value for l_debug
3319: IF g_is_pickrelease_set IS NULL THEN
3320: g_is_pickrelease_set := 2;
3321: IF INV_CACHE.is_pickrelease THEN
3322: g_is_pickrelease_set := 1;
3323: END IF;
3324: END IF;
3325: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 4751: IF INV_CACHE.is_pickrelease THEN

4747:
4748: -- Use cache to get value for l_debug
4749: IF g_is_pickrelease_set IS NULL THEN
4750: g_is_pickrelease_set := 2;
4751: IF INV_CACHE.is_pickrelease THEN
4752: g_is_pickrelease_set := 1;
4753: END IF;
4754: END IF;
4755: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 8152: IF INV_CACHE.is_pickrelease THEN

8148: BEGIN
8149: -- Use cache to get value for l_debug
8150: IF g_is_pickrelease_set IS NULL THEN
8151: g_is_pickrelease_set := 2;
8152: IF INV_CACHE.is_pickrelease THEN
8153: g_is_pickrelease_set := 1;
8154: END IF;
8155: END IF;
8156: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 8670: -- INV_CACHE

8666: debug_print('Before Rsv rec project id: ' || l_rsv_rec.project_id);
8667: debug_print('Before Rsv rec task id: ' || l_rsv_rec.task_id);
8668: END IF;
8669: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8670: -- INV_CACHE
8671: IF INV_CACHE.is_pickrelease THEN
8672: -- Query for and cache the org record.
8673: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8674: THEN

Line 8671: IF INV_CACHE.is_pickrelease THEN

8667: debug_print('Before Rsv rec task id: ' || l_rsv_rec.task_id);
8668: END IF;
8669: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8670: -- INV_CACHE
8671: IF INV_CACHE.is_pickrelease THEN
8672: -- Query for and cache the org record.
8673: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8674: THEN
8675: IF (l_debug = 1) THEN

Line 8673: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))

8669: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8670: -- INV_CACHE
8671: IF INV_CACHE.is_pickrelease THEN
8672: -- Query for and cache the org record.
8673: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8674: THEN
8675: IF (l_debug = 1) THEN
8676: debug_print('Error caching the org record');
8677: END IF;

Line 8681: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;

8677: END IF;
8678: RAISE fnd_api.g_exc_unexpected_error;
8679: END IF;
8680: -- Set the PJM enabled flag.
8681: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;
8682: ELSE
8683:
8684: BEGIN
8685: SELECT project_reference_enabled

Line 9819: IF INV_CACHE.is_pickrelease THEN

9815:
9816: -- Use cache to get value for l_debug
9817: IF g_is_pickrelease_set IS NULL THEN
9818: g_is_pickrelease_set := 2;
9819: IF INV_CACHE.is_pickrelease THEN
9820: g_is_pickrelease_set := 1;
9821: END IF;
9822: END IF;
9823: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 10033: IF INV_CACHE.is_pickrelease THEN

10029:
10030: -- Use cache to get value for l_debug
10031: IF g_is_pickrelease_set IS NULL THEN
10032: g_is_pickrelease_set := 2;
10033: IF INV_CACHE.is_pickrelease THEN
10034: g_is_pickrelease_set := 1;
10035: END IF;
10036: END IF;
10037: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 11867: IF INV_CACHE.is_pickrelease THEN

11863: --
11864: -- Use cache to get value for l_debug
11865: IF g_is_pickrelease_set IS NULL THEN
11866: g_is_pickrelease_set := 2;
11867: IF INV_CACHE.is_pickrelease THEN
11868: g_is_pickrelease_set := 1;
11869: END IF;
11870: END IF;
11871: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 12629: IF INV_CACHE.is_pickrelease THEN

12625: BEGIN
12626: -- Use cache to get value for l_debug
12627: IF g_is_pickrelease_set IS NULL THEN
12628: g_is_pickrelease_set := 2;
12629: IF INV_CACHE.is_pickrelease THEN
12630: g_is_pickrelease_set := 1;
12631: END IF;
12632: END IF;
12633: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 13004: IF INV_CACHE.is_pickrelease THEN

13000:
13001: -- Use cache to get value for l_debug
13002: IF g_is_pickrelease_set IS NULL THEN
13003: g_is_pickrelease_set := 2;
13004: IF INV_CACHE.is_pickrelease THEN
13005: g_is_pickrelease_set := 1;
13006: END IF;
13007: END IF;
13008: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 13235: IF INV_CACHE.is_pickrelease THEN

13231: BEGIN
13232: -- Use cache to get value for l_debug
13233: IF g_is_pickrelease_set IS NULL THEN
13234: g_is_pickrelease_set := 2;
13235: IF INV_CACHE.is_pickrelease THEN
13236: g_is_pickrelease_set := 1;
13237: END IF;
13238: END IF;
13239: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 13534: -- from INV_CACHE.

13530: debug_print('Before Rsv rec project id: ' || l_to_rsv_rec.project_id);
13531: debug_print('Before Rsv rec task id: ' || l_to_rsv_rec.task_id);
13532: END IF;
13533: -- Bug : 5264987 : For Pick Release seeting the l_pjm_enabled flag
13534: -- from INV_CACHE.
13535: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
13536: debug_print ('is_pickrelaese is true');
13537: -- Query for and cache the org record.
13538: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))

Line 13535: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN

13531: debug_print('Before Rsv rec task id: ' || l_to_rsv_rec.task_id);
13532: END IF;
13533: -- Bug : 5264987 : For Pick Release seeting the l_pjm_enabled flag
13534: -- from INV_CACHE.
13535: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
13536: debug_print ('is_pickrelaese is true');
13537: -- Query for and cache the org record.
13538: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))
13539: THEN

Line 13538: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))

13534: -- from INV_CACHE.
13535: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
13536: debug_print ('is_pickrelaese is true');
13537: -- Query for and cache the org record.
13538: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))
13539: THEN
13540: IF (l_debug = 1) THEN
13541: debug_print('Error caching the org record');
13542: END IF;

Line 13546: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;

13542: END IF;
13543: RAISE fnd_api.g_exc_unexpected_error;
13544: END IF;
13545: -- Set the PJM enabled flag.
13546: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;
13547: ELSE
13548: debug_print ('is_pickrelaese is not true');
13549: BEGIN
13550: SELECT project_reference_enabled

Line 17536: IF INV_CACHE.is_pickrelease THEN

17532:
17533: -- Use cache to get value for l_debug
17534: IF g_is_pickrelease_set IS NULL THEN
17535: g_is_pickrelease_set := 2;
17536: IF INV_CACHE.is_pickrelease THEN
17537: g_is_pickrelease_set := 1;
17538: END IF;
17539: END IF;
17540: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 17561: IF inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) THEN

17557: l_primary_uom_code :=NULL;
17558:
17559: IF p_organization_id IS NOT NULL AND p_inventory_item_id IS NOT NULL THEN
17560: BEGIN
17561: IF inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) THEN
17562: l_primary_uom_code := inv_cache.item_rec.primary_uom_code;
17563: IF (l_debug = 1) THEN
17564: debug_print('l_primary_uom_code='||l_primary_uom_code);
17565: END IF;

Line 17562: l_primary_uom_code := inv_cache.item_rec.primary_uom_code;

17558:
17559: IF p_organization_id IS NOT NULL AND p_inventory_item_id IS NOT NULL THEN
17560: BEGIN
17561: IF inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) THEN
17562: l_primary_uom_code := inv_cache.item_rec.primary_uom_code;
17563: IF (l_debug = 1) THEN
17564: debug_print('l_primary_uom_code='||l_primary_uom_code);
17565: END IF;
17566: END IF;

Line 17909: IF INV_CACHE.is_pickrelease THEN

17905: SAVEPOINT transfer_lpn_trx_reservation;
17906: -- Use cache to get value for l_debug
17907: IF g_is_pickrelease_set IS NULL THEN
17908: g_is_pickrelease_set := 2;
17909: IF INV_CACHE.is_pickrelease THEN
17910: g_is_pickrelease_set := 1;
17911: END IF;
17912: END IF;
17913: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 18372: IF INV_CACHE.is_pickrelease THEN

18368:
18369: -- Use cache to get value for l_debug
18370: IF g_is_pickrelease_set IS NULL THEN
18371: g_is_pickrelease_set := 2;
18372: IF INV_CACHE.is_pickrelease THEN
18373: g_is_pickrelease_set := 1;
18374: END IF;
18375: END IF;
18376: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN