DBA Data[Home] [Help]

APPS.FND_LOGVIEW dependencies on FND_LOG

Line 1: package body fnd_logview as

1: package body fnd_logview as
2: /* $Header: AFUTLPFB.pls 115.16 2002/02/08 21:49:36 nbhambha ship $ */
3:
4:
5: M_ROWS_PER_PAGE NUMBER := 1000;

Line 67: (not fnd_function.test('FND_LOGPREFS'))) then

63: if(substr(user_mode,1,1) = 'S') then
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:

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 181:

177: end if;
178:
179: htp.p('
180:
181:
182:
183:
184:
185:

Line 350: if(not fnd_function.test('FND_LOGFIND')) then

346:
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;

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 368:

364: end if;
365:
366: htp.p('
367:
368:
369:
370:
371:
372:

Line 524: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(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... */
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||

Line 532: nrows := FND_LOG_ADMIN.DELETE_BY_USER(FND_GLOBAL.USER_ID);

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.');

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 625: 'from fnd_log_messages '||

621: end if;
622:
623: l_dynamic_sql :=
624: 'select MODULE||to_number(rownum), LOG_LEVEL, MESSAGE_TEXT, SESSION_ID, USER_ID, TIMESTAMP '||
625: 'from fnd_log_messages '||
626: 'where ';
627:
628: b_previous_clause := FALSE;
629:

Line 985:

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:
989:

Line 1116: fnd_log_repository.init;

1112: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'SITE');
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;

Line 1136: fnd_log_repository.init;

1132: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'USER',
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');

Line 1145: fnd_log_repository.init;

1141: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'SITE');
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;

Line 1159: fnd_log_repository.init;

1155: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'USER', user_id_x);
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;

Line 1162: nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));

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;

Line 1173: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,

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;

Line 1189: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

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||'.

');
1193: purged := TRUE;

Line 1198: nrows := FND_LOG_ADMIN.DELETE_ALL;

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;

Line 1214: fnd_logview.preferences_generic('U', user_id_x);

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);
1215: go_back_to_prefs := FALSE;
1216: end if;
1217: made_changes := FALSE;
1218: elsif (clearuserlog is not null) then /* if user pressed... */

Line 1224: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

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.

');

Line 1241: fnd_logview.preferences_generic('U');

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
1239: if(user_id_x is not NULL) then
1240: if(user_id is NULL) then
1241: fnd_logview.preferences_generic('U');
1242: else
1243: fnd_logview.preferences_generic('U', user_id);
1244: end if;
1245: go_back_to_prefs := FALSE;

Line 1243: fnd_logview.preferences_generic('U', user_id);

1239: if(user_id_x is not NULL) then
1240: if(user_id is NULL) then
1241: fnd_logview.preferences_generic('U');
1242: else
1243: fnd_logview.preferences_generic('U', user_id);
1244: end if;
1245: go_back_to_prefs := FALSE;
1246: end if;
1247: else

Line 1249: fnd_logview.preferences_sysadmin;

1245: go_back_to_prefs := FALSE;
1246: end if;
1247: else
1248: if (go_back_to_prefs) then
1249: fnd_logview.preferences_sysadmin;
1250: end if;
1251: end if;
1252:
1253: end if;

Line 1278: FND_LOGVIEW.Update_Prefs('on', null, 3,

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,
1281: null, null, null, null, null, null);
1282:

Line 1315: delete from FND_LOG_MESSAGES where user_id = USER_ID;

1311: htp.p('
1312:

Test logging system


1313: ');
1314:
1315: delete from FND_LOG_MESSAGES where user_id = USER_ID;
1316: commit;
1317:
1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');
1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');

Line 1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');

1314:
1315: delete from FND_LOG_MESSAGES where user_id = USER_ID;
1316: commit;
1317:
1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');
1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');
1320: FND_LOG.STRING(3, 'fnd.src.flex.fdfvl.fdfval.kff.start', '3 ');
1321: FND_LOG.STRING(4, 'fnd.src.flex.fdfvl.fdfval.kff.start', '4 '||
1322: 'Lots of text: (1200 characters or so) '||

Line 1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');

1315: delete from FND_LOG_MESSAGES where user_id = USER_ID;
1316: commit;
1317:
1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');
1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');
1320: FND_LOG.STRING(3, 'fnd.src.flex.fdfvl.fdfval.kff.start', '3 ');
1321: FND_LOG.STRING(4, 'fnd.src.flex.fdfvl.fdfval.kff.start', '4 '||
1322: 'Lots of text: (1200 characters or so) '||
1323: '123456789 123456789 123456789 123456789 123456789 -------- '||

Line 1320: FND_LOG.STRING(3, 'fnd.src.flex.fdfvl.fdfval.kff.start', '3 ');

1316: commit;
1317:
1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');
1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');
1320: FND_LOG.STRING(3, 'fnd.src.flex.fdfvl.fdfval.kff.start', '3 ');
1321: FND_LOG.STRING(4, 'fnd.src.flex.fdfvl.fdfval.kff.start', '4 '||
1322: 'Lots of text: (1200 characters or so) '||
1323: '123456789 123456789 123456789 123456789 123456789 -------- '||
1324: '123456789 123456789 123456789 123456789 123456789 -------- '||

Line 1321: FND_LOG.STRING(4, 'fnd.src.flex.fdfvl.fdfval.kff.start', '4 '||

1317:
1318: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '1 (first)');
1319: FND_LOG.STRING(3, 'fnd.src.dict.afdict.afdget.start', '2 ');
1320: FND_LOG.STRING(3, 'fnd.src.flex.fdfvl.fdfval.kff.start', '3 ');
1321: FND_LOG.STRING(4, 'fnd.src.flex.fdfvl.fdfval.kff.start', '4 '||
1322: 'Lots of text: (1200 characters or so) '||
1323: '123456789 123456789 123456789 123456789 123456789 -------- '||
1324: '123456789 123456789 123456789 123456789 123456789 -------- '||
1325: '123456789 123456789 123456789 123456789 123456789 -------- '||

Line 1345: FND_LOG.STRING(5, 'fnd.src.dict.afdict.afdget.start', '5 (last)');

1341: '123456789 123456789 123456789 123456789 123456789 -------- '||
1342: '123456789 123456789 123456789 123456789 123456789 -------- '||
1343: '123456789 123456789 123456789 123456789 123456789 -------- '
1344: );
1345: FND_LOG.STRING(5, 'fnd.src.dict.afdict.afdget.start', '5 (last)');
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

Line 1346: FND_LOG.STRING(3, 'ThisWontLog', 'String that wont log');

1342: '123456789 123456789 123456789 123456789 123456789 -------- '||
1343: '123456789 123456789 123456789 123456789 123456789 -------- '
1344: );
1345: FND_LOG.STRING(5, 'fnd.src.dict.afdict.afdget.start', '5 (last)');
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
');

Line 1347: FND_LOG.STRING(1, 'fnd.src.dict.afdict.afdget.start', 'String that wont log 2');

1343: '123456789 123456789 123456789 123456789 123456789 -------- '
1344: );
1345: FND_LOG.STRING(5, 'fnd.src.dict.afdict.afdget.start', '5 (last)');
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

Line 1349: if FND_LOG.TEST(3, 'fnd.src.flex.fdfvl.fdfval.kff.start') then

1345: FND_LOG.STRING(5, 'fnd.src.dict.afdict.afdget.start', '5 (last)');
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;

Line 1356: if FND_LOG.TEST(3, 'fnd.src.something.blah.blah') then

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
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;

Line 1363: if FND_LOG.TEST(2, 'fnd.src.flex.fdfvl.fdfval.kff.start') then

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
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;

Line 1370: FND_LOGVIEW.Display(3, 'fnd.src.%',

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.%',
1371: null, null, null, null, null, 'Find');
1372:
1373: end if; --icx_sec.validatesession
1374:

Line 1380: end fnd_logview;

1376: when others then
1377: htp.p(SQLERRM);
1378: end;
1379:
1380: end fnd_logview;