eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DIAGUNITTEST_CATHLCHK dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 34: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

30: l_master_org_code VARCHAR2(3);
31: l_script VARCHAR2(20);
32:
33: BEGIN
34: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
35: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
36: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
37:
38: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/

Line 35: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

31: l_script VARCHAR2(20);
32:
33: BEGIN
34: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
35: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
36: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
37:
38: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
39: row_limit :=1000;

Line 42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');

38: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
39: row_limit :=1000;
40:
41: -- accept input
42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
43:
44: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
Script Selected: '||l_script);
45:
46: /* l_script is NOT a mandatory input. If it is not entered, then run all the scripts.

Line 57: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

53: isFatal := 'TRUE';
54: fixInfo := ' Please review the error message below and take corrective action.';
55: errStr := ' Invalid value for input field Script ';
56:
57: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
58: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
59: Return;
60: End If;
61: /* End of script name validation*/

Line 58: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

54: fixInfo := ' Please review the error message below and take corrective action.';
55: errStr := ' Invalid value for input field Script ';
56:
57: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
58: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
59: Return;
60: End If;
61: /* End of script name validation*/
62:

Line 129: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

125:
under this category set which is not allowed.
126:
5) Delete the unwanted item category assignments.
127:
6) Save the changes to the Item.
128:
';
129: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
130: End If; /* End of Impact and Action */
131:
132: statusStr := 'SUCCESS';
133: isFatal := 'FALSE';

Line 258: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

254: and structure_id = :old_structure_id ;
255:
256: 6) Commit the transaction.
257:
';
258: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
259: End If; /* End of Impact and Action */
260:
261: statusStr := 'SUCCESS';
262: isFatal := 'FALSE';

Line 270: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

266: /* End of script 2*/
267:
268: <>
269: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
270: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
271: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
272:
273: EXCEPTION
274: when others then

Line 271: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

267:
268: <>
269: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
270: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
271: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
272:
273: EXCEPTION
274: when others then
275: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

Line 281: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

277: statusStr := 'FAILURE';
278: errStr := sqlerrm ||' occurred in script. ';
279: fixInfo := 'Unexpected Exception in BOMDGICB.pls';
280: isFatal := 'FALSE';
281: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
282: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
283: END runTest;
284:
285: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 282: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

278: errStr := sqlerrm ||' occurred in script. ';
279: fixInfo := 'Unexpected Exception in BOMDGICB.pls';
280: isFatal := 'FALSE';
281: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
282: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
283: END runTest;
284:
285: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
286: BEGIN

Line 306: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

302: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
303: tempDependencies JTF_DIAG_DEPENDTBL;
304:
305: BEGIN
306: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
307: END getDependencies;
308:
309: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
310: BEGIN

Line 318: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

314:
315: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
316: tempOutput JTF_DIAG_OUTPUTTBL;
317: BEGIN
318: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
319: outputValues := tempOutput;
320: EXCEPTION
321: when others then
322: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 322: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

318: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
319: outputValues := tempOutput;
320: EXCEPTION
321: when others then
322: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
323: END getOutputValues;
324:
325:
326: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 329: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

325:
326: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
327: tempInput JTF_DIAG_INPUTTBL;
328: BEGIN
329: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
330: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.CatHealthLov');
331: defaultInputValues := tempInput;
332: EXCEPTION
333: when others then

Line 330: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.CatHealthLov');

326: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
327: tempInput JTF_DIAG_INPUTTBL;
328: BEGIN
329: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
330: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.CatHealthLov');
331: defaultInputValues := tempInput;
332: EXCEPTION
333: when others then
334: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 334: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

330: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.CatHealthLov');
331: defaultInputValues := tempInput;
332: EXCEPTION
333: when others then
334: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
335: END getDefaultTestParams;
336:
337: Function getTestMode return INTEGER IS
338: BEGIN

Line 339: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

335: END getDefaultTestParams;
336:
337: Function getTestMode return INTEGER IS
338: BEGIN
339: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
340:
341: END getTestMode;
342:
343: END BOM_DIAGUNITTEST_CATHLCHK;