33: row_limit NUMBER;
34:
35: BEGIN
36:
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
34:
35: BEGIN
36:
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
44:
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input : '||l_org_id||' Serial '||l_sn||' ItemId : '||l_item_id);
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
44:
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input : '||l_org_id||' Serial '||l_sn||' ItemId : '||l_item_id);
46: row_limit :=INV_DIAG_GRP.g_max_row;
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
44:
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input : '||l_org_id||' Serial '||l_sn||' ItemId : '||l_item_id);
46: row_limit :=INV_DIAG_GRP.g_max_row;
47: test_out :='MSN';
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
44:
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input : '||l_org_id||' Serial '||l_sn||' ItemId : '||l_item_id);
46: row_limit :=INV_DIAG_GRP.g_max_row;
47: test_out :='MSN';
48: reportStr :='';
49:
95: where inventory_item_id = nvl(l_item_id, inventory_item_id)
96: and current_organization_id = nvl(l_org_id, current_organization_id)
97: and serial_number = nvl(l_sn, serial_number);
98:
99: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
100: statusStr := 'SUCCESS';
101:
102: ELSE
103:
108: isFatal := 'SUCCESS';
109:
110: end if;
111:
112: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
113: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
114:
115: EXCEPTION
116: when others then
109:
110: end if;
111:
112: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
113: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
114:
115: EXCEPTION
116: when others then
117: -- this should never happen
114:
115: EXCEPTION
116: when others then
117: -- this should never happen
118: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('Exception Occurred In RUNTEST');
119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
120: raise;
121:
122: END runTest;
115: EXCEPTION
116: when others then
117: -- this should never happen
118: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('Exception Occurred In RUNTEST');
119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
120: raise;
121:
122: END runTest;
123:
139: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
140: tempDependencies JTF_DIAG_DEPENDTBL;
141:
142: BEGIN
143: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
144: END getDependencies;
145:
146: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
147: BEGIN
151:
152: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
153: tempOutput JTF_DIAG_OUTPUTTBL;
154: BEGIN
155: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
157: outputValues := tempOutput;
158: EXCEPTION
159: when others then
152: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
153: tempOutput JTF_DIAG_OUTPUTTBL;
154: BEGIN
155: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
157: outputValues := tempOutput;
158: EXCEPTION
159: when others then
160: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
157: outputValues := tempOutput;
158: EXCEPTION
159: when others then
160: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
161: END getOutputValues;
162:
163:
164: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
163:
164: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
165: tempInput JTF_DIAG_INPUTTBL;
166: BEGIN
167: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
168: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
169: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
170: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
171: -- tempInput := JTF_DIAGNOSTIC_
164: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
165: tempInput JTF_DIAG_INPUTTBL;
166: BEGIN
167: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
168: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
169: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
170: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
171: -- tempInput := JTF_DIAGNOSTIC_
172: defaultInputValues := tempInput;
165: tempInput JTF_DIAG_INPUTTBL;
166: BEGIN
167: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
168: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
169: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
170: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
171: -- tempInput := JTF_DIAGNOSTIC_
172: defaultInputValues := tempInput;
173: EXCEPTION
166: BEGIN
167: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
168: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
169: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
170: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
171: -- tempInput := JTF_DIAGNOSTIC_
172: defaultInputValues := tempInput;
173: EXCEPTION
174: when others then
171: -- tempInput := JTF_DIAGNOSTIC_
172: defaultInputValues := tempInput;
173: EXCEPTION
174: when others then
175: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
176: END getDefaultTestParams;
177:
178: Function getTestMode return INTEGER IS
179: BEGIN
176: END getDefaultTestParams;
177:
178: Function getTestMode return INTEGER IS
179: BEGIN
180: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
181:
182: END getTestMode;
183:
184: END;