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: l_org_id := null ;
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: l_org_id := null ;
36: l_job_id := null ;
35: l_org_id := null ;
36: l_job_id := null ;
37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
36: l_job_id := null ;
37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;
37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;
45: end if;
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;
45: end if;
46:
54: statusStr := 'FAILURE';
55: errStr := 'This test failed with : no/incorrect input';
56:
57: <
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61: else
62:
55: errStr := 'This test failed with : no/incorrect input';
56:
57: <
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61: else
62:
63: WIP_DIAG_DATA_COLL.disc_lot_job(l_job_id);
62:
63: WIP_DIAG_DATA_COLL.disc_lot_job(l_job_id);
64:
65: reportStr := '
The output generated gives you the details regarding a particular discrete job or a lot-based job. ';
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
67:
68:
69: <
70: statusStr := 'SUCCESS';
67:
68:
69: <
70: statusStr := 'SUCCESS';
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73:
74: end if ;
75:
68:
69: <
70: statusStr := 'SUCCESS';
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73:
74: end if ;
75:
76: EXCEPTION
80: statusStr := 'FAILURE';
81: errStr := sqlerrm ||' occurred in script Exception handled';
82: fixInfo := 'Unexpected Exception in WIPDC01B.pls';
83: isFatal := 'FALSE';
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86:
87:
88: END runTest;
81: errStr := sqlerrm ||' occurred in script Exception handled';
82: fixInfo := 'Unexpected Exception in WIPDC01B.pls';
83: isFatal := 'FALSE';
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86:
87:
88: END runTest;
89:
107: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
108: tempDependencies JTF_DIAG_DEPENDTBL;
109:
110: BEGIN
111: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
112: END getDependencies;
113:
114: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
115: BEGIN
119:
120: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
121: tempOutput JTF_DIAG_OUTPUTTBL;
122: BEGIN
123: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
124: outputValues := tempOutput;
125: EXCEPTION
126: when others then
127: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
123: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
124: outputValues := tempOutput;
125: EXCEPTION
126: when others then
127: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
128: END getOutputValues;
129:
130:
131: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
131: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
132: tempInput JTF_DIAG_INPUTTBL;
133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:
132: tempInput JTF_DIAG_INPUTTBL;
133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:
140: EXCEPTION
133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:
140: EXCEPTION
141: when others then
138: defaultInputValues := tempInput;
139:
140: EXCEPTION
141: when others then
142: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
143: END getDefaultTestParams;
144:
145: Function getTestMode return INTEGER IS
146: BEGIN
143: END getDefaultTestParams;
144:
145: Function getTestMode return INTEGER IS
146: BEGIN
147: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
148:
149: END getTestMode;
150:
151: END;