APPS.WMS_CARTNZN_PUB dependencies on FND_PROFILE

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

3398:
3399: x_return_status := fnd_api.g_ret_sts_success;
3400:
3401: --setting the global variable for trace
3402: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
3403:
3404: log_event('G_CURRENT_RELEASE_LEVEL : '||G_CURRENT_RELEASE_LEVEL);
3405:
3406: if (g_trace_on = 1) then

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

5305: IS
5306:
5307: l_module VARCHAR2(255);
5308: l_mesg VARCHAR2(255);
5309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5310: BEGIN
5311:
5312: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5313:

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

5338: mlid NUMBER;
5339: v_qty_per_cont NUMBER;
5340: v_container_item_id NUMBER;
5341: v_return_status VARCHAR2(300);
5342: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5343: BEGIN
5344: /*mlid := 1;
5345: table_name := 'WMS_CARTONIZATION_TEMP';
5346: mlid := do_cartonization(mohdrid =>5388, trxhdrid =>3243813, outbound => 'N', sublvlctrl =>'1');

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

5710: wdrData wdr_row;
5711: l_device_id NUMBER;
5712: l_qty NUMBER;
5713: l_count NUMBER;
5714: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5715: BEGIN
5716: error_code := 'INS_WCT_ROWS_TO_MMTT';
5717: if (g_trace_on = 1) then log_event(' Entered insert wct rows to mmtt'||p_m_o_h_id); END IF;
5718: -- Initialize API return status to success

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

5878:
5879: log_flag VARCHAR2(1) := 'Y';
5880: --Bug 3319754 changes. Also made change so that get_log_flag
5881: --returns 'Y' irrespective of level
5882: g_trace_on number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5883: --l_dbg_lvl NUMBER := 0;
5884:
5885: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5886: BEGIN

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

5881: --returns 'Y' irrespective of level
5882: g_trace_on number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5883: --l_dbg_lvl NUMBER := 0;
5884:
5885: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5886: BEGIN
5887: error_code := 'GET_LOG_FLAG';
5888:
5889: -- select fnd_profile.value('INV_DEBUG_TRACE')

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

5885: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5886: BEGIN
5887: error_code := 'GET_LOG_FLAG';
5888:
5889: -- select fnd_profile.value('INV_DEBUG_TRACE')
5890: -- into g_trace_on
5891: -- from dual;
5892:
5893: -- if( g_trace_on = 1 ) then

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

5890: -- into g_trace_on
5891: -- from dual;
5892:
5893: -- if( g_trace_on = 1 ) then
5894: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5895: -- into l_dbg_lvl
5896: -- from dual;
5897: -- END IF;
5898:

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

7420: l_cartonization_profile VARCHAR2(1) := 'Y';
7421: BEGIN
7422:
7423: --setting the global variable for trace
7424: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
7425: -- Setting the global variable for packaging
7426: -- packaging_mode := p_packaging_mode;
7427: -- Setting the global variable for sequence
7428: --sequence_id := 1;