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 FND_PROFILE

Line 22: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

18: -- disable by default since dbm_s_output.put_line is not allowed
19: PROCEDURE debug_print(p_message IN VARCHAR2, p_level IN NUMBER := 9) IS
20: --Bug: 3559328: Performance bug fix.The fnd call happens everytime
21: -- debug_print is called.
22: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
23: BEGIN
24: inv_log_util.TRACE(p_message, 'INV_RESERVATION_PVT', p_level);
25: END debug_print;
26:

Line 44: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
44: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
45: END IF;
46:
47: l_debug := g_debug;
48: IF (l_debug = 1) THEN

Line 107: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

103: l_requested_qty NUMBER := 0;
104: BEGIN
105:
106: IF (g_debug IS NULL) THEN
107: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
108: END IF;
109:
110: l_debug := g_debug;
111:

Line 222: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

218: l_reservable_qty NUMBER;
219: BEGIN
220:
221: IF (g_debug IS NULL) THEN
222: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
223: END IF;
224:
225: l_debug := g_debug;
226:

Line 362: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

358: l_reservation_margin_above NUMBER;
359: BEGIN
360:
361: IF (g_debug IS NULL) THEN
362: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
363: END IF;
364:
365: l_debug := g_debug;
366:

Line 565: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

561: l_ordered_quantity_primary_uom NUMBER;
562: BEGIN
563:
564: IF (g_debug IS NULL) THEN
565: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
566: END IF;
567:
568: l_debug := g_debug;
569:

Line 2133: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2129: -- return true if the given index points to an item record
2130: -- in the cache which has a dual UOM control as true
2131: FUNCTION is_dual_control(p_item_cache_index IN INTEGER)
2132: RETURN BOOLEAN IS
2133: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2134: BEGIN
2135: IF inv_reservation_global.g_item_record_cache(p_item_cache_index).tracking_quantity_ind <> 'PS' THEN
2136: RETURN FALSE;
2137: ELSE

Line 2151: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2147: RETURN BOOLEAN IS
2148: l_debug number;
2149: BEGIN
2150: IF (g_debug IS NULL) THEN
2151: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2152: END IF;
2153:
2154: l_debug := g_debug;
2155:

Line 2185: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2181: l_lot_control_code NUMBER;
2182: BEGIN
2183:
2184: IF (g_debug IS NULL) THEN
2185: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2186: END IF;
2187:
2188: l_debug := g_debug;
2189:

Line 2247: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2243: l_api_name CONSTANT VARCHAR2(30) := 'Get_WIP_Entity_Type';
2244:
2245: BEGIN
2246: IF (g_debug IS NULL) THEN
2247: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2248: END IF;
2249:
2250: l_debug := g_debug;
2251:

Line 2338: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2334: l_update_count NUMBER := 0;
2335: l_debug NUMBER;
2336: BEGIN
2337: IF (g_debug is NULL) THEN
2338: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2339: END IF;
2340:
2341: l_debug := g_debug;
2342:

Line 2394: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2390: l_debug NUMBER;
2391: l_index NUMBER := 0;
2392: BEGIN
2393: IF (g_debug is NULL) THEN
2394: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2395: END IF;
2396:
2397: l_debug := g_debug;
2398:

Line 2544: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2540: FROM mtl_reservations
2541: WHERE reservation_id = p_reservation_id;
2542: BEGIN
2543: IF (g_debug is NULL) THEN
2544: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2545: END IF;
2546:
2547: l_debug := g_debug;
2548:

Line 2667: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
2667: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2668: END IF;
2669:
2670: l_debug := g_debug;
2671:

Line 2939: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
2939: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2940: END IF;
2941:
2942: l_debug := g_debug;
2943:

Line 4369: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
4369: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4370: END IF;
4371:
4372: l_debug := g_debug;
4373:

Line 7740: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
7740: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7741: END IF;
7742:
7743: l_debug := g_debug;
7744:

Line 9264: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
9264: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9265: END IF;
9266:
9267: l_debug := g_debug;
9268:

Line 9457: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
9457: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9458: END IF;
9459:
9460: l_debug := g_debug;
9461:

Line 11108: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
11108: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11109: END IF;
11110:
11111: l_debug := g_debug;
11112:

Line 11867: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
11867: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11868: END IF;
11869:
11870: l_debug := g_debug;
11871: IF (l_debug = 1) THEN

Line 12238: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
12238: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12239: END IF;
12240:
12241: l_debug := g_debug;
12242:

Line 12444: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
12444: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12445: END IF;
12446:
12447: l_debug := g_debug;
12448: IF (l_debug = 1) THEN

Line 16409: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
16409: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16410: END IF;
16411:
16412: l_debug := g_debug;
16413:

Line 16747: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
16747: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16748: END IF; -- Use cache to get value for l_debug
16749:
16750: l_debug := g_debug;
16751: -- If p_lpn_id parameter has been popluated, then transfer is a consolidation

Line 16979: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

16975: l_api_name VARCHAR2(100) := 'Insert_rsv_temp';
16976: x_msg_count NUMBER;
16977: x_msg_data VARCHAR2(1000);
16978: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
16979: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16980: BEGIN
16981: INSERT INTO rsv_temp
16982: (
16983: p_organization_id

Line 17051: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

17047: l_demand_source_name VARCHAR2(1000);
17048: l_organization_id NUMBER;
17049: l_inventory_item_id NUMBER;
17050:
17051: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17052:
17053: -- Bug 3926414, added order by clause to avoid deadlock.
17054: CURSOR tree_csr IS
17055: SELECT p_tree_id

Line 17209: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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
17209: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17210: END IF;
17211:
17212: l_debug := g_debug;
17213:

Line 17414: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

17410: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
17411:
17412: BEGIN
17413: IF (g_debug IS NULL) THEN
17414: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17415: END IF;
17416:
17417: l_debug := g_debug;
17418: