DBA Data[Home] [Help]

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.12010000.3 2010/03/19 11:20:54 mburra 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 292: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');

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

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

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:

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

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

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

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

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

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

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

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,

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

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:

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

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;