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.');
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 '
1165: ||SESSION_TO_PURGE||'.');
1166: purged := TRUE;
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;
1176: htp.p('Purged '|| nrows || ' rows of log data for this session.');
1177: purged := TRUE;
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);
1190: commit;
1191: htp.p('
Purged '|| nrows|| ' rows of log data for user '
1192: ||USER_TO_PURGE||'.
1194: else
1195: made_changes := FALSE;
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;
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;
1227: htp.p('
Purged '|| nrows ||
1228: ' rows of log data for this user.