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 2458: --dbms_lob.write(JTF_DIAGNOSTIC_ADAPTUTIL.reportClob, length(text)+1, g_curr_loc, text || l_newline);

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

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

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

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

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

Line 4713: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4709: -----------------------------------------------------------------------
4710:
4711: procedure line_out (text varchar2) IS
4712: BEGIN
4713: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4714: line_out_html (text);
4715: ELSE
4716: line_out_text (text );
4717: END IF;

Line 4723: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4719:
4720:
4721: procedure Insert_Style_Sheet IS
4722: BEGIN
4723: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4724: Insert_Style_Sheet_html;
4725: ELSE
4726: -- API currently not implemented for text
4727: null;

Line 4734: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4730:
4731:
4732: procedure Insert_HTML(p_text varchar2) IS
4733: BEGIN
4734: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4735: Insert_HTML_html(p_text);
4736: ELSE
4737: -- API currently not implemented for text
4738: null;

Line 4745: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4741:
4742:
4743: procedure ActionErrorPrint(p_text varchar2) IS
4744: BEGIN
4745: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4746: ActionErrorPrint_html(p_text);
4747: ELSE
4748: ActionErrorPrint_text(p_text);
4749: END IF;

Line 4757: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4753:
4754:
4755: procedure ActionPrint(p_text varchar2) IS
4756: BEGIN
4757: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4758: ActionPrint_html(p_text);
4759: ELSE
4760: ActionPrint_text(p_text);
4761: END IF;

Line 4767: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4763:
4764:
4765: procedure ActionWarningPrint(p_text varchar2) IS
4766: BEGIN
4767: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4768: ActionWarningPrint_html(p_text);
4769: ELSE
4770: ActionWarningPrint_text(p_text);
4771: END IF;

Line 4778: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4774:
4775:
4776: procedure WarningPrint(p_text varchar2) IS
4777: BEGIN
4778: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4779: WarningPrint_html(p_text);
4780: ELSE
4781: WarningPrint_text(p_text);
4782: END IF;

Line 4790: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4786: procedure ActionErrorLink(p_txt1 varchar2
4787: , p_note varchar2
4788: , p_txt2 varchar2) IS
4789: BEGIN
4790: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4791: ActionErrorLink_html(p_txt1, p_note, p_txt2);
4792: ELSE
4793: -- API currently not implemented for text
4794: null;

Line 4804: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4800: , p_url varchar2
4801: , p_link_txt varchar2
4802: , p_txt2 varchar2) IS
4803: BEGIN
4804: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4805: ActionErrorLink_html(p_txt1,p_url,p_link_txt,p_txt2);
4806: ELSE
4807: -- API currently not implemented for text
4808: null;

Line 4817: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4813: procedure ActionWarningLink(p_txt1 varchar2
4814: , p_note varchar2
4815: , p_txt2 varchar2) IS
4816: BEGIN
4817: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4818: ActionWarningLink_html(p_txt1, p_note, p_txt2);
4819: ELSE
4820: -- API currently not implemented for text
4821: null;

Line 4831: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4827: , p_url varchar2
4828: , p_link_txt varchar2
4829: , p_txt2 varchar2) IS
4830: BEGIN
4831: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4832: ActionWarningLink_html(p_txt1,p_url ,p_link_txt,p_txt2);
4833: ELSE
4834: -- API currently not implemented for text
4835: null;

Line 4842: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4838:
4839:
4840: procedure ErrorPrint(p_text varchar2) IS
4841: BEGIN
4842: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4843: ErrorPrint_html(p_text);
4844: ELSE
4845: ErrorPrint_text(p_text);
4846: END IF;

Line 4852: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4848:
4849:
4850: procedure SectionPrint(p_text varchar2) IS
4851: BEGIN
4852: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4853: SectionPrint_html(p_text);
4854: ELSE
4855: SectionPrint_text(p_text);
4856: END IF;

Line 4862: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4858:
4859:
4860: procedure Tab0Print (p_text varchar2) IS
4861: BEGIN
4862: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4863: Tab0Print_html(p_text);
4864: ELSE
4865: Tab0Print_text(p_text);
4866: END IF;

Line 4872: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4868:
4869:
4870: procedure Tab1Print (p_text varchar2) IS
4871: BEGIN
4872: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4873: Tab1Print_html(p_text);
4874: ELSE
4875: Tab1Print_text(p_text);
4876: END IF;

Line 4883: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4879:
4880:
4881: procedure Tab2Print (p_text varchar2) IS
4882: BEGIN
4883: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4884: Tab2Print_html(p_text);
4885: ELSE
4886: Tab2Print_text(p_text);
4887: END IF;

Line 4892: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4888: END;
4889:
4890: procedure Tab3Print (p_text varchar2) IS
4891: BEGIN
4892: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4893: Tab3Print_html(p_text);
4894: ELSE
4895: Tab3Print_text(p_text);
4896: END IF;

Line 4901: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4897: END;
4898:
4899: procedure BRPrint IS
4900: BEGIN
4901: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4902: BRPrint_html;
4903: ELSE
4904: BRPrint_text;
4905: END IF;

Line 4910: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4906: END;
4907:
4908: procedure checkFinPeriod (p_sobid NUMBER, p_appid NUMBER ) IS
4909: BEGIN
4910: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4911: checkFinPeriod_html(p_sobid, p_appid);
4912: ELSE
4913: checkFinPeriod_text(p_sobid, p_appid );
4914: END IF;

Line 4922: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4918: procedure CheckKeyFlexfield(p_flex_code in varchar2
4919: , p_flex_num in number default null
4920: , p_print_heading in boolean default true) IS
4921: BEGIN
4922: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4923: CheckKeyFlexfield_html(p_flex_code,p_flex_num,p_print_heading);
4924: ELSE
4925: CheckKeyFlexfield_text(p_flex_code,p_flex_num,p_print_heading);
4926: END IF;

Line 4937: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4933: , p_appl_id in number
4934: , p_default in varchar2 default null
4935: , p_indent in integer default 0) IS
4936: BEGIN
4937: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4938: CheckProfile_html(p_prof_name, p_user_id, p_resp_id,p_appl_id,p_default,p_indent);
4939: ELSE
4940: CheckProfile_text(p_prof_name, p_user_id, p_resp_id,p_appl_id,p_default,p_indent);
4941: END IF;

Line 4947: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4943:
4944:
4945: procedure Begin_Pre IS
4946: BEGIN
4947: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4948: Begin_Pre_html;
4949: ELSE
4950: -- API currently not implemented for text
4951: null;

Line 4958: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4954:
4955:
4956: procedure End_Pre IS
4957: BEGIN
4958: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4959: End_Pre_html;
4960: ELSE
4961: -- API currently not implemented for text
4962: null;

Line 4969: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4965:
4966:
4967: procedure Show_Table(p_type varchar2, p_values V2T, p_caption varchar2 default null, p_options V2T default null) IS
4968: BEGIN
4969: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4970: Show_Table_html(p_type, p_values, p_caption, p_options);
4971: ELSE
4972: -- API currently not implemented for text
4973: null;

Line 4980: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4976:
4977:
4978: procedure Show_Table(p_values V2T) IS
4979: BEGIN
4980: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4981: Show_Table_html(p_values);
4982: ELSE
4983: -- API currently not implemented for text
4984: null;

Line 4991: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4987:
4988:
4989: procedure Show_Table(p_type varchar2) IS
4990: BEGIN
4991: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
4992: Show_Table_html(p_type);
4993: ELSE
4994: -- API currently not implemented for text
4995: null;

Line 5002: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

4998:
4999:
5000: procedure Show_Table_Row(p_values V2T, p_options V2T default null) IS
5001: BEGIN
5002: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5003: Show_Table_Row_html(p_values, p_options);
5004: ELSE
5005: -- API currently not implemented for text
5006: null;

Line 5013: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5009:
5010:
5011: procedure Show_Table_Header(p_values V2T, p_options V2T default null) IS
5012: BEGIN
5013: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5014: Show_Table_Header_html(p_values, p_options);
5015: ELSE
5016: -- API currently not implemented for text
5017: null;

Line 5023: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5019: END;
5020:
5021: procedure Show_Table_Header(p_headers in headers, p_lengths in out NOCOPY lengths) IS
5022: BEGIN
5023: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5024: Show_Table_Header_text(p_headers,p_lengths);
5025: ELSE
5026: -- API currently not implemented for text
5027: null;

Line 5034: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5030:
5031:
5032: procedure Start_Table(p_caption varchar2 default null) IS
5033: BEGIN
5034: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5035: Start_Table_html(p_caption);
5036: ELSE
5037: -- API currently not implemented for text
5038: null;

Line 5045: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5041:
5042:
5043: procedure End_Table IS
5044: BEGIN
5045: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5046: End_Table_html;
5047: ELSE
5048: -- API currently not implemented for text
5049: null;

Line 5056: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5052:
5053:
5054: function Run_SQL(p_title varchar2, p_sql_statement varchar2) return number is
5055: BEGIN
5056: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5057: return Run_SQL_html(p_title,p_sql_statement);
5058: ELSE
5059: -- API currently not implemented for text
5060: null;

Line 5068: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5064: function Run_SQL(p_title varchar2
5065: , p_sql_statement varchar2
5066: , p_feedback varchar2) return number is
5067: BEGIN
5068: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5069: return Run_SQL_html(p_title,p_sql_statement,p_feedback);
5070: ELSE
5071: -- API currently not implemented for text
5072: null;

Line 5081: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5077: function Run_SQL(p_title varchar2
5078: , p_sql_statement varchar2
5079: , p_max_rows number) return number is
5080: BEGIN
5081: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5082: return Run_SQL_html(p_title,p_sql_statement,p_max_rows);
5083: ELSE
5084: -- API currently not implemented for text
5085: null;

Line 5096: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5092: , p_sql_statement varchar2
5093: , p_feedback varchar2
5094: , p_max_rows number) return number is
5095: BEGIN
5096: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5097: return Run_SQL_html(p_title,p_sql_statement,p_feedback ,p_max_rows);
5098: ELSE
5099: -- API currently not implemented for text
5100: null;

Line 5107: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5103:
5104:
5105: procedure Run_SQL(p_title varchar2, p_sql_statement varchar2) is
5106: BEGIN
5107: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5108: Run_SQL_html(p_title,p_sql_statement);
5109: ELSE
5110: -- API currently not implemented for text
5111: null;

Line 5120: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5116: procedure Run_SQL(p_title varchar2
5117: , p_sql_statement varchar2
5118: , p_feedback varchar2) is
5119: BEGIN
5120: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5121: Run_SQL_html(p_title,p_sql_statement,p_feedback);
5122: ELSE
5123: -- API currently not implemented for text
5124: null;

Line 5133: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5129: procedure Run_SQL(p_title varchar2
5130: , p_sql_statement varchar2
5131: , p_max_rows number) is
5132: BEGIN
5133: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5134: Run_SQL_html(p_title,p_sql_statement,p_max_rows);
5135: ELSE
5136: -- API currently not implemented for text
5137: null;

Line 5146: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5142: , p_sql_statement varchar2
5143: , p_feedback varchar2
5144: , p_max_rows number) IS
5145: BEGIN
5146: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5147: Run_SQL_html(p_title,p_sql_statement,p_feedback ,p_max_rows);
5148: ELSE
5149: -- API currently not implemented for text
5150: null;

Line 5159: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5155: function Run_SQL(p_title varchar2,
5156: p_sql_statement varchar2,
5157: p_disp_lengths lengths) return number is
5158: BEGIN
5159: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5160: -- API currently not implemented for html
5161: null;
5162: ELSE
5163: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths);

Line 5174: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5170: p_sql_statement varchar2,
5171: p_disp_lengths lengths,
5172: p_headers headers) return number is
5173: BEGIN
5174: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5175: -- API currently not implemented for html
5176: null;
5177: ELSE
5178: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers);

Line 5188: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5184: p_disp_lengths lengths,
5185: p_headers headers,
5186: p_feedback varchar2) return number is
5187: BEGIN
5188: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5189: -- API currently not implemented for html
5190: null;
5191: ELSE
5192: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_feedback);

Line 5203: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5199: p_disp_lengths lengths,
5200: p_headers headers,
5201: p_max_rows number) return number is
5202: BEGIN
5203: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5204: -- API currently not implemented for html
5205: null;
5206: ELSE
5207: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_max_rows);

Line 5219: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5215: p_headers headers,
5216: p_feedback varchar2,
5217: p_max_rows number) return number is
5218: BEGIN
5219: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5220: -- API currently not implemented for html
5221: null;
5222: ELSE
5223: return Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers,p_feedback,p_max_rows);

Line 5233: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5229: procedure Run_SQL(p_title varchar2,
5230: p_sql_statement varchar2,
5231: p_disp_lengths lengths) IS
5232: BEGIN
5233: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5234: -- API currently not implemented for html
5235: null;
5236: ELSE
5237: Run_SQL_text(p_title,p_sql_statement,p_disp_lengths);

Line 5248: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5244: p_sql_statement varchar2,
5245: p_disp_lengths lengths,
5246: p_headers headers) is
5247: BEGIN
5248: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5249: -- API currently not implemented for html
5250: null;
5251: ELSE
5252: Run_SQL_text(p_title,p_sql_statement,p_disp_lengths,p_headers);

Line 5264: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5260: p_where_clause varchar2,
5261: p_order_by_clause varchar2 default null,
5262: p_display_longs varchar2 default 'Y') IS
5263: BEGIN
5264: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5265: Display_Table_html(p_table_name,p_table_alias ,p_where_clause,p_order_by_clause,p_display_longs);
5266: ELSE
5267: -- API currently not implemented for text
5268: null;

Line 5276: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5272:
5273:
5274: procedure Show_Header(p_note varchar2, p_title varchar2) IS
5275: BEGIN
5276: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5277: Show_Header_html(p_note, p_title);
5278: ELSE
5279: Show_Header_text(p_note, p_title);
5280: END IF;

Line 5288: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5284:
5285:
5286: procedure Show_Footer(p_script_name varchar2, p_header varchar2) IS
5287: BEGIN
5288: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5289: Show_Footer_html(p_script_name,p_header );
5290: ELSE
5291: Show_Footer_text;
5292: END IF;

Line 5298: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5294:
5295:
5296: procedure Show_Footer IS
5297: BEGIN
5298: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5299: -- API currently not implemented for html
5300: null;
5301: ELSE
5302: Show_Footer_text;

Line 5309: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5318: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5314: END;
5315:
5316: procedure Show_Link(p_link varchar2, p_link_name varchar2 ) IS
5317: BEGIN
5318: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5319: Show_Link_html(p_link, p_link_name);
5320: ELSE
5321: Show_Link_text(p_link, p_link_name);
5322: END IF;

Line 5332: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5328: , p_subject varchar2
5329: , p_message varchar2
5330: , p_mailhost varchar2) IS
5331: BEGIN
5332: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5333: Send_Email_html( p_sender, p_recipient, p_subject , p_message , p_mailhost);
5334: ELSE
5335: -- API currently not implemented for text
5336: null;

Line 5344: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5340:
5341: procedure Display_Profiles (p_application_id varchar2
5342: , p_short_name varchar2 default null) IS
5343: BEGIN
5344: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5345: Display_Profiles_html(p_application_id, p_short_name);
5346: ELSE
5347: Display_Profiles_text(p_application_id, p_short_name);
5348: END IF;

Line 5354: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5350:
5351:
5352: procedure Set_Org (p_org_id number) IS
5353: BEGIN
5354: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5355: Set_Org_html(p_org_id);
5356: ELSE
5357: Set_Org_text(p_org_id);
5358: END IF;

Line 5364: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5373: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5383: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5379:
5380: procedure Set_Client(p_user_name varchar2, p_resp_id number,
5381: p_app_id number ) IS
5382: BEGIN
5383: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5384: Set_Client_html(p_user_name, p_resp_id,p_app_id);
5385: ELSE
5386: Set_Client_text(p_user_name, p_resp_id,p_app_id);
5387: END IF;

Line 5403: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5399: , p_bug_number varchar2 default '%'
5400: , p_start_date date default to_date(olddate,'MM-DD-YYYY')
5401: , p_output_option varchar2 default 'TABLE') IS
5402: BEGIN
5403: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5404: Get_DB_Patch_List_html (p_heading, p_app_short_name, p_bug_number, p_start_date, p_output_option);
5405: ELSE
5406: -- API currently not implemented for text
5407: null;

Line 5425: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5421: , p_app_short_name varchar2 default '%'
5422: , p_bug_number varchar2 default '%'
5423: , p_start_date date default to_date(olddate,'MM-DD-YYYY')) is
5424: BEGIN
5425: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5426: -- API currently not implemented for html
5427: null;
5428: ELSE
5429: Get_DB_Patch_List_text(p_heading, p_app_short_name, p_bug_number, p_start_date);

Line 5446: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5442: Procedure Show_Invalids (p_start_string varchar2
5443: , p_include_errors varchar2 default 'N'
5444: , p_heading varchar2 default null) IS
5445: BEGIN
5446: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5447: Show_Invalids_html(p_start_string,p_include_errors,p_heading);
5448: ELSE
5449: Show_Invalids_text(p_start_string,p_include_errors,p_heading);
5450: END IF;

Line 5458: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5454: Function CheckKeyFlexfield(p_flex_code in varchar2
5455: , p_flex_num in number default null
5456: , p_print_heading in boolean default true) return V2T IS
5457: BEGIN
5458: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5459: return CheckKeyFlexfield_html(p_flex_code,p_flex_num,p_print_heading);
5460: ELSE
5461: return CheckKeyFlexfield_text(p_flex_code,p_flex_num,p_print_heading);
5462: END IF;

Line 5473: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5469: , p_appl_id in number
5470: , p_default in varchar2 default null
5471: , p_indent in integer default 0) return varchar2 IS
5472: BEGIN
5473: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5474: return CheckProfile_html(p_prof_name, p_user_id, p_resp_id, p_appl_id, p_default, p_indent);
5475: ELSE
5476: return CheckProfile_text(p_prof_name, p_user_id, p_resp_id, p_appl_id, p_default, p_indent);
5477: END IF;

Line 5484: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5480:
5481:
5482: function Column_Exists(p_tab in varchar, p_col in varchar, p_owner in varchar) return varchar2 IS
5483: BEGIN
5484: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5485: return Column_Exists_html(p_tab, p_col, p_owner);
5486: ELSE
5487: return Column_Exists_text(p_tab, p_col, p_owner);
5488: END IF;

Line 5499: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5495: , p_feedback varchar2 default 'Y'
5496: , p_max_rows number default null
5497: , p_current_exec number default 0) return number IS
5498: BEGIN
5499: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5500: return Display_SQL_html(p_sql_statement, table_alias, FALSE, display_longs, p_feedback, p_max_rows, p_current_exec);
5501: ELSE
5502: -- API currently not implemented for text
5503: null;

Line 5515: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5511: , p_feedback varchar2 default 'Y'
5512: , p_max_rows number default null
5513: , p_current_exec number default 0) return number IS
5514: BEGIN
5515: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5516: return Display_SQL_html(p_sql_statement, table_alias, hideHeader, display_longs, p_feedback, p_max_rows, p_current_exec);
5517: ELSE
5518: -- API currently not implemented for text
5519: null;

Line 5531: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5527: version_str in out NOCOPY varchar2,
5528: compare_version in varchar2)
5529: return varchar2 is
5530: BEGIN
5531: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5532: -- API currently not implemented for html
5533: null;
5534: ELSE
5535: return Compare_Pkg_Version_text(package_name,object_type,object_owner,version_str,compare_version);

Line 5547: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5543: p_where_clause varchar2,
5544: p_order_by_clause varchar2 default null,
5545: p_display_longs varchar2 default 'Y') return number IS
5546: BEGIN
5547: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5548: return Display_Table_html (p_table_name,p_table_alias, p_where_clause, p_order_by_clause, p_display_longs);
5549: ELSE
5550: -- API currently not implemented for text
5551: null;

Line 5559: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5555:
5556:
5557: function Get_DB_Apps_Version return varchar2 IS
5558: BEGIN
5559: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5560: return Get_DB_Apps_Version_html;
5561: ELSE
5562: return Get_DB_Apps_Version_text;
5563: END IF;

Line 5568: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5564: END;
5565:
5566: function Get_Package_Version (p_type varchar2, p_schema varchar2, p_package varchar2) return varchar2 IS
5567: BEGIN
5568: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5569: return Get_Package_Version_html(p_type, p_schema,p_package);
5570: ELSE
5571: return Get_Package_Version_text(p_type, p_schema,p_package);
5572: END IF;

Line 5577: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5573: END;
5574:
5575: function Get_Package_Spec(p_package varchar2) return varchar2 IS
5576: BEGIN
5577: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5578: return Get_Package_Spec_html(p_package);
5579: ELSE
5580: return Get_Package_Spec_text(p_package);
5581: END IF;

Line 5586: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5582: END;
5583:
5584: function Get_Package_Body(p_package varchar2) return varchar2 IS
5585: BEGIN
5586: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5587: return Get_Package_Body_html(p_package);
5588: ELSE
5589: return Get_Package_Body_text(p_package);
5590: END IF;

Line 5596: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5592:
5593:
5594: function Get_Profile_Option (p_profile_option varchar2) return varchar2 IS
5595: BEGIN
5596: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5597: return Get_Profile_Option_html(p_profile_option);
5598: ELSE
5599: return Get_Profile_Option_text(p_profile_option);
5600: END IF;

Line 5606: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5602:
5603:
5604: Function Get_RDBMS_Header return varchar2 IS
5605: BEGIN
5606: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5607: return Get_RDBMS_Header_html;
5608: ELSE
5609: return Get_RDBMS_Header_text;
5610: END IF;

Line 5630: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5626: , p_feedback varchar2 default 'Y'
5627: , p_max_rows number default null)
5628: return number is
5629: BEGIN
5630: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5631: -- API currently not implemented for html
5632: null;
5633: ELSE
5634: return Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers,p_feedback, p_max_rows);

Line 5643: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5656: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5670: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

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

Line 5687: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN

5683: , p_headers headers
5684: , p_feedback varchar2
5685: , p_max_rows number) is
5686: BEGIN
5687: IF (JTF_DIAGNOSTIC_ADAPTUTIL.b_html_on) THEN
5688: -- API currently not implemented for html
5689: null;
5690: ELSE
5691: Display_SQL_text(p_sql_statement,p_disp_lengths,p_headers,p_feedback, p_max_rows);