27: l_org_id NUMBER;
28: l_job_id NUMBER;
29: BEGIN
30:
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
28: l_job_id NUMBER;
29: BEGIN
30:
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
36: if( ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
36: if( ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then
37: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
38: else
39: l_org_id := null;
40: end if;
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
36: if( ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then
37: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
38: else
39: l_org_id := null;
40: end if;
41:
49: isFatal := 'FALSE';
50:
51:
52: <
53: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
54: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
55:
56: else
57:
50:
51:
52: <
53: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
54: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
55:
56: else
57:
58: WIP_DIAG_DATA_COLL.setup(l_org_id, report, reportClob);
57:
58: WIP_DIAG_DATA_COLL.setup(l_org_id, report, reportClob);
59:
60: reportStr := '
The output generated gives you the details regarding a WIP Setup ';
61: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
62:
63:
64: <
65: statusStr := 'SUCCESS';
62:
63:
64: <
65: statusStr := 'SUCCESS';
66: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
68: end if ;
69:
70: EXCEPTION
63:
64: <
65: statusStr := 'SUCCESS';
66: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
68: end if ;
69:
70: EXCEPTION
71: when others then
74: statusStr := 'FAILURE';
75: errStr := sqlerrm ||' occurred in script Exception handled';
76: fixInfo := 'Unexpected Exception in WIPDC04B.pls';
77: isFatal := 'FALSE';
78: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
79: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
80:
81:
82: END runTest;
75: errStr := sqlerrm ||' occurred in script Exception handled';
76: fixInfo := 'Unexpected Exception in WIPDC04B.pls';
77: isFatal := 'FALSE';
78: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
79: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
80:
81:
82: END runTest;
83:
101: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
102: tempDependencies JTF_DIAG_DEPENDTBL;
103:
104: BEGIN
105: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
106: END getDependencies;
107:
108: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
109: BEGIN
113:
114: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
115: tempOutput JTF_DIAG_OUTPUTTBL;
116: BEGIN
117: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
118: outputValues := tempOutput;
119: EXCEPTION
120: when others then
121: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
117: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
118: outputValues := tempOutput;
119: EXCEPTION
120: when others then
121: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
122: END getOutputValues;
123:
124:
125: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
125: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
126: tempInput JTF_DIAG_INPUTTBL;
127: BEGIN
128:
129: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
130: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
131: defaultInputValues := tempInput;
132:
133: EXCEPTION
126: tempInput JTF_DIAG_INPUTTBL;
127: BEGIN
128:
129: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
130: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
131: defaultInputValues := tempInput;
132:
133: EXCEPTION
134: when others then
131: defaultInputValues := tempInput;
132:
133: EXCEPTION
134: when others then
135: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: END getDefaultTestParams;
137:
138: Function getTestMode return INTEGER IS
139: BEGIN
136: END getDefaultTestParams;
137:
138: Function getTestMode return INTEGER IS
139: BEGIN
140: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
141:
142: END getTestMode;
143:
144: END;