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_DIAG_REQUEST_ANALYZER dependencies on JTF_DIAG_REPORT_FACTORY

Line 100: note := jtf_diag_report_factory.create_note('- ' || mgr_rec.name || ' | Status: ' || mgr_rec.status || ' (' || mgr_rec.active || ' active processes)', reportcontext);

96:
97: BEGIN
98: FOR mgr_rec IN c_mgrs(p_req_id)
99: LOOP
100: note := jtf_diag_report_factory.create_note('- ' || mgr_rec.name || ' | Status: ' || mgr_rec.status || ' (' || mgr_rec.active || ' active processes)', reportcontext);
101: inner_section.add_note(note);
102: END LOOP;
103:
104: END print_mgrs;

Line 217: header1 := jtf_diag_report_factory.create_header('CP Diagnostic Request Analyzer', reportcontext);

213: report := exec_obj.get_report;
214: -- To get the report context to create other components for the report
215: reportcontext := report.get_report_context;
216: -- Creating a header of the report
217: header1 := jtf_diag_report_factory.create_header('CP Diagnostic Request Analyzer', reportcontext);
218: -- Adding the header to the report
219: report.add_header(header1);
220:
221: SECTION := jtf_diag_report_factory.create_section('Analyzing request ' || p_req_id || ':', reportcontext);

Line 221: SECTION := jtf_diag_report_factory.create_section('Analyzing request ' || p_req_id || ':', reportcontext);

217: header1 := jtf_diag_report_factory.create_header('CP Diagnostic Request Analyzer', reportcontext);
218: -- Adding the header to the report
219: report.add_header(header1);
220:
221: SECTION := jtf_diag_report_factory.create_section('Analyzing request ' || p_req_id || ':', reportcontext);
222:
223: -- Taking request id from the user
224: allinputs := exec_obj.inputset;
225: p_req_id := to_number(jtf_diagnostic_adaptutil.getinputvalue('RequestId', allinputs));

Line 239: message := jtf_diag_report_factory.create_message(str_error, 'error', reportcontext);

235: result := 'false';
236: -- Creating a message component and adding it to a section
237: str_error := 'Request ' || p_req_id || ' not found.';
238: str_fix_info := 'Please Enter the valid Request Id';
239: message := jtf_diag_report_factory.create_message(str_error, 'error', reportcontext);
240: SECTION.add_message(message);
241: GOTO endoffile;
242: END;
243:

Line 295: form_view := jtf_diag_report_factory.create_form('Program information', form_keys, form_values, reportcontext);

291: form_values.extend;
292: form_values(form_values.COUNT) := proginfo.execution_options;
293: END IF;
294:
295: form_view := jtf_diag_report_factory.create_form('Program information', form_keys, form_values, reportcontext);
296: SECTION.add_form(form_view);
297:
298: IF proginfo.enable_trace = 'Y' THEN
299: inner_section := jtf_diag_report_factory.create_section('Note:', reportcontext);

Line 299: inner_section := jtf_diag_report_factory.create_section('Note:', reportcontext);

295: form_view := jtf_diag_report_factory.create_form('Program information', form_keys, form_values, reportcontext);
296: SECTION.add_form(form_view);
297:
298: IF proginfo.enable_trace = 'Y' THEN
299: inner_section := jtf_diag_report_factory.create_section('Note:', reportcontext);
300: note := jtf_diag_report_factory.create_note('SQL Trace has been enabled for this program.', reportcontext);
301: inner_section.add_note(note);
302: SECTION.add_section(inner_section);
303: END IF;

Line 300: note := jtf_diag_report_factory.create_note('SQL Trace has been enabled for this program.', reportcontext);

296: SECTION.add_form(form_view);
297:
298: IF proginfo.enable_trace = 'Y' THEN
299: inner_section := jtf_diag_report_factory.create_section('Note:', reportcontext);
300: note := jtf_diag_report_factory.create_note('SQL Trace has been enabled for this program.', reportcontext);
301: inner_section.add_note(note);
302: SECTION.add_section(inner_section);
303: END IF;
304:

Line 337: form_view := jtf_diag_report_factory.create_form('Submission information', form_keys, form_values, reportcontext);

333:
334: form_keys := jtf_varchar2_table_4000('It was submitted by user', 'Using responsibility', 'It was submitted on', 'It was requested to start on', 'Parent request id', 'Language', 'Territory', 'Priority', 'Arguments');
335: form_values := jtf_varchar2_table_4000(c_user, resp_name, to_char(reqinfo.request_date, 'DD-MON-RR HH24:MI:SS'), to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'),
336: reqinfo.parent_request_id, reqinfo.nls_language, reqinfo.nls_territory, to_char(reqinfo.priority), '(' || reqinfo.number_of_arguments || '): ' || reqinfo.argument_text);
337: form_view := jtf_diag_report_factory.create_form('Submission information', form_keys, form_values, reportcontext);
338: SECTION.add_form(form_view);
339:
340: c_status := get_status(reqinfo.status_code);
341:

Line 342: inner_section := jtf_diag_report_factory.create_section('Analysis', reportcontext);

338: SECTION.add_form(form_view);
339:
340: c_status := get_status(reqinfo.status_code);
341:
342: inner_section := jtf_diag_report_factory.create_section('Analysis', reportcontext);
343:
344: IF reqinfo.phase_code = 'C' THEN
345: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' has completed with status "' || c_status || '".', reportcontext);
346: inner_section.add_note(note);

Line 345: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' has completed with status "' || c_status || '".', reportcontext);

341:
342: inner_section := jtf_diag_report_factory.create_section('Analysis', reportcontext);
343:
344: IF reqinfo.phase_code = 'C' THEN
345: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' has completed with status "' || c_status || '".', reportcontext);
346: inner_section.add_note(note);
347: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
348: inner_section.add_note(note);
349: note := jtf_diag_report_factory.create_note('It completed on: ' || nvl(to_char(reqinfo.actual_completion_date, 'DD-MON-RR HH24:MI:SS'), '-- NO COMPLETION DATE --'), reportcontext);

Line 347: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);

343:
344: IF reqinfo.phase_code = 'C' THEN
345: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' has completed with status "' || c_status || '".', reportcontext);
346: inner_section.add_note(note);
347: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
348: inner_section.add_note(note);
349: note := jtf_diag_report_factory.create_note('It completed on: ' || nvl(to_char(reqinfo.actual_completion_date, 'DD-MON-RR HH24:MI:SS'), '-- NO COMPLETION DATE --'), reportcontext);
350: inner_section.add_note(note);
351:

Line 349: note := jtf_diag_report_factory.create_note('It completed on: ' || nvl(to_char(reqinfo.actual_completion_date, 'DD-MON-RR HH24:MI:SS'), '-- NO COMPLETION DATE --'), reportcontext);

345: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' has completed with status "' || c_status || '".', reportcontext);
346: inner_section.add_note(note);
347: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
348: inner_section.add_note(note);
349: note := jtf_diag_report_factory.create_note('It completed on: ' || nvl(to_char(reqinfo.actual_completion_date, 'DD-MON-RR HH24:MI:SS'), '-- NO COMPLETION DATE --'), reportcontext);
350: inner_section.add_note(note);
351:
352: BEGIN
353: SELECT user_concurrent_queue_name

Line 357: note := jtf_diag_report_factory.create_note('It was run by manager: ' || mgrname, reportcontext);

353: SELECT user_concurrent_queue_name
354: INTO mgrname
355: FROM fnd_concurrent_queues_vl
356: WHERE concurrent_queue_id = reqinfo.controlling_manager;
357: note := jtf_diag_report_factory.create_note('It was run by manager: ' || mgrname, reportcontext);
358: inner_section.add_note(note);
359:
360: EXCEPTION
361: WHEN no_data_found THEN

Line 369: note := jtf_diag_report_factory.create_note('This request is a queue control request, it was run by the ICM', reportcontext);

365: WHERE concurrent_program_id = reqinfo.concurrent_program_id
366: AND application_id = reqinfo.program_application_id;
367:
368: IF qcf = 'Y' THEN
369: note := jtf_diag_report_factory.create_note('This request is a queue control request, it was run by the ICM', reportcontext);
370: ELSE
371: note := jtf_diag_report_factory.create_note('It was run by an unknown manager.', reportcontext);
372: END IF;
373:

Line 371: note := jtf_diag_report_factory.create_note('It was run by an unknown manager.', reportcontext);

367:
368: IF qcf = 'Y' THEN
369: note := jtf_diag_report_factory.create_note('This request is a queue control request, it was run by the ICM', reportcontext);
370: ELSE
371: note := jtf_diag_report_factory.create_note('It was run by an unknown manager.', reportcontext);
372: END IF;
373:
374: inner_section.add_note(note);
375: END;

Line 380: note := jtf_diag_report_factory.create_note('Logfile: ' || filename, reportcontext);

376:
377: SELECT nvl(reqinfo.logfile_name, '-- No logfile --')
378: INTO filename
379: FROM dual;
380: note := jtf_diag_report_factory.create_note('Logfile: ' || filename, reportcontext);
381: inner_section.add_note(note);
382: SELECT nvl(reqinfo.outfile_name, '-- No output file --')
383: INTO filename
384: FROM dual;

Line 385: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);

381: inner_section.add_note(note);
382: SELECT nvl(reqinfo.outfile_name, '-- No output file --')
383: INTO filename
384: FROM dual;
385: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);
386: inner_section.add_note(note);
387: note := jtf_diag_report_factory.create_note('It produced completion message: ' || nvl(reqinfo.completion_text, '-- NO COMPLETION MESSAGE --'), reportcontext);
388: inner_section.add_note(note);
389: ELSIF reqinfo.phase_code = 'R' THEN

Line 387: note := jtf_diag_report_factory.create_note('It produced completion message: ' || nvl(reqinfo.completion_text, '-- NO COMPLETION MESSAGE --'), reportcontext);

383: INTO filename
384: FROM dual;
385: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);
386: inner_section.add_note(note);
387: note := jtf_diag_report_factory.create_note('It produced completion message: ' || nvl(reqinfo.completion_text, '-- NO COMPLETION MESSAGE --'), reportcontext);
388: inner_section.add_note(note);
389: ELSIF reqinfo.phase_code = 'R' THEN
390: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is currently running with status "' || c_status || '".', reportcontext);
391: inner_section.add_note(note);

Line 390: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is currently running with status "' || c_status || '".', reportcontext);

386: inner_section.add_note(note);
387: note := jtf_diag_report_factory.create_note('It produced completion message: ' || nvl(reqinfo.completion_text, '-- NO COMPLETION MESSAGE --'), reportcontext);
388: inner_section.add_note(note);
389: ELSIF reqinfo.phase_code = 'R' THEN
390: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is currently running with status "' || c_status || '".', reportcontext);
391: inner_section.add_note(note);
392: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
393: inner_section.add_note(note);
394: BEGIN

Line 392: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);

388: inner_section.add_note(note);
389: ELSIF reqinfo.phase_code = 'R' THEN
390: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is currently running with status "' || c_status || '".', reportcontext);
391: inner_section.add_note(note);
392: note := jtf_diag_report_factory.create_note('It began running on: ' || nvl(to_char(reqinfo.actual_start_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
393: inner_section.add_note(note);
394: BEGIN
395: SELECT user_concurrent_queue_name
396: INTO mgrname

Line 399: note := jtf_diag_report_factory.create_note('It is being run by manager: ' || mgrname, reportcontext);

395: SELECT user_concurrent_queue_name
396: INTO mgrname
397: FROM fnd_concurrent_queues_vl
398: WHERE concurrent_queue_id = reqinfo.controlling_manager;
399: note := jtf_diag_report_factory.create_note('It is being run by manager: ' || mgrname, reportcontext);
400: inner_section.add_note(note);
401:
402: EXCEPTION
403: WHEN no_data_found THEN

Line 410: note := jtf_diag_report_factory.create_note('Logfile: ' || filename, reportcontext);

406:
407: SELECT nvl(reqinfo.logfile_name, '-- No logfile --')
408: INTO filename
409: FROM dual;
410: note := jtf_diag_report_factory.create_note('Logfile: ' || filename, reportcontext);
411: inner_section.add_note(note);
412: SELECT nvl(reqinfo.outfile_name, '-- No output file --')
413: INTO filename
414: FROM dual;

Line 415: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);

411: inner_section.add_note(note);
412: SELECT nvl(reqinfo.outfile_name, '-- No output file --')
413: INTO filename
414: FROM dual;
415: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);
416: inner_section.add_note(note);
417:
418: IF reqinfo.os_process_id IS NOT NULL THEN
419: note := jtf_diag_report_factory.create_note('OS process id: ' || reqinfo.os_process_id, reportcontext);

Line 419: note := jtf_diag_report_factory.create_note('OS process id: ' || reqinfo.os_process_id, reportcontext);

415: note := jtf_diag_report_factory.create_note('Output file: ' || filename, reportcontext);
416: inner_section.add_note(note);
417:
418: IF reqinfo.os_process_id IS NOT NULL THEN
419: note := jtf_diag_report_factory.create_note('OS process id: ' || reqinfo.os_process_id, reportcontext);
420: inner_section.add_note(note);
421: END IF;
422:
423: IF reqinfo.status_code = 'Z' THEN

Line 429: note := jtf_diag_report_factory.create_note('It is waiting on request ' || child.request_id || ' phase = ' || get_phase(child.phase_code) || ' status = ' || get_status(child.status_code), reportcontext);

425: -- Waiting request, See what it is waiting on
426: FOR child IN c_wait
427: LOOP
428:
429: note := jtf_diag_report_factory.create_note('It is waiting on request ' || child.request_id || ' phase = ' || get_phase(child.phase_code) || ' status = ' || get_status(child.status_code), reportcontext);
430: inner_section.add_note(note);
431: END LOOP;
432:
433: ELSIF reqinfo.status_code = 'W' THEN

Line 441: note := jtf_diag_report_factory.create_note('A Running/Paused request is waiting on one or more child requests to complete.', reportcontext);

437: INTO conc_prog_name
438: FROM fnd_concurrent_programs
439: WHERE concurrent_program_id = reqinfo.concurrent_program_id;
440:
441: note := jtf_diag_report_factory.create_note('A Running/Paused request is waiting on one or more child requests to complete.', reportcontext);
442: inner_section.add_note(note);
443:
444: IF conc_prog_name = 'FNDRSSTG' THEN
445: note := jtf_diag_report_factory.create_note('This program appears to be a Request Set Stage.', reportcontext);

Line 445: note := jtf_diag_report_factory.create_note('This program appears to be a Request Set Stage.', reportcontext);

441: note := jtf_diag_report_factory.create_note('A Running/Paused request is waiting on one or more child requests to complete.', reportcontext);
442: inner_section.add_note(note);
443:
444: IF conc_prog_name = 'FNDRSSTG' THEN
445: note := jtf_diag_report_factory.create_note('This program appears to be a Request Set Stage.', reportcontext);
446: inner_section.add_note(note);
447: END IF;
448:
449: IF instr(conc_prog_name, 'RSSUB') > 0 THEN

Line 450: note := jtf_diag_report_factory.create_note('This program appears to be a Request Set parent program.', reportcontext);

446: inner_section.add_note(note);
447: END IF;
448:
449: IF instr(conc_prog_name, 'RSSUB') > 0 THEN
450: note := jtf_diag_report_factory.create_note('This program appears to be a Request Set parent program.', reportcontext);
451: inner_section.add_note(note);
452: END IF;
453:
454: live_child := FALSE;

Line 458: note := jtf_diag_report_factory.create_note('It has a child request: ' || child.request_id || ' (phase = ' || get_phase(child.phase_code) || ' - status = ' || get_status(child.status_code) || ')', reportcontext);

454: live_child := FALSE;
455: FOR child IN c_wait
456: LOOP
457:
458: note := jtf_diag_report_factory.create_note('It has a child request: ' || child.request_id || ' (phase = ' || get_phase(child.phase_code) || ' - status = ' || get_status(child.status_code) || ')', reportcontext);
459: inner_section.add_note(note);
460:
461: IF child.phase_code <> 'C' THEN
462: live_child := TRUE;

Line 470: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

466:
467: IF live_child = FALSE THEN
468: str_error := 'This request has no child requests that are still running.';
469: str_fix_info := 'You need to wake this request up manually.';
470: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
471: SECTION.add_message(message);
472: result := 'false';
473: GOTO endoffile;
474: END IF;

Line 482: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is in phase "Pending" with status "' || c_status || '".', reportcontext);

478: -- Pending Requests
479: -------------------------------------------------------------------------------------------------------------
480: ELSIF reqinfo.phase_code = 'P' THEN
481:
482: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is in phase "Pending" with status "' || c_status || '".', reportcontext);
483: inner_section.add_note(note);
484: note := jtf_diag_report_factory.create_note(' (phase_code = P) (status_code = ' || reqinfo.status_code || ')', reportcontext);
485: inner_section.add_note(note);
486:

Line 484: note := jtf_diag_report_factory.create_note(' (phase_code = P) (status_code = ' || reqinfo.status_code || ')', reportcontext);

480: ELSIF reqinfo.phase_code = 'P' THEN
481:
482: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is in phase "Pending" with status "' || c_status || '".', reportcontext);
483: inner_section.add_note(note);
484: note := jtf_diag_report_factory.create_note(' (phase_code = P) (status_code = ' || reqinfo.status_code || ')', reportcontext);
485: inner_section.add_note(note);
486:
487: -- could be a queue control request
488: SELECT queue_control_flag

Line 495: note := jtf_diag_report_factory.create_note('This request is a queue control request', reportcontext);

491: WHERE concurrent_program_id = reqinfo.concurrent_program_id
492: AND application_id = reqinfo.program_application_id;
493:
494: IF qcf = 'Y' THEN
495: note := jtf_diag_report_factory.create_note('This request is a queue control request', reportcontext);
496: inner_section.add_note(note);
497: note := jtf_diag_report_factory.create_note('It will be run by the ICM on its next sleep cycle', reportcontext);
498: inner_section.add_note(note);
499: GOTO diagnose;

Line 497: note := jtf_diag_report_factory.create_note('It will be run by the ICM on its next sleep cycle', reportcontext);

493:
494: IF qcf = 'Y' THEN
495: note := jtf_diag_report_factory.create_note('This request is a queue control request', reportcontext);
496: inner_section.add_note(note);
497: note := jtf_diag_report_factory.create_note('It will be run by the ICM on its next sleep cycle', reportcontext);
498: inner_section.add_note(note);
499: GOTO diagnose;
500: END IF;
501:

Line 507: note := jtf_diag_report_factory.create_note('This is a scheduled request.', reportcontext);

503:
504: -- could be scheduled
505:
506: IF reqinfo.requested_start_date > sysdate OR reqinfo.status_code = 'P' THEN
507: note := jtf_diag_report_factory.create_note('This is a scheduled request.', reportcontext);
508: inner_section.add_note(note);
509: note := jtf_diag_report_factory.create_note('It is currently scheduled to start running on ' || to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
510: inner_section.add_note(note);
511: note := jtf_diag_report_factory.create_note('This should show on the form as Pending/Scheduled', reportcontext);

Line 509: note := jtf_diag_report_factory.create_note('It is currently scheduled to start running on ' || to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);

505:
506: IF reqinfo.requested_start_date > sysdate OR reqinfo.status_code = 'P' THEN
507: note := jtf_diag_report_factory.create_note('This is a scheduled request.', reportcontext);
508: inner_section.add_note(note);
509: note := jtf_diag_report_factory.create_note('It is currently scheduled to start running on ' || to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
510: inner_section.add_note(note);
511: note := jtf_diag_report_factory.create_note('This should show on the form as Pending/Scheduled', reportcontext);
512: inner_section.add_note(note);
513: GOTO diagnose;

Line 511: note := jtf_diag_report_factory.create_note('This should show on the form as Pending/Scheduled', reportcontext);

507: note := jtf_diag_report_factory.create_note('This is a scheduled request.', reportcontext);
508: inner_section.add_note(note);
509: note := jtf_diag_report_factory.create_note('It is currently scheduled to start running on ' || to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
510: inner_section.add_note(note);
511: note := jtf_diag_report_factory.create_note('This should show on the form as Pending/Scheduled', reportcontext);
512: inner_section.add_note(note);
513: GOTO diagnose;
514: END IF;
515:

Line 519: note := jtf_diag_report_factory.create_note('This request is currently on hold. It will not run until the hold is released.', reportcontext);

515:
516: -- could be on hold
517:
518: IF reqinfo.hold_flag = 'Y' THEN
519: note := jtf_diag_report_factory.create_note('This request is currently on hold. It will not run until the hold is released.', reportcontext);
520: inner_section.add_note(note);
521: note := jtf_diag_report_factory.create_note('It was placed on hold by: ' || last_user || ' on ' || to_char(reqinfo.last_update_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
522: inner_section.add_note(note);
523: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/On Hold', reportcontext);

Line 521: note := jtf_diag_report_factory.create_note('It was placed on hold by: ' || last_user || ' on ' || to_char(reqinfo.last_update_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);

517:
518: IF reqinfo.hold_flag = 'Y' THEN
519: note := jtf_diag_report_factory.create_note('This request is currently on hold. It will not run until the hold is released.', reportcontext);
520: inner_section.add_note(note);
521: note := jtf_diag_report_factory.create_note('It was placed on hold by: ' || last_user || ' on ' || to_char(reqinfo.last_update_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
522: inner_section.add_note(note);
523: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/On Hold', reportcontext);
524: inner_section.add_note(note);
525: GOTO diagnose;

Line 523: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/On Hold', reportcontext);

519: note := jtf_diag_report_factory.create_note('This request is currently on hold. It will not run until the hold is released.', reportcontext);
520: inner_section.add_note(note);
521: note := jtf_diag_report_factory.create_note('It was placed on hold by: ' || last_user || ' on ' || to_char(reqinfo.last_update_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
522: inner_section.add_note(note);
523: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/On Hold', reportcontext);
524: inner_section.add_note(note);
525: GOTO diagnose;
526: END IF;
527:

Line 531: note := jtf_diag_report_factory.create_note('This request is currently disabled.', reportcontext);

527:
528: -- could be disabled
529:
530: IF proginfo.enabled_flag = 'N' THEN
531: note := jtf_diag_report_factory.create_note('This request is currently disabled.', reportcontext);
532: inner_section.add_note(note);
533: note := jtf_diag_report_factory.create_note('The concurrent_program ' || proginfo.user_concurrent_program_name || ' needs to be enabled for this request to run.', reportcontext);
534: inner_section.add_note(note);
535: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/Disabled', reportcontext);

Line 533: note := jtf_diag_report_factory.create_note('The concurrent_program ' || proginfo.user_concurrent_program_name || ' needs to be enabled for this request to run.', reportcontext);

529:
530: IF proginfo.enabled_flag = 'N' THEN
531: note := jtf_diag_report_factory.create_note('This request is currently disabled.', reportcontext);
532: inner_section.add_note(note);
533: note := jtf_diag_report_factory.create_note('The concurrent_program ' || proginfo.user_concurrent_program_name || ' needs to be enabled for this request to run.', reportcontext);
534: inner_section.add_note(note);
535: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/Disabled', reportcontext);
536: inner_section.add_note(note);
537: GOTO diagnose;

Line 535: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/Disabled', reportcontext);

531: note := jtf_diag_report_factory.create_note('This request is currently disabled.', reportcontext);
532: inner_section.add_note(note);
533: note := jtf_diag_report_factory.create_note('The concurrent_program ' || proginfo.user_concurrent_program_name || ' needs to be enabled for this request to run.', reportcontext);
534: inner_section.add_note(note);
535: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/Disabled', reportcontext);
536: inner_section.add_note(note);
537: GOTO diagnose;
538: END IF;
539:

Line 544: note := jtf_diag_report_factory.create_note('This request is an unconstrained request. (queue_method_code = I)', reportcontext);

540: -- check queue_method_code
541: -- unconstrained requests
542:
543: IF reqinfo.queue_method_code = 'I' THEN
544: note := jtf_diag_report_factory.create_note('This request is an unconstrained request. (queue_method_code = I)', reportcontext);
545: inner_section.add_note(note);
546:
547: IF reqinfo.status_code = 'I' THEN
548: note := jtf_diag_report_factory.create_note('It is in a "Pending/Normal" status, ready to be run by the next available manager.', reportcontext);

Line 548: note := jtf_diag_report_factory.create_note('It is in a "Pending/Normal" status, ready to be run by the next available manager.', reportcontext);

544: note := jtf_diag_report_factory.create_note('This request is an unconstrained request. (queue_method_code = I)', reportcontext);
545: inner_section.add_note(note);
546:
547: IF reqinfo.status_code = 'I' THEN
548: note := jtf_diag_report_factory.create_note('It is in a "Pending/Normal" status, ready to be run by the next available manager.', reportcontext);
549: inner_section.add_note(note);
550: ELSIF reqinfo.status_code = 'Q' THEN
551: note := jtf_diag_report_factory.create_note('It has a status of "Standby" even though it is unconstrained. It will not be run by any manager.', reportcontext);
552: inner_section.add_note(note);

Line 551: note := jtf_diag_report_factory.create_note('It has a status of "Standby" even though it is unconstrained. It will not be run by any manager.', reportcontext);

547: IF reqinfo.status_code = 'I' THEN
548: note := jtf_diag_report_factory.create_note('It is in a "Pending/Normal" status, ready to be run by the next available manager.', reportcontext);
549: inner_section.add_note(note);
550: ELSIF reqinfo.status_code = 'Q' THEN
551: note := jtf_diag_report_factory.create_note('It has a status of "Standby" even though it is unconstrained. It will not be run by any manager.', reportcontext);
552: inner_section.add_note(note);
553: ELSIF reqinfo.status_code IN('A', 'Z') THEN
554: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);
555: inner_section.add_note(note);

Line 554: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);

550: ELSIF reqinfo.status_code = 'Q' THEN
551: note := jtf_diag_report_factory.create_note('It has a status of "Standby" even though it is unconstrained. It will not be run by any manager.', reportcontext);
552: inner_section.add_note(note);
553: ELSIF reqinfo.status_code IN('A', 'Z') THEN
554: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);
555: inner_section.add_note(note);
556: SELECT nvl(parent_request_id, -1)
557: INTO parent_id
558: FROM fnd_conc_req_summary_v

Line 562: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);

558: FROM fnd_conc_req_summary_v
559: WHERE request_id = p_req_id;
560:
561: IF parent_id = -1 THEN
562: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);
563: inner_section.add_note(note);
564: ELSE
565: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);
566: inner_section.add_note(note);

Line 565: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);

561: IF parent_id = -1 THEN
562: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);
563: inner_section.add_note(note);
564: ELSE
565: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);
566: inner_section.add_note(note);
567: END IF;
568:
569: ELSE

Line 572: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

568:
569: ELSE
570: str_error := 'Unexpected status of ' || reqinfo.status_code || ' occurred';
571: str_fix_info := ' Please contact System Administrator';
572: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
573: SECTION.add_message(message);
574: result := 'false';
575: GOTO endoffile;
576: END IF;

Line 580: note := jtf_diag_report_factory.create_note('This request is a constrained request. (queue_method_code = B)', reportcontext);

576: END IF;
577:
578: -- constrained requests
579: ELSIF reqinfo.queue_method_code = 'B' THEN
580: note := jtf_diag_report_factory.create_note('This request is a constrained request. (queue_method_code = B)', reportcontext);
581: inner_section.add_note(note);
582:
583: IF reqinfo.status_code = 'I' THEN
584: note := jtf_diag_report_factory.create_note('The Conflict Resolution manager has released this request, and it is in a "Pending/Normal" status.', reportcontext);

Line 584: note := jtf_diag_report_factory.create_note('The Conflict Resolution manager has released this request, and it is in a "Pending/Normal" status.', reportcontext);

580: note := jtf_diag_report_factory.create_note('This request is a constrained request. (queue_method_code = B)', reportcontext);
581: inner_section.add_note(note);
582:
583: IF reqinfo.status_code = 'I' THEN
584: note := jtf_diag_report_factory.create_note('The Conflict Resolution manager has released this request, and it is in a "Pending/Normal" status.', reportcontext);
585: inner_section.add_note(note);
586: note := jtf_diag_report_factory.create_note('It is ready to be run by the next available manager.', reportcontext);
587: inner_section.add_note(note);
588: ELSIF reqinfo.status_code = 'Q' THEN

Line 586: note := jtf_diag_report_factory.create_note('It is ready to be run by the next available manager.', reportcontext);

582:
583: IF reqinfo.status_code = 'I' THEN
584: note := jtf_diag_report_factory.create_note('The Conflict Resolution manager has released this request, and it is in a "Pending/Normal" status.', reportcontext);
585: inner_section.add_note(note);
586: note := jtf_diag_report_factory.create_note('It is ready to be run by the next available manager.', reportcontext);
587: inner_section.add_note(note);
588: ELSIF reqinfo.status_code = 'Q' THEN
589: note := jtf_diag_report_factory.create_note('It is in a "Pending/Standby" status. The Conflict Resolution manager will need to release it before it can be run.', reportcontext);
590: inner_section.add_note(note);

Line 589: note := jtf_diag_report_factory.create_note('It is in a "Pending/Standby" status. The Conflict Resolution manager will need to release it before it can be run.', reportcontext);

585: inner_section.add_note(note);
586: note := jtf_diag_report_factory.create_note('It is ready to be run by the next available manager.', reportcontext);
587: inner_section.add_note(note);
588: ELSIF reqinfo.status_code = 'Q' THEN
589: note := jtf_diag_report_factory.create_note('It is in a "Pending/Standby" status. The Conflict Resolution manager will need to release it before it can be run.', reportcontext);
590: inner_section.add_note(note);
591: ELSIF reqinfo.status_code IN('A', 'Z') THEN
592: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);
593: inner_section.add_note(note);

Line 592: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);

588: ELSIF reqinfo.status_code = 'Q' THEN
589: note := jtf_diag_report_factory.create_note('It is in a "Pending/Standby" status. The Conflict Resolution manager will need to release it before it can be run.', reportcontext);
590: inner_section.add_note(note);
591: ELSIF reqinfo.status_code IN('A', 'Z') THEN
592: note := jtf_diag_report_factory.create_note('It is in a "Waiting" status. This usually indicates a child request waiting for the parent to release it.', reportcontext);
593: inner_section.add_note(note);
594: SELECT nvl(parent_request_id, -1)
595: INTO parent_id
596: FROM fnd_conc_req_summary_v

Line 600: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);

596: FROM fnd_conc_req_summary_v
597: WHERE request_id = p_req_id;
598:
599: IF parent_id = -1 THEN
600: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);
601: inner_section.add_note(note);
602: ELSE
603: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);
604: inner_section.add_note(note);

Line 603: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);

599: IF parent_id = -1 THEN
600: note := jtf_diag_report_factory.create_note('** Unable to find a parent request for this request', reportcontext);
601: inner_section.add_note(note);
602: ELSE
603: note := jtf_diag_report_factory.create_note('It''s parent request id is: ' || to_char(parent_id), reportcontext);
604: inner_section.add_note(note);
605: END IF;
606:
607: ELSE

Line 608: note := jtf_diag_report_factory.create_note('Hmmm. A status of ' || reqinfo.status_code || '. I was not really expecting to see this status.', reportcontext);

604: inner_section.add_note(note);
605: END IF;
606:
607: ELSE
608: note := jtf_diag_report_factory.create_note('Hmmm. A status of ' || reqinfo.status_code || '. I was not really expecting to see this status.', reportcontext);
609: inner_section.add_note(note);
610: END IF;
611:
612: -- incompatible programs

Line 639: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is waiting, or will have to wait, on an incompatible request: ' || ireqid, reportcontext);

635: scode;
636: EXIT
637: WHEN c_ireqs % NOTFOUND;
638:
639: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is waiting, or will have to wait, on an incompatible request: ' || ireqid, reportcontext);
640: inner_section.add_note(note);
641: note := jtf_diag_report_factory.create_note('which has phase = ' || pcode || ' and status = ' || scode, reportcontext);
642: inner_section.add_note(note);
643: icount := icount + 1;

Line 641: note := jtf_diag_report_factory.create_note('which has phase = ' || pcode || ' and status = ' || scode, reportcontext);

637: WHEN c_ireqs % NOTFOUND;
638:
639: note := jtf_diag_report_factory.create_note('Request ' || p_req_id || ' is waiting, or will have to wait, on an incompatible request: ' || ireqid, reportcontext);
640: inner_section.add_note(note);
641: note := jtf_diag_report_factory.create_note('which has phase = ' || pcode || ' and status = ' || scode, reportcontext);
642: inner_section.add_note(note);
643: icount := icount + 1;
644:
645: END LOOP;

Line 652: note := jtf_diag_report_factory.create_note('No running incompatible requests were found for request ' || p_req_id, reportcontext);

648:
649: END LOOP;
650:
651: IF icount = 0 THEN
652: note := jtf_diag_report_factory.create_note('No running incompatible requests were found for request ' || p_req_id, reportcontext);
653: inner_section.add_note(note);
654: END IF;
655:
656: -- could be a runalone itself

Line 659: note := jtf_diag_report_factory.create_note('This request is constrained because it is a runalone request.', reportcontext);

655:
656: -- could be a runalone itself
657:
658: IF proginfo.run_alone_flag = 'Y' THEN
659: note := jtf_diag_report_factory.create_note('This request is constrained because it is a runalone request.', reportcontext);
660: inner_section.add_note(note);
661: END IF;
662:
663: -- single threaded

Line 666: note := jtf_diag_report_factory.create_note('This request is constrained because the profile option Concurrent: Sequential Requests is set.', reportcontext);

662:
663: -- single threaded
664:
665: IF reqinfo.single_thread_flag = 'Y' THEN
666: note := jtf_diag_report_factory.create_note('This request is constrained because the profile option Concurrent: Sequential Requests is set.', reportcontext);
667: inner_section.add_note(note);
668: reqlimit := TRUE;
669: END IF;
670:

Line 674: note := jtf_diag_report_factory.create_note('This request is constrained because the profile option Concurrent: Active Request Limit is set.', reportcontext);

670:
671: -- request limit
672:
673: IF reqinfo.request_limit = 'Y' THEN
674: note := jtf_diag_report_factory.create_note('This request is constrained because the profile option Concurrent: Active Request Limit is set.', reportcontext);
675: inner_section.add_note(note);
676: reqlimit := TRUE;
677: END IF;
678:

Line 680: note := jtf_diag_report_factory.create_note('This request may have to wait on these requests:', reportcontext);

676: reqlimit := TRUE;
677: END IF;
678:
679: IF reqlimit = TRUE THEN
680: note := jtf_diag_report_factory.create_note('This request may have to wait on these requests:', reportcontext);
681: inner_section.add_note(note);
682: FOR progs IN c_userreqs(reqinfo.requested_by, reqinfo.requested_start_date)
683: LOOP
684: note := jtf_diag_report_factory.create_note('Request id: ' || progs.request_id || ' Requested start date: ' || progs.start_date, reportcontext);

Line 684: note := jtf_diag_report_factory.create_note('Request id: ' || progs.request_id || ' Requested start date: ' || progs.start_date, reportcontext);

680: note := jtf_diag_report_factory.create_note('This request may have to wait on these requests:', reportcontext);
681: inner_section.add_note(note);
682: FOR progs IN c_userreqs(reqinfo.requested_by, reqinfo.requested_start_date)
683: LOOP
684: note := jtf_diag_report_factory.create_note('Request id: ' || progs.request_id || ' Requested start date: ' || progs.start_date, reportcontext);
685: inner_section.add_note(note);
686: note := jtf_diag_report_factory.create_note(' Phase: ' || get_phase(progs.phase_code) || ' Status: ' || get_status(progs.status_code), reportcontext);
687: inner_section.add_note(note);
688: END LOOP;

Line 686: note := jtf_diag_report_factory.create_note(' Phase: ' || get_phase(progs.phase_code) || ' Status: ' || get_status(progs.status_code), reportcontext);

682: FOR progs IN c_userreqs(reqinfo.requested_by, reqinfo.requested_start_date)
683: LOOP
684: note := jtf_diag_report_factory.create_note('Request id: ' || progs.request_id || ' Requested start date: ' || progs.start_date, reportcontext);
685: inner_section.add_note(note);
686: note := jtf_diag_report_factory.create_note(' Phase: ' || get_phase(progs.phase_code) || ' Status: ' || get_status(progs.status_code), reportcontext);
687: inner_section.add_note(note);
688: END LOOP;
689: END IF;
690:

Line 695: message := jtf_diag_report_factory.create_message(str_error, 'error', reportcontext);

691: -- error, invalid queue_method_code
692: ELSE
693: str_error := 'This request has an invalid queue_method_code of ' || reqinfo.queue_method_code || ' This request will not be run.';
694: str_fix_info := 'You may need to apply patch 739644';
695: message := jtf_diag_report_factory.create_message(str_error, 'error', reportcontext);
696: inner_section.add_message(message);
697: message := jtf_diag_report_factory.create_message(str_fix_info, 'info', reportcontext);
698: inner_section.add_message(message);
699: result := 'false';

Line 697: message := jtf_diag_report_factory.create_message(str_fix_info, 'info', reportcontext);

693: str_error := 'This request has an invalid queue_method_code of ' || reqinfo.queue_method_code || ' This request will not be run.';
694: str_fix_info := 'You may need to apply patch 739644';
695: message := jtf_diag_report_factory.create_message(str_error, 'error', reportcontext);
696: inner_section.add_message(message);
697: message := jtf_diag_report_factory.create_message(str_fix_info, 'info', reportcontext);
698: inner_section.add_message(message);
699: result := 'false';
700: SECTION.add_section(inner_section);
701: GOTO endoffile;

Line 704: note := jtf_diag_report_factory.create_note('Checking managers available to run this request...', reportcontext);

700: SECTION.add_section(inner_section);
701: GOTO endoffile;
702: END IF;
703:
704: note := jtf_diag_report_factory.create_note('Checking managers available to run this request...', reportcontext);
705: inner_section.add_note(note);
706:
707: -- check the managers
708: manager_check(p_req_id, reqinfo.cd_id, mgr_defined, mgr_active, mgr_workshift, mgr_running, run_alone);

Line 713: note := jtf_diag_report_factory.create_note('There is a runalone request running ahead of this request', reportcontext);

709:
710: -- could be a runalone ahead of it
711:
712: IF run_alone = TRUE THEN
713: note := jtf_diag_report_factory.create_note('There is a runalone request running ahead of this request', reportcontext);
714: inner_section.add_note(note);
715: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
716: inner_section.add_note(note);
717:

Line 715: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);

711:
712: IF run_alone = TRUE THEN
713: note := jtf_diag_report_factory.create_note('There is a runalone request running ahead of this request', reportcontext);
714: inner_section.add_note(note);
715: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
716: inner_section.add_note(note);
717:
718: SELECT user_cd_name
719: INTO conflict_domain

Line 723: note := jtf_diag_report_factory.create_note('Conflict domain = ' || conflict_domain, reportcontext);

719: INTO conflict_domain
720: FROM fnd_conflicts_domain
721: WHERE cd_id = reqinfo.cd_id;
722:
723: note := jtf_diag_report_factory.create_note('Conflict domain = ' || conflict_domain, reportcontext);
724: inner_section.add_note(note);
725: -- see what is running
726: BEGIN
727: SELECT request_id,

Line 740: note := jtf_diag_report_factory.create_note('This request is waiting for request ' || tmp_id || ', which is running with status ' || get_status(tmp_status), reportcontext);

736: AND fcp.concurrent_program_id = fcr.concurrent_program_id
737: AND fcr.phase_code = 'R'
738: AND fcr.cd_id = reqinfo.cd_id;
739:
740: note := jtf_diag_report_factory.create_note('This request is waiting for request ' || tmp_id || ', which is running with status ' || get_status(tmp_status), reportcontext);
741: inner_section.add_note(note);
742: note := jtf_diag_report_factory.create_note('It has been running since: ' || nvl(to_char(tmp_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
743: inner_section.add_note(note);
744:

Line 742: note := jtf_diag_report_factory.create_note('It has been running since: ' || nvl(to_char(tmp_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);

738: AND fcr.cd_id = reqinfo.cd_id;
739:
740: note := jtf_diag_report_factory.create_note('This request is waiting for request ' || tmp_id || ', which is running with status ' || get_status(tmp_status), reportcontext);
741: inner_section.add_note(note);
742: note := jtf_diag_report_factory.create_note('It has been running since: ' || nvl(to_char(tmp_date, 'DD-MON-RR HH24:MI:SS'), '-- NO START DATE --'), reportcontext);
743: inner_section.add_note(note);
744:
745: EXCEPTION
746: WHEN no_data_found THEN

Line 749: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

745: EXCEPTION
746: WHEN no_data_found THEN
747: str_error := 'The runalone flag is set for conflict domain ' || conflict_domain || ' but there is no runalone request running. ';
748: str_fix_info := 'Please contact System Administrator';
749: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
750: SECTION.add_message(message);
751: result := 'false';
752: GOTO endoffile;
753: END;

Line 758: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

754:
755: ELSIF mgr_defined = FALSE THEN
756: str_error := 'There is no manager defined that can run this request. This should show on the form as Inactive/No Manager. ';
757: str_fix_info := 'Check the specialization rules for each manager to make sure they are defined correctly.';
758: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
759: SECTION.add_message(message);
760: result := 'false';
761: GOTO endoffile;
762: ELSIF mgr_active = FALSE THEN

Line 763: note := jtf_diag_report_factory.create_note('There are one or more managers defined that can run this request, but none of them are currently active', reportcontext);

759: SECTION.add_message(message);
760: result := 'false';
761: GOTO endoffile;
762: ELSIF mgr_active = FALSE THEN
763: note := jtf_diag_report_factory.create_note('There are one or more managers defined that can run this request, but none of them are currently active', reportcontext);
764: inner_section.add_note(note);
765: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
766: inner_section.add_note(note);
767: -- print out which managers can run it and their status

Line 765: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);

761: GOTO endoffile;
762: ELSIF mgr_active = FALSE THEN
763: note := jtf_diag_report_factory.create_note('There are one or more managers defined that can run this request, but none of them are currently active', reportcontext);
764: inner_section.add_note(note);
765: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
766: inner_section.add_note(note);
767: -- print out which managers can run it and their status
768: note := jtf_diag_report_factory.create_note('These managers are defined to run this request:', reportcontext);
769: inner_section.add_note(note);

Line 768: note := jtf_diag_report_factory.create_note('These managers are defined to run this request:', reportcontext);

764: inner_section.add_note(note);
765: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
766: inner_section.add_note(note);
767: -- print out which managers can run it and their status
768: note := jtf_diag_report_factory.create_note('These managers are defined to run this request:', reportcontext);
769: inner_section.add_note(note);
770: print_mgrs(p_req_id, inner_section, reportcontext);
771:
772: str_error := 'Inactive/No Manager. ';

Line 774: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

770: print_mgrs(p_req_id, inner_section, reportcontext);
771:
772: str_error := 'Inactive/No Manager. ';
773: str_fix_info := 'Please contact the System Administrator.';
774: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
775: SECTION.add_message(message);
776: result := 'false';
777: GOTO endoffile;
778:

Line 780: note := jtf_diag_report_factory.create_note('Right now, there is no manager running in an active workshift that can run this request', reportcontext);

776: result := 'false';
777: GOTO endoffile;
778:
779: ELSIF mgr_workshift = FALSE THEN
780: note := jtf_diag_report_factory.create_note('Right now, there is no manager running in an active workshift that can run this request', reportcontext);
781: inner_section.add_note(note);
782: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
783: inner_section.add_note(note);
784: -- display details about the workshifts

Line 782: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);

778:
779: ELSIF mgr_workshift = FALSE THEN
780: note := jtf_diag_report_factory.create_note('Right now, there is no manager running in an active workshift that can run this request', reportcontext);
781: inner_section.add_note(note);
782: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
783: inner_section.add_note(note);
784: -- display details about the workshifts
785: ELSIF mgr_running = FALSE THEN
786: note := jtf_diag_report_factory.create_note('There is one or more managers available to run this request, but none of them are running', reportcontext);

Line 786: note := jtf_diag_report_factory.create_note('There is one or more managers available to run this request, but none of them are running', reportcontext);

782: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
783: inner_section.add_note(note);
784: -- display details about the workshifts
785: ELSIF mgr_running = FALSE THEN
786: note := jtf_diag_report_factory.create_note('There is one or more managers available to run this request, but none of them are running', reportcontext);
787: inner_section.add_note(note);
788: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
789: inner_section.add_note(note);
790: -- print out which managers can run it and their status

Line 788: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);

784: -- display details about the workshifts
785: ELSIF mgr_running = FALSE THEN
786: note := jtf_diag_report_factory.create_note('There is one or more managers available to run this request, but none of them are running', reportcontext);
787: inner_section.add_note(note);
788: note := jtf_diag_report_factory.create_note('This should show on the form as Inactive/No Manager', reportcontext);
789: inner_section.add_note(note);
790: -- print out which managers can run it and their status
791: print_mgrs(p_req_id, inner_section, reportcontext);
792:

Line 795: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

791: print_mgrs(p_req_id, inner_section, reportcontext);
792:
793: str_error := 'Inactive/No Manager. ';
794: str_fix_info := 'Please contact the System Administrator.';
795: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
796: SECTION.add_message(message);
797: result := 'false';
798: GOTO endoffile;
799:

Line 802: note := jtf_diag_report_factory.create_note('These managers are available to run this request:', reportcontext);

798: GOTO endoffile;
799:
800: ELSE
801: -- print out the managers available to run it
802: note := jtf_diag_report_factory.create_note('These managers are available to run this request:', reportcontext);
803: inner_section.add_note(note);
804: print_mgrs(p_req_id, inner_section, reportcontext);
805:
806: END IF;

Line 812: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);

808: -- invalid phase code
809: ELSE
810: str_error := 'Request ' || p_req_id || ' has an invalid phase_code of "' || reqinfo.phase_code || '" ';
811: str_fix_info := '';
812: message := jtf_diag_report_factory.create_message(str_error || str_fix_info, 'error', reportcontext);
813: SECTION.add_message(message);
814: result := 'false';
815: GOTO endoffile;
816:

Line 829: footer := jtf_diag_report_factory.create_footer(str, reportcontext);

825: report.add_section(SECTION);
826:
827: -- Creating a custom footer for the report
828: str := 'Oracle corporation.';
829: footer := jtf_diag_report_factory.create_footer(str, reportcontext);
830: -- Adding the footer to the report
831: report.add_footer(footer);
832:
833: EXCEPTION