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_BILLHLCHK dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

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

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

Line 41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

37: row_limit :=1000;
38: l_org_exists :=0; /* Initialize to zero */
39:
40: -- accept input
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
43:
44: /*JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Script: '||l_script);
45: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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

38: l_org_exists :=0; /* Initialize to zero */
39:
40: -- accept input
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
43:
44: /*JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Script: '||l_script);
45: JTF_DIAGNOSTIC_COREAPI.BRPrint;
46: */

Line 44: /*JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Script: '||l_script);

40: -- accept input
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
43:
44: /*JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Script: '||l_script);
45: JTF_DIAGNOSTIC_COREAPI.BRPrint;
46: */
47:
48: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('script: '||l_script);

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

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

Line 62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

82: isFatal := 'TRUE';
83: fixInfo := ' Please review the error message below and take corrective action.';
84: errStr := ' Invalid value for input field Organization Id ';
85:
86: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
87: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
88: End;
89: End If; /* End of l_org_id is not null */
90:

Line 87: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

83: fixInfo := ' Please review the error message below and take corrective action.';
84: errStr := ' Invalid value for input field Organization Id ';
85:
86: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
87: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
88: End;
89: End If; /* End of l_org_id is not null */
90:
91: If (l_org_id is null) or (l_org_exists = 1) Then

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

293:
6) Save the changes to the bill.
294:
Note: If the number of invalid unit numbers are huge,
295:
then use the Bills Open Interface functionality to correct them.
296:
';
297: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
298: End If; /* End of Impact and Action */
299:
300: statusStr := 'SUCCESS';
301: isFatal := 'FALSE';

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

357: (3) Make sure that the total number of records updated
358:
are same as the number of records fetched above.
359:
(4) Commit the transaction.
360:
';
361: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
362:
363: End If; /* End of Impact and Action */
364:
365: statusStr := 'SUCCESS';

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

370: /* End of script 2- Bills with NULL Implementation Date */
371:
372: <>
373: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
374: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
375: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
376: End If; /* End of l_org_id is null or l_org_exists=1 */
377:
378: EXCEPTION

Line 375: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

371:
372: <>
373: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
374: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
375: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
376: End If; /* End of l_org_id is null or l_org_exists=1 */
377:
378: EXCEPTION
379: when others then

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

382: statusStr := 'FAILURE';
383: errStr := sqlerrm ||' occurred in script. ';
384: fixInfo := 'Unexpected Exception in BOMDGBIB.pls';
385: isFatal := 'FALSE';
386: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
387: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
388: END runTest;
389:
390: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 387: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

383: errStr := sqlerrm ||' occurred in script. ';
384: fixInfo := 'Unexpected Exception in BOMDGBIB.pls';
385: isFatal := 'FALSE';
386: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
387: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
388: END runTest;
389:
390: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
391: BEGIN

Line 411: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

407: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
408: tempDependencies JTF_DIAG_DEPENDTBL;
409:
410: BEGIN
411: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
412: END getDependencies;
413:
414: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
415: BEGIN

Line 423: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

419:
420: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
421: tempOutput JTF_DIAG_OUTPUTTBL;
422: BEGIN
423: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
424: outputValues := tempOutput;
425: EXCEPTION
426: when others then
427: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 427: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

423: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
424: outputValues := tempOutput;
425: EXCEPTION
426: when others then
427: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
428: END getOutputValues;
429:
430:
431: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 434: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

430:
431: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
432: tempInput JTF_DIAG_INPUTTBL;
433: BEGIN
434: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
435: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
436: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.BomHealthLov');
437: defaultInputValues := tempInput;
438: EXCEPTION

Line 435: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260

431: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
432: tempInput JTF_DIAG_INPUTTBL;
433: BEGIN
434: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
435: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
436: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.BomHealthLov');
437: defaultInputValues := tempInput;
438: EXCEPTION
439: when others then

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

432: tempInput JTF_DIAG_INPUTTBL;
433: BEGIN
434: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
435: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
436: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.BomHealthLov');
437: defaultInputValues := tempInput;
438: EXCEPTION
439: when others then
440: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 440: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

436: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.BomHealthLov');
437: defaultInputValues := tempInput;
438: EXCEPTION
439: when others then
440: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
441: END getDefaultTestParams;
442:
443: Function getTestMode return INTEGER IS
444: BEGIN

Line 445: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

441: END getDefaultTestParams;
442:
443: Function getTestMode return INTEGER IS
444: BEGIN
445: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
446:
447: END getTestMode;
448:
449: END BOM_DIAGUNITTEST_BILLHLCHK;