DBA Data[Home] [Help]

APPS.INV_DIAG_MSN dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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);

Line 38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

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);

Line 41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',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);

Line 42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);

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;

Line 43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

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';

Line 45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input : '||l_org_id||' Serial '||l_sn||' ItemId : '||l_item_id);

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:

Line 99: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

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:

Line 112: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

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

Line 113: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

Line 118: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('Exception Occurred In RUNTEST');

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;

Line 119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

Line 143: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

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

Line 155: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);

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;

Line 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

Line 167: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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_

Line 168: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');

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;

Line 169: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');

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

Line 170: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');

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

Line 175: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

Line 180: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

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;