eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_LOGVIEW dependencies on FND_PROFILE

Line 72: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',

68: htp.p('Access denied; function FND_LOGPREFS required.');
69: return;
70: end if;
71:
72: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',
73: user_id_z => -9999999,
74: responsibility_id_z => -9999999,
75: application_id_z => -9999999,
76: val_z => aflog_enabled_txt,

Line 78: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',

74: responsibility_id_z => -9999999,
75: application_id_z => -9999999,
76: val_z => aflog_enabled_txt,
77: defined_z => result);
78: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',
79: user_id_z => -9999999,
80: responsibility_id_z => -9999999,
81: application_id_z => -9999999,
82: val_z => aflog_filename,

Line 84: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',

80: responsibility_id_z => -9999999,
81: application_id_z => -9999999,
82: val_z => aflog_filename,
83: defined_z => result);
84: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',
85: user_id_z => -9999999,
86: responsibility_id_z => -9999999,
87: application_id_z => -9999999,
88: val_z => aflog_level,

Line 90: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_MODULE',

86: responsibility_id_z => -9999999,
87: application_id_z => -9999999,
88: val_z => aflog_level,
89: defined_z => result);
90: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_MODULE',
91: user_id_z => -9999999,
92: responsibility_id_z => -9999999,
93: application_id_z => -9999999,
94: val_z => aflog_module,

Line 103: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',

99: aflog_enabled := FALSE;
100: end if;
101: elsif(user_id_x is not null) then
102: /* Getting profile values for a particular user (not current user)*/
103: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',
104: user_id_z => user_id_x,
105: val_z => aflog_enabled_txt,
106: defined_z => result);
107: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',

Line 107: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',

103: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_ENABLED',
104: user_id_z => user_id_x,
105: val_z => aflog_enabled_txt,
106: defined_z => result);
107: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',
108: user_id_z => user_id_x,
109: val_z => aflog_filename,
110: defined_z => result);
111: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',

Line 111: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',

107: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_FILENAME',
108: user_id_z => user_id_x,
109: val_z => aflog_filename,
110: defined_z => result);
111: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',
112: user_id_z => user_id_x,
113: val_z => aflog_level,
114: defined_z => result);
115: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_MODULE',

Line 115: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_MODULE',

111: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_LEVEL',
112: user_id_z => user_id_x,
113: val_z => aflog_level,
114: defined_z => result);
115: FND_PROFILE.GET_SPECIFIC(name_z => 'AFLOG_MODULE',
116: user_id_z => user_id_x,
117: val_z => aflog_module,
118: defined_z => result);
119: if (aflog_enabled_txt = 'Y') then

Line 125: if (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') then

121: else
122: aflog_enabled := FALSE;
123: end if;
124: else /* Getting profile values for the current user */
125: if (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') then
126: aflog_enabled_txt := 'Y';
127: aflog_enabled := TRUE;
128: else
129: aflog_enabled_txt := 'N';

Line 132: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');

128: else
129: aflog_enabled_txt := 'N';
130: aflog_enabled := FALSE;
131: end if;
132: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
133: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
134: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
135: end if;
136:

Line 133: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));

129: aflog_enabled_txt := 'N';
130: aflog_enabled := FALSE;
131: end if;
132: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
133: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
134: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
135: end if;
136:
137: if(AFLOG_ENABLED) then

Line 134: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');

130: aflog_enabled := FALSE;
131: end if;
132: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
133: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
134: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
135: end if;
136:
137: if(AFLOG_ENABLED) then
138: AFLOG_ENABLED_TXT := 'Checked';

Line 412: fnd_profile.value('USERNAME')||'">:

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

Line 1039: 'in the fnd_profile_options table and if not, use the '||

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;
1042: end;
1043:

Line 1107: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'SITE');

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');
1108: else
1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');
1110: end if;
1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');

Line 1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');

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');
1108: else
1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');
1110: end if;
1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');
1112: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'SITE');
1113: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'SITE');

Line 1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');

1107: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'SITE');
1108: else
1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');
1110: end if;
1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');
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;

Line 1112: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'SITE');

1108: else
1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');
1110: end if;
1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');
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;

Line 1113: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'SITE');

1109: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'SITE');
1110: end if;
1111: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'SITE');
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. ');

Line 1125: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'USER', user_id_x);

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
1127: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'USER', user_id_x);
1128: end if;
1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',

Line 1127: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'USER', user_id_x);

1123: end if;
1124: if(ENABLED = 'on') then
1125: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'USER', user_id_x);
1126: else
1127: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'USER', user_id_x);
1128: end if;
1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',
1130: user_id_x);
1131: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'USER', user_id_x);

Line 1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',

1125: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'Y', 'USER', user_id_x);
1126: else
1127: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'USER', user_id_x);
1128: end if;
1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',
1130: user_id_x);
1131: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'USER', user_id_x);
1132: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'USER',
1133: user_id_x);

Line 1131: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'USER', user_id_x);

1127: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', 'N', 'USER', user_id_x);
1128: end if;
1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',
1130: user_id_x);
1131: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'USER', user_id_x);
1132: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'USER',
1133: user_id_x);
1134: internal_check_results(result1, result2, result3, result4);
1135: commit;

Line 1132: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', THE_MODULE, 'USER',

1128: end if;
1129: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', THE_FILENAME, 'USER',
1130: user_id_x);
1131: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', LEVEL, 'USER', user_id_x);
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;

Line 1139: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', '', 'SITE');

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');
1142: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'SITE');
1143: internal_check_results(result1, result2, result3, result4);

Line 1140: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', '', 'SITE');

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');
1142: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'SITE');
1143: internal_check_results(result1, result2, result3, result4);
1144: commit;

Line 1141: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'SITE');

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');
1142: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'SITE');
1143: internal_check_results(result1, result2, result3, result4);
1144: commit;
1145: fnd_log_repository.init;

Line 1142: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'SITE');

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

Line 1153: result1 := FND_PROFILE.SAVE('AFLOG_ENABLED', '', 'USER', user_id_x);

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);
1156: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'USER', user_id_x);
1157: internal_check_results(result1, result2, result3, result4);

Line 1154: result2 := FND_PROFILE.SAVE('AFLOG_FILENAME', '', 'USER', user_id_x);

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);
1156: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'USER', user_id_x);
1157: internal_check_results(result1, result2, result3, result4);
1158: commit;

Line 1155: result3 := FND_PROFILE.SAVE('AFLOG_LEVEL', '', 'USER', user_id_x);

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

Line 1156: result4 := FND_PROFILE.SAVE('AFLOG_MODULE', '', 'USER', user_id_x);

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

Line 1283: if (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') then

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:
1283: if (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') then
1284: aflog_enabled := TRUE;
1285: else
1286: aflog_enabled := FALSE;
1287: end if;

Line 1289: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');

1285: else
1286: aflog_enabled := FALSE;
1287: end if;
1288:
1289: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
1290: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1291: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
1292: user_id := fnd_profile.value('USER_ID');
1293: session_id := icx_sec.getsessioncookie();

Line 1290: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));

1286: aflog_enabled := FALSE;
1287: end if;
1288:
1289: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
1290: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
1291: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');
1292: user_id := fnd_profile.value('USER_ID');
1293: session_id := icx_sec.getsessioncookie();
1294:

Line 1291: aflog_module := FND_PROFILE.VALUE('AFLOG_MODULE');

1287: end if;
1288:
1289: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
1290: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
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);

Line 1292: user_id := fnd_profile.value('USER_ID');

1288:
1289: aflog_filename := FND_PROFILE.VALUE('AFLOG_FILENAME');
1290: aflog_level := to_number(FND_PROFILE.VALUE('AFLOG_LEVEL'));
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));