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:
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:
36: -- accept input
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35:
36: -- accept input
37: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null ) then
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
39: WIP_DIAG_DISCRETE_LOT.corrupt_osp_txn_wdj(l_org_id, report, reportClob);
40:
41: <
34:
35:
36: -- accept input
37: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null ) then
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
39: WIP_DIAG_DISCRETE_LOT.corrupt_osp_txn_wdj(l_org_id, report, reportClob);
40:
41: <
42: statusStr := 'SUCCESS';
39: WIP_DIAG_DISCRETE_LOT.corrupt_osp_txn_wdj(l_org_id, report, reportClob);
40:
41: <
42: statusStr := 'SUCCESS';
43: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
45: else
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');
47: if l_org_id is null then
40:
41: <
42: statusStr := 'SUCCESS';
43: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
45: else
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');
47: if l_org_id is null then
48: fixInfo := 'Please enter the Org id for which output is desired.';
51: statusStr := 'FAILURE';
52: errStr := 'This test failed with : no/Incorrect input';
53:
54: <
55: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
56: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
57:
58: end if;
59:
52: errStr := 'This test failed with : no/Incorrect input';
53:
54: <
55: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
56: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
57:
58: end if;
59:
60:
65: statusStr := 'FAILURE';
66: errStr := sqlerrm ||' occurred in script Exception handled';
67: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';
68: isFatal := 'FALSE';
69: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
70: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
71:
72:
73: END runTest;
66: errStr := sqlerrm ||' occurred in script Exception handled';
67: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';
68: isFatal := 'FALSE';
69: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
70: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
71:
72:
73: END runTest;
74:
94: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
95: tempDependencies JTF_DIAG_DEPENDTBL;
96:
97: BEGIN
98: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
99: END getDependencies;
100:
101: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
102: BEGIN
106:
107: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
108: tempOutput JTF_DIAG_OUTPUTTBL;
109: BEGIN
110: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
111: outputValues := tempOutput;
112: EXCEPTION
113: when others then
114: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
110: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
111: outputValues := tempOutput;
112: EXCEPTION
113: when others then
114: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
115: END getOutputValues;
116:
117:
118: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
118: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
119: tempInput JTF_DIAG_INPUTTBL;
120: BEGIN
121:
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
119: tempInput JTF_DIAG_INPUTTBL;
120: BEGIN
121:
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
127: when others then
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
127: when others then
128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
129: END getDefaultTestParams;
130:
131: Function getTestMode return INTEGER IS
132: BEGIN
129: END getDefaultTestParams;
130:
131: Function getTestMode return INTEGER IS
132: BEGIN
133: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
134:
135: END getTestMode;
136:
137: END;