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

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

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

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

293: fnd_message.set_token('REQUEST', id);
294: return null;
295: end;
296: if (fname is null) then
297: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');
298: fnd_message.set_token('REQUEST_ID', id);
299: return null;
300: end if;
301:

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

294: return null;
295: end;
296: if (fname is null) then
297: fnd_message.set_name('FND', 'SYSTEM-REQUEST LOGFILE NULL');
298: fnd_message.set_token('REQUEST_ID', id);
299: return null;
300: end if;
301:
302: elsif (file_type = request_out or file_type = request_xml_output) then

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

343: and RO.file_type = fmt.file_format_code
344: and rownum = 1;
345: exception
346: when no_data_found then
347: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
348: fnd_message.set_token('REQUEST_ID', id);
349: return null;
350: end;
351: else /* Only a REPRINT request */

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

344: and rownum = 1;
345: exception
346: when no_data_found then
347: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
348: fnd_message.set_token('REQUEST_ID', id);
349: return null;
350: end;
351: else /* Only a REPRINT request */
352: begin

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

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

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

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

376: and RO.file_type = fmt.file_format_code
377: and rownum = 1;
378: exception
379: when no_data_found then
380: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
381: fnd_message.set_token('REQUEST_ID', id);
382: return null;
383: end;
384: else /* Parent program is not layout enabled*/

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

377: and rownum = 1;
378: exception
379: when no_data_found then
380: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
381: fnd_message.set_token('REQUEST_ID', id);
382: return null;
383: end;
384: else /* Parent program is not layout enabled*/
385: begin

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

390: and fcr.output_file_type = fmt.file_format_code
391: and rownum = 1;
392: exception
393: when no_data_found then
394: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
395: fnd_message.set_token('REQUEST_ID', id);
396: return null;
397: end;
398: end if;

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

391: and rownum = 1;
392: exception
393: when no_data_found then
394: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
395: fnd_message.set_token('REQUEST_ID', id);
396: return null;
397: end;
398: end if;
399: end if;

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

406: and RO.file_type = fmt.file_format_code
407: and rownum = 1;
408: exception
409: when no_data_found then
410: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
411: fnd_message.set_token('REQUEST_ID', id);
412: return null;
413: end;
414: end if;

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

407: and rownum = 1;
408: exception
409: when no_data_found then
410: fnd_message.set_name('FND', 'CONC-NO OUTPUT FILE');
411: fnd_message.set_token('REQUEST_ID', id);
412: return null;
413: end;
414: end if;
415:

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

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

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

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

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

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

425: fnd_message.set_name('FND', 'CONC-Output file not saved');
426: return null;
427: end if;
428: if (fname is null) then
429: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');
430: fnd_message.set_token('REQUEST_ID', id);
431: return null;
432: end if;
433:

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

426: return null;
427: end if;
428: if (fname is null) then
429: fnd_message.set_name('FND', 'SYSTEM-REQUEST OUTFILE NULL');
430: fnd_message.set_token('REQUEST_ID', id);
431: return null;
432: end if;
433:
434: /* Decide the transfer mode, after getting the fnd_file_format datamodal

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

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

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

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

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

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

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

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

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

461: fnd_message.set_token('CPID', controlling_mgr);
462: return null;
463: end if;
464: if (fname is null) then
465: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
466: fnd_message.set_token('PROCESS_ID', cpid);
467: return null;
468: end if;
469:

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

462: return null;
463: end if;
464: if (fname is null) then
465: fnd_message.set_name('FND', 'SYSTEM-MANAGER LOGFILE NULL');
466: fnd_message.set_token('PROCESS_ID', cpid);
467: return null;
468: end if;
469:
470: elsif (file_type = frd_log) then

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

476: EXECUTE IMMEDIATE sqlstmt INTO fname USING id;
477:
478: exception
479: when no_data_found then
480: fnd_message.set_name('FND', 'CONC-ROW MISSING');
481: return null;
482:
483: end;
484: if (fname is null) then

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

481: return null;
482:
483: end;
484: if (fname is null) then
485: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');
486: return null;
487: end if;
488:
489: elsif (file_type >= generic_log and file_type <= generic_cfg) then

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

497: ext := substr(fname, (pos + 1));
498:
499: exception
500: when no_data_found then
501: fnd_message.set_name('FND', 'CONC-ROW MISSING');
502: return null;
503: end;
504: if (fname is null) then
505: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');

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

501: fnd_message.set_name('FND', 'CONC-ROW MISSING');
502: return null;
503: end;
504: if (fname is null) then
505: fnd_message.set_name('FND', 'SYSTEM-LOGFILE NULL');
506: return null;
507: end if;
508:
509: if(file_type = generic_log) then

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

516: cmpext := 'CFG';
517: end if;
518:
519: if (upper(ext) <> cmpext) then
520: fnd_message.set_name('FND', 'CONC-BAD EXTENSION');
521: return null;
522: end if;
523:
524: elsif ( file_type in (context_file, generic_text, generic_binary) ) then

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

530: and node_name = dest_node
531: and rownum = 1;
532: exception
533: when no_data_found then
534: fnd_message.set_name('FND', 'CONC-ROW MISSING');
535: return null;
536: end;
537: end if;
538:

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

647: * req_log - Output URL for the request log.
648: *
649: * mgr_log - Output URL for the manager log.
650: *
651: * Returns FALSE on error. Check the FND message stack.
652: */
653:
654: function get_req_log_urls( request_id IN number,
655: gwyuid IN varchar2,

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

732:
733: if allow_enc = 'Y' then
734: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
735: if (nc_encoding is null) then
736: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
737: fnd_message.set_token('ROUTINE', 'CREATE_ID');
738: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
739: fnd_message.set_token('REASON', 'Check if profile is set');
740: end if;

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

733: if allow_enc = 'Y' then
734: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
735: if (nc_encoding is null) then
736: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
737: fnd_message.set_token('ROUTINE', 'CREATE_ID');
738: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
739: fnd_message.set_token('REASON', 'Check if profile is set');
740: end if;
741: end if;

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

734: fnd_profile.get('FND_NATIVE_CLIENT_ENCODING', nc_encoding);
735: if (nc_encoding is null) then
736: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
737: fnd_message.set_token('ROUTINE', 'CREATE_ID');
738: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
739: fnd_message.set_token('REASON', 'Check if profile is set');
740: end if;
741: end if;
742: end if;

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

735: if (nc_encoding is null) then
736: fnd_message.set_name('CONC', 'CONC-Cannot get profile value');
737: fnd_message.set_token('ROUTINE', 'CREATE_ID');
738: fnd_message.set_token('PROFILE', 'FND_NATIVE_CLIENT_ENCODING');
739: fnd_message.set_token('REASON', 'Check if profile is set');
740: end if;
741: end if;
742: end if;
743: