APPS.WMS_CARTNZN_PUB dependencies on FND_PROFILE

Line 3420: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');

3416:
3417: x_return_status := fnd_api.g_ret_sts_success;
3418:
3419: --setting the global variable for trace
3420: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
3421:
3422: log_event('G_CURRENT_RELEASE_LEVEL : '||G_CURRENT_RELEASE_LEVEL);
3423:
3424: if (g_trace_on = 1) then

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

5279: IS
5280:
5281: l_module VARCHAR2(255);
5282: l_mesg VARCHAR2(255);
5283: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5284: BEGIN
5285:
5286: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5287:

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

5312: mlid NUMBER;
5313: v_qty_per_cont NUMBER;
5314: v_container_item_id NUMBER;
5315: v_return_status VARCHAR2(300);
5316: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5317: BEGIN
5318: /*mlid := 1;
5319: table_name := 'WMS_CARTONIZATION_TEMP';
5320: mlid := do_cartonization(mohdrid =>5388, trxhdrid =>3243813, outbound => 'N', sublvlctrl =>'1');

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

5674: wdrData wdr_row;
5675: l_device_id NUMBER;
5676: l_qty NUMBER;
5677: l_count NUMBER;
5678: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5679: BEGIN
5680: error_code := 'INS_WCT_ROWS_TO_MMTT';
5681: if (g_trace_on = 1) then log_event(' Entered insert wct rows to mmtt'||p_m_o_h_id); END IF;
5682: -- Initialize API return status to success

Line 5843: g_trace_on number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5839:
5840: log_flag VARCHAR2(1) := 'Y';
5841: --Bug 3319754 changes. Also made change so that get_log_flag
5842: --returns 'Y' irrespective of level
5843: g_trace_on number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5844: --l_dbg_lvl NUMBER := 0;
5845:
5846: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5847: BEGIN

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

5842: --returns 'Y' irrespective of level
5843: g_trace_on number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5844: --l_dbg_lvl NUMBER := 0;
5845:
5846: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5847: BEGIN
5848: error_code := 'GET_LOG_FLAG';
5849:
5850: -- select fnd_profile.value('INV_DEBUG_TRACE')

Line 5850: -- select fnd_profile.value('INV_DEBUG_TRACE')

5846: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5847: BEGIN
5848: error_code := 'GET_LOG_FLAG';
5849:
5850: -- select fnd_profile.value('INV_DEBUG_TRACE')
5851: -- into g_trace_on
5852: -- from dual;
5853:
5854: -- if( g_trace_on = 1 ) then

Line 5855: -- select fnd_profile.value('INV_DEBUG_LEVEL')

5851: -- into g_trace_on
5852: -- from dual;
5853:
5854: -- if( g_trace_on = 1 ) then
5855: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5856: -- into l_dbg_lvl
5857: -- from dual;
5858: -- END IF;
5859:

Line 7341: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');

7337: l_cartonization_profile VARCHAR2(1) := 'Y';
7338: BEGIN
7339:
7340: --setting the global variable for trace
7341: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
7342: -- Setting the global variable for packaging
7343: -- packaging_mode := p_packaging_mode;
7344: -- Setting the global variable for sequence
7345: --sequence_id := 1;