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_DIAGNOSTIC_COREAPI dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 19: --JTF_DIAGNOSTIC_ADAPTUTIL.setReportClob(tempClob);

15: if l_hold_num + length(text) > 32759 then
16: l_ptext := '';
17: --dbms_lob.write(g_hold_output, length(l_ptext), g_curr_loc, l_ptext);
18: --dbms_lob.write(tempClob, length(l_ptext), g_curr_loc, l_ptext);
19: --JTF_DIAGNOSTIC_ADAPTUTIL.setReportClob(tempClob);
20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(l_ptext);
21: g_curr_loc := g_curr_loc + length(l_ptext);
22: end if;
23: --dbms_lob.write(g_hold_output, length(text)+1, g_curr_loc, text || l_newline);

Line 20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(l_ptext);

16: l_ptext := '';
17: --dbms_lob.write(g_hold_output, length(l_ptext), g_curr_loc, l_ptext);
18: --dbms_lob.write(tempClob, length(l_ptext), g_curr_loc, l_ptext);
19: --JTF_DIAGNOSTIC_ADAPTUTIL.setReportClob(tempClob);
20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(l_ptext);
21: g_curr_loc := g_curr_loc + length(l_ptext);
22: end if;
23: --dbms_lob.write(g_hold_output, length(text)+1, g_curr_loc, text || l_newline);
24: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||l_newline);

Line 24: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||l_newline);

20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(l_ptext);
21: g_curr_loc := g_curr_loc + length(l_ptext);
22: end if;
23: --dbms_lob.write(g_hold_output, length(text)+1, g_curr_loc, text || l_newline);
24: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||l_newline);
25: --dbms_lob.write(tempClob, length(text)+1, g_curr_loc, text || l_newline);
26: g_curr_loc := g_curr_loc + length(text)+1;
27: end line_out_html;
28:

Line 2454: --dbms_lob.write(JTF_DIAGNOSTIC_ADAPTUTIL.reportClob, length(text)+1, g_curr_loc, text || l_newline);

2450: -- end;
2451:
2452: procedure line_out_text(text varchar2) is
2453: begin
2454: --dbms_lob.write(JTF_DIAGNOSTIC_ADAPTUTIL.reportClob, length(text)+1, g_curr_loc, text || l_newline);
2455: --JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text || l_newline);
2456: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||FND_GLOBAL.Local_Chr(10));
2457: g_curr_loc := g_curr_loc + length(text)+1;
2458: end line_out_text;

Line 2455: --JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text || l_newline);

2451:
2452: procedure line_out_text(text varchar2) is
2453: begin
2454: --dbms_lob.write(JTF_DIAGNOSTIC_ADAPTUTIL.reportClob, length(text)+1, g_curr_loc, text || l_newline);
2455: --JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text || l_newline);
2456: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||FND_GLOBAL.Local_Chr(10));
2457: g_curr_loc := g_curr_loc + length(text)+1;
2458: end line_out_text;
2459:

Line 2456: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||FND_GLOBAL.Local_Chr(10));

2452: procedure line_out_text(text varchar2) is
2453: begin
2454: --dbms_lob.write(JTF_DIAGNOSTIC_ADAPTUTIL.reportClob, length(text)+1, g_curr_loc, text || l_newline);
2455: --JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text || l_newline);
2456: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(text||FND_GLOBAL.Local_Chr(10));
2457: g_curr_loc := g_curr_loc + length(text)+1;
2458: end line_out_text;
2459:
2460: -- Procedure Name: ActionPrint

Line 4705: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4701: -----------------------------------------------------------------------
4702:
4703: procedure line_out (text varchar2) IS
4704: BEGIN
4705: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4706: line_out_html (text);
4707: ELSE
4708: line_out_text (text );
4709: END IF;

Line 4715: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4711:
4712:
4713: procedure Insert_Style_Sheet IS
4714: BEGIN
4715: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4716: Insert_Style_Sheet_html;
4717: ELSE
4718: -- API currently not implemented for text
4719: null;

Line 4726: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4722:
4723:
4724: procedure Insert_HTML(p_text varchar2) IS
4725: BEGIN
4726: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4727: Insert_HTML_html(p_text);
4728: ELSE
4729: -- API currently not implemented for text
4730: null;

Line 4737: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4733:
4734:
4735: procedure ActionErrorPrint(p_text varchar2) IS
4736: BEGIN
4737: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4738: ActionErrorPrint_html(p_text);
4739: ELSE
4740: ActionErrorPrint_text(p_text);
4741: END IF;

Line 4749: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4745:
4746:
4747: procedure ActionPrint(p_text varchar2) IS
4748: BEGIN
4749: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4750: ActionPrint_html(p_text);
4751: ELSE
4752: ActionPrint_text(p_text);
4753: END IF;

Line 4759: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4755:
4756:
4757: procedure ActionWarningPrint(p_text varchar2) IS
4758: BEGIN
4759: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4760: ActionWarningPrint_html(p_text);
4761: ELSE
4762: ActionWarningPrint_text(p_text);
4763: END IF;

Line 4770: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4766:
4767:
4768: procedure WarningPrint(p_text varchar2) IS
4769: BEGIN
4770: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4771: WarningPrint_html(p_text);
4772: ELSE
4773: WarningPrint_text(p_text);
4774: END IF;

Line 4782: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4778: procedure ActionErrorLink(p_txt1 varchar2
4779: , p_note varchar2
4780: , p_txt2 varchar2) IS
4781: BEGIN
4782: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4783: ActionErrorLink_html(p_txt1, p_note, p_txt2);
4784: ELSE
4785: -- API currently not implemented for text
4786: null;

Line 4796: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4792: , p_url varchar2
4793: , p_link_txt varchar2
4794: , p_txt2 varchar2) IS
4795: BEGIN
4796: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4797: ActionErrorLink_html(p_txt1,p_url,p_link_txt,p_txt2);
4798: ELSE
4799: -- API currently not implemented for text
4800: null;

Line 4809: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4805: procedure ActionWarningLink(p_txt1 varchar2
4806: , p_note varchar2
4807: , p_txt2 varchar2) IS
4808: BEGIN
4809: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4810: ActionWarningLink_html(p_txt1, p_note, p_txt2);
4811: ELSE
4812: -- API currently not implemented for text
4813: null;

Line 4823: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4819: , p_url varchar2
4820: , p_link_txt varchar2
4821: , p_txt2 varchar2) IS
4822: BEGIN
4823: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4824: ActionWarningLink_html(p_txt1,p_url ,p_link_txt,p_txt2);
4825: ELSE
4826: -- API currently not implemented for text
4827: null;

Line 4834: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4830:
4831:
4832: procedure ErrorPrint(p_text varchar2) IS
4833: BEGIN
4834: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4835: ErrorPrint_html(p_text);
4836: ELSE
4837: ErrorPrint_text(p_text);
4838: END IF;

Line 4844: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4840:
4841:
4842: procedure SectionPrint(p_text varchar2) IS
4843: BEGIN
4844: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4845: SectionPrint_html(p_text);
4846: ELSE
4847: SectionPrint_text(p_text);
4848: END IF;

Line 4854: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4850:
4851:
4852: procedure Tab0Print (p_text varchar2) IS
4853: BEGIN
4854: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4855: Tab0Print_html(p_text);
4856: ELSE
4857: Tab0Print_text(p_text);
4858: END IF;

Line 4864: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4860:
4861:
4862: procedure Tab1Print (p_text varchar2) IS
4863: BEGIN
4864: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4865: Tab1Print_html(p_text);
4866: ELSE
4867: Tab1Print_text(p_text);
4868: END IF;

Line 4875: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4871:
4872:
4873: procedure Tab2Print (p_text varchar2) IS
4874: BEGIN
4875: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4876: Tab2Print_html(p_text);
4877: ELSE
4878: Tab2Print_text(p_text);
4879: END IF;

Line 4884: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4880: END;
4881:
4882: procedure Tab3Print (p_text varchar2) IS
4883: BEGIN
4884: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4885: Tab3Print_html(p_text);
4886: ELSE
4887: Tab3Print_text(p_text);
4888: END IF;

Line 4893: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4889: END;
4890:
4891: procedure BRPrint IS
4892: BEGIN
4893: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4894: BRPrint_html;
4895: ELSE
4896: BRPrint_text;
4897: END IF;

Line 4902: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4898: END;
4899:
4900: procedure checkFinPeriod (p_sobid NUMBER, p_appid NUMBER ) IS
4901: BEGIN
4902: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4903: checkFinPeriod_html(p_sobid, p_appid);
4904: ELSE
4905: checkFinPeriod_text(p_sobid, p_appid );
4906: END IF;

Line 4914: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4910: procedure CheckKeyFlexfield(p_flex_code in varchar2
4911: , p_flex_num in number default null
4912: , p_print_heading in boolean default true) IS
4913: BEGIN
4914: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4915: CheckKeyFlexfield_html(p_flex_code,p_flex_num,p_print_heading);
4916: ELSE
4917: CheckKeyFlexfield_text(p_flex_code,p_flex_num,p_print_heading);
4918: END IF;

Line 4929: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4925: , p_appl_id in number
4926: , p_default in varchar2 default null
4927: , p_indent in integer default 0) IS
4928: BEGIN
4929: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4930: CheckProfile_html(p_prof_name, p_user_id, p_resp_id,p_appl_id,p_default,p_indent);
4931: ELSE
4932: CheckProfile_text(p_prof_name, p_user_id, p_resp_id,p_appl_id,p_default,p_indent);
4933: END IF;

Line 4939: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4935:
4936:
4937: procedure Begin_Pre IS
4938: BEGIN
4939: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4940: Begin_Pre_html;
4941: ELSE
4942: -- API currently not implemented for text
4943: null;

Line 4950: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4946:
4947:
4948: procedure End_Pre IS
4949: BEGIN
4950: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4951: End_Pre_html;
4952: ELSE
4953: -- API currently not implemented for text
4954: null;

Line 4961: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4957:
4958:
4959: procedure Show_Table(p_type varchar2, p_values V2T, p_caption varchar2 default null, p_options V2T default null) IS
4960: BEGIN
4961: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4962: Show_Table_html(p_type, p_values, p_caption, p_options);
4963: ELSE
4964: -- API currently not implemented for text
4965: null;

Line 4972: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4968:
4969:
4970: procedure Show_Table(p_values V2T) IS
4971: BEGIN
4972: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4973: Show_Table_html(p_values);
4974: ELSE
4975: -- API currently not implemented for text
4976: null;

Line 4983: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4979:
4980:
4981: procedure Show_Table(p_type varchar2) IS
4982: BEGIN
4983: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4984: Show_Table_html(p_type);
4985: ELSE
4986: -- API currently not implemented for text
4987: null;

Line 4994: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4990:
4991:
4992: procedure Show_Table_Row(p_values V2T, p_options V2T default null) IS
4993: BEGIN
4994: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4995: Show_Table_Row_html(p_values, p_options);
4996: ELSE
4997: -- API currently not implemented for text
4998: null;

Line 5005: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5001:
5002:
5003: procedure Show_Table_Header(p_values V2T, p_options V2T default null) IS
5004: BEGIN
5005: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5006: Show_Table_Header_html(p_values, p_options);
5007: ELSE
5008: -- API currently not implemented for text
5009: null;

Line 5015: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5011: END;
5012:
5013: procedure Show_Table_Header(p_headers in headers, p_lengths in out NOCOPY lengths) IS
5014: BEGIN
5015: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5016: Show_Table_Header_text(p_headers,p_lengths);
5017: ELSE
5018: -- API currently not implemented for text
5019: null;

Line 5026: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5022:
5023:
5024: procedure Start_Table(p_caption varchar2 default null) IS
5025: BEGIN
5026: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5027: Start_Table_html(p_caption);
5028: ELSE
5029: -- API currently not implemented for text
5030: null;

Line 5037: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5033:
5034:
5035: procedure End_Table IS
5036: BEGIN
5037: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5038: End_Table_html;
5039: ELSE
5040: -- API currently not implemented for text
5041: null;

Line 5048: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5044:
5045:
5046: function Run_SQL(p_title varchar2, p_sql_statement varchar2) return number is
5047: BEGIN
5048: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5049: return Run_SQL_html(p_title,p_sql_statement);
5050: ELSE
5051: -- API currently not implemented for text
5052: null;

Line 5060: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5056: function Run_SQL(p_title varchar2
5057: , p_sql_statement varchar2
5058: , p_feedback varchar2) return number is
5059: BEGIN
5060: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5061: return Run_SQL_html(p_title,p_sql_statement,p_feedback);
5062: ELSE
5063: -- API currently not implemented for text
5064: null;

Line 5073: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5069: function Run_SQL(p_title varchar2
5070: , p_sql_statement varchar2
5071: , p_max_rows number) return number is
5072: BEGIN
5073: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5074: return Run_SQL_html(p_title,p_sql_statement,p_max_rows);
5075: ELSE
5076: -- API currently not implemented for text
5077: null;

Line 5088: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5084: , p_sql_statement varchar2
5085: , p_feedback varchar2
5086: , p_max_rows number) return number is
5087: BEGIN
5088: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5089: return Run_SQL_html(p_title,p_sql_statement,p_feedback ,p_max_rows);
5090: ELSE
5091: -- API currently not implemented for text
5092: null;

Line 5099: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5095:
5096:
5097: procedure Run_SQL(p_title varchar2, p_sql_statement varchar2) is
5098: BEGIN
5099: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5100: Run_SQL_html(p_title,p_sql_statement);
5101: ELSE
5102: -- API currently not implemented for text
5103: null;

Line 5112: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5108: procedure Run_SQL(p_title varchar2
5109: , p_sql_statement varchar2
5110: , p_feedback varchar2) is
5111: BEGIN
5112: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5113: Run_SQL_html(p_title,p_sql_statement,p_feedback);
5114: ELSE
5115: -- API currently not implemented for text
5116: null;

Line 5125: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5121: procedure Run_SQL(p_title varchar2
5122: , p_sql_statement varchar2
5123: , p_max_rows number) is
5124: BEGIN
5125: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5126: Run_SQL_html(p_title,p_sql_statement,p_max_rows);
5127: ELSE
5128: -- API currently not implemented for text
5129: null;

Line 5138: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5134: , p_sql_statement varchar2
5135: , p_feedback varchar2
5136: , p_max_rows number) IS
5137: BEGIN
5138: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5139: Run_SQL_html(p_title,p_sql_statement,p_feedback ,p_max_rows);
5140: ELSE
5141: -- API currently not implemented for text
5142: null;

Line 5151: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5147: function Run_SQL(p_title varchar2,
5148: p_sql_statement varchar2,
5149: p_disp_lengths lengths) return number is
5150: BEGIN
5151: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5152: -- API currently not implemented for html
5153: null;
5154: ELSE
5155: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths);

Line 5166: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5162: p_sql_statement varchar2,
5163: p_disp_lengths lengths,
5164: p_headers headers) return number is
5165: BEGIN
5166: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5167: -- API currently not implemented for html
5168: null;
5169: ELSE
5170: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers);

Line 5180: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5176: p_disp_lengths lengths,
5177: p_headers headers,
5178: p_feedback varchar2) return number is
5179: BEGIN
5180: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5181: -- API currently not implemented for html
5182: null;
5183: ELSE
5184: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_feedback);

Line 5195: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5191: p_disp_lengths lengths,
5192: p_headers headers,
5193: p_max_rows number) return number is
5194: BEGIN
5195: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5196: -- API currently not implemented for html
5197: null;
5198: ELSE
5199: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_max_rows);

Line 5211: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5207: p_headers headers,
5208: p_feedback varchar2,
5209: p_max_rows number) return number is
5210: BEGIN
5211: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5212: -- API currently not implemented for html
5213: null;
5214: ELSE
5215: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_feedback,p_max_rows);

Line 5225: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5221: procedure Run_SQL(p_title varchar2,
5222: p_sql_statement varchar2,
5223: p_disp_lengths lengths) IS
5224: BEGIN
5225: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5226: -- API currently not implemented for html
5227: null;
5228: ELSE
5229: Run_SQL_text(p_title,p_sql_statement,p_disp_lengths);

Line 5240: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5236: p_sql_statement varchar2,
5237: p_disp_lengths lengths,
5238: p_headers headers) is
5239: BEGIN
5240: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5241: -- API currently not implemented for html
5242: null;
5243: ELSE
5244: Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers);

Line 5256: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5252: p_where_clause varchar2,
5253: p_order_by_clause varchar2 default null,
5254: p_display_longs varchar2 default 'Y') IS
5255: BEGIN
5256: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5257: Display_Table_html(p_table_name,p_table_alias ,p_where_clause,p_order_by_clause,p_display_longs);
5258: ELSE
5259: -- API currently not implemented for text
5260: null;

Line 5268: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5264:
5265:
5266: procedure Show_Header(p_note varchar2, p_title varchar2) IS
5267: BEGIN
5268: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5269: Show_Header_html(p_note, p_title);
5270: ELSE
5271: Show_Header_text(p_note, p_title);
5272: END IF;

Line 5280: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5276:
5277:
5278: procedure Show_Footer(p_script_name varchar2, p_header varchar2) IS
5279: BEGIN
5280: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5281: Show_Footer_html(p_script_name,p_header );
5282: ELSE
5283: Show_Footer_text;
5284: END IF;

Line 5290: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5286:
5287:
5288: procedure Show_Footer IS
5289: BEGIN
5290: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5291: -- API currently not implemented for html
5292: null;
5293: ELSE
5294: Show_Footer_text;

Line 5301: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5297:
5298:
5299: procedure Show_Link(p_note varchar2) IS
5300: BEGIN
5301: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5302: Show_Link_html(p_note);
5303: ELSE
5304: Show_Link_text(p_note);
5305: END IF;

Line 5310: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5306: END;
5307:
5308: procedure Show_Link(p_link varchar2, p_link_name varchar2 ) IS
5309: BEGIN
5310: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5311: Show_Link_html(p_link, p_link_name);
5312: ELSE
5313: Show_Link_text(p_link, p_link_name);
5314: END IF;

Line 5324: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5320: , p_subject varchar2
5321: , p_message varchar2
5322: , p_mailhost varchar2) IS
5323: BEGIN
5324: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5325: Send_Email_html( p_sender, p_recipient, p_subject , p_message , p_mailhost);
5326: ELSE
5327: -- API currently not implemented for text
5328: null;

Line 5336: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5332:
5333: procedure Display_Profiles (p_application_id varchar2
5334: , p_short_name varchar2 default null) IS
5335: BEGIN
5336: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5337: Display_Profiles_html(p_application_id, p_short_name);
5338: ELSE
5339: Display_Profiles_text(p_application_id, p_short_name);
5340: END IF;

Line 5346: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5342:
5343:
5344: procedure Set_Org (p_org_id number) IS
5345: BEGIN
5346: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5347: Set_Org_html(p_org_id);
5348: ELSE
5349: Set_Org_text(p_org_id);
5350: END IF;

Line 5356: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5352:
5353: procedure Set_Client(p_user_name varchar2, p_resp_id number,
5354: p_app_id number, p_sec_grp_id number) IS
5355: BEGIN
5356: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5357: Set_Client_html(p_user_name, p_resp_id,p_app_id, p_sec_grp_id);
5358: ELSE
5359: Set_Client_text(p_user_name, p_resp_id,p_app_id, p_sec_grp_id);
5360: END IF;

Line 5365: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5361: END;
5362:
5363: procedure Set_Client(p_user_name varchar2, p_resp_id number) IS
5364: BEGIN
5365: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5366: Set_Client_html(p_user_name, p_resp_id);
5367: ELSE
5368: Set_Client_text(p_user_name, p_resp_id);
5369: END IF;

Line 5375: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5371:
5372: procedure Set_Client(p_user_name varchar2, p_resp_id number,
5373: p_app_id number ) IS
5374: BEGIN
5375: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5376: Set_Client_html(p_user_name, p_resp_id,p_app_id);
5377: ELSE
5378: Set_Client_text(p_user_name, p_resp_id,p_app_id);
5379: END IF;

Line 5395: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5391: , p_bug_number varchar2 default '%'
5392: , p_start_date date default to_date(olddate,'MM-DD-YYYY')
5393: , p_output_option varchar2 default 'TABLE') IS
5394: BEGIN
5395: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5396: Get_DB_Patch_List_html (p_heading, p_app_short_name, p_bug_number, p_start_date, p_output_option);
5397: ELSE
5398: -- API currently not implemented for text
5399: null;

Line 5417: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5413: , p_app_short_name varchar2 default '%'
5414: , p_bug_number varchar2 default '%'
5415: , p_start_date date default to_date(olddate,'MM-DD-YYYY')) is
5416: BEGIN
5417: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5418: -- API currently not implemented for html
5419: null;
5420: ELSE
5421: Get_DB_Patch_List_text(p_heading, p_app_short_name, p_bug_number, p_start_date);

Line 5438: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5434: Procedure Show_Invalids (p_start_string varchar2
5435: , p_include_errors varchar2 default 'N'
5436: , p_heading varchar2 default null) IS
5437: BEGIN
5438: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5439: Show_Invalids_html(p_start_string,p_include_errors,p_heading);
5440: ELSE
5441: Show_Invalids_text(p_start_string,p_include_errors,p_heading);
5442: END IF;

Line 5450: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5446: Function CheckKeyFlexfield(p_flex_code in varchar2
5447: , p_flex_num in number default null
5448: , p_print_heading in boolean default true) return V2T IS
5449: BEGIN
5450: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5451: return CheckKeyFlexfield_html(p_flex_code,p_flex_num,p_print_heading);
5452: ELSE
5453: return CheckKeyFlexfield_text(p_flex_code,p_flex_num,p_print_heading);
5454: END IF;

Line 5465: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5461: , p_appl_id in number
5462: , p_default in varchar2 default null
5463: , p_indent in integer default 0) return varchar2 IS
5464: BEGIN
5465: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5466: return CheckProfile_html(p_prof_name, p_user_id, p_resp_id, p_appl_id, p_default, p_indent);
5467: ELSE
5468: return CheckProfile_text(p_prof_name, p_user_id, p_resp_id, p_appl_id, p_default, p_indent);
5469: END IF;

Line 5476: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5472:
5473:
5474: function Column_Exists(p_tab in varchar, p_col in varchar, p_owner in varchar) return varchar2 IS
5475: BEGIN
5476: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5477: return Column_Exists_html(p_tab, p_col, p_owner);
5478: ELSE
5479: return Column_Exists_text(p_tab, p_col, p_owner);
5480: END IF;

Line 5491: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5487: , p_feedback varchar2 default 'Y'
5488: , p_max_rows number default null
5489: , p_current_exec number default 0) return number IS
5490: BEGIN
5491: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5492: return Display_SQL_html(p_sql_statement, table_alias, FALSE, display_longs, p_feedback, p_max_rows, p_current_exec);
5493: ELSE
5494: -- API currently not implemented for text
5495: null;

Line 5507: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5503: , p_feedback varchar2 default 'Y'
5504: , p_max_rows number default null
5505: , p_current_exec number default 0) return number IS
5506: BEGIN
5507: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5508: return Display_SQL_html(p_sql_statement, table_alias, hideHeader, display_longs, p_feedback, p_max_rows, p_current_exec);
5509: ELSE
5510: -- API currently not implemented for text
5511: null;

Line 5523: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5519: version_str in out NOCOPY varchar2,
5520: compare_version in varchar2)
5521: return varchar2 is
5522: BEGIN
5523: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5524: -- API currently not implemented for html
5525: null;
5526: ELSE
5527: return Compare_Pkg_Version_text(package_name,object_type,object_owner,version_str,compare_version);

Line 5539: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5535: p_where_clause varchar2,
5536: p_order_by_clause varchar2 default null,
5537: p_display_longs varchar2 default 'Y') return number IS
5538: BEGIN
5539: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5540: return Display_Table_html (p_table_name,p_table_alias, p_where_clause, p_order_by_clause, p_display_longs);
5541: ELSE
5542: -- API currently not implemented for text
5543: null;

Line 5551: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5547:
5548:
5549: function Get_DB_Apps_Version return varchar2 IS
5550: BEGIN
5551: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5552: return Get_DB_Apps_Version_html;
5553: ELSE
5554: return Get_DB_Apps_Version_text;
5555: END IF;

Line 5560: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5556: END;
5557:
5558: function Get_Package_Version (p_type varchar2, p_schema varchar2, p_package varchar2) return varchar2 IS
5559: BEGIN
5560: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5561: return Get_Package_Version_html(p_type, p_schema,p_package);
5562: ELSE
5563: return Get_Package_Version_text(p_type, p_schema,p_package);
5564: END IF;

Line 5569: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5565: END;
5566:
5567: function Get_Package_Spec(p_package varchar2) return varchar2 IS
5568: BEGIN
5569: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5570: return Get_Package_Spec_html(p_package);
5571: ELSE
5572: return Get_Package_Spec_text(p_package);
5573: END IF;

Line 5578: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5574: END;
5575:
5576: function Get_Package_Body(p_package varchar2) return varchar2 IS
5577: BEGIN
5578: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5579: return Get_Package_Body_html(p_package);
5580: ELSE
5581: return Get_Package_Body_text(p_package);
5582: END IF;

Line 5588: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5584:
5585:
5586: function Get_Profile_Option (p_profile_option varchar2) return varchar2 IS
5587: BEGIN
5588: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5589: return Get_Profile_Option_html(p_profile_option);
5590: ELSE
5591: return Get_Profile_Option_text(p_profile_option);
5592: END IF;

Line 5598: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5594:
5595:
5596: Function Get_RDBMS_Header return varchar2 IS
5597: BEGIN
5598: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5599: return Get_RDBMS_Header_html;
5600: ELSE
5601: return Get_RDBMS_Header_text;
5602: END IF;

Line 5615: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5611: , p_feedback varchar2 default 'Y'
5612: , p_max_rows number default null)
5613: return number is
5614: BEGIN
5615: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5616: -- API currently not implemented for html
5617: null;
5618: ELSE
5619: return Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers,p_feedback, p_max_rows);

Line 5628: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5624: procedure Display_SQL (
5625: p_sql_statement varchar2
5626: , p_disp_lengths lengths) is
5627: BEGIN
5628: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5629: -- API currently not implemented for html
5630: null;
5631: ELSE
5632: Display_SQL_text(p_sql_statement,p_disp_lengths);

Line 5641: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5637: p_sql_statement varchar2
5638: , p_disp_lengths lengths
5639: , p_headers headers) is
5640: BEGIN
5641: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5642: -- API currently not implemented for html
5643: null;
5644: ELSE
5645: Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers);

Line 5655: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5651: , p_disp_lengths lengths
5652: , p_headers headers
5653: , p_feedback varchar2) is
5654: BEGIN
5655: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5656: -- API currently not implemented for html
5657: null;
5658: ELSE
5659: Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers,p_feedback);

Line 5672: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5668: , p_headers headers
5669: , p_feedback varchar2
5670: , p_max_rows number) is
5671: BEGIN
5672: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5673: -- API currently not implemented for html
5674: null;
5675: ELSE
5676: Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers,p_feedback, p_max_rows);