253:
255: User name to purge: 256: 258: |
259: Value="Purge log data for particular user"> |
261:
263: User name to set preferences for: 264: 266: |
267: Value="Navigate to user log preferences screen"> |
515: if icx_sec.validateSession
516: then
517: if (find_user is not null) then
518: f_buttonname := 'FIND_USER';
519: f_user_id := fnd_global.user_id;
520: elsif (find_sysadmin is not null) then
521: f_buttonname := 'FIND_SYSADMIN';
522: f_user_id := NULL;
523: elsif (clearsessionlog is not null) then /* if user pressed... */
520: elsif (find_sysadmin is not null) then
521: f_buttonname := 'FIND_SYSADMIN';
522: f_user_id := NULL;
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||
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... */
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.');
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:
590:
959: htp.p('
1087:
1088: the_module := module;
1089: /* strip whitespace */
1090:
1091: /* Per bug 1687209, the following line was modified to use fnd_global.local_chr() instead of chr() */
1092: -- the_module := translate(the_module, chr(9)||chr(10)||chr(13), ' ');
1093: the_module := translate(the_module, fnd_global.local_chr(9)||fnd_global.local_chr(10)||fnd_global.local_chr(13), ' ');
1094: the_module := rtrim(ltrim(the_module));
1095:
1089: /* strip whitespace */
1090:
1091: /* Per bug 1687209, the following line was modified to use fnd_global.local_chr() instead of chr() */
1092: -- the_module := translate(the_module, chr(9)||chr(10)||chr(13), ' ');
1093: the_module := translate(the_module, fnd_global.local_chr(9)||fnd_global.local_chr(10)||fnd_global.local_chr(13), ' ');
1094: the_module := rtrim(ltrim(the_module));
1095:
1096: the_filename := filename;
1097: /* strip whitespace */
1095:
1096: the_filename := filename;
1097: /* strip whitespace */
1098:
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('');
1096: the_filename := filename;
1097: /* strip whitespace */
1098:
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:
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
1122: user_id_x := FND_GLOBAL.USER_ID;
1123: end if;
1124: if(ENABLED = 'on') then
1125: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'USER', user_id_x);
1126: else
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
1151: user_id_x := FND_GLOBAL.USER_ID;
1152: end if;
1153: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', '', 'USER', user_id_x);
1154: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', '', 'USER', user_id_x);
1155: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'USER', user_id_x);
1167: elsif (clearsessionlog is not null) then /* if user pressed... */
1168: if(user_id is not NULL) then
1169: user_id_x := user_id;
1170: else
1171: user_id_x := FND_GLOBAL.USER_ID;
1172: end if;
1173: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,
1174: icx_sec.getsessioncookie());
1175: commit;
1218: elsif (clearuserlog is not null) then /* if user pressed... */
1219: if(user_id is not NULL) then
1220: user_id_x := user_id;
1221: else
1222: user_id_x := FND_GLOBAL.USER_ID;
1223: end if;
1224: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);
1225: commit;
1226: purged := TRUE;