DBA Data[Home] [Help]

APPS.IEM_DIAG_DATABASE_LINK_PVT dependencies on FND_MESSAGE

Line 67: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

63:
64: if (l_count = 0) then
65: statusStr := 'FAILURE';
66: errOO1 := errOO1 || l_db_name || ', ';
67: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
68: isFatal := 'TRUE';
69: else
70: select a.db_link into l_db_link from iem_db_connections a, iem_db_servers b where a.db_server_id=b.db_server_id and a.is_admin='A' and a.db_server_id=l_db_server_tbl(i);
71:

Line 79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

75:
76: if (l_link_count = 0) then
77: statusStr := 'FAILURE';
78: errOO2 := errOO2 || l_db_link || ', ';
79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
80: isFatal := 'TRUE';
81: else
82: -- check if oo link is valid
83: BEGIN

Line 97: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

93:
94: WHEN OTHERS THEN
95: statusStr := 'FAILURE';
96: errOO3 := errOO3 || l_db_link || ', ';
97: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
98: isFatal := 'TRUE';
99: END;
100: end if; -- (l_link_count = 0)
101: end if; -- (l_count = 0)

Line 109: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

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';
111: else
112: select a.db_link into l_db_link from iem_db_connections a, iem_db_servers b where a.db_server_id=b.db_server_id and a.is_admin='P' and a.db_server_id=l_db_server_tbl(i);
113:

Line 121: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

117:
118: if (l_link_count = 0) then
119: statusStr := 'FAILURE';
120: errOra2 := errOra2 || l_db_link || ', ';
121: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
122: isFatal := 'TRUE';
123: else
124: -- check if ora link is valid
125: BEGIN

Line 138: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

134: EXCEPTION
135: WHEN OTHERS THEN
136: statusStr := 'FAILURE';
137: errOra3 := errOra3 || l_db_link || ', ';
138: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
139: isFatal := 'TRUE';
140: END;
141:
142: end if; -- (l_link_count = 0)

Line 148: reportStr := ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUCCESS') || '

';

144:
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

Line 154: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR1') || ' ';

150: else
151: 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:

Line 155: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint( FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM1') );

151: 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

Line 161: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR2') || ' (' || errOO2 || ' )' || ' ';

157: end if;
158:
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

Line 162: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM2'));

158:
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, ', ');

Line 167: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR5') || ' (' || errOO3 || ' )' || ' ';

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 || ' )' || ' ';
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:

Line 168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM5'));

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 || ' )' || ' ';
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

Line 174: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR3') || ' ';

170: end if;
171:
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

Line 175: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM3'));

171:
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, ', ');

Line 180: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR4') || ' (' || errOra2|| ' )' || ' ';

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|| ' )' || ' ';
181: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM4'));
182: end if;
183: if (errOra3 <> FND_API.G_MISS_CHAR) then
184: errOra3 := RTRIM(errOra3, ', ');

Line 181: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM4'));

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|| ' )' || ' ';
181: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM4'));
182: end if;
183: if (errOra3 <> FND_API.G_MISS_CHAR) then
184: errOra3 := RTRIM(errOra3, ', ');
185: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR6') || ' (' || errOra3|| ' )' || ' ';

Line 185: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR6') || ' (' || errOra3|| ' )' || ' ';

181: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM4'));
182: end if;
183: if (errOra3 <> FND_API.G_MISS_CHAR) then
184: errOra3 := RTRIM(errOra3, ', ');
185: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR6') || ' (' || errOra3|| ' )' || ' ';
186: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM6'));
187: end if;
188: end if;
189:

Line 186: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_SUM6'));

182: end if;
183: if (errOra3 <> FND_API.G_MISS_CHAR) then
184: errOra3 := RTRIM(errOra3, ', ');
185: errStr := errStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC7_ERROR6') || ' (' || errOra3|| ' )' || ' ';
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);

Line 196: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT3');

192: END runTest;
193:
194: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
195: BEGIN
196: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT3');
197: END getComponentName;
198:
199: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
200: BEGIN

Line 201: descStr := '';

197: END getComponentName;
198:
199: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
200: BEGIN
201: descStr := '

';
202: END getTestDesc;
203:
204: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
205: BEGIN

Line 206: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME7');

202: END getTestDesc;
203:
204: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
205: BEGIN
206: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME7');
207: END getTestName;
208:
209: FUNCTION getTestMode RETURN INTEGER IS
210: BEGIN