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