DBA Data[Home] [Help]

APPS.IEM_DIAG_OES_RULE_PVT dependencies on FND_MESSAGE

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

91: EXECUTE IMMEDIATE l_str using OUT l_ret,l_account_rec.email_user,l_account_rec.domain,l_account_rec.email_password;
92: IF l_ret<>0 THEN
93: statusStr := 'FAILURE';
94: l_notauthen_accounts := l_notauthen_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
95: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
96: isFatal := 'FALSE';
97: END IF;
98:
99: l_cursorID := DBMS_SQL.OPEN_CURSOR;

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

126: if (l_account_rec.account_flag = 'A') then
127: if (l_rule_count <> 0) then
128: statusStr := 'FAILURE';
129: l_mulrule_accounts := l_mulrule_accounts || l_account_rec.email_user || ', ';
130: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
131: isFatal := 'FALSE';
132: end if;
133:
134: else

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

134: else
135: if (l_rule_count = 0) then
136: statusStr := 'FAILURE';
137: l_norule_accounts := l_norule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
138: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
139: isFatal := 'FALSE';
140: elsif (l_rule_count > 1) then
141: statusStr := 'FAILURE';
142: l_mulrule_accounts := l_mulrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';

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

139: isFatal := 'FALSE';
140: elsif (l_rule_count > 1) then
141: statusStr := 'FAILURE';
142: l_mulrule_accounts := l_mulrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
143: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
144: isFatal := 'FALSE';
145: else
146:
147: -- Check the rule has valid apps link name

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

167:
168: if (l_length < 35) then
169: statusStr := 'FAILURE';
170: l_invalidrule_accounts := l_invalidrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
171: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
172: isFatal := 'FALSE';
173: else
174: select substr(l_rule_name, 35) into l_rule_apps_name from dual;
175:

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

175:
176: if (l_rule_apps_name <> l_apps_link) then
177: statusStr := 'FAILURE';
178: l_invalidrule_accounts := l_invalidrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
179: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
180: isFatal := 'FALSE';
181: end if;
182: end if;
183:

Line 196: reportStr := ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUCCESS') || '

';

192:
193: close email_account_cur;
194:
195: if (statusStr = 'SUCCESS') then
196: reportStr := ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUCCESS') || '

';
197: else
198: if (l_notauthen_accounts <> FND_API.G_MISS_CHAR) then
199: l_notauthen_accounts := RTRIM(l_notauthen_accounts, ', ');
200: errStr := errStr || l_notauthen_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_ERROR1') || ' ';

Line 200: errStr := errStr || l_notauthen_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_ERROR1') || ' ';

196: reportStr := ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUCCESS') || '

';
197: else
198: if (l_notauthen_accounts <> FND_API.G_MISS_CHAR) then
199: l_notauthen_accounts := RTRIM(l_notauthen_accounts, ', ');
200: errStr := errStr || l_notauthen_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_ERROR1') || ' ';
201: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_SUM1'));
202: end if;
203: if (l_norule_accounts <> FND_API.G_MISS_CHAR) then
204: l_norule_accounts := RTRIM(l_norule_accounts, ', ');

Line 201: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_SUM1'));

197: else
198: if (l_notauthen_accounts <> FND_API.G_MISS_CHAR) then
199: l_notauthen_accounts := RTRIM(l_notauthen_accounts, ', ');
200: errStr := errStr || l_notauthen_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_ERROR1') || ' ';
201: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_SUM1'));
202: end if;
203: if (l_norule_accounts <> FND_API.G_MISS_CHAR) then
204: l_norule_accounts := RTRIM(l_norule_accounts, ', ');
205: errStr := errStr || l_norule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR2') || ' ';

Line 205: errStr := errStr || l_norule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR2') || ' ';

201: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC2_SUM1'));
202: end if;
203: if (l_norule_accounts <> FND_API.G_MISS_CHAR) then
204: l_norule_accounts := RTRIM(l_norule_accounts, ', ');
205: errStr := errStr || l_norule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR2') || ' ';
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM1'));
207: end if;
208: if (l_mulrule_accounts <> FND_API.G_MISS_CHAR) then
209: l_mulrule_accounts := RTRIM(l_mulrule_accounts, ', ');

Line 206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM1'));

202: end if;
203: if (l_norule_accounts <> FND_API.G_MISS_CHAR) then
204: l_norule_accounts := RTRIM(l_norule_accounts, ', ');
205: errStr := errStr || l_norule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR2') || ' ';
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM1'));
207: end if;
208: if (l_mulrule_accounts <> FND_API.G_MISS_CHAR) then
209: l_mulrule_accounts := RTRIM(l_mulrule_accounts, ', ');
210: errStr := errStr || l_mulrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR3') || ' ';

Line 210: errStr := errStr || l_mulrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR3') || ' ';

206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM1'));
207: end if;
208: if (l_mulrule_accounts <> FND_API.G_MISS_CHAR) then
209: l_mulrule_accounts := RTRIM(l_mulrule_accounts, ', ');
210: errStr := errStr || l_mulrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR3') || ' ';
211: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));
212: end if;
213: if (l_invalidrule_accounts <> FND_API.G_MISS_CHAR) then
214: l_invalidrule_accounts := RTRIM(l_invalidrule_accounts, ', ');

Line 211: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));

207: end if;
208: if (l_mulrule_accounts <> FND_API.G_MISS_CHAR) then
209: l_mulrule_accounts := RTRIM(l_mulrule_accounts, ', ');
210: errStr := errStr || l_mulrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR3') || ' ';
211: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));
212: end if;
213: if (l_invalidrule_accounts <> FND_API.G_MISS_CHAR) then
214: l_invalidrule_accounts := RTRIM(l_invalidrule_accounts, ', ');
215: errStr := errStr || l_invalidrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR4') || ' ';

Line 215: errStr := errStr || l_invalidrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR4') || ' ';

211: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));
212: end if;
213: if (l_invalidrule_accounts <> FND_API.G_MISS_CHAR) then
214: l_invalidrule_accounts := RTRIM(l_invalidrule_accounts, ', ');
215: errStr := errStr || l_invalidrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR4') || ' ';
216: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));
217: end if;
218: end if;
219:

Line 216: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));

212: end if;
213: if (l_invalidrule_accounts <> FND_API.G_MISS_CHAR) then
214: l_invalidrule_accounts := RTRIM(l_invalidrule_accounts, ', ');
215: errStr := errStr || l_invalidrule_accounts || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_ERROR4') || ' ';
216: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC3_SUM2'));
217: end if;
218: end if;
219:
220: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

Line 229: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT1');

225:
226:
227: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
228: BEGIN
229: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT1');
230: END getComponentName;
231:
232: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
233: BEGIN

Line 234: descStr := '';

230: END getComponentName;
231:
232: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: descStr := '

';
235: END getTestDesc;
236:
237: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
238: BEGIN

Line 239: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME3');

235: END getTestDesc;
236:
237: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
238: BEGIN
239: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME3');
240: END getTestName;
241:
242: FUNCTION getTestMode RETURN INTEGER IS
243: BEGIN