DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on INV_CACHE

Line 39: IF INV_CACHE.is_pickrelease THEN

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

Line 2662: IF INV_CACHE.is_pickrelease THEN

2658: BEGIN
2659: -- Use cache to get value for l_debug
2660: IF g_is_pickrelease_set IS NULL THEN
2661: g_is_pickrelease_set := 2;
2662: IF INV_CACHE.is_pickrelease THEN
2663: g_is_pickrelease_set := 1;
2664: END IF;
2665: END IF;
2666: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 2934: IF INV_CACHE.is_pickrelease THEN

2930: BEGIN
2931: -- Use cache to get value for l_debug
2932: IF g_is_pickrelease_set IS NULL THEN
2933: g_is_pickrelease_set := 2;
2934: IF INV_CACHE.is_pickrelease THEN
2935: g_is_pickrelease_set := 1;
2936: END IF;
2937: END IF;
2938: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 4364: IF INV_CACHE.is_pickrelease THEN

4360:
4361: -- Use cache to get value for l_debug
4362: IF g_is_pickrelease_set IS NULL THEN
4363: g_is_pickrelease_set := 2;
4364: IF INV_CACHE.is_pickrelease THEN
4365: g_is_pickrelease_set := 1;
4366: END IF;
4367: END IF;
4368: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 7735: IF INV_CACHE.is_pickrelease THEN

7731: BEGIN
7732: -- Use cache to get value for l_debug
7733: IF g_is_pickrelease_set IS NULL THEN
7734: g_is_pickrelease_set := 2;
7735: IF INV_CACHE.is_pickrelease THEN
7736: g_is_pickrelease_set := 1;
7737: END IF;
7738: END IF;
7739: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 8250: -- INV_CACHE

8246: debug_print('Before Rsv rec project id: ' || l_rsv_rec.project_id);
8247: debug_print('Before Rsv rec task id: ' || l_rsv_rec.task_id);
8248: END IF;
8249: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8250: -- INV_CACHE
8251: IF INV_CACHE.is_pickrelease THEN
8252: -- Query for and cache the org record.
8253: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8254: THEN

Line 8251: IF INV_CACHE.is_pickrelease THEN

8247: debug_print('Before Rsv rec task id: ' || l_rsv_rec.task_id);
8248: END IF;
8249: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8250: -- INV_CACHE
8251: IF INV_CACHE.is_pickrelease THEN
8252: -- Query for and cache the org record.
8253: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8254: THEN
8255: IF (l_debug = 1) THEN

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

8249: -- Bug : 5264987 : For pick release getting the l_pjm_enabled flag
8250: -- INV_CACHE
8251: IF INV_CACHE.is_pickrelease THEN
8252: -- Query for and cache the org record.
8253: IF (NOT INV_CACHE.set_org_rec(l_rsv_rec.organization_id))
8254: THEN
8255: IF (l_debug = 1) THEN
8256: debug_print('Error caching the org record');
8257: END IF;

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

8257: END IF;
8258: RAISE fnd_api.g_exc_unexpected_error;
8259: END IF;
8260: -- Set the PJM enabled flag.
8261: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;
8262: ELSE
8263:
8264: BEGIN
8265: SELECT project_reference_enabled

Line 9259: IF INV_CACHE.is_pickrelease THEN

9255:
9256: -- Use cache to get value for l_debug
9257: IF g_is_pickrelease_set IS NULL THEN
9258: g_is_pickrelease_set := 2;
9259: IF INV_CACHE.is_pickrelease THEN
9260: g_is_pickrelease_set := 1;
9261: END IF;
9262: END IF;
9263: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 9452: IF INV_CACHE.is_pickrelease THEN

9448:
9449: -- Use cache to get value for l_debug
9450: IF g_is_pickrelease_set IS NULL THEN
9451: g_is_pickrelease_set := 2;
9452: IF INV_CACHE.is_pickrelease THEN
9453: g_is_pickrelease_set := 1;
9454: END IF;
9455: END IF;
9456: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 11103: IF INV_CACHE.is_pickrelease THEN

11099: --
11100: -- Use cache to get value for l_debug
11101: IF g_is_pickrelease_set IS NULL THEN
11102: g_is_pickrelease_set := 2;
11103: IF INV_CACHE.is_pickrelease THEN
11104: g_is_pickrelease_set := 1;
11105: END IF;
11106: END IF;
11107: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 11862: IF INV_CACHE.is_pickrelease THEN

11858: BEGIN
11859: -- Use cache to get value for l_debug
11860: IF g_is_pickrelease_set IS NULL THEN
11861: g_is_pickrelease_set := 2;
11862: IF INV_CACHE.is_pickrelease THEN
11863: g_is_pickrelease_set := 1;
11864: END IF;
11865: END IF;
11866: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 12233: IF INV_CACHE.is_pickrelease THEN

12229:
12230: -- Use cache to get value for l_debug
12231: IF g_is_pickrelease_set IS NULL THEN
12232: g_is_pickrelease_set := 2;
12233: IF INV_CACHE.is_pickrelease THEN
12234: g_is_pickrelease_set := 1;
12235: END IF;
12236: END IF;
12237: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 12439: IF INV_CACHE.is_pickrelease THEN

12435: BEGIN
12436: -- Use cache to get value for l_debug
12437: IF g_is_pickrelease_set IS NULL THEN
12438: g_is_pickrelease_set := 2;
12439: IF INV_CACHE.is_pickrelease THEN
12440: g_is_pickrelease_set := 1;
12441: END IF;
12442: END IF;
12443: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 12738: -- from INV_CACHE.

12734: debug_print('Before Rsv rec project id: ' || l_to_rsv_rec.project_id);
12735: debug_print('Before Rsv rec task id: ' || l_to_rsv_rec.task_id);
12736: END IF;
12737: -- Bug : 5264987 : For Pick Release seeting the l_pjm_enabled flag
12738: -- from INV_CACHE.
12739: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
12740: debug_print ('is_pickrelaese is true');
12741: -- Query for and cache the org record.
12742: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))

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

12735: debug_print('Before Rsv rec task id: ' || l_to_rsv_rec.task_id);
12736: END IF;
12737: -- Bug : 5264987 : For Pick Release seeting the l_pjm_enabled flag
12738: -- from INV_CACHE.
12739: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
12740: debug_print ('is_pickrelaese is true');
12741: -- Query for and cache the org record.
12742: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))
12743: THEN

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

12738: -- from INV_CACHE.
12739: IF INV_CACHE.is_pickrelease OR g_is_pickrelease_set = 1 THEN
12740: debug_print ('is_pickrelaese is true');
12741: -- Query for and cache the org record.
12742: IF (NOT INV_CACHE.set_org_rec(l_to_rsv_rec.organization_id))
12743: THEN
12744: IF (l_debug = 1) THEN
12745: debug_print('Error caching the org record');
12746: END IF;

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

12746: END IF;
12747: RAISE fnd_api.g_exc_unexpected_error;
12748: END IF;
12749: -- Set the PJM enabled flag.
12750: l_pjm_enabled := INV_CACHE.org_rec.project_reference_enabled;
12751: ELSE
12752: debug_print ('is_pickrelaese is not true');
12753: BEGIN
12754: SELECT project_reference_enabled

Line 16404: IF INV_CACHE.is_pickrelease THEN

16400:
16401: -- Use cache to get value for l_debug
16402: IF g_is_pickrelease_set IS NULL THEN
16403: g_is_pickrelease_set := 2;
16404: IF INV_CACHE.is_pickrelease THEN
16405: g_is_pickrelease_set := 1;
16406: END IF;
16407: END IF;
16408: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 16742: IF INV_CACHE.is_pickrelease THEN

16738: SAVEPOINT transfer_lpn_trx_reservation;
16739: -- Use cache to get value for l_debug
16740: IF g_is_pickrelease_set IS NULL THEN
16741: g_is_pickrelease_set := 2;
16742: IF INV_CACHE.is_pickrelease THEN
16743: g_is_pickrelease_set := 1;
16744: END IF;
16745: END IF;
16746: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 17204: IF INV_CACHE.is_pickrelease THEN

17200:
17201: -- Use cache to get value for l_debug
17202: IF g_is_pickrelease_set IS NULL THEN
17203: g_is_pickrelease_set := 2;
17204: IF INV_CACHE.is_pickrelease THEN
17205: g_is_pickrelease_set := 1;
17206: END IF;
17207: END IF;
17208: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN