DBA Data[Home] [Help]

APPS.BIS_DIAG_SETUP_ENV_TEST dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

61: l_apps_version VARCHAR2(30);
62: l_db_version VARCHAR2 (2000);
63: l_num_rows NUMBER;
64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

Line 66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

62: l_db_version VARCHAR2 (2000);
63: l_num_rows NUMBER;
64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');

Line 69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');

66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;

Line 72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);

68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);

71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);

Line 88: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');
85: errStr := '';
86: fixInfo := '';
87: isFatal := 'FALSE';
88: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
89: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
90: END runTest;
91: ------------------------------------------------------------
92: -- procedure to report name back to framework

Line 89: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

85: errStr := '';
86: fixInfo := '';
87: isFatal := 'FALSE';
88: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
89: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
90: END runTest;
91: ------------------------------------------------------------
92: -- procedure to report name back to framework
93: ------------------------------------------------------------

Line 122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

118: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL)
119: IS
120: tempInput JTF_DIAG_INPUTTBL;
121: BEGIN
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: -- tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'USERID','SYSADMIN');
124: -- tempInput := JTF_DIAGNOSTIC_defaultInputValues := tempInput;
125: EXCEPTION
126: when others then

Line 123: -- tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'USERID','SYSADMIN');

119: IS
120: tempInput JTF_DIAG_INPUTTBL;
121: BEGIN
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: -- tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'USERID','SYSADMIN');
124: -- tempInput := JTF_DIAGNOSTIC_defaultInputValues := tempInput;
125: EXCEPTION
126: when others then
127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

123: -- tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'USERID','SYSADMIN');
124: -- tempInput := JTF_DIAGNOSTIC_defaultInputValues := tempInput;
125: EXCEPTION
126: when others then
127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
128: END getDefaultTestParams;
129:
130: END BIS_DIAG_SETUP_ENV_TEST;