DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on INV_CACHE

Line 308: IF INV_CACHE.is_pickrelease THEN

304:
305: -- Use cache to get value for l_debug
306: IF g_is_pickrelease_set IS NULL THEN
307: g_is_pickrelease_set := 2;
308: IF INV_CACHE.is_pickrelease THEN
309: g_is_pickrelease_set := 1;
310: END IF;
311: END IF;
312: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 571: IF INV_CACHE.is_pickrelease THEN

567: BEGIN
568: -- Use cache to get value for l_debug
569: IF g_is_pickrelease_set IS NULL THEN
570: g_is_pickrelease_set := 2;
571: IF INV_CACHE.is_pickrelease THEN
572: g_is_pickrelease_set := 1;
573: END IF;
574: END IF;
575: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 1144: IF INV_CACHE.is_pickrelease THEN

1140: BEGIN
1141: -- Use cache to get value for l_debug
1142: IF g_is_pickrelease_set IS NULL THEN
1143: g_is_pickrelease_set := 2;
1144: IF INV_CACHE.is_pickrelease THEN
1145: g_is_pickrelease_set := 1;
1146: END IF;
1147: END IF;
1148: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 1737: IF INV_CACHE.is_pickrelease THEN

1733:
1734: -- Use cache to get value for l_debug
1735: IF g_is_pickrelease_set IS NULL THEN
1736: g_is_pickrelease_set := 2;
1737: IF INV_CACHE.is_pickrelease THEN
1738: g_is_pickrelease_set := 1;
1739: END IF;
1740: END IF;
1741: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 2153: IF INV_CACHE.is_pickrelease THEN

2149: BEGIN
2150: -- Use cache to get value for l_debug
2151: IF g_is_pickrelease_set IS NULL THEN
2152: g_is_pickrelease_set := 2;
2153: IF INV_CACHE.is_pickrelease THEN
2154: g_is_pickrelease_set := 1;
2155: END IF;
2156: END IF;
2157: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 2304: IF INV_CACHE.is_pickrelease THEN

2300: BEGIN
2301: -- Use cache to get value for l_debug
2302: IF g_is_pickrelease_set IS NULL THEN
2303: g_is_pickrelease_set := 2;
2304: IF INV_CACHE.is_pickrelease THEN
2305: g_is_pickrelease_set := 1;
2306: END IF;
2307: END IF;
2308: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 2674: IF INV_CACHE.is_pickrelease THEN

2670: BEGIN
2671: -- Use cache to get value for l_debug
2672: IF g_is_pickrelease_set IS NULL THEN
2673: g_is_pickrelease_set := 2;
2674: IF INV_CACHE.is_pickrelease THEN
2675: g_is_pickrelease_set := 1;
2676: END IF;
2677: END IF;
2678: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN

Line 2843: l_return_value := INV_CACHE.set_wms_installed(l_organization_id);

2839: x_msg_data => x_msg_data,
2840: p_organization_id => l_trolin_rec.organization_id);*/
2841:
2842: l_organization_id := l_trolin_rec.organization_id;
2843: l_return_value := INV_CACHE.set_wms_installed(l_organization_id);
2844: If NOT l_return_value Then
2845: RAISE fnd_api.g_exc_unexpected_error;
2846: End If;
2847: l_wms_org_flag := INV_CACHE.wms_installed;

Line 2847: l_wms_org_flag := INV_CACHE.wms_installed;

2843: l_return_value := INV_CACHE.set_wms_installed(l_organization_id);
2844: If NOT l_return_value Then
2845: RAISE fnd_api.g_exc_unexpected_error;
2846: End If;
2847: l_wms_org_flag := INV_CACHE.wms_installed;
2848:
2849: -- End of Changes for Bug#3153166
2850:
2851: -- Cannot overpick in a WMS organization in Release I and belw.Feature enabled in J:Bug 3415741

Line 5756: DEBUG('Set tosub INV cache.', 'Finalize_Pick_confirm');

5752: l_lpn_id := NVL(l_mmtt_rec.content_lpn_id, l_mmtt_rec.transfer_lpn_id);
5753:
5754: -- bug 10094254 start
5755: IF (l_debug = 1) THEN
5756: DEBUG('Set tosub INV cache.', 'Finalize_Pick_confirm');
5757: END IF;
5758: l_set_sub_return_value := inv_cache.set_tosub_rec(l_mmtt_rec.organization_id,l_mmtt_rec.transfer_subinventory);
5759:
5760: If NOT l_set_sub_return_value Then

Line 5758: l_set_sub_return_value := inv_cache.set_tosub_rec(l_mmtt_rec.organization_id,l_mmtt_rec.transfer_subinventory);

5754: -- bug 10094254 start
5755: IF (l_debug = 1) THEN
5756: DEBUG('Set tosub INV cache.', 'Finalize_Pick_confirm');
5757: END IF;
5758: l_set_sub_return_value := inv_cache.set_tosub_rec(l_mmtt_rec.organization_id,l_mmtt_rec.transfer_subinventory);
5759:
5760: If NOT l_set_sub_return_value Then
5761: RAISE fnd_api.g_exc_unexpected_error;
5762: End If;

Line 5768: IF NVL(inv_cache.tosub_rec.lpn_controlled_flag,2) <> 1 THEN

5764: -- Check if the sub is lpn controlled
5765: IF (l_debug = 1) THEN
5766: DEBUG('Check if the sub is lpn controlled.', 'Finalize_Pick_confirm');
5767: END IF;
5768: IF NVL(inv_cache.tosub_rec.lpn_controlled_flag,2) <> 1 THEN
5769: IF (l_debug = 1) THEN
5770: DEBUG('Xfer sub is not LPN controlled.', 'Finalize_Pick_confirm');
5771: END IF;
5772: l_lpn_id := NULL;

Line 6671: IF INV_CACHE.is_pickrelease THEN

6667:
6668: -- Use cache to get value for l_debug
6669: IF g_is_pickrelease_set IS NULL THEN
6670: g_is_pickrelease_set := 2;
6671: IF INV_CACHE.is_pickrelease THEN
6672: g_is_pickrelease_set := 1;
6673: END IF;
6674: END IF;
6675: IF (g_is_pickrelease_set <> 1) OR (g_debug IS NULL) THEN