APPS.CSK_DIAG_SOLUTION_PVT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');

190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');
195: END currentUser;
196: ------------------
197: -- cascadeDeleteTest
198: ------------------

Line 218: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Name Move Solutions Test ');

214: l_end_tag number;
215: l_categories_section varchar2(4000) := '';
216:
217: BEGIN
218: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Name Move Solutions Test ');
219: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Ref CS_KB_SOLN_CATEGORIES_PVT_MOVE_SOLUTIONS_TEST');
220: -- step 10
221: l_soln_ids.EXTEND;
222: l_soln_ids(1) := g_move_solutions_test_s1_aID;

Line 219: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Ref CS_KB_SOLN_CATEGORIES_PVT_MOVE_SOLUTIONS_TEST');

215: l_categories_section varchar2(4000) := '';
216:
217: BEGIN
218: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Name Move Solutions Test ');
219: JTF_DIAGNOSTIC_COREAPI.line_out('
Test Ref CS_KB_SOLN_CATEGORIES_PVT_MOVE_SOLUTIONS_TEST');
220: -- step 10
221: l_soln_ids.EXTEND;
222: l_soln_ids(1) := g_move_solutions_test_s1_aID;
223: l_soln_ids.EXTEND;

Line 240: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 10] moveSolutions() execution ');

236: l_success := 'Y';
237: END IF;
238:
239: IF l_success = 'Y' THEN
240: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 10] moveSolutions() execution ');
241: --Step 20
242: select count(1) into l_count_1
243: from cs_kb_set_categories
244: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c2ID;

Line 249: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 20] solutions have been moved into c2');

245: select count(1) into l_count_2
246: from cs_kb_set_categories
247: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c2ID;
248: if l_count_1 = 1 and l_count_2 = 1 then
249: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 20] solutions have been moved into c2');
250: --step 30
251: select count(1) into l_count_1
252: from cs_kb_set_categories
253: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c1ID;

Line 258: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 30] solutions have been moved out of c1');

254: select count(1) into l_count_2
255: from cs_kb_set_categories
256: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c1ID;
257: if l_count_1 = 0 and l_count_2 = 0 then
258: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 30] solutions have been moved out of c1');
259: --step 40
260: l_index_content := CSK_SETUP_UTILITY_PKG.Calculate_Set_Index_Content(g_move_solutions_test_s1_aID);
261: select INSTR(l_index_content,'') into l_end_tag from dual;
262: if (l_end_tag > 0) then

Line 267: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');

263: select INSTR(l_index_content,'') into l_start_tag from dual;
264: l_categories_section := substr(l_index_content,l_start_tag+12,l_end_tag-l_start_tag-12);
265: select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;
266: if(l_count > 0) then
267: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');
268: else
269: l_success := 'N';
270: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 40] text index of child solution updated. ');
271: l_statusStr := 'FAILURE';

Line 270: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 40] text index of child solution updated. ');

266: if(l_count > 0) then
267: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');
268: else
269: l_success := 'N';
270: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 40] text index of child solution updated. ');
271: l_statusStr := 'FAILURE';
272: l_errStr := l_errStr||'
text index of child solution was not updated correctly';
273: l_fixInfo := '.';
274: l_isFatal := 'TRUE';

Line 277: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'WARNING: [ 50] Cannot fetch the whole section.');

273: l_fixInfo := '.';
274: l_isFatal := 'TRUE';
275: end if;
276: else
277: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'WARNING: [ 50] Cannot fetch the whole section.');
278: end if;
279: else
280: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 30] solutions have been moved out of c1 ');
281: l_statusStr := 'FAILURE';

Line 280: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 30] solutions have been moved out of c1 ');

276: else
277: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'WARNING: [ 50] Cannot fetch the whole section.');
278: end if;
279: else
280: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 30] solutions have been moved out of c1 ');
281: l_statusStr := 'FAILURE';
282: l_errStr := l_errStr||'
solutions have not been moved into c2';
283: l_fixInfo := '.';
284: l_isFatal := 'TRUE';

Line 288: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 20] solutions have been moved into c2 ');

284: l_isFatal := 'TRUE';
285: end if;
286:
287: else
288: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 20] solutions have been moved into c2 ');
289: l_statusStr := 'FAILURE';
290: l_errStr := l_errStr||'
solutions have not been moved into c2';
291: l_fixInfo := '.';
292: l_isFatal := 'TRUE';

Line 295: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 10] moveSolutions() execution ');

291: l_fixInfo := '.';
292: l_isFatal := 'TRUE';
293: end if;
294: ELSE
295: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 10] moveSolutions() execution ');
296: l_statusStr := 'FAILURE';
297: l_errStr := l_errStr||'
moveSolutions() execution failed';
298: l_fixInfo := '.';
299: l_isFatal := 'TRUE';

Line 320: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

316: -- if the report is HTML-based, then the first string added to
317: -- the report must be "@html".
318: -- addStringToReport writes to the Report CLOB
319: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
320: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
321: -- line_out writes to the Report CLOB
322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');

318: -- addStringToReport writes to the Report CLOB
319: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
320: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
321: -- line_out writes to the Report CLOB
322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;
325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');
326: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 324: JTF_DIAGNOSTIC_COREAPI.BRPrint;

320: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
321: -- line_out writes to the Report CLOB
322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;
325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');
326: JTF_DIAGNOSTIC_COREAPI.BRPrint;
327: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
328: l_statusStr := 'SUCCESS';

Line 325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');

321: -- line_out writes to the Report CLOB
322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;
325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');
326: JTF_DIAGNOSTIC_COREAPI.BRPrint;
327: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
328: l_statusStr := 'SUCCESS';
329: ----------------------------------------------

Line 326: JTF_DIAGNOSTIC_COREAPI.BRPrint;

322: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;
325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');
326: JTF_DIAGNOSTIC_COREAPI.BRPrint;
327: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
328: l_statusStr := 'SUCCESS';
329: ----------------------------------------------
330: -- Add Product Specific Tests Here:

Line 327: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');

323: -- BRPrint Adds a New Line to the Report CLOB
324: JTF_DIAGNOSTIC_COREAPI.BRPrint;
325: JTF_DIAGNOSTIC_COREAPI.line_out('=== Knowledge Management Diagnostics - cs_kb_solution_pvt');
326: JTF_DIAGNOSTIC_COREAPI.BRPrint;
327: JTF_DIAGNOSTIC_COREAPI.line_out('======================================================');
328: l_statusStr := 'SUCCESS';
329: ----------------------------------------------
330: -- Add Product Specific Tests Here:
331: ----------------------------------------------