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.

[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on FND_PROFILE

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

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

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

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

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

107: l_requested_qty2 NUMBER := 0;
108: BEGIN
109:
110: IF (g_debug IS NULL) THEN
111: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
112: END IF;
113:
114: l_debug := g_debug;
115:

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

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

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

405: l_reservable_qty NUMBER;
406: BEGIN
407:
408: IF (g_debug IS NULL) THEN
409: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
410: END IF;
411:
412: l_debug := g_debug;
413:

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

554: l_requested_qty2 NUMBER;
555: BEGIN
556:
557: IF (g_debug IS NULL) THEN
558: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
559: END IF;
560:
561: l_debug := g_debug;
562:

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

802: l_line_rec_ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE;
803: BEGIN
804:
805: IF (g_debug IS NULL) THEN
806: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
807: END IF;
808:
809: l_debug := g_debug;
810:

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

1896: l_fulfill_base VARCHAR2(1) := 'P';
1897: BEGIN
1898:
1899: IF (g_debug is NULL) THEN
1900: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1901: END IF;
1902:
1903: l_debug := g_debug;
1904:

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

2478: -- return true if the given index points to an item record
2479: -- in the cache which has a dual UOM control as true
2480: FUNCTION is_dual_control(p_item_cache_index IN INTEGER)
2481: RETURN BOOLEAN IS
2482: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2483: BEGIN
2484: IF inv_reservation_global.g_item_record_cache(p_item_cache_index).tracking_quantity_ind <> 'PS' THEN
2485: RETURN FALSE;
2486: ELSE

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

2496: RETURN BOOLEAN IS
2497: l_debug number;
2498: BEGIN
2499: IF (g_debug IS NULL) THEN
2500: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2501: END IF;
2502:
2503: l_debug := g_debug;
2504:

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

2530: l_lot_control_code NUMBER;
2531: BEGIN
2532:
2533: IF (g_debug IS NULL) THEN
2534: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2535: END IF;
2536:
2537: l_debug := g_debug;
2538:

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

2592: l_api_name CONSTANT VARCHAR2(30) := 'Get_WIP_Entity_Type';
2593:
2594: BEGIN
2595: IF (g_debug IS NULL) THEN
2596: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2597: END IF;
2598:
2599: l_debug := g_debug;
2600:

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

2683: l_update_count NUMBER := 0;
2684: l_debug NUMBER;
2685: BEGIN
2686: IF (g_debug is NULL) THEN
2687: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2688: END IF;
2689:
2690: l_debug := g_debug;
2691:

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

2739: l_debug NUMBER;
2740: l_index NUMBER := 0;
2741: BEGIN
2742: IF (g_debug is NULL) THEN
2743: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2744: END IF;
2745:
2746: l_debug := g_debug;
2747:

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

2889: FROM mtl_reservations
2890: WHERE reservation_id = p_reservation_id;
2891: BEGIN
2892: IF (g_debug is NULL) THEN
2893: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2894: END IF;
2895:
2896: l_debug := g_debug;
2897:

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

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
3021: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3022: END IF;
3023:
3024: l_debug := g_debug;
3025:

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

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
3326: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3327: END IF;
3328:
3329: l_debug := g_debug;
3330:

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

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
4756: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4757: END IF;
4758:
4759: l_debug := g_debug;
4760:

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

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
8157: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8158: END IF;
8159:
8160: l_debug := g_debug;
8161:

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

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
9824: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9825: END IF;
9826:
9827: l_debug := g_debug;
9828:

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

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
10038: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10039: END IF;
10040:
10041: l_debug := g_debug;
10042:

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

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
11872: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11873: END IF;
11874:
11875: l_debug := g_debug;
11876:

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

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
12634: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12635: END IF;
12636:
12637: l_debug := g_debug;
12638: IF (l_debug = 1) THEN

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

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
13009: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13010: END IF;
13011:
13012: l_debug := g_debug;
13013:

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

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
13240: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13241: END IF;
13242:
13243: l_debug := g_debug;
13244: IF (l_debug = 1) THEN

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

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
17541: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17542: END IF;
17543:
17544: l_debug := g_debug;
17545:

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

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

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

18143: l_api_name VARCHAR2(100) := 'Insert_rsv_temp';
18144: x_msg_count NUMBER;
18145: x_msg_data VARCHAR2(1000);
18146: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
18147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18148: BEGIN
18149: INSERT INTO rsv_temp
18150: (
18151: p_organization_id

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

18215: l_demand_source_name VARCHAR2(1000);
18216: l_organization_id NUMBER;
18217: l_inventory_item_id NUMBER;
18218:
18219: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18220:
18221: -- Bug 3926414, added order by clause to avoid deadlock.
18222: CURSOR tree_csr IS
18223: SELECT p_tree_id

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

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
18377: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18378: END IF;
18379:
18380: l_debug := g_debug;
18381:

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

18578: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
18579:
18580: BEGIN
18581: IF (g_debug IS NULL) THEN
18582: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18583: END IF;
18584:
18585: l_debug := g_debug;
18586: