APPS.JTF_DEBUG_PUB dependencies on FND_PROFILE

Line 74: from fnd_profile_options_vl

70: x_msg_count out nocopy number,
71: x_msg_data out nocopy varchar2) is
72: CURSOR C_profile IS
73: select user_profile_option_name
74: from fnd_profile_options_vl
75: where profile_option_name = 'UTL_FILE_LOG';
76:
77: l_profile_name varchar2(250);
78: begin

Line 321: fnd_profile.get('UTL_FILE_LOG', l_dir);

317: p_debug_tbl(i).debug_message);
318: END LOOP;
319: end if;
320:
321: fnd_profile.get('UTL_FILE_LOG', l_dir);
322: if l_dir is null then
323: SELECT substr(value,1,instr(value,',',1,1)-1)
324: INTO l_dir
325: FROM v$parameter

Line 334: --fnd_profile.put('UTL_FILE_LOG',l_dir);

330: FROM v$parameter
331: WHERE name = 'utl_file_dir';
332: end if;
333:
334: --fnd_profile.put('UTL_FILE_LOG',l_dir);
335: if l_dir is null then
336: RAISE UTL_FILE.INVALID_PATH;
337: end if;
338: end if;

Line 349: l_user_id := to_number(FND_PROFILE.VALUE( 'USER_ID'));

345: l_filetype := UTL_FILE.fopen(location => l_dir,
346: filename => l_filename,
347: open_mode=> 'a');
348:
349: l_user_id := to_number(FND_PROFILE.VALUE( 'USER_ID'));
350: l_session_id := icx_sec.getsessioncookie();
351: if l_session_id is NULL then
352: l_session_id := -1;
353: end if;

Line 538: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

534:
535: l_message_num := NULL;
536: IF l_id is not NULL THEN
537: OPEN Get_Message_Num (l_message_name, l_id,
538: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
539: FETCH Get_Message_Num into l_message_num;
540: CLOSE Get_Message_Num;
541: END IF;
542: