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_MLS_REQUEST dependencies on FND_MESSAGE

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

11: function GEN_ERROR(routine in varchar2,
12: errcode in number,
13: errmsg in varchar2) return varchar2 is
14: begin
15: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
16: fnd_message.set_token('ROUTINE', routine);
17: fnd_message.set_token('ERRNO', errcode);
18: fnd_message.set_token('REASON', errmsg);
19: return substr( fnd_message.get, 1, 240);

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

12: errcode in number,
13: errmsg in varchar2) return varchar2 is
14: begin
15: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
16: fnd_message.set_token('ROUTINE', routine);
17: fnd_message.set_token('ERRNO', errcode);
18: fnd_message.set_token('REASON', errmsg);
19: return substr( fnd_message.get, 1, 240);
20: end;

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

13: errmsg in varchar2) return varchar2 is
14: begin
15: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
16: fnd_message.set_token('ROUTINE', routine);
17: fnd_message.set_token('ERRNO', errcode);
18: fnd_message.set_token('REASON', errmsg);
19: return substr( fnd_message.get, 1, 240);
20: end;
21:

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

14: begin
15: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
16: fnd_message.set_token('ROUTINE', routine);
17: fnd_message.set_token('ERRNO', errcode);
18: fnd_message.set_token('REASON', errmsg);
19: return substr( fnd_message.get, 1, 240);
20: end;
21:
22: /*

Line 19: return substr( fnd_message.get, 1, 240);

15: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
16: fnd_message.set_token('ROUTINE', routine);
17: fnd_message.set_token('ERRNO', errcode);
18: fnd_message.set_token('REASON', errmsg);
19: return substr( fnd_message.get, 1, 240);
20: end;
21:
22: /*
23: ** FNDMLSUB

Line 217: fnd_message.set_name('FND','CONC-Missing program');

213: and e.application_id(+) = p.mls_executable_app_id;
214:
215: exception
216: when NO_DATA_FOUND then
217: fnd_message.set_name('FND','CONC-Missing program');
218: errbuf := substr(fnd_message.get,1, 240);
219: retcode := 2;
220: return;
221: end;

Line 218: errbuf := substr(fnd_message.get,1, 240);

214:
215: exception
216: when NO_DATA_FOUND then
217: fnd_message.set_name('FND','CONC-Missing program');
218: errbuf := substr(fnd_message.get,1, 240);
219: retcode := 2;
220: return;
221: end;
222:

Line 230: fnd_message.set_name('FND', 'CONC-Before lang function');

226: fnd_request_info.initialize;
227:
228: fnd_file.put_line(fnd_file.log,
229: '+---------------------------------------------------------------------------+');
230: fnd_message.set_name('FND', 'CONC-Before lang function');
231: fnd_message.set_token('FUNCTION', funct);
232: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
233: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
234:

Line 231: fnd_message.set_token('FUNCTION', funct);

227:
228: fnd_file.put_line(fnd_file.log,
229: '+---------------------------------------------------------------------------+');
230: fnd_message.set_name('FND', 'CONC-Before lang function');
231: fnd_message.set_token('FUNCTION', funct);
232: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
233: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
234:
235: fcursor := 'begin :r := '||funct||'; end;';

Line 232: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||

228: fnd_file.put_line(fnd_file.log,
229: '+---------------------------------------------------------------------------+');
230: fnd_message.set_name('FND', 'CONC-Before lang function');
231: fnd_message.set_token('FUNCTION', funct);
232: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
233: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
234:
235: fcursor := 'begin :r := '||funct||'; end;';
236: begin

Line 250: fnd_message.set_name('FND', 'CONC-After lang function');

246: retcode := 2;
247: return;
248: end;
249:
250: fnd_message.set_name('FND', 'CONC-After lang function');
251: fnd_message.set_token('VALUE', func_outcome );
252:
253: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
254: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

Line 251: fnd_message.set_token('VALUE', func_outcome );

247: return;
248: end;
249:
250: fnd_message.set_name('FND', 'CONC-After lang function');
251: fnd_message.set_token('VALUE', func_outcome );
252:
253: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
254: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
255: fnd_file.put_line(fnd_file.log,

Line 253: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||

249:
250: fnd_message.set_name('FND', 'CONC-After lang function');
251: fnd_message.set_token('VALUE', func_outcome );
252:
253: fnd_file.put_line(fnd_file.log, fnd_message.get || ' : ' ||
254: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
255: fnd_file.put_line(fnd_file.log,
256: '+---------------------------------------------------------------------------+');
257:

Line 268: fnd_file.put_line(fnd_file.log, fnd_message.get);

264: -- Language function associated with [PROGRAM] determined no data exists
265: -- for the given set of parameters
266:
267: if (func_outcome is null ) then
268: fnd_file.put_line(fnd_file.log, fnd_message.get);
269: fnd_message.set_name('FND', 'CONC-MLS no data');
270: fnd_message.set_token('PROGRAM', UserProgramName);
271: errbuf := substr(fnd_message.get, 1, 240);
272: retcode := 1;

Line 269: fnd_message.set_name('FND', 'CONC-MLS no data');

265: -- for the given set of parameters
266:
267: if (func_outcome is null ) then
268: fnd_file.put_line(fnd_file.log, fnd_message.get);
269: fnd_message.set_name('FND', 'CONC-MLS no data');
270: fnd_message.set_token('PROGRAM', UserProgramName);
271: errbuf := substr(fnd_message.get, 1, 240);
272: retcode := 1;
273: return;

Line 270: fnd_message.set_token('PROGRAM', UserProgramName);

266:
267: if (func_outcome is null ) then
268: fnd_file.put_line(fnd_file.log, fnd_message.get);
269: fnd_message.set_name('FND', 'CONC-MLS no data');
270: fnd_message.set_token('PROGRAM', UserProgramName);
271: errbuf := substr(fnd_message.get, 1, 240);
272: retcode := 1;
273: return;
274: end if;

Line 271: errbuf := substr(fnd_message.get, 1, 240);

267: if (func_outcome is null ) then
268: fnd_file.put_line(fnd_file.log, fnd_message.get);
269: fnd_message.set_name('FND', 'CONC-MLS no data');
270: fnd_message.set_token('PROGRAM', UserProgramName);
271: errbuf := substr(fnd_message.get, 1, 240);
272: retcode := 1;
273: return;
274: end if;
275:

Line 350: fnd_message.set_name('FND','CONC-Missing Request');

346: from fnd_concurrent_requests
347: where request_id = parent_id;
348: exception
349: when NO_DATA_FOUND then
350: fnd_message.set_name('FND','CONC-Missing Request');
351: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
352: fnd_message.set_token('REQUEST', to_char(parent_id));
353: errbuf := fnd_message.get;
354: retcode := 2;

Line 351: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');

347: where request_id = parent_id;
348: exception
349: when NO_DATA_FOUND then
350: fnd_message.set_name('FND','CONC-Missing Request');
351: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
352: fnd_message.set_token('REQUEST', to_char(parent_id));
353: errbuf := fnd_message.get;
354: retcode := 2;
355: return;

Line 352: fnd_message.set_token('REQUEST', to_char(parent_id));

348: exception
349: when NO_DATA_FOUND then
350: fnd_message.set_name('FND','CONC-Missing Request');
351: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
352: fnd_message.set_token('REQUEST', to_char(parent_id));
353: errbuf := fnd_message.get;
354: retcode := 2;
355: return;
356: end;

Line 353: errbuf := fnd_message.get;

349: when NO_DATA_FOUND then
350: fnd_message.set_name('FND','CONC-Missing Request');
351: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
352: fnd_message.set_token('REQUEST', to_char(parent_id));
353: errbuf := fnd_message.get;
354: retcode := 2;
355: return;
356: end;
357:

Line 373: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

369: from fnd_languages
370: where language_code = P_LANG(i).lang_code;
371: exception
372: when no_data_found then
373: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
374: fnd_message.set_token('LANG', P_LANG(i).lang_code);
375: errbuf := substr(fnd_message.get, 1, 240);
376: retcode := 2;
377: return;

Line 374: fnd_message.set_token('LANG', P_LANG(i).lang_code);

370: where language_code = P_LANG(i).lang_code;
371: exception
372: when no_data_found then
373: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
374: fnd_message.set_token('LANG', P_LANG(i).lang_code);
375: errbuf := substr(fnd_message.get, 1, 240);
376: retcode := 2;
377: return;
378: end;

Line 375: errbuf := substr(fnd_message.get, 1, 240);

371: exception
372: when no_data_found then
373: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
374: fnd_message.set_token('LANG', P_LANG(i).lang_code);
375: errbuf := substr(fnd_message.get, 1, 240);
376: retcode := 2;
377: return;
378: end;
379: else

Line 388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');

384: from fnd_languages
385: where language_code = P_LANG(i).lang_code;
386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
389: fnd_message.set_token('LANG', P_LANG(i).lang_code);
390: fnd_message.set_token('TERR', P_LANG(i).terr_code);
391: errbuf := substr(fnd_message.get, 1, 240);
392: retcode := 2;

Line 389: fnd_message.set_token('LANG', P_LANG(i).lang_code);

385: where language_code = P_LANG(i).lang_code;
386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
389: fnd_message.set_token('LANG', P_LANG(i).lang_code);
390: fnd_message.set_token('TERR', P_LANG(i).terr_code);
391: errbuf := substr(fnd_message.get, 1, 240);
392: retcode := 2;
393: return;

Line 390: fnd_message.set_token('TERR', P_LANG(i).terr_code);

386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
389: fnd_message.set_token('LANG', P_LANG(i).lang_code);
390: fnd_message.set_token('TERR', P_LANG(i).terr_code);
391: errbuf := substr(fnd_message.get, 1, 240);
392: retcode := 2;
393: return;
394: end;

Line 391: errbuf := substr(fnd_message.get, 1, 240);

387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
389: fnd_message.set_token('LANG', P_LANG(i).lang_code);
390: fnd_message.set_token('TERR', P_LANG(i).terr_code);
391: errbuf := substr(fnd_message.get, 1, 240);
392: retcode := 2;
393: return;
394: end;
395: else

Line 404: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');

400: where language_code = P_LANG(i).lang_code
401: and territory_code = P_LANG(i).terr_code;
402: exception
403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
405: fnd_message.set_token('LANG', P_LANG(i).lang_code);
406: fnd_message.set_token('TERR', P_LANG(i).terr_code);
407: errbuf := substr(fnd_message.get, 1, 240);
408: retcode := 2;

Line 405: fnd_message.set_token('LANG', P_LANG(i).lang_code);

401: and territory_code = P_LANG(i).terr_code;
402: exception
403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
405: fnd_message.set_token('LANG', P_LANG(i).lang_code);
406: fnd_message.set_token('TERR', P_LANG(i).terr_code);
407: errbuf := substr(fnd_message.get, 1, 240);
408: retcode := 2;
409: return;

Line 406: fnd_message.set_token('TERR', P_LANG(i).terr_code);

402: exception
403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
405: fnd_message.set_token('LANG', P_LANG(i).lang_code);
406: fnd_message.set_token('TERR', P_LANG(i).terr_code);
407: errbuf := substr(fnd_message.get, 1, 240);
408: retcode := 2;
409: return;
410: end;

Line 407: errbuf := substr(fnd_message.get, 1, 240);

403: when no_data_found then
404: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');
405: fnd_message.set_token('LANG', P_LANG(i).lang_code);
406: fnd_message.set_token('TERR', P_LANG(i).terr_code);
407: errbuf := substr(fnd_message.get, 1, 240);
408: retcode := 2;
409: return;
410: end;
411: end if;

Line 426: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

422: from fnd_languages
423: where language_code = P_LANG(i).lang_code;
424: exception
425: when no_data_found then
426: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
427: fnd_message.set_token('LANG', P_LANG(i).lang_code);
428: errbuf := substr(fnd_message.get, 1, 240);
429: retcode := 2;
430: return;

Line 427: fnd_message.set_token('LANG', P_LANG(i).lang_code);

423: where language_code = P_LANG(i).lang_code;
424: exception
425: when no_data_found then
426: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
427: fnd_message.set_token('LANG', P_LANG(i).lang_code);
428: errbuf := substr(fnd_message.get, 1, 240);
429: retcode := 2;
430: return;
431: end;

Line 428: errbuf := substr(fnd_message.get, 1, 240);

424: exception
425: when no_data_found then
426: fnd_message.set_name('FND', 'CONC-Invalid Language Code');
427: fnd_message.set_token('LANG', P_LANG(i).lang_code);
428: errbuf := substr(fnd_message.get, 1, 240);
429: retcode := 2;
430: return;
431: end;
432:

Line 447: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');

443: from fnd_territories
444: where territory_code = P_LANG(i).terr_code;
445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
448: fnd_message.set_token('TERR', P_LANG(i).terr_code);
449: errbuf := substr(fnd_message.get, 1, 240);
450: retcode := 2;
451: return;

Line 448: fnd_message.set_token('TERR', P_LANG(i).terr_code);

444: where territory_code = P_LANG(i).terr_code;
445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
448: fnd_message.set_token('TERR', P_LANG(i).terr_code);
449: errbuf := substr(fnd_message.get, 1, 240);
450: retcode := 2;
451: return;
452: end;

Line 449: errbuf := substr(fnd_message.get, 1, 240);

445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
448: fnd_message.set_token('TERR', P_LANG(i).terr_code);
449: errbuf := substr(fnd_message.get, 1, 240);
450: retcode := 2;
451: return;
452: end;
453: end if;

Line 498: fnd_message.set_name('FND', 'CONC-About submitted requests');

494:
495:
496: -- 12.1 NEW MLS Function Str with optional territory and num char
497: if ( chkstrloc = 0 ) then
498: fnd_message.set_name('FND', 'CONC-About submitted requests');
499: else
500: fnd_message.set_name('FND', 'CONC-About submitted req full');
501: end if;
502: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 500: fnd_message.set_name('FND', 'CONC-About submitted req full');

496: -- 12.1 NEW MLS Function Str with optional territory and num char
497: if ( chkstrloc = 0 ) then
498: fnd_message.set_name('FND', 'CONC-About submitted requests');
499: else
500: fnd_message.set_name('FND', 'CONC-About submitted req full');
501: end if;
502: fnd_file.put_line(fnd_file.log, fnd_message.get);
503:
504: /* process all the requests */

Line 502: fnd_file.put_line(fnd_file.log, fnd_message.get);

498: fnd_message.set_name('FND', 'CONC-About submitted requests');
499: else
500: fnd_message.set_name('FND', 'CONC-About submitted req full');
501: end if;
502: fnd_file.put_line(fnd_file.log, fnd_message.get);
503:
504: /* process all the requests */
505: begin
506: /* using cursor for loop for easy coding. run_req_info will return

Line 522: errbuf := substr(fnd_message.get, 1, 240);

518: language => P_LANG(ind).nls_language,
519: territory => P_LANG(ind).nls_territory,
520: datagroup => '',
521: numeric_characters => P_LANG(ind).numeric_characters )) then
522: errbuf := substr(fnd_message.get, 1, 240);
523: retcode := 2;
524: rollback;
525: return;
526: end if;

Line 541: errbuf := substr(fnd_message.get, 1, 240);

537: copies => copies,
538: save_output => (req.save_output_flag = 'Y'),
539: print_together => NULL))
540: then
541: errbuf := substr(fnd_message.get, 1, 240);
542: retcode := 2;
543: close mls_req_printers;
544: rollback;
545: return;

Line 553: errbuf := substr(fnd_message.get, 1, 240);

549: while (mls_req_printers%found) loop
550: if (not fnd_request.add_printer(
551: printer => printer,
552: copies => copies)) then
553: errbuf := substr(fnd_message.get, 1, 240);
554: retcode := 2;
555: close mls_req_printers;
556: rollback;
557: return;

Line 569: errbuf := substr(fnd_message.get, 1, 240);

565: copies => 0,
566: save_output => (req.save_output_flag = 'Y'),
567: print_together => NULL))
568: then
569: errbuf := substr(fnd_message.get, 1, 240);
570: retcode := 2;
571: close mls_req_printers;
572: rollback;
573: return;

Line 584: errbuf := substr(fnd_message.get, 1, 240);

580: (parent_id, req.request_set_program_id,
581: P_LANG(ind).nls_language) loop
582: if (not fnd_request.add_notification(
583: user=>notify_rec.notify)) then
584: errbuf := substr(fnd_message.get, 1, 240);
585: retcode := 2;
586: rollback;
587: return;
588: end if;

Line 616: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');

612: from fnd_territories
613: where territory_code = P_LANG(ind).terr_code;
614: exception
615: when no_data_found then
616: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
617: fnd_message.set_token('TERR', P_LANG(ind).terr_code);
618: errbuf := substr(fnd_message.get, 1, 240);
619: retcode := 2;
620: return;

Line 617: fnd_message.set_token('TERR', P_LANG(ind).terr_code);

613: where territory_code = P_LANG(ind).terr_code;
614: exception
615: when no_data_found then
616: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
617: fnd_message.set_token('TERR', P_LANG(ind).terr_code);
618: errbuf := substr(fnd_message.get, 1, 240);
619: retcode := 2;
620: return;
621: end;

Line 618: errbuf := substr(fnd_message.get, 1, 240);

614: exception
615: when no_data_found then
616: fnd_message.set_name('FND', 'CONC-Invalid Territory Code');
617: fnd_message.set_token('TERR', P_LANG(ind).terr_code);
618: errbuf := substr(fnd_message.get, 1, 240);
619: retcode := 2;
620: return;
621: end;
622: t_territory := UPPER(P_LANG(ind).terr_code);

Line 635: errbuf := substr(fnd_message.get, 1, 240);

631: t_code,
632: t_language,
633: t_territory,
634: t_format)) then
635: errbuf := substr(fnd_message.get, 1, 240);
636: retcode := 2;
637: close mls_function_req_layouts;
638: rollback;
639: return;

Line 663: errbuf := substr(fnd_message.get, 1, 240);

659: t_code,
660: t_language,
661: t_territory,
662: t_format)) then
663: errbuf := substr(fnd_message.get, 1, 240);
664: retcode := 2;
665: close mls_req_layouts;
666: rollback;
667: return;

Line 720: errbuf := substr(fnd_message.get, 1, 240);

716: req.argument94, req.argument95, req.argument96,
717: req.argument97, req.argument98, req.argument99,
718: req.argument100);
719: if (req_id = 0) then
720: errbuf := substr(fnd_message.get, 1, 240);
721: retcode := 2;
722: return;
723: end if;
724: has_reqs := TRUE;

Line 747: fnd_message.set_name('FND', 'CONC-MLS has no requests');

743: end loop; /* run_req_info */
744:
745:
746: if ( has_reqs = FALSE ) then
747: fnd_message.set_name('FND', 'CONC-MLS has no requests');
748: errbuf := substr(fnd_message.get, 1, 240);
749: retcode := 2;
750: else
751: fnd_conc_global.set_req_globals(

Line 748: errbuf := substr(fnd_message.get, 1, 240);

744:
745:
746: if ( has_reqs = FALSE ) then
747: fnd_message.set_name('FND', 'CONC-MLS has no requests');
748: errbuf := substr(fnd_message.get, 1, 240);
749: retcode := 2;
750: else
751: fnd_conc_global.set_req_globals(
752: conc_status => 'PAUSED',

Line 788: fnd_message.set_name('FND', 'CONC-About completed requests');

784: startloc := endloc + 1;
785: end loop;
786:
787: /* print the header for completed request status */
788: fnd_message.set_name('FND', 'CONC-About completed requests');
789: fnd_file.put_line(fnd_file.log, fnd_message.get);
790:
791: for ind in 1..P_LCOUNT loop
792: begin

Line 789: fnd_file.put_line(fnd_file.log, fnd_message.get);

785: end loop;
786:
787: /* print the header for completed request status */
788: fnd_message.set_name('FND', 'CONC-About completed requests');
789: fnd_file.put_line(fnd_file.log, fnd_message.get);
790:
791: for ind in 1..P_LCOUNT loop
792: begin
793: select decode(status_code, 'C', 'S', 'G', 'W', 'E')

Line 806: fnd_message.set_name('FND','CONC-Missing Request');

802: end if;
803:
804: exception
805: when NO_DATA_FOUND then
806: fnd_message.set_name('FND','CONC-Missing Request');
807: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
808: fnd_message.set_token('REQUEST', to_char(P_REQ(ind).req_id));
809: errbuf := fnd_message.get;
810: retcode := 2;

Line 807: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');

803:
804: exception
805: when NO_DATA_FOUND then
806: fnd_message.set_name('FND','CONC-Missing Request');
807: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
808: fnd_message.set_token('REQUEST', to_char(P_REQ(ind).req_id));
809: errbuf := fnd_message.get;
810: retcode := 2;
811: return;

Line 808: fnd_message.set_token('REQUEST', to_char(P_REQ(ind).req_id));

804: exception
805: when NO_DATA_FOUND then
806: fnd_message.set_name('FND','CONC-Missing Request');
807: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
808: fnd_message.set_token('REQUEST', to_char(P_REQ(ind).req_id));
809: errbuf := fnd_message.get;
810: retcode := 2;
811: return;
812: end;

Line 809: errbuf := fnd_message.get;

805: when NO_DATA_FOUND then
806: fnd_message.set_name('FND','CONC-Missing Request');
807: fnd_message.set_token('ROUTINE', 'FND_MLS_REQUEST.FNDMLSUB');
808: fnd_message.set_token('REQUEST', to_char(P_REQ(ind).req_id));
809: errbuf := fnd_message.get;
810: retcode := 2;
811: return;
812: end;
813:

Line 840: fnd_message.set_name('FND', 'CONC-mls Completed');

836: from fnd_lookups
837: where lookup_type = 'CP_SET_OUTCOME'
838: and lookup_code = decode(retcode,2,'E',1,'W','S');
839:
840: fnd_message.set_name('FND', 'CONC-mls Completed');
841: fnd_message.set_token('OUTCOME', outcome_meaning);
842: errbuf := substr(fnd_message.get, 1, 240);
843:
844: end if; /* req_data */

Line 841: fnd_message.set_token('OUTCOME', outcome_meaning);

837: where lookup_type = 'CP_SET_OUTCOME'
838: and lookup_code = decode(retcode,2,'E',1,'W','S');
839:
840: fnd_message.set_name('FND', 'CONC-mls Completed');
841: fnd_message.set_token('OUTCOME', outcome_meaning);
842: errbuf := substr(fnd_message.get, 1, 240);
843:
844: end if; /* req_data */
845:

Line 842: errbuf := substr(fnd_message.get, 1, 240);

838: and lookup_code = decode(retcode,2,'E',1,'W','S');
839:
840: fnd_message.set_name('FND', 'CONC-mls Completed');
841: fnd_message.set_token('OUTCOME', outcome_meaning);
842: errbuf := substr(fnd_message.get, 1, 240);
843:
844: end if; /* req_data */
845:
846: end FNDMLSUB;