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.JTF_DIAG_REPORT_FACTORY dependencies on DBMS_XMLGEN

Line 27: footer_content := DBMS_XMLGEN.CONVERT(footer,0) || ' If you are experiencing any issues regarding this diagnostic test, please ' ||

23: diag_com_url varchar2(2000);
24: BEGIN
25: VALIDATE_REPORT_CONTEXT(report_context);
26: IF footer IS NOT NULL THEN
27: footer_content := DBMS_XMLGEN.CONVERT(footer,0) || ' If you are experiencing any issues regarding this diagnostic test, please ' ||
28: 'use My Oracle Support to log an iTAR (Service Request) for product "Oracle E-Business' ||
29: 'Suite Diagnostics" (ID=1332). If you have any question related to E-Business Suite Diagnostics (installation, execution, usage or availability), you can ask us using the' ||
30: '''Diagnosibility'' ? available on My Oracle Support (or classic' ||
31: 'Metalink). We would also appreciate your feedback regarding the usefulness of this ' ||

Line 60: header_content := DBMS_XMLGEN.CONVERT(header,0);

56: header_content VARCHAR2(2000);
57: BEGIN
58: VALIDATE_REPORT_CONTEXT(report_context);
59: IF header IS NOT NULL THEN
60: header_content := DBMS_XMLGEN.CONVERT(header,0);
61: exec_id := report_context.EXEC_ID;
62: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
63: header_component := JTF_DIAG_HEADER(exec_id,ui_node_id,header_content,0);
64: ELSE

Line 78: section_heading := DBMS_XMLGEN.CONVERT(heading,0);

74: section_heading VARCHAR2(2000);
75: BEGIN
76: VALIDATE_REPORT_CONTEXT(report_context);
77: IF heading IS NOT NULL THEN
78: section_heading := DBMS_XMLGEN.CONVERT(heading,0);
79: exec_id := report_context.EXEC_ID;
80: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
81: section_component := JTF_DIAG_SECTION(exec_id,ui_node_id,section_heading,0);
82: ELSE

Line 96: message_content := DBMS_XMLGEN.CONVERT(message,0);

92: message_content VARCHAR2(2000);
93: BEGIN
94: VALIDATE_REPORT_CONTEXT(report_context);
95: IF message IS NOT NULL THEN
96: message_content := DBMS_XMLGEN.CONVERT(message,0);
97: exec_id := report_context.EXEC_ID;
98: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
99: IF message_type IS NOT NULL AND (message_type = 'info' OR message_type = 'warning' OR message_type = 'error' OR message_type = 'attention') THEN
100: message_component := JTF_DIAG_MESSAGE(exec_id,ui_node_id,message_content,message_type,null,0,0,0);

Line 158: hide_show_content := DBMS_XMLGEN.CONVERT(content,0);

154: hide_show_content VARCHAR2(20000);
155: BEGIN
156: VALIDATE_REPORT_CONTEXT(report_context);
157: IF content IS NOT NULL THEN
158: hide_show_content := DBMS_XMLGEN.CONVERT(content,0);
159: exec_id := report_context.EXEC_ID;
160: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
161: hide_show_component := JTF_DIAG_HIDE_SHOW(exec_id,ui_node_id,hide_show_content,'Hide','Show',0);
162: ELSE

Line 195: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);

191: link_url_content VARCHAR2(20000);
192: BEGIN
193: VALIDATE_REPORT_CONTEXT(report_context);
194: IF linkText IS NOT NULL AND linkURL IS NOT NULL THEN
195: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
196: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);
197: exec_id := report_context.EXEC_ID;
198: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
199: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);

Line 196: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);

192: BEGIN
193: VALIDATE_REPORT_CONTEXT(report_context);
194: IF linkText IS NOT NULL AND linkURL IS NOT NULL THEN
195: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
196: link_url_content := DBMS_XMLGEN.CONVERT(linkURL,0);
197: exec_id := report_context.EXEC_ID;
198: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
199: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
200: ELSE

Line 216: form_heading := DBMS_XMLGEN.CONVERT(heading,0);

212: form_heading VARCHAR2(2000);
213: BEGIN
214: VALIDATE_REPORT_CONTEXT(report_context);
215: IF heading IS NOT NULL THEN
216: form_heading := DBMS_XMLGEN.CONVERT(heading,0);
217: exec_id := report_context.EXEC_ID;
218: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;
219: select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;
220: form_data_component := JTF_DIAG_FORMDATA(exec_id,form_data_ui_node_id,form_values,0);

Line 239: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

235: VALIDATE_REPORT_CONTEXT(report_context);
236: IF heading IS NULL THEN
237: table_heading := ' ';
238: ELSE
239: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
240: END IF;
241: IF column_headers IS NOT NULL THEN
242: exec_id := report_context.EXEC_ID;
243: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;

Line 293: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

289: END IF;
290: IF heading IS NULL THEN
291: table_heading := ' ';
292: ELSE
293: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
294: END IF;
295: table_column_headers := GET_COLUMN_NAMES(sql_query);
296: --Check if the column_headers provided by the user is consistent with the query
297: IF column_headers IS NOT NULL THEN

Line 332: table_heading := DBMS_XMLGEN.CONVERT(heading,0);

328: END IF;
329: IF heading IS NULL THEN
330: table_heading := ' ';
331: ELSE
332: table_heading := DBMS_XMLGEN.CONVERT(heading,0);
333: END IF;
334: table_column_headers := GET_COLUMN_NAMES(sql_query);
335:
336: exec_id := report_context.EXEC_ID;

Line 388: tree_heading := DBMS_XMLGEN.CONVERT(heading,0);

384: tree_heading VARCHAR2(20000);
385: BEGIN
386: VALIDATE_REPORT_CONTEXT(report_context);
387: IF heading IS NOT NULL THEN
388: tree_heading := DBMS_XMLGEN.CONVERT(heading,0);
389: exec_id := report_context.EXEC_ID;
390: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
391: tree_component := JTF_DIAG_TREE(exec_id,ui_node_id,tree_heading,0);
392: ELSE

Line 405: tree_content := DBMS_XMLGEN.CONVERT(content,0);

401: tree_content VARCHAR2(20000);
402: BEGIN
403: VALIDATE_REPORT_CONTEXT(report_context);
404: IF content IS NOT NULL THEN
405: tree_content := DBMS_XMLGEN.CONVERT(content,0);
406: exec_id := report_context.EXEC_ID;
407: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
408: tree_node_component := JTF_DIAG_TREE_NODE(exec_id,ui_node_id,tree_content,0);
409: ELSE

Line 425: note_content := DBMS_XMLGEN.CONVERT(content,0);

421: content_lenght NUMBER;
422: BEGIN
423: VALIDATE_REPORT_CONTEXT(report_context);
424: IF content IS NOT NULL THEN
425: note_content := DBMS_XMLGEN.CONVERT(content,0);
426: exec_id := report_context.EXEC_ID;
427: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
428: no_of_links := length(content)-length(replace(content,'?',''));
429: IF no_of_links > 0 THEN

Line 456: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);

452: metalink_url VARCHAR2(20000);
453: BEGIN
454: VALIDATE_REPORT_CONTEXT(report_context);
455: IF linkText IS NOT NULL AND note_id IS NOT NULL THEN
456: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
457: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
458: metalink_url := metalink_url || note_id;
459: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
460: exec_id := report_context.EXEC_ID;

Line 459: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);

455: IF linkText IS NOT NULL AND note_id IS NOT NULL THEN
456: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
457: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
458: metalink_url := metalink_url || note_id;
459: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
460: exec_id := report_context.EXEC_ID;
461: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
462: link_component := JTF_DIAG_LINK(exec_id,ui_node_id,link_text_content,link_url_content,0);
463: ELSE