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_WEBFILE dependencies on FND_WEBFILE

Line 1: package body fnd_webfile as

1: package body fnd_webfile as
2: /* $Header: AFCPFILB.pls 120.7 2007/06/26 13:08:09 ddhulla ship $ */
3:
4:
5: debug varchar2(1) := 'N';

Line 108: * fnd_webfile.process_log = The log of the concurrent process identified

104: * log or output file.
105: *
106: * Arguments:
107: * file_type - Specifies the type of file desired:
108: * fnd_webfile.process_log = The log of the concurrent process identified
109: * by the parameter ID.
110: * fnd_webfile.icm_log = The log of the ICM process identified by ID.
111: * Or, the log of the ICM process that spawned
112: * the concurrent process identified by ID.

Line 110: * fnd_webfile.icm_log = The log of the ICM process identified by ID.

106: * Arguments:
107: * file_type - Specifies the type of file desired:
108: * fnd_webfile.process_log = The log of the concurrent process identified
109: * by the parameter ID.
110: * fnd_webfile.icm_log = The log of the ICM process identified by ID.
111: * Or, the log of the ICM process that spawned
112: * the concurrent process identified by ID.
113: * Or, the log of the most recent ICM process
114: * if ID is null.

Line 115: * fnd_webfile.request_log = The log of the request identified by ID.

111: * Or, the log of the ICM process that spawned
112: * the concurrent process identified by ID.
113: * Or, the log of the most recent ICM process
114: * if ID is null.
115: * fnd_webfile.request_log = The log of the request identified by ID.
116: * fnd_webfile.request_out = The output of the request identified by ID.
117: * fnd_webfile.request_mgr = The log of the concurrent process that ran
118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified

Line 116: * fnd_webfile.request_out = The output of the request identified by ID.

112: * the concurrent process identified by ID.
113: * Or, the log of the most recent ICM process
114: * if ID is null.
115: * fnd_webfile.request_log = The log of the request identified by ID.
116: * fnd_webfile.request_out = The output of the request identified by ID.
117: * fnd_webfile.request_mgr = The log of the concurrent process that ran
118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.

Line 117: * fnd_webfile.request_mgr = The log of the concurrent process that ran

113: * Or, the log of the most recent ICM process
114: * if ID is null.
115: * fnd_webfile.request_log = The log of the request identified by ID.
116: * fnd_webfile.request_out = The output of the request identified by ID.
117: * fnd_webfile.request_mgr = The log of the concurrent process that ran
118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.

Line 119: * fnd_webfile.frd_log = The log of the forms process identified

115: * fnd_webfile.request_log = The log of the request identified by ID.
116: * fnd_webfile.request_out = The output of the request identified by ID.
117: * fnd_webfile.request_mgr = The log of the concurrent process that ran
118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.

Line 121: * fnd_webfile.generic_log = The log file identified by ID.

117: * fnd_webfile.request_mgr = The log of the concurrent process that ran
118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.

Line 122: * fnd_webfile.generic_trc = The trace file identified by ID.

118: * the request identified by ID.
119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.

Line 123: * fnd_webfile.generic_ora = The ora file identified by ID.

119: * fnd_webfile.frd_log = The log of the forms process identified
120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.

Line 124: * fnd_webfile.generic_cfg = The config file identified by ID.

120: * by ID.
121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.
128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.

Line 125: * fnd_webfile.context_file= The context file identified by ID.

121: * fnd_webfile.generic_log = The log file identified by ID.
122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.
128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.
129: *

Line 126: * fnd_webfile.generic_text= Generic file using text transfer mode.

122: * fnd_webfile.generic_trc = The trace file identified by ID.
123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.
128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.
129: *
130: * id - A concurrent process ID, concurrent request ID, or file ID

Line 127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.

123: * fnd_webfile.generic_ora = The ora file identified by ID.
124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.
128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.
129: *
130: * id - A concurrent process ID, concurrent request ID, or file ID
131: * depending on the file type specified.

Line 128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.

124: * fnd_webfile.generic_cfg = The config file identified by ID.
125: * fnd_webfile.context_file= The context file identified by ID.
126: * fnd_webfile.generic_text= Generic file using text transfer mode.
127: * fnd_webfile.generic_binary = Generic file using binary transfer mode.
128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.
129: *
130: * id - A concurrent process ID, concurrent request ID, or file ID
131: * depending on the file type specified.
132: * For fnd_webfile.context_file,fnd_webfile.generic_text,

Line 132: * For fnd_webfile.context_file,fnd_webfile.generic_text,

128: * fnd_webfile.request_xml_output = The XML output of Concurrent Request.
129: *
130: * id - A concurrent process ID, concurrent request ID, or file ID
131: * depending on the file type specified.
132: * For fnd_webfile.context_file,fnd_webfile.generic_text,
133: * fnd_webfile.generic_binary this value is null.
134: *
135: * gwyuid - The value of the environment variable GWYUID used in
136: * constructing the URL. No longer used.

Line 133: * fnd_webfile.generic_binary this value is null.

129: *
130: * id - A concurrent process ID, concurrent request ID, or file ID
131: * depending on the file type specified.
132: * For fnd_webfile.context_file,fnd_webfile.generic_text,
133: * fnd_webfile.generic_binary this value is null.
134: *
135: * gwyuid - The value of the environment variable GWYUID used in
136: * constructing the URL. No longer used.
137: *

Line 230: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

226: where concurrent_process_id = id;
227: exception
228: when no_data_found then
229: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');
230: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
231: fnd_message.set_token('CPID', id);
232: return null;
233: end;
234: if (fname is null) then

Line 265: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

261: and p.concurrent_queue_id = 1 ) ));
262: exception
263: when no_data_found then
264: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');
265: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
266: fnd_message.set_token('CPID', id);
267: return null;
268: end;
269: if (fname is null) then

Line 286: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

282: req_id := id;
283: exception
284: when no_data_found then
285: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
286: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
287: fnd_message.set_token('REQUEST', id);
288: return null;
289: end;
290: if (fname is null) then

Line 358: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

354: and fcr.request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id);
355: exception
356: when no_data_found then
357: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
358: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
359: fnd_message.set_token('REQUEST', id);
360: return null;
361: end;
362:

Line 414: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

410: req_id := id;
411: exception
412: when no_data_found then
413: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
414: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
415: fnd_message.set_token('REQUEST', id);
416: return null;
417: end;
418: if (save_out = 'N') then

Line 448: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

444: the manager row was missing if cpid is null. */
445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
448: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
449: fnd_message.set_token('REQUEST', id);
450: return null;
451: end;
452: if (cpid is null) then

Line 454: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

450: return null;
451: end;
452: if (cpid is null) then
453: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');
454: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
455: fnd_message.set_token('CPID', controlling_mgr);
456: return null;
457: end if;
458: if (fname is null) then

Line 569: temp_id := fnd_webfile.create_id(fname,

565: if ( file_type = generic_binary ) then
566: x_mode := 'BINARY';
567: end if;
568:
569: temp_id := fnd_webfile.create_id(fname,
570: svc,
571: expire_time,
572: mtype,
573: req_id,

Line 614: generic_error('fnd_webfile.get_url', SQLCODE, SQLERRM);

610: RETURN url;
611:
612: exception
613: when others then
614: generic_error('fnd_webfile.get_url', SQLCODE, SQLERRM);
615: return null;
616: end get_url;
617:
618:

Line 790: generic_error('fnd_webfile.create_id', SQLCODE, SQLERRM);

786: return my_file_id;
787:
788: exception
789: when OTHERS then
790: generic_error('fnd_webfile.create_id', SQLCODE, SQLERRM);
791: rollback;
792: return null;
793:
794: end create_id;