DBA Data[Home] [Help]

APPS.IEM_DIAG_OES_RULE_PVT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 20: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

16: reports OUT NOCOPY JTF_DIAG_REPORT,
17: reportClob OUT NOCOPY CLOB) IS
18: reportStr LONG;
19: counter NUMBER;
20: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
21: c_userid VARCHAR2(50);
22: statusStr VARCHAR2(50) := 'SUCCESS';
23: errStr VARCHAR2(4000);
24: fixInfo VARCHAR2(4000);

Line 62: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

58: l_length NUMBER;
59: BEGIN
60: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
61: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
62: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
63:
64: l_string := 'select email_user, domain, db_server_id, email_password, account_flag from iem_email_accounts';
65:
66: select db_link into l_apps_link from iem_db_connections where is_admin='O';

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