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_PLAN_TASKS_PVT dependencies on FND_PROFILE

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

175: l_to_tonum_mso_seg1 VARCHAR2(40);
176: l_from_mso_seg2 VARCHAR2(150);
177: l_to_mso_seg2 VARCHAR2(150);
178: l_from_mso_seg1 VARCHAR2(40);
179: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
180:
181: CURSOR upd_op_seq IS
182: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
183: FROM

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

919: l_wdth_from_str VARCHAR2(3000);
920: l_wdth_where_str VARCHAR2(3000);
921:
922: l_inline_query VARCHAR2(500);
923: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
924: BEGIN
925: IF l_debug = 1 THEN
926: debug('in get_plans ','get_plans');
927: END IF;

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

1471:
1472: l_is_pending boolean;
1473: l_is_loaded boolean;
1474: l_is_completed boolean;
1475: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1476: BEGIN
1477: IF l_debug = 1 THEN
1478: debug('in get_tasks ', 'get_tasks');
1479: END IF;

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

2192: x_wdth_where_str OUT NOCOPY varchar2) is
2193: l_wdth_select_str wms_plan_tasks_pvt.short_sql:= NULL;
2194: l_wdth_from_str wms_plan_tasks_pvt.short_sql:= NULL;
2195: l_wdth_where_str wms_plan_tasks_pvt.short_sql:= NULL;
2196: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2197:
2198: begin
2199: /**** First build the Select string ****/
2200: IF l_debug = 1 THEN

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

2694: , p_plan_type_id NUMBER DEFAULT NULL
2695: , p_op_plan_id NUMBER DEFAULT NULL) IS
2696:
2697: l_module_name CONSTANT VARCHAR2(20) := 'set_globals';
2698: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2699:
2700: BEGIN
2701: IF l_debug = 1 THEN
2702: debug(' in set_globals ','set_globals');

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

2901: ,p_is_completed_rec IN NUMBER) IS
2902: l_inbound_select wms_plan_tasks_pvt.short_sql;
2903: l_inbound_from wms_plan_tasks_pvt.short_sql;
2904: l_inbound_where VARCHAR2(5000);
2905: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2906:
2907: BEGIN
2908: /**** Inbound specific queries ****/
2909: --

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

3160: --l_inbound_select wms_plan_tasks_pvt.short_sql;
3161: l_from_outbound wms_plan_tasks_pvt.short_sql;
3162: l_where_outbound wms_plan_tasks_pvt.short_sql;
3163: l_is_range_so BOOLEAN;
3164: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3165:
3166: BEGIN
3167: /**** Outbound specific queries ****/
3168: IF l_debug = 1 THEN

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

3566: l_wdth_str VARCHAR2(6000);
3567: l_wdth_select_str wms_plan_tasks_pvt.short_sql;
3568: l_wdth_from_str VARCHAR2(500);
3569: l_wdth_where_str wms_plan_tasks_pvt.short_sql;
3570: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3571: BEGIN
3572: IF l_debug = 1 THEN
3573: debug(' in get_wdth_plan_records','get_wdth_plan_records');
3574: END IF;

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

3963:
3964: PROCEDURE clear_globals IS
3965:
3966: l_module_name CONSTANT VARCHAR2(20) := 'clear_globals';
3967: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3968: BEGIN
3969: IF l_debug = 1 THEN
3970: debug(' in clear_globals ',l_module_name);
3971: END IF;