63: l_temp_result := g_head;
64: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
65:
66: -- If GSM is enabled in ICM
67: select decode(fnd_profile.value('CONC_GSM_ENABLED'), 'Y', 'ENABLED', 'NOT ENABLED')
68: into l_gsm_enabled from dual;
69:
70: l_temp_result := '
GSM is ' || l_gsm_enabled || 71: ' |
287: module varchar2(2000);
288:
289: --i_file_name varchar2(2000);
290: begin
291: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
292: fnd_profile.get('AFLOG_MODULE',module);
293: if(logging_enabled = 'Y'
294: AND instrb(module,'ecx') > 0
295: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
288:
289: --i_file_name varchar2(2000);
290: begin
291: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
292: fnd_profile.get('AFLOG_MODULE',module);
293: if(logging_enabled = 'Y'
294: AND instrb(module,'ecx') > 0
295: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
296: ecx_logging_enabled := true;