59: where UPPER(email_user)=UPPER(c_account) and UPPER(domain)=UPPER(c_domain);
60:
61: if (l_account_count = 0) then
62: statusStr := 'FAILURE';
63: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1');
64: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1') || '
';
65: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
66: isFatal := 'FALSE';
67: else
60:
61: if (l_account_count = 0) then
62: statusStr := 'FAILURE';
63: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1');
64: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1') || '
';
65: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
66: isFatal := 'FALSE';
67: else
68:
61: if (l_account_count = 0) then
62: statusStr := 'FAILURE';
63: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1');
64: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR1') || '
';
65: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
66: isFatal := 'FALSE';
67: else
68:
69:
73: and UPPER(b.classification)=UPPER(c_intent);
74:
75: if (l_classification_count = 0) then
76: statusStr := 'FAILURE';
77: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2');
78: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2') || '
';
79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
80: isFatal := 'FALSE';
81: else
74:
75: if (l_classification_count = 0) then
76: statusStr := 'FAILURE';
77: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2');
78: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2') || '
';
79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
80: isFatal := 'FALSE';
81: else
82:
75: if (l_classification_count = 0) then
76: statusStr := 'FAILURE';
77: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2');
78: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR2') || '
';
79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
80: isFatal := 'FALSE';
81: else
82:
83: select b.classification_id into l_classification_id from iem_email_accounts a, iem_classifications b
94: WHERE CLASSIFICATION_ID=l_classification_id AND QUERY_RESPONSE='R' and score>0;
95:
96: if (l_theme_count = 0) then
97: statusStr := 'FAILURE';
98: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3');
99: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3') || '
';
100: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
101: isFatal := 'FALSE';
102: else
95:
96: if (l_theme_count = 0) then
97: statusStr := 'FAILURE';
98: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3');
99: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3') || '
';
100: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
101: isFatal := 'FALSE';
102: else
103:
96: if (l_theme_count = 0) then
97: statusStr := 'FAILURE';
98: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3');
99: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC9_ERROR3') || '
';
100: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
101: isFatal := 'FALSE';
102: else
103:
104: FOR v1 in theme_csr LOOP
131: l_result_string := l_result_string || '
';
139:
148:
149:
150: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
151: BEGIN
152: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT4');
153: END getComponentName;
154:
155: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
156: BEGIN
153: END getComponentName;
154:
155: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
156: BEGIN
157: descStr := '
';
158: END getTestDesc;
159:
160: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
161: BEGIN
158: END getTestDesc;
159:
160: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
161: BEGIN
162: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME9');
163: END getTestName;
164:
165: FUNCTION getTestMode RETURN INTEGER IS
166: BEGIN