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_MESSAGE

Line 18: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

14: procedure GENERIC_ERROR(routine in varchar2,
15: errcode in number,
16: errmsg in varchar2) is
17: begin
18: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
19: fnd_message.set_token('ROUTINE', routine);
20: fnd_message.set_token('ERRNO', errcode);
21: fnd_message.set_token('REASON', errmsg);
22: end;

Line 19: fnd_message.set_token('ROUTINE', routine);

15: errcode in number,
16: errmsg in varchar2) is
17: begin
18: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
19: fnd_message.set_token('ROUTINE', routine);
20: fnd_message.set_token('ERRNO', errcode);
21: fnd_message.set_token('REASON', errmsg);
22: end;
23:

Line 20: fnd_message.set_token('ERRNO', errcode);

16: errmsg in varchar2) is
17: begin
18: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
19: fnd_message.set_token('ROUTINE', routine);
20: fnd_message.set_token('ERRNO', errcode);
21: fnd_message.set_token('REASON', errmsg);
22: end;
23:
24: /*--

Line 21: fnd_message.set_token('REASON', errmsg);

17: begin
18: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
19: fnd_message.set_token('ROUTINE', routine);
20: fnd_message.set_token('ERRNO', errcode);
21: fnd_message.set_token('REASON', errmsg);
22: end;
23:
24: /*--
25: *-- UPDATE SVC (Internal)

Line 154: * Returns NULL on error. Check the FND message stack.

150: * page_no - Current page number
151: *
152: * page_size - Number of lines in a page
153: *
154: * Returns NULL on error. Check the FND message stack.
155: *
156: * Note that gwyuid and two_task are no longer used. They are retained for
157: * compatibility only.
158: *

Line 215: fnd_message.set_name('FND', 'FS-NO URL');

211: base_type := 'WEB';
212: END IF;
213:
214: if (base is null) then
215: fnd_message.set_name('FND', 'FS-NO URL');
216: return null;
217: end if;
218:
219:

Line 229: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');

225: from fnd_concurrent_processes
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;

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 231: fnd_message.set_token('CPID', 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
235: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

Line 235: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

231: fnd_message.set_token('CPID', id);
232: return null;
233: end;
234: if (fname is null) then
235: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
236: fnd_message.set_token('PROCESS_ID', id);
237: return null;
238: end if;
239:

Line 236: fnd_message.set_token('PROCESS_ID', id);

232: return null;
233: end;
234: if (fname is null) then
235: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
236: fnd_message.set_token('PROCESS_ID', id);
237: return null;
238: end if;
239:
240: elsif (file_type = icm_log) then

Line 264: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');

260: where p.queue_application_id = 0
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;

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 266: fnd_message.set_token('CPID', id);

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
270: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

Line 270: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

266: fnd_message.set_token('CPID', id);
267: return null;
268: end;
269: if (fname is null) then
270: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
271: fnd_message.set_token('PROCESS_ID', id);
272: return null;
273: end if;
274:

Line 271: fnd_message.set_token('PROCESS_ID', id);

267: return null;
268: end;
269: if (fname is null) then
270: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
271: fnd_message.set_token('PROCESS_ID', id);
272: return null;
273: end if;
274:
275: elsif (file_type = request_log) then

Line 285: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');

281: where request_id = id;
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;

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 287: fnd_message.set_token('REQUEST', 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
291: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');

Line 291: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');

287: fnd_message.set_token('REQUEST', id);
288: return null;
289: end;
290: if (fname is null) then
291: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');
292: fnd_message.set_token('REQUEST_ID', id);
293: return null;
294: end if;
295:

Line 292: fnd_message.set_token('REQUEST_ID', id);

288: return null;
289: end;
290: if (fname is null) then
291: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');
292: fnd_message.set_token('REQUEST_ID', id);
293: return null;
294: end if;
295:
296: elsif (file_type = request_out or file_type = request_xml_output) then

Line 341: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');

337: and RO.file_type = fmt.file_format_code
338: and rownum = 1;
339: exception
340: when no_data_found then
341: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
342: fnd_message.set_token('REQUEST_ID', id);
343: return null;
344: end;
345: else /* Only a REPRINT request */

Line 342: fnd_message.set_token('REQUEST_ID', id);

338: and rownum = 1;
339: exception
340: when no_data_found then
341: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
342: fnd_message.set_token('REQUEST_ID', id);
343: return null;
344: end;
345: else /* Only a REPRINT request */
346: begin

Line 357: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');

353: and fcp.application_id = a.application_id
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;

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 359: fnd_message.set_token('REQUEST', 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:
363: /* Check if the parent program is layout enabled */

Line 374: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');

370: and RO.file_type = fmt.file_format_code
371: and rownum = 1;
372: exception
373: when no_data_found then
374: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
375: fnd_message.set_token('REQUEST_ID', id);
376: return null;
377: end;
378: else /* Parent program is not layout enabled*/

Line 375: fnd_message.set_token('REQUEST_ID', id);

371: and rownum = 1;
372: exception
373: when no_data_found then
374: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
375: fnd_message.set_token('REQUEST_ID', id);
376: return null;
377: end;
378: else /* Parent program is not layout enabled*/
379: begin

Line 388: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');

384: and fcr.output_file_type = fmt.file_format_code
385: and rownum = 1;
386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
389: fnd_message.set_token('REQUEST_ID', id);
390: return null;
391: end;
392: end if;

Line 389: fnd_message.set_token('REQUEST_ID', id);

385: and rownum = 1;
386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
389: fnd_message.set_token('REQUEST_ID', id);
390: return null;
391: end;
392: end if;
393: end if;

Line 404: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');

400: and RO.file_type = fmt.file_format_code
401: and rownum = 1;
402: exception
403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
405: fnd_message.set_token('REQUEST_ID', id);
406: return null;
407: end;
408: end if;

Line 405: fnd_message.set_token('REQUEST_ID', id);

401: and rownum = 1;
402: exception
403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
405: fnd_message.set_token('REQUEST_ID', id);
406: return null;
407: end;
408: end if;
409:

Line 413: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');

409:
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;

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 415: fnd_message.set_token('REQUEST', 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
419: fnd_message.set_name('FND', 'CONC-Output file not saved');

Line 419: fnd_message.set_name('FND', 'CONC-Output file not saved');

415: fnd_message.set_token('REQUEST', id);
416: return null;
417: end;
418: if (save_out = 'N') then
419: fnd_message.set_name('FND', 'CONC-Output file not saved');
420: return null;
421: end if;
422: if (fname is null) then
423: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');

Line 423: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');

419: fnd_message.set_name('FND', 'CONC-Output file not saved');
420: return null;
421: end if;
422: if (fname is null) then
423: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');
424: fnd_message.set_token('REQUEST_ID', id);
425: return null;
426: end if;
427:

Line 424: fnd_message.set_token('REQUEST_ID', id);

420: return null;
421: end if;
422: if (fname is null) then
423: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');
424: fnd_message.set_token('REQUEST_ID', id);
425: return null;
426: end if;
427:
428: /* Decide the transfer mode, after getting the fnd_file_format datamodal

Line 447: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');

443: row is missing, when the manager row is missing. We know that
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;

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 449: fnd_message.set_token('REQUEST', id);

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
453: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');

Line 453: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');

449: fnd_message.set_token('REQUEST', id);
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;

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 455: fnd_message.set_token('CPID', controlling_mgr);

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
459: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

Line 459: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');

455: fnd_message.set_token('CPID', controlling_mgr);
456: return null;
457: end if;
458: if (fname is null) then
459: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
460: fnd_message.set_token('PROCESS_ID', cpid);
461: return null;
462: end if;
463:

Line 460: fnd_message.set_token('PROCESS_ID', cpid);

456: return null;
457: end if;
458: if (fname is null) then
459: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
460: fnd_message.set_token('PROCESS_ID', cpid);
461: return null;
462: end if;
463:
464: elsif (file_type = frd_log) then

Line 474: fnd_message.set_name('FND', 'CONC-ROW MISSING');

470: EXECUTE IMMEDIATE sqlstmt INTO fname USING id;
471:
472: exception
473: when no_data_found then
474: fnd_message.set_name('FND', 'CONC-ROW MISSING');
475: return null;
476:
477: end;
478: if (fname is null) then

Line 479: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');

475: return null;
476:
477: end;
478: if (fname is null) then
479: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');
480: return null;
481: end if;
482:
483: elsif (file_type >= generic_log and file_type <= generic_cfg) then

Line 495: fnd_message.set_name('FND', 'CONC-ROW MISSING');

491: ext := substr(fname, (pos + 1));
492:
493: exception
494: when no_data_found then
495: fnd_message.set_name('FND', 'CONC-ROW MISSING');
496: return null;
497: end;
498: if (fname is null) then
499: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');

Line 499: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');

495: fnd_message.set_name('FND', 'CONC-ROW MISSING');
496: return null;
497: end;
498: if (fname is null) then
499: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');
500: return null;
501: end if;
502:
503: if(file_type = generic_log) then

Line 514: fnd_message.set_name('FND', 'CONC-BAD EXTENSION');

510: cmpext := 'CFG';
511: end if;
512:
513: if (upper(ext) <> cmpext) then
514: fnd_message.set_name('FND', 'CONC-BAD EXTENSION');
515: return null;
516: end if;
517:
518: elsif ( file_type in (context_file, generic_text, generic_binary) ) then

Line 528: fnd_message.set_name('FND', 'CONC-ROW MISSING');

524: and node_name = dest_node
525: and rownum = 1;
526: exception
527: when no_data_found then
528: fnd_message.set_name('FND', 'CONC-ROW MISSING');
529: return null;
530: end;
531: end if;
532:

Line 645: * Returns FALSE on error. Check the FND message stack.

641: * req_log - Output URL for the request log.
642: *
643: * mgr_log - Output URL for the manager log.
644: *
645: * Returns FALSE on error. Check the FND message stack.
646: */
647:
648: function get_req_log_urls( request_id IN number,
649: gwyuid IN varchar2,

Line 730: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');

726:
727: if allow_enc = 'Y' then
728: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
729: if (nc_encoding is null) then
730: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
731: fnd_message.set_token('ROUTINE', 'CREATE_ID');
732: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
733: fnd_message.set_token('REASON', 'Check if profile is set');
734: end if;

Line 731: fnd_message.set_token('ROUTINE', 'CREATE_ID');

727: if allow_enc = 'Y' then
728: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
729: if (nc_encoding is null) then
730: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
731: fnd_message.set_token('ROUTINE', 'CREATE_ID');
732: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
733: fnd_message.set_token('REASON', 'Check if profile is set');
734: end if;
735: end if;

Line 732: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');

728: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
729: if (nc_encoding is null) then
730: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
731: fnd_message.set_token('ROUTINE', 'CREATE_ID');
732: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
733: fnd_message.set_token('REASON', 'Check if profile is set');
734: end if;
735: end if;
736: end if;

Line 733: fnd_message.set_token('REASON', 'Check if profile is set');

729: if (nc_encoding is null) then
730: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
731: fnd_message.set_token('ROUTINE', 'CREATE_ID');
732: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
733: fnd_message.set_token('REASON', 'Check if profile is set');
734: end if;
735: end if;
736: end if;
737: