26: row_limit NUMBER;
27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
36: sqltxt :=' SELECT mp.organization_code' ||
37: ' || '' (''' ||
38: ' ||moqd.organization_id' ||
68:
69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with status not populated for Onhand material status tracked organization for non serial controlled Item');
70:
71: reportStr := 'The test completed as expected';
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
73: statusStr := 'SUCCESS';
74: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
75: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
76:
70:
71: reportStr := 'The test completed as expected';
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
73: statusStr := 'SUCCESS';
74: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
75: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
76:
77: EXCEPTION
78: when others then
71: reportStr := 'The test completed as expected';
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
73: statusStr := 'SUCCESS';
74: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
75: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
76:
77: EXCEPTION
78: when others then
79: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
81: statusStr := 'FAILURE';
82: errStr := sqlerrm ||' occurred in script Exception handled';
83: fixInfo := 'Unexpected Exception in INVDOH1B.pls';
84: isFatal := 'FALSE';
85: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
86: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
87: END runTest;
88:
89: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
82: errStr := sqlerrm ||' occurred in script Exception handled';
83: fixInfo := 'Unexpected Exception in INVDOH1B.pls';
84: isFatal := 'FALSE';
85: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
86: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
87: END runTest;
88:
89: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
90: BEGIN
105: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
106: tempDependencies JTF_DIAG_DEPENDTBL;
107:
108: BEGIN
109: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
110: END getDependencies;
111:
112: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
113: BEGIN
116:
117: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
118: tempOutput JTF_DIAG_OUTPUTTBL;
119: BEGIN
120: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
121: outputValues := tempOutput;
122: EXCEPTION
123: when others then
124: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
120: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
121: outputValues := tempOutput;
122: EXCEPTION
123: when others then
124: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
125: END getOutputValues;
126:
127:
128: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
127:
128: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
129: tempInput JTF_DIAG_INPUTTBL;
130: BEGIN
131: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
132: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
133: defaultInputValues := tempInput;
134:
135: EXCEPTION
128: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
129: tempInput JTF_DIAG_INPUTTBL;
130: BEGIN
131: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
132: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
133: defaultInputValues := tempInput;
134:
135: EXCEPTION
136: when others then
133: defaultInputValues := tempInput;
134:
135: EXCEPTION
136: when others then
137: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
138: END getDefaultTestParams;
139:
140: Function getTestMode return INTEGER IS
141: BEGIN
138: END getDefaultTestParams;
139:
140: Function getTestMode return INTEGER IS
141: BEGIN
142: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
143: END getTestMode;
144: END INV_DIAG_OH_PLAIN_NO_STATUS;