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.

[Home] [Help]

APPS.FND_GFM dependencies on FND_PROFILE

Line 120: export_mime := fnd_profile.value('FND_EXPORT_MIME_TYPE');

116: -- purge_on_view is TRUE then exporting
117:
118: if purge_on_view then
119:
120: export_mime := fnd_profile.value('FND_EXPORT_MIME_TYPE');
121:
122: if export_mime = 'text/tab-separated-values' then
123: file_ext := '.tsv';
124: elsif

Line 171: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;

167: if (modplsql) then
168: url := fnd_web_config.trail_slash(gfm_agent)||'fndgfm/fnd_gfm.get/'||access_id||'/'||file_id||'/'||file_name;
169: else
170: if (authenticate) then
171: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;
172: else
173: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;
174: end if;
175:

Line 173: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;

169: else
170: if (authenticate) then
171: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;
172: else
173: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;
174: end if;
175:
176: end if;
177: end if;

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

202: sec_grp_id number :=0;
203: begin
204: if (fnd_gfm.getRelease = 12) then
205:
206: user_id := fnd_profile.value('USER_ID');
207: resp_id := fnd_profile.value('RESP_ID');
208: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
209: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
210:

Line 207: resp_id := fnd_profile.value('RESP_ID');

203: begin
204: if (fnd_gfm.getRelease = 12) then
205:
206: user_id := fnd_profile.value('USER_ID');
207: resp_id := fnd_profile.value('RESP_ID');
208: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
209: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
210:
211: params_passed := 'access_id'||access_id;

Line 208: resp_appl_id := fnd_profile.value('RESP_APPL_ID');

204: if (fnd_gfm.getRelease = 12) then
205:
206: user_id := fnd_profile.value('USER_ID');
207: resp_id := fnd_profile.value('RESP_ID');
208: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
209: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
210:
211: params_passed := 'access_id'||access_id;
212:

Line 209: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');

205:
206: user_id := fnd_profile.value('USER_ID');
207: resp_id := fnd_profile.value('RESP_ID');
208: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
209: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
210:
211: params_passed := 'access_id'||access_id;
212:
213: begin

Line 389: if fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT') is null then

385:
386: -- bug 3045375, added if to check length of blob.
387: -- bug 4279252. added UPLOAD_FILE_SIZE_LIMIT check.
388:
389: if fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT') is null then
390: ufslim := bloblength;
391: else
392: /* The profile is not limited to being a numeric value. Stripping off any
393: reference to kilobytes. */

Line 395: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then

391: else
392: /* The profile is not limited to being a numeric value. Stripping off any
393: reference to kilobytes. */
394:
395: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
396: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
397: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
398: else
399: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');

Line 396: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,

392: /* The profile is not limited to being a numeric value. Stripping off any
393: reference to kilobytes. */
394:
395: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
396: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
397: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
398: else
399: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
400: end if;

Line 397: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);

393: reference to kilobytes. */
394:
395: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
396: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
397: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
398: else
399: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
400: end if;
401:

Line 399: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');

395: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
396: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
397: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
398: else
399: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
400: end if;
401:
402: /* Bug 6490050 - profile is defined to be in KB so we need to convert
403: here. Consistent with the fwk code. */

Line 1014: fnd_profile.get_specific('FND_NATIVE_CLIENT_ENCODING',fnd_global.user_id,NULL,NULL,nce,bb);

1010: cs := substr(ct, eq, semi-eq);
1011: end if;
1012: end if;
1013:
1014: fnd_profile.get_specific('FND_NATIVE_CLIENT_ENCODING',fnd_global.user_id,NULL,NULL,nce,bb);
1015:
1016: if (pn = 'export' and nce is not null) then
1017: cs := fnd_gfm.oracle_to_iana(nce);
1018: nce := 'american_america.'||nce;

Line 1237: fnd_profile.get('FND_EXPORT_PURGE_ON_VIEW',p_purge_on_view);

1233: from fnd_lobs
1234: where file_id = l_file_id;
1235:
1236: if (prog_name = 'export' and exp_date is not null) then
1237: fnd_profile.get('FND_EXPORT_PURGE_ON_VIEW',p_purge_on_view);
1238:
1239: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1240: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Export - purge on view: '||p_purge_on_view);
1241: end if;

Line 1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');

1596: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1597: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Begin');
1598: end if;
1599:
1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');
1601:
1602: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1603: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is: '||nvl(l_dflt_allow,'Profile not set'));
1604: end if;