DBA Data[Home] [Help]

APPS.IEM_DIAG_DATABASE_LINK_PVT dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 49: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

45: l_link_cur LinkCur;
46: l_statement VARCHAR2(2000);
47:
48: BEGIN
49: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
50: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
51: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
52:
53: select oracle_username into l_schema_owner from fnd_oracle_userid where read_only_flag = 'U';

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

46: l_statement VARCHAR2(2000);
47:
48: BEGIN
49: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
50: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
51: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
52:
53: select oracle_username into l_schema_owner from fnd_oracle_userid where read_only_flag = 'U';
54:

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

102:
103: select count(*) into l_count from iem_db_connections where db_server_id=l_db_server_tbl(i) and is_admin='P';
104:
105: if (l_count = 0) then
106: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
107: statusStr := 'FAILURE';
108: errOra1 := errOra1 || l_db_name || ', ';
109: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
110: isFatal := 'TRUE';

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

145: END LOOP;
146:
147: if (statusStr = 'SUCCESS') then
148: reportStr := ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUCCESS') || '

';
149: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
150: else
151: reportStr := '


';
152: if (errOO1 <> FND_API.G_MISS_CHAR) then
153: errOO1 := RTRIM(errOO1, ', ');

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

152: if (errOO1 <> FND_API.G_MISS_CHAR) then
153: errOO1 := RTRIM(errOO1, ', ');
154: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR1') || ' ';
155: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint( FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM1') );
156: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
157: end if;
158:
159: if (errOO2 <> FND_API.G_MISS_CHAR) then
160: errOO2 := RTRIM(errOO2, ', ');

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

159: if (errOO2 <> FND_API.G_MISS_CHAR) then
160: errOO2 := RTRIM(errOO2, ', ');
161: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR2') || ' (' || errOO2 || ' )' || ' ';
162: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM2'));
163: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
164: end if;
165: if (errOO3 <> FND_API.G_MISS_CHAR) then
166: errOO3 := RTRIM(errOO3, ', ');
167: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR5') || ' (' || errOO3 || ' )' || ' ';

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

165: if (errOO3 <> FND_API.G_MISS_CHAR) then
166: errOO3 := RTRIM(errOO3, ', ');
167: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR5') || ' (' || errOO3 || ' )' || ' ';
168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM5'));
169: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
170: end if;
171:
172: if (errOra1 <> FND_API.G_MISS_CHAR) then
173: errOra1 := RTRIM(errOra1, ', ');

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

172: if (errOra1 <> FND_API.G_MISS_CHAR) then
173: errOra1 := RTRIM(errOra1, ', ');
174: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR3') || ' ';
175: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM3'));
176: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
177: end if;
178: if (errOra2 <> FND_API.G_MISS_CHAR) then
179: errOra2 := RTRIM(errOra2, ', ');
180: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR4') || ' (' || errOra2|| ' )' || ' ';

Line 190: reports := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

186: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM6'));
187: end if;
188: end if;
189:
190: reports := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
191: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
192: END runTest;
193:
194: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 191: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

187: end if;
188: end if;
189:
190: reports := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
191: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
192: END runTest;
193:
194: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
195: BEGIN

Line 211: return JTF_DIAGNOSTIC_ADAPTUTIL.BOTH_MODE;

207: END getTestName;
208:
209: FUNCTION getTestMode RETURN INTEGER IS
210: BEGIN
211: return JTF_DIAGNOSTIC_ADAPTUTIL.BOTH_MODE;
212: END getTestMode;
213:
214: PROCEDURE getDefaultTestParams(defaultInputvalues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
215: tempInput JTF_DIAG_INPUTTBL;