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.WMS_WAVEPLAN_TASKS_PVT dependencies on FND_PROFILE

Line 92: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

88: END;
89:
90: PROCEDURE wwtt_dump
91: IS
92: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
93: CURSOR cur_wwtt
94: IS
95: SELECT transaction_temp_id, task_id, is_modified, status_id,
96: status_id_original, person_id, person_id_original, priority,

Line 169: fnd_profile.get ('USER_ID', l_user_id);

165:
166: visible_columns visible_columns_type;
167: l_user_id NUMBER;
168: BEGIN
169: fnd_profile.get ('USER_ID', l_user_id);
170:
171: SELECT NVL (jcgc.visible_flag, jgc.visible_flag)
172: BULK COLLECT INTO visible_columns
173: FROM jtf_grid_cols_b jgc, jtf_custom_grid_cols jcgc

Line 473: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

469: -- bug 11705135 START
470: PROCEDURE set_num_of_cc_child_tasks
471: IS
472: l_debug NUMBER
473: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
474: l_progress NUMBER;
475: l_count_same_sku_cc_tasks NUMBER := 0;
476:
477: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;

Line 561: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

557: --associated with parent tasks
558: PROCEDURE set_num_of_child_tasks
559: IS
560: l_debug NUMBER
561: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
562: l_progress NUMBER;
563:
564: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;
565:

Line 963: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

959: RETURN VARCHAR2
960: IS
961: l_select_generic VARCHAR2 (4000);
962: l_join_wdt BOOLEAN;
963: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
964: BEGIN
965: IF l_debug = 1 then
966: Debug(' Entered into get_generic_select ' || i );
967: end if;

Line 2422: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2418: )
2419: RETURN VARCHAR2
2420: IS
2421: l_where_generic VARCHAR2 (4000);
2422: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2423: --R12: Additional Query criteria
2424: --Age UOM conversion factor
2425: n VARCHAR2 (10);
2426: BEGIN

Line 4274: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

4270: --Age UOM conversion factor
4271: n VARCHAR2 (10);
4272:
4273: l_debug NUMBER
4274: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4275:
4276: BEGIN
4277:
4278: if (p_from_sales_order_id = p_to_sales_order_id) then

Line 6657: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

6653: l_is_picknone BOOLEAN; --ER13869750
6654: l_wms_task_type NUMBER; -- for bug 5129375
6655: l_task_count NUMBER;
6656: l_debug NUMBER
6657: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
6658: BEGIN
6659: /* Commented for --ER13869750 starts
6660: IF p_is_completed THEN
6661: --Bug 3627575:Setting the variable to true for Inbound queries

Line 7994: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

7990: --R12: Additional Query criteria
7991: --Age UOM conversion factor
7992: n VARCHAR2 (10);
7993: l_debug NUMBER
7994: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
7995: BEGIN
7996: -- Cycle tasks currently cannot have priorities, quantities or dest sub/loc. If user wants to
7997: -- query up tasks with certain priorities, quantities or dest sub/loc, we should not
7998: -- query cycle count tasks.

Line 9070: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

9066: l_is_picknone BOOLEAN; --ER13869750
9067: l_wms_task_type NUMBER; -- for bug 5129375
9068: l_task_count NUMBER;
9069: l_debug NUMBER
9070: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9071: BEGIN
9072: /* Commented for ER13869750-Starts
9073: IF p_is_completed THEN
9074: --Bug 3627575:Setting the variable to true for Inbound queries

Line 9727: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

9723: l_is_active BOOLEAN;
9724: l_is_loaded BOOLEAN;
9725: l_is_completed BOOLEAN;
9726: l_is_picknone BOOLEAN; --ER13869750
9727: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9728:
9729: BEGIN
9730: /* Commented for ER13869750 --Starts
9731: IF p_is_completed THEN

Line 10290: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

10286: )
10287: IS
10288: l_parent_inserted NUMBER := 0;
10289: l_is_pending BOOLEAN := p_is_pending;
10290: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10291: BEGIN
10292: x_return_status := 'S';
10293: g_is_api_call := p_is_api_call;--Bug 13594691
10294:

Line 10983: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

10979: IS
10980: l_task_id NUMBER;
10981: l_index NUMBER;
10982: l_message wms_waveplan_tasks_temp.error%TYPE;
10983: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10984:
10985: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
10986:
10987: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line 11603: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

11599: l_update_date DATE;
11600: l_non_cycle_count_number NUMBER := 0;
11601: l_cycle_count_number NUMBER := 0;
11602: l_children_task_count NUMBER := 0;
11603: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
11604:
11605: CURSOR cur_wwtt
11606: IS
11607: SELECT transaction_temp_id, task_type_id, mmtt_last_updated_by,

Line 12691: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

12687: l_msg_data VARCHAR2 (2000);
12688: l_msg_count NUMBER;
12689: l_error_code NUMBER;
12690: l_cancel_plan BOOLEAN;
12691: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
12692: BEGIN
12693:
12694: FOR i IN 1 .. p_transaction_temp_table.COUNT
12695: LOOP