DBA Data[Home] [Help]

APPS.FND_LOGVIEW dependencies on HTP

Line 59: htp.p('

Note: you are running an unsupported screen. This developer/troubleshooting screen is intended only as a last resort when regular screens are unreachable from the menu. ');

55:
56: if icx_sec.validateSession
57: then
58: if(user_mode = 'SD') then
59: htp.p('

Note: you are running an unsupported screen. This developer/troubleshooting screen is intended only as a last resort when regular screens are unreachable from the menu. ');
60: htp.p('You may get "access denied" errors after you press buttons in this screen; ignore them and press the back arrow to get back.

');
61: end if;
62:
63: if(substr(user_mode,1,1) = 'S') then

Line 60: htp.p('You may get "access denied" errors after you press buttons in this screen; ignore them and press the back arrow to get back.

');

56: if icx_sec.validateSession
57: then
58: if(user_mode = 'SD') then
59: htp.p('

Note: you are running an unsupported screen. This developer/troubleshooting screen is intended only as a last resort when regular screens are unreachable from the menu. ');
60: htp.p('You may get "access denied" errors after you press buttons in this screen; ignore them and press the back arrow to get back.

');
61: end if;
62:
63: if(substr(user_mode,1,1) = 'S') then
64: /* Don't allow people who don't have sysadmin function */

Line 68: htp.p('Access denied; function FND_LOGPREFS required.');

64: /* Don't allow people who don't have sysadmin function */
65: /* to run sysadmin version of the page. */
66: if((user_mode = 'S') and
67: (not fnd_function.test('FND_LOGPREFS'))) then
68: htp.p('Access denied; function FND_LOGPREFS required.');
69: return;
70: end if;
71:
72: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',

Line 165: htp.p('');

161: LEVEL_6 := 'Checked';
162: end if;
163:
164:
165: htp.p('');
166: if (substr(user_mode,1,1) = 'S') then
167: htp.p(''||'Site Logging Preferences'||'');
168: else
169: htp.p(''||'User Logging Preferences'||'');

Line 167: htp.p(''||'Site Logging Preferences'||'');

163:
164:
165: htp.p('');
166: if (substr(user_mode,1,1) = 'S') then
167: htp.p(''||'Site Logging Preferences'||'');
168: else
169: htp.p(''||'User Logging Preferences'||'');
170: end if;
171:

Line 169: htp.p(''||'User Logging Preferences'||'');

165: htp.p('');
166: if (substr(user_mode,1,1) = 'S') then
167: htp.p(''||'Site Logging Preferences'||'');
168: else
169: htp.p(''||'User Logging Preferences'||'');
170: end if;
171:
172:
173: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then

Line 174: htp.p('');

170: end if;
171:
172:
173: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
174: htp.p('');
175: else
176: htp.p('');
177: end if;
178:

Line 176: htp.p('');

172:
173: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
174: htp.p('');
175: else
176: htp.p('');
177: end if;
178:
179: htp.p('
180:

Line 179: htp.p('

175: else
176: htp.p('');
177: end if;
178:
179: htp.p('
180:
181:


182:
183:

Line 188: htp.p('

Site Logging Preferences

');

184:


185:
201:
202:
233: ');
234: if(substr(user_mode,1,1) = 'S') then /* SYSADMIN MODE..... */
235: htp.p('
236:
272: ');
273: else /* USER MODE..... */
274: htp.p('
275:
297: ');
298: end if;
299: htp.p('
300:

186: ');
187: if (substr(user_mode,1,1) = 'S') then
188: htp.p('

Site Logging Preferences

');
189: else
190: if (user_id_x is not null) then
191: htp.p('

User Logging Preferences

preferences for Userid: '||
192: '

');
194: else
195: htp.p('

User Logging Preferences

');

Line 195: htp.p('

User Logging Preferences

');

191: htp.p('

User Logging Preferences

preferences for Userid: '||
192: '

');
194: else
195: htp.p('

User Logging Preferences

');
196: end if;
197: end if;
198:
199: htp.p('

Line 199: htp.p('

195: htp.p('

User Logging Preferences

');
196: end if;
197: end if;
198:
199: htp.p('
200:

203: Runtime Logging Enabled:

Line 235: htp.p('

231:
232:


237:
238: 239: Value="Clear site preferences">

Line 274: htp.p('

270: 271: Value="Purge log data for all sessions for all users">


276:
277: 278: Value="Clear user preferences and use defaults">

Line 299: htp.p('

295:
296:


301:

302: ');
303: end if; --icx_sec.validatesession

Line 307: htp.p(SQLERRM);

303: end if; --icx_sec.validatesession
304:
305: exception
306: when others then
307: htp.p(SQLERRM);
308: end;
309:
310: /* Deprecated */
311: procedure find_display is

Line 344: htp.p('

Note: you are running an unsupported screen. This developer/troubleshooting screen is intended only as a last resort when the regular screens are unreachable from the menu.

');

340: if icx_sec.validateSession
341: then
342:
343: if(user_mode = 'SD') then
344: htp.p('

Note: you are running an unsupported screen. This developer/troubleshooting screen is intended only as a last resort when the regular screens are unreachable from the menu.

');
345: end if;
346:
347: /* Don't allow people who don't have sysadmin function */
348: /* to run sysadmin version of the page. */

Line 351: htp.p('Access denied; function FND_LOGFIND required.');

347: /* Don't allow people who don't have sysadmin function */
348: /* to run sysadmin version of the page. */
349: if(user_mode = 'S') then
350: if(not fnd_function.test('FND_LOGFIND')) then
351: htp.p('Access denied; function FND_LOGFIND required.');
352: return;
353: end if;
354: end if;
355:

Line 357: htp.p('');

353: end if;
354: end if;
355:
356:
357: htp.p('');
358: htp.p(''||'Find Log'||'');
359:
360: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
361: htp.p('');

Line 358: htp.p(''||'Find Log'||'');

354: end if;
355:
356:
357: htp.p('');
358: htp.p(''||'Find Log'||'');
359:
360: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
361: htp.p('');
362: else

Line 361: htp.p('');

357: htp.p('');
358: htp.p(''||'Find Log'||'');
359:
360: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
361: htp.p('');
362: else
363: htp.p('');
364: end if;
365:

Line 363: htp.p('');

359:
360: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
361: htp.p('');
362: else
363: htp.p('');
364: end if;
365:
366: htp.p('
367:

Line 366: htp.p('

362: else
363: htp.p('');
364: end if;
365:
366: htp.p('
367:
368:


369:
370:

Line 409: htp.p('

405:


406: ');
407:
408: if(substr(user_mode,1,1) = 'S') then
409: htp.p('
410: Only show log for user
411: :
413:

Line 419: htp.p('

415:
416:


417: ');
418: end if;
419: htp.p('
420: Messages per result page:
421:
422:

Line 426: htp.p('

422:
424:


425: ');
426: htp.p('
427:
428: 429: Value="Purge log data for this current user session">
430:

Line 442: htp.p('

438:


439: ');
440:
441: if(substr(user_mode,1,1) = 'S') then
442: htp.p('
443:
444: ');
445: else
446: htp.p('

Line 446: htp.p('

442: htp.p('
443:
444: ');
445: else
446: htp.p('
447:
448: ');
449: end if;
450:

Line 451: htp.p('

447:
448: ');
449: end if;
450:
451: htp.p('
452:
453:


454:

455: ');

Line 460: htp.p(SQLERRM);

456: end if; --icx_sec.validatesession
457:
458: exception
459: when others then
460: htp.p(SQLERRM);
461: end;
462:
463:
464: procedure display( LEVEL in VARCHAR2,

Line 527: htp.p(

523: elsif (clearsessionlog is not null) then /* if user pressed... */
524: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(FND_GLOBAL.USER_ID,
525: icx_sec.getsessioncookie());
526: commit;
527: htp.p(
528: 'Cleared '|| nrows||
529: ' rows of log data for this session. Use back arrow to get back.');
530: return;
531: elsif (clearuserlog is not null) then /* if user pressed... */

Line 534: htp.p(

530: return;
531: elsif (clearuserlog is not null) then /* if user pressed... */
532: nrows := FND_LOG_ADMIN.DELETE_BY_USER(FND_GLOBAL.USER_ID);
533: commit;
534: htp.p(
535: 'Cleared '|| nrows ||
536: ' rows of log data for this user. Use back arrow to get back.');
537: return;
538: else

Line 539: htp.p('Error- no buttonpress in fnd_logview.display.');

535: 'Cleared '|| nrows ||
536: ' rows of log data for this user. Use back arrow to get back.');
537: return;
538: else
539: htp.p('Error- no buttonpress in fnd_logview.display.');
540: return; /* Should never happen */
541: end if;
542:
543: if (startrow is NULL) then

Line 585: htp.p('Invalid username entered. Finding data for current user.');

581: select user_id into f_user_id from fnd_user
582: where user_name = upper(username);
583: exception
584: when no_data_found then
585: htp.p('Invalid username entered. Finding data for current user.');
586: f_user_id := fnd_global.user_id;
587: end;
588: end if;
589:

Line 867: htp.p('');

863: end if;
864: end if;
865: end if;
866:
867: htp.p('');
868: htp.p(''||'Logged Messages'||'');
869:
870: htp.p('
871:

Logged Messages


Line 868: htp.p(''||'Logged Messages'||'');

864: end if;
865: end if;
866:
867: htp.p('');
868: htp.p(''||'Logged Messages'||'');
869:
870: htp.p('
871:

Logged Messages


872:

Line 870: htp.p('

866:
867: htp.p('');
868: htp.p(''||'Logged Messages'||'');
869:
870: htp.p('
871:

Logged Messages


872:
873: ');
874: htp.p('Context');

Line 874: htp.p('Context');

870: htp.p('
871:

Logged Messages


872:
873: ');
874: htp.p('Context');
875: if(f_level = 1) then
876: htp.p('
Level: Statement');
877: elsif(f_level = 2) then
878: htp.p('
Level: Procedure');

Line 876: htp.p('
Level: Statement');

872:
873: ');
874: htp.p('Context');
875: if(f_level = 1) then
876: htp.p('
Level: Statement');
877: elsif(f_level = 2) then
878: htp.p('
Level: Procedure');
879: elsif(f_level = 3) then
880: htp.p('
Level: Event');

Line 878: htp.p('
Level: Procedure');

874: htp.p('Context');
875: if(f_level = 1) then
876: htp.p('
Level: Statement');
877: elsif(f_level = 2) then
878: htp.p('
Level: Procedure');
879: elsif(f_level = 3) then
880: htp.p('
Level: Event');
881: elsif(f_level = 4) then
882: htp.p('
Level: Exception');

Line 880: htp.p('
Level: Event');

876: htp.p('
Level: Statement');
877: elsif(f_level = 2) then
878: htp.p('
Level: Procedure');
879: elsif(f_level = 3) then
880: htp.p('
Level: Event');
881: elsif(f_level = 4) then
882: htp.p('
Level: Exception');
883: elsif(f_level = 5) then
884: htp.p('
Level: Error');

Line 882: htp.p('
Level: Exception');

878: htp.p('
Level: Procedure');
879: elsif(f_level = 3) then
880: htp.p('
Level: Event');
881: elsif(f_level = 4) then
882: htp.p('
Level: Exception');
883: elsif(f_level = 5) then
884: htp.p('
Level: Error');
885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');

Line 884: htp.p('
Level: Error');

880: htp.p('
Level: Event');
881: elsif(f_level = 4) then
882: htp.p('
Level: Exception');
883: elsif(f_level = 5) then
884: htp.p('
Level: Error');
885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));

Line 886: htp.p('
Level: Unexpected');

882: htp.p('
Level: Exception');
883: elsif(f_level = 5) then
884: htp.p('
Level: Error');
885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));

Line 888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));

884: htp.p('
Level: Error');
885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));

Line 889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),

885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));

Line 891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),

887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');

Line 893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));

889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');
896:
897: htp.p('');

Line 894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));

890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');
896:
897: htp.p('
');
898: htp.p('');

Line 895: htp.p('

');

891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');
896:
897: htp.p('
');
898: htp.p('');
899: htp.p('');

Line 897: htp.p('
Time
');

893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');
896:
897: htp.p('
');
898: htp.p('');
899: htp.p('');
900: htp.p('');
901: htp.p('');

Line 898: htp.p('
');

894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('

');
896:
897: htp.p('
TimeSessionUser
');
898: htp.p('');
899: htp.p('');
900: htp.p('');
901: htp.p('');
902: htp.p('');

Line 899: htp.p('
');

895: htp.p('

');
896:
897: htp.p('
TimeSessionUserLevel Time
');
898: htp.p('');
899: htp.p('');
900: htp.p('');
901: htp.p('');
902: htp.p('');
903: htp.p('');

Line 900: htp.p('
');

896:
897: htp.p('

TimeSessionUserLevelModule Session
');
898: htp.p('');
899: htp.p('');
900: htp.p('');
901: htp.p('');
902: htp.p('');
903: htp.p('');
904: htp.p('');

Line 901: htp.p('
');

897: htp.p('

Time SessionUserLevelModuleMessage Text User
');
898: htp.p('');
899: htp.p('');
900: htp.p('');
901: htp.p('');
902: htp.p('');
903: htp.p('');
904: htp.p('');
905: htp.p('');

Line 902: htp.p('
');

898: htp.p('

');
899: htp.p('');
900: htp.p('');
901: htp.p('');
902: htp.p('');
903: htp.p('');
904: htp.p('');
905: htp.p('');
906:

Line 903: htp.p('
');

899: htp.p('

');
900: htp.p('');
901: htp.p('');
902: htp.p('');
903: htp.p('');
904: htp.p('');
905: htp.p('');
906:
907:

Line 904: htp.p('
');

900: htp.p('

');
901: htp.p('');
902: htp.p('');
903: htp.p('');
904: htp.p('');
905: htp.p('');
906:
907:
908: l_index := 0;

Line 905: htp.p('');

901: htp.p('

');
902: htp.p('');
903: htp.p('');
904: htp.p('');
905: htp.p('');
906:
907:
908: l_index := 0;
909: LOOP

Line 952: htp.p('
');

948: else
949: found_username := NULL;
950: end if;
951:
952: htp.p('

');
953: htp.p('');
955: htp.p('');

Line 953: htp.p('
');
953: htp.p('');
955: htp.p('');
957: htp.p('');
953: htp.p('');
955: htp.p('');
957: htp.p('');
959: htp.p('');
955: htp.p('');
957: htp.p('');
959: htp.p('');
961: htp.p('');
957: htp.p('');
959: htp.p('');
961: htp.p('');
963: if ((not( instr(l_msg_text, fnd_global.local_chr(0)) = 0)) or

Line 961: htp.p('
');
959: htp.p('');
961: htp.p('');
963: if ((not( instr(l_msg_text, fnd_global.local_chr(0)) = 0)) or
964: substr(l_msg_text,1,1) = '<') then /* If encoded message */
965: FND_MESSAGE.SET_ENCODED(l_msg_text);

Line 966: htp.p('
');
963: if ((not( instr(l_msg_text, fnd_global.local_chr(0)) = 0)) or
964: substr(l_msg_text,1,1) = '<') then /* If encoded message */
965: FND_MESSAGE.SET_ENCODED(l_msg_text);
966: htp.p('');
968: else
969: htp.p('');

Line 969: htp.p('
');
968: else
969: htp.p('');
971: end if;
972: htp.p('');
973: end if; /* if (l_index >= f_startrow) */

Line 972: htp.p('');

968: else
969: htp.p('

');
971: end if;
972: htp.p('');
973: end if; /* if (l_index >= f_startrow) */
974: END LOOP;
975: CLOSE row_set;
976: if (l_index > 0) then

Line 977: htp.p('

Showing messages '||to_char(f_startrow)||

973: end if; /* if (l_index >= f_startrow) */
974: END LOOP;
975: CLOSE row_set;
976: if (l_index > 0) then
977: htp.p('

Showing messages '||to_char(f_startrow)||
978: '..'||to_char(l_index));
979: end if;
980: if (l_index >= (f_maxrow-1)) then
981: /* If this row is further than what will fit on screen, render a */

Line 984: htp.p('

980: if (l_index >= (f_maxrow-1)) then
981: /* If this row is further than what will fit on screen, render a */
982: /* button for the next screen of data */
983: f_startrow := f_startrow + f_numrows;
984: htp.p('
985:

986: 987: Value="Next '||to_char(f_numrows)|| ' Messages">
988:

Line 1000: htp.p('
');

996:
997:


998: ');
999: elsif (l_index = 0) then
1000: htp.p('

');
1001: htp.p('');
1002: htp.p('');
1003: end if;
1004: htp.p('
TimeSession UserLevelModuleMessage Text
Level
TimeSessionUser LevelModuleMessage Text
Module TimeSessionUserLevel ModuleMessage Text
Message Text SessionUserLevelModule Message Text
UserLevelModuleMessage Text
'||
954: convert_special_chars(timestamp_str)||'		'||
956: convert_special_chars(l_session_id)||'		 '||

949: found_username := NULL;
950: end if;
951:
952: htp.p('

'||
954: convert_special_chars(timestamp_str)||'		'||
956: convert_special_chars(l_session_id)||'		'||

Line 955: htp.p('
'||

951:
952: htp.p('

'||
954: convert_special_chars(timestamp_str)||'		'||
956: convert_special_chars(l_session_id)||'		'||
958: convert_special_chars(found_username)||'		'||

Line 957: htp.p('
'||

953: htp.p('

'||
954: convert_special_chars(timestamp_str)||'		'||
956: convert_special_chars(l_session_id)||'		'||
958: convert_special_chars(found_username)||'		'||
960: convert_special_chars(log_level_name)||'		'||

Line 959: htp.p('
'||

955: htp.p('

'||
956: convert_special_chars(l_session_id)||'		'||
958: convert_special_chars(found_username)||'		'||
960: convert_special_chars(log_level_name)||'		'||
962: convert_special_chars(l_module)||'		'||

957: htp.p('

'||
958: convert_special_chars(found_username)||'		'||
960: convert_special_chars(log_level_name)||'		'||
962: convert_special_chars(l_module)||'		'||

962: convert_special_chars(l_module)||'

'||
967: convert_special_chars(FND_MESSAGE.GET)||'		'||
970: convert_special_chars(l_msg_text)||'		'||

965: FND_MESSAGE.SET_ENCODED(l_msg_text);
966: htp.p('

'||
967: convert_special_chars(FND_MESSAGE.GET)||'		'||
970: convert_special_chars(l_msg_text)||'
'||
970: convert_special_chars(l_msg_text)||'
'||'No Log Messages returned.'||'
');

Line 1001: htp.p(''||'No Log Messages returned.'||'');

997:


998: ');
999: elsif (l_index = 0) then
1000: htp.p('');
1001: htp.p(''||'No Log Messages returned.'||'');
1002: htp.p('');
1003: end if;
1004: htp.p('');
1005:

Line 1002: htp.p('');

998: ');
999: elsif (l_index = 0) then
1000: htp.p('');
1001: htp.p(''||'No Log Messages returned.'||'');
1002: htp.p('');
1003: end if;
1004: htp.p('');
1005:
1006: end if; --icx_sec.validatesession

Line 1004: htp.p('');

1000: htp.p('');
1001: htp.p(''||'No Log Messages returned.'||'');
1002: htp.p('');
1003: end if;
1004: htp.p('');
1005:
1006: end if; --icx_sec.validatesession
1007:
1008: exception

Line 1010: htp.p(SQLERRM);

1006: end if; --icx_sec.validatesession
1007:
1008: exception
1009: when others then
1010: htp.p(SQLERRM);
1011: end;
1012:
1013:
1014: procedure internal_check_results(result1 in boolean, result2 in boolean,

Line 1021: htp.p(

1017: if(result1 = FALSE or
1018: result2 = FALSE or
1019: result3 = FALSE or
1020: result4 = FALSE ) then
1021: htp.p(
1022: '

'||
1023: '

Error- could not save value(s) to the '||
1024: 'profiles option(s): ');
1025: if(result1 = FALSE) then

Line 1026: htp.p(' AFLOG_ENABLED');

1022: '

'||
1023: '

Error- could not save value(s) to the '||
1024: 'profiles option(s): ');
1025: if(result1 = FALSE) then
1026: htp.p(' AFLOG_ENABLED');
1027: end if;
1028: if(result2 = FALSE) then
1029: htp.p(' AFLOG_FILENAME');
1030: end if;

Line 1029: htp.p(' AFLOG_FILENAME');

1025: if(result1 = FALSE) then
1026: htp.p(' AFLOG_ENABLED');
1027: end if;
1028: if(result2 = FALSE) then
1029: htp.p(' AFLOG_FILENAME');
1030: end if;
1031: if(result3 = FALSE) then
1032: htp.p(' AFLOG_LEVEL');
1033: end if;

Line 1032: htp.p(' AFLOG_LEVEL');

1028: if(result2 = FALSE) then
1029: htp.p(' AFLOG_FILENAME');
1030: end if;
1031: if(result3 = FALSE) then
1032: htp.p(' AFLOG_LEVEL');
1033: end if;
1034: if(result4 = FALSE) then
1035: htp.p(' AFLOG_MODULE');
1036: end if;

Line 1035: htp.p(' AFLOG_MODULE');

1031: if(result3 = FALSE) then
1032: htp.p(' AFLOG_LEVEL');
1033: end if;
1034: if(result4 = FALSE) then
1035: htp.p(' AFLOG_MODULE');
1036: end if;
1037: htp.p(
1038: '. Check to make sure that profile options are '||
1039: 'in the fnd_profile_options table and if not, use the '||

Line 1037: htp.p(

1033: end if;
1034: if(result4 = FALSE) then
1035: htp.p(' AFLOG_MODULE');
1036: end if;
1037: htp.p(
1038: '. Check to make sure that profile options are '||
1039: 'in the fnd_profile_options table and if not, use the '||
1040: 'aflogpro.ldt loader file to upload.

');
1041: end if;

Line 1103: htp.p('');

1099: /* Per bug 1687209, the following line was modified to use fnd_global.local_chr() instead of chr() */
1100: the_filename := translate(the_filename, fnd_global.local_chr(9)||fnd_global.local_chr(10)||fnd_global.local_chr(13), ' ');
1101: the_filename := rtrim(ltrim(the_filename));
1102:
1103: htp.p('');
1104:
1105: if(syssave is not null) then /* If user pressed system save button */
1106: if(ENABLED = 'on') then
1107: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'SITE');

Line 1117: htp.p('Saved Site Level information. ');

1113: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'SITE');
1114: internal_check_results(result1, result2, result3, result4);
1115: commit;
1116: fnd_log_repository.init;
1117: htp.p('Saved Site Level information. ');
1118: elsif(save is not null) then /* If user pressed user save */
1119: if(user_id is not NULL) then
1120: user_id_x := user_id;
1121: else

Line 1137: htp.p('Saved User Level information. ');

1133: user_id_x);
1134: internal_check_results(result1, result2, result3, result4);
1135: commit;
1136: fnd_log_repository.init;
1137: htp.p('Saved User Level information. ');
1138: elsif (sysclearprefs is not null) then /* If user pressed sysclearprefs*/
1139: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', '', 'SITE');
1140: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', '', 'SITE');
1141: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'SITE');

Line 1146: htp.p('Cleared site level information.');

1142: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'SITE');
1143: internal_check_results(result1, result2, result3, result4);
1144: commit;
1145: fnd_log_repository.init;
1146: htp.p('Cleared site level information.');
1147: elsif (clearprefs is not null) then /* If user pressed clearprefs */
1148: if(user_id is not NULL) then
1149: user_id_x := user_id;
1150: else

Line 1160: htp.p('Cleared user level information.');

1156: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'USER', user_id_x);
1157: internal_check_results(result1, result2, result3, result4);
1158: commit;
1159: fnd_log_repository.init;
1160: htp.p('Cleared user level information.');
1161: elsif (sysclearsessionlog is not null) then /* if user pressed... */
1162: nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));
1163: commit;
1164: htp.p('Purged '|| nrows ||' rows of log data for session '

Line 1164: htp.p('Purged '|| nrows ||' rows of log data for session '

1160: htp.p('Cleared user level information.');
1161: elsif (sysclearsessionlog is not null) then /* if user pressed... */
1162: nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));
1163: commit;
1164: htp.p('Purged '|| nrows ||' rows of log data for session '
1165: ||SESSION_TO_PURGE||'.');
1166: purged := TRUE;
1167: elsif (clearsessionlog is not null) then /* if user pressed... */
1168: if(user_id is not NULL) then

Line 1176: htp.p('Purged '|| nrows || ' rows of log data for this session.');

1172: end if;
1173: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,
1174: icx_sec.getsessioncookie());
1175: commit;
1176: htp.p('Purged '|| nrows || ' rows of log data for this session.');
1177: purged := TRUE;
1178: elsif (sysclearuserlog is not null) then /* if user pressed... */
1179: user_id_x := NULL;
1180: begin

Line 1185: htp.p('Invalid username entered. Enter a valid username.');

1181: select user_id into user_id_x from fnd_user
1182: where user_name = upper(USER_TO_PURGE);
1183: exception
1184: when no_data_found then
1185: htp.p('Invalid username entered. Enter a valid username.');
1186: user_id_x := NULL;
1187: end;
1188: if(user_id_x is not NULL) then
1189: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

Line 1191: htp.p('

Purged '|| nrows|| ' rows of log data for user '

1187: end;
1188: if(user_id_x is not NULL) then
1189: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);
1190: commit;
1191: htp.p('

Purged '|| nrows|| ' rows of log data for user '
1192: ||USER_TO_PURGE||'.

');
1193: purged := TRUE;
1194: else
1195: made_changes := FALSE;

Line 1200: htp.p('Purged '|| nrows||

1196: end if;
1197: elsif (syspurgeallusers is not null) then /* if user pressed... */
1198: nrows := FND_LOG_ADMIN.DELETE_ALL;
1199: commit;
1200: htp.p('Purged '|| nrows||
1201: ' rows of log data for all users, all sessions.');
1202: purged := TRUE;
1203: elsif (syssetuserprefs is not null) then /* if user pressed... */
1204: user_id_x := NULL;

Line 1210: htp.p('Invalid username entered. Enter a valid username.');

1206: select user_id into user_id_x from fnd_user
1207: where user_name = upper(USER_TO_SET);
1208: exception
1209: when no_data_found then
1210: htp.p('Invalid username entered. Enter a valid username.');
1211: user_id_x := NULL;
1212: end;
1213: if(user_id_x is not NULL) then
1214: fnd_logview.preferences_generic('U', user_id_x);

Line 1227: htp.p('

Purged '|| nrows ||

1223: end if;
1224: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);
1225: commit;
1226: purged := TRUE;
1227: htp.p('

Purged '|| nrows ||
1228: ' rows of log data for this user.

');
1229: else
1230: htp.p('

Internal Error- update_prefs call missing args.

');
1231: htp.p('

No data was changed.

');

Line 1230: htp.p('

Internal Error- update_prefs call missing args.

');

1226: purged := TRUE;
1227: htp.p('

Purged '|| nrows ||
1228: ' rows of log data for this user.

');
1229: else
1230: htp.p('

Internal Error- update_prefs call missing args.

');
1231: htp.p('

No data was changed.

');
1232: end if;
1233: if ((made_changes) and (not purged)) then
1234: htp.p('

This change will be in effect upon switching responsibility.

');

Line 1231: htp.p('

No data was changed.

');

1227: htp.p('

Purged '|| nrows ||
1228: ' rows of log data for this user.

');
1229: else
1230: htp.p('

Internal Error- update_prefs call missing args.

');
1231: htp.p('

No data was changed.

');
1232: end if;
1233: if ((made_changes) and (not purged)) then
1234: htp.p('

This change will be in effect upon switching responsibility.

');
1235: end if;

Line 1234: htp.p('

This change will be in effect upon switching responsibility.

');

1230: htp.p('

Internal Error- update_prefs call missing args.

');
1231: htp.p('

No data was changed.

');
1232: end if;
1233: if ((made_changes) and (not purged)) then
1234: htp.p('

This change will be in effect upon switching responsibility.

');
1235: end if;
1236:
1237: if((save is not NULL) or (clear is not NULL) or (clearprefs is not NULL) or
1238: (clearsessionlog is not NULL) or (clearuserlog is not NULL)) then

Line 1276: htp.p('');

1272: begin
1273:
1274: if icx_sec.validateSession
1275: then
1276: htp.p('');
1277:
1278: FND_LOGVIEW.Update_Prefs('on', null, 3,
1279: 'FnD.sRc.FlEx.%, fnd.src.dict.afdict.afdget.start, fnd.src.flex.fdfv.fdfval.dff',
1280: null, null, null, 'Save', null, null, null, null, null, null,

Line 1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);

1291: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
1292: user_id := fnd_profile.value('USER_ID');
1293: session_id := icx_sec.getsessioncookie();
1294:
1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);
1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));
1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);

Line 1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));

1292: user_id := fnd_profile.value('USER_ID');
1293: session_id := icx_sec.getsessioncookie();
1294:
1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);
1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));
1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);
1300:

Line 1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);

1293: session_id := icx_sec.getsessioncookie();
1294:
1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);
1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));
1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);
1300:
1301: htp.p(''||'Logging system self-test results:'||'');

Line 1298: htp.p('
SESSION_ID='||SESSION_ID);

1294:
1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);
1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));
1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);
1300:
1301: htp.p(''||'Logging system self-test results:'||'');
1302:

Line 1299: htp.p('
USER_ID='||USER_ID);

1295: htp.p('
AFLOG_FILENAME='||AFLOG_FILENAME);
1296: htp.p('
AFLOG_LEVEL='||TO_CHAR(AFLOG_LEVEL));
1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);
1300:
1301: htp.p(''||'Logging system self-test results:'||'');
1302:
1303: htp.p('

Note: This test routine clears the log messages for the ');

Line 1301: htp.p(''||'Logging system self-test results:'||'');

1297: htp.p('
AFLOG_MODULE='||AFLOG_MODULE);
1298: htp.p('
SESSION_ID='||SESSION_ID);
1299: htp.p('
USER_ID='||USER_ID);
1300:
1301: htp.p(''||'Logging system self-test results:'||'');
1302:
1303: htp.p('

Note: This test routine clears the log messages for the ');
1304: htp.p(' user and resets the user preferences, so be careful!

');
1305: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then

Line 1303: htp.p('

Note: This test routine clears the log messages for the ');

1299: htp.p('
USER_ID='||USER_ID);
1300:
1301: htp.p(''||'Logging system self-test results:'||'');
1302:
1303: htp.p('

Note: This test routine clears the log messages for the ');
1304: htp.p(' user and resets the user preferences, so be careful!

');
1305: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1306: htp.p('');
1307: else

Line 1304: htp.p(' user and resets the user preferences, so be careful!

');

1300:
1301: htp.p(''||'Logging system self-test results:'||'');
1302:
1303: htp.p('

Note: This test routine clears the log messages for the ');
1304: htp.p(' user and resets the user preferences, so be careful!

');
1305: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1306: htp.p('');
1307: else
1308: htp.p('');

Line 1306: htp.p('');

1302:
1303: htp.p('

Note: This test routine clears the log messages for the ');
1304: htp.p(' user and resets the user preferences, so be careful!

');
1305: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1306: htp.p('');
1307: else
1308: htp.p('');
1309: end if;
1310:

Line 1308: htp.p('');

1304: htp.p(' user and resets the user preferences, so be careful!

');
1305: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1306: htp.p('');
1307: else
1308: htp.p('');
1309: end if;
1310:
1311: htp.p('
1312:

Test logging system


Line 1311: htp.p('

1307: else
1308: htp.p('');
1309: end if;
1310:
1311: htp.p('
1312:

Test logging system


1313: ');
1314:
1315: delete from FND_LOG_MESSAGES where user_id = USER_ID;

Line 1350: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start found
');

1346: FND_LOG.STRING(3, 'ThisWontLog', 'String that wont log');
1347: FND_LOG.STRING(1, 'fnd.src.dict.afdict.afdget.start', 'String that wont log 2');
1348:
1349: if FND_LOG.TEST(3, 'fnd.src.flex.fdfvl.fdfval.kff.start') then
1350: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start found
');
1351: else
1352: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start not found
');
1353: end if;
1354:

Line 1352: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start not found
');

1348:
1349: if FND_LOG.TEST(3, 'fnd.src.flex.fdfvl.fdfval.kff.start') then
1350: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start found
');
1351: else
1352: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start not found
');
1353: end if;
1354:
1355:
1356: if FND_LOG.TEST(3, 'fnd.src.something.blah.blah') then

Line 1357: htp.p('incorrect- fnd.src.something.blah.blah found
');

1353: end if;
1354:
1355:
1356: if FND_LOG.TEST(3, 'fnd.src.something.blah.blah') then
1357: htp.p('incorrect- fnd.src.something.blah.blah found
');
1358: else
1359: htp.p('correct- fnd.src.something.blah.blah not found
');
1360: end if;
1361:

Line 1359: htp.p('correct- fnd.src.something.blah.blah not found
');

1355:
1356: if FND_LOG.TEST(3, 'fnd.src.something.blah.blah') then
1357: htp.p('incorrect- fnd.src.something.blah.blah found
');
1358: else
1359: htp.p('correct- fnd.src.something.blah.blah not found
');
1360: end if;
1361:
1362:
1363: if FND_LOG.TEST(2, 'fnd.src.flex.fdfvl.fdfval.kff.start') then

Line 1364: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start found at level 2
');

1360: end if;
1361:
1362:
1363: if FND_LOG.TEST(2, 'fnd.src.flex.fdfvl.fdfval.kff.start') then
1364: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start found at level 2
');
1365: else
1366: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start not found at level 2
');
1367: end if;
1368:

Line 1366: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start not found at level 2
');

1362:
1363: if FND_LOG.TEST(2, 'fnd.src.flex.fdfvl.fdfval.kff.start') then
1364: htp.p('incorrect- fnd.src.flex.fdfvl.fdfval.kff.start found at level 2
');
1365: else
1366: htp.p('correct- fnd.src.flex.fdfvl.fdfval.kff.start not found at level 2
');
1367: end if;
1368:
1369:
1370: FND_LOGVIEW.Display(3, 'fnd.src.%',

Line 1377: htp.p(SQLERRM);

1373: end if; --icx_sec.validatesession
1374:
1375: exception
1376: when others then
1377: htp.p(SQLERRM);
1378: end;
1379:
1380: end fnd_logview;