DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_ECOHLCHK dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

27: l_org_id NUMBER;
28: l_org_exists NUMBER;
29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/

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

28: l_org_exists NUMBER;
29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
36: row_limit :=1000;

Line 40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

36: row_limit :=1000;
37: l_org_exists :=0; /* Initialize to zero */
38:
39: -- accept input
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41:
42: /* l_org_id is NOT a mandatory input. If it is not entered, then run the scripts for all orgs.
43: However if a value is entered for org_id, then validate it for existence. */
44:

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

56: isFatal := 'TRUE';
57: fixInfo := ' Please review the error message below and take corrective action.';
58: errStr := ' Invalid value for input field Organization Id ';
59:
60: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
61: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
62: End;
63: End If; /* End of l_org_id is not null */
64:

Line 61: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

57: fixInfo := ' Please review the error message below and take corrective action.';
58: errStr := ' Invalid value for input field Organization Id ';
59:
60: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
61: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
62: End;
63: End If; /* End of l_org_id is not null */
64:
65: If (l_org_id is null) or (l_org_exists = 1) Then

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

133:
(d) Repeat steps b and c for all the ECOs to be corrected.
134:
(e) Use (N) Engineering > Setup > ''Auto Implement'' feature
135:
to auto implement all the scheduled ECOs.
136:
';
137: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
138: End If; /* End of Impact and Action */
139:
140: statusStr := 'SUCCESS';
141: isFatal := 'FALSE';

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

142: /* End of Script 1 */
143:
144: <>
145: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148:
149: End If; /* End of l_org_id is null or l_org_exists=1 */
150:

Line 147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

143:
144: <>
145: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148:
149: End If; /* End of l_org_id is null or l_org_exists=1 */
150:
151: EXCEPTION

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

155: statusStr := 'FAILURE';
156: errStr := sqlerrm ||' occurred in script. ';
157: fixInfo := 'Unexpected Exception in BOMDGECB.pls';
158: isFatal := 'FALSE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
161:
162: END runTest;
163:

Line 160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

156: errStr := sqlerrm ||' occurred in script. ';
157: fixInfo := 'Unexpected Exception in BOMDGECB.pls';
158: isFatal := 'FALSE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
161:
162: END runTest;
163:
164: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 185: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

181: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
182: tempDependencies JTF_DIAG_DEPENDTBL;
183:
184: BEGIN
185: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
186: END getDependencies;
187:
188: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
189: BEGIN

Line 197: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

193:
194: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
195: tempOutput JTF_DIAG_OUTPUTTBL;
196: BEGIN
197: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
198: outputValues := tempOutput;
199: EXCEPTION
200: when others then
201: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 201: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

197: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
198: outputValues := tempOutput;
199: EXCEPTION
200: when others then
201: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
202: END getOutputValues;
203:
204:
205: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 208: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

204:
205: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
206: tempInput JTF_DIAG_INPUTTBL;
207: BEGIN
208: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
209: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
210: defaultInputValues := tempInput;
211: EXCEPTION
212: when others then

Line 209: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260

205: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
206: tempInput JTF_DIAG_INPUTTBL;
207: BEGIN
208: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
209: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
210: defaultInputValues := tempInput;
211: EXCEPTION
212: when others then
213: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 213: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

209: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
210: defaultInputValues := tempInput;
211: EXCEPTION
212: when others then
213: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
214: END getDefaultTestParams;
215:
216: Function getTestMode return INTEGER IS
217: BEGIN

Line 218: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

214: END getDefaultTestParams;
215:
216: Function getTestMode return INTEGER IS
217: BEGIN
218: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
219:
220: END getTestMode;
221:
222: END BOM_DIAGUNITTEST_ECOHLCHK;