[Home] [Help]
1: package body fnd_webfile as
2: /* $Header: AFCPFILB.pls 120.7.12010000.3 2010/03/19 11:20:54 mburra ship $ */
3:
4:
5: debug varchar2(1) := 'N';
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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: *
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
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.
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,
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.
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: *
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
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
288: req_id := id;
289: exception
290: when no_data_found then
291: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
292: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
293: fnd_message.set_token('REQUEST', id);
294: return null;
295: end;
296: if (fname is null) then
360: and fcr.request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id);
361: exception
362: when no_data_found then
363: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
364: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
365: fnd_message.set_token('REQUEST', id);
366: return null;
367: end;
368:
416: req_id := id;
417: exception
418: when no_data_found then
419: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
420: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
421: fnd_message.set_token('REQUEST', id);
422: return null;
423: end;
424: if (save_out = 'N') then
450: the manager row was missing if cpid is null. */
451: exception
452: when no_data_found then
453: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
454: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
455: fnd_message.set_token('REQUEST', id);
456: return null;
457: end;
458: if (cpid is null) then
456: return null;
457: end;
458: if (cpid is null) then
459: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');
460: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
461: fnd_message.set_token('CPID', controlling_mgr);
462: return null;
463: end if;
464: if (fname is null) then
571: if ( file_type = generic_binary ) then
572: x_mode := 'BINARY';
573: end if;
574:
575: temp_id := fnd_webfile.create_id(fname,
576: svc,
577: expire_time,
578: mtype,
579: req_id,
616: RETURN url;
617:
618: exception
619: when others then
620: generic_error('fnd_webfile.get_url', SQLCODE, SQLERRM);
621: return null;
622: end get_url;
623:
624:
792: return my_file_id;
793:
794: exception
795: when OTHERS then
796: generic_error('fnd_webfile.create_id', SQLCODE, SQLERRM);
797: rollback;
798: return null;
799:
800: end create_id;