APPS.WMS_PLAN_TASKS_PVT dependencies on FND_PROFILE

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

199: l_to_tonum_mso_seg1 VARCHAR2(40);
200: l_from_mso_seg2 VARCHAR2(150);
201: l_to_mso_seg2 VARCHAR2(150);
202: l_from_mso_seg1 VARCHAR2(40);
203: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
204:
205: CURSOR upd_op_seq IS
206: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
207: FROM

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

943: l_wdth_from_str VARCHAR2(3000);
944: l_wdth_where_str VARCHAR2(3000);
945:
946: l_inline_query VARCHAR2(500);
947: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
948: BEGIN
949: IF l_debug = 1 THEN
950: debug('in get_plans ','get_plans');
951: END IF;

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

1496:
1497: l_is_pending boolean;
1498: l_is_loaded boolean;
1499: l_is_completed boolean;
1500: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1501: BEGIN
1502: IF l_debug = 1 THEN
1503: debug('in get_tasks ', 'get_tasks');
1504: END IF;

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

2221: x_wdth_where_str OUT NOCOPY varchar2) is
2222: l_wdth_select_str wms_plan_tasks_pvt.short_sql:= NULL;
2223: l_wdth_from_str wms_plan_tasks_pvt.short_sql:= NULL;
2224: l_wdth_where_str wms_plan_tasks_pvt.short_sql:= NULL;
2225: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2226:
2227: begin
2228: /**** First build the Select string ****/
2229: IF l_debug = 1 THEN

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

2743: , p_op_plan_id NUMBER DEFAULT NULL
2744: , p_is_picknone_task BOOLEAN DEFAULT FALSE ) IS --ER13869750
2745:
2746: l_module_name CONSTANT VARCHAR2(20) := 'set_globals';
2747: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2748:
2749: BEGIN
2750: IF l_debug = 1 THEN
2751: debug(' in set_globals ','set_globals');

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

2951: ,p_is_completed_rec IN NUMBER) IS
2952: l_inbound_select wms_plan_tasks_pvt.short_sql;
2953: l_inbound_from wms_plan_tasks_pvt.short_sql;
2954: l_inbound_where VARCHAR2(5000);
2955: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2956: L_MOVER_ORDER_LINE VARCHAR2(5000); --code for Bug#8467334
2957: --Hardik LSP bug 9274233
2958: l_from_client_code VARCHAR2(30);
2959: l_delimiter VARCHAR2(1);

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

3269: --l_inbound_select wms_plan_tasks_pvt.short_sql;
3270: l_from_outbound wms_plan_tasks_pvt.short_sql;
3271: l_where_outbound wms_plan_tasks_pvt.short_sql;
3272: l_is_range_so BOOLEAN;
3273: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3274:
3275: BEGIN
3276: /**** Outbound specific queries ****/
3277: IF l_debug = 1 THEN

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

3675: l_wdth_str VARCHAR2(6000);
3676: l_wdth_select_str wms_plan_tasks_pvt.short_sql;
3677: l_wdth_from_str VARCHAR2(500);
3678: l_wdth_where_str wms_plan_tasks_pvt.short_sql;
3679: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3680: BEGIN
3681: IF l_debug = 1 THEN
3682: debug(' in get_wdth_plan_records','get_wdth_plan_records');
3683: END IF;

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

4073:
4074: PROCEDURE clear_globals IS
4075:
4076: l_module_name CONSTANT VARCHAR2(20) := 'clear_globals';
4077: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4078: BEGIN
4079: IF l_debug = 1 THEN
4080: debug(' in clear_globals ',l_module_name);
4081: END IF;