APPS.INV_DIAG_OH_COMINGLING dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

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

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:

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

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: ' ||x.organization_id' ||

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

104:
105: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand Records for which commingling of the status exists');
106:
107: reportStr := 'The test completed as expected';
108: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
109: statusStr := 'SUCCESS';
110: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
112:

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

106:
107: reportStr := 'The test completed as expected';
108: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
109: statusStr := 'SUCCESS';
110: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
112:
113: EXCEPTION
114: when others then

Line 111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

107: reportStr := 'The test completed as expected';
108: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
109: statusStr := 'SUCCESS';
110: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
112:
113: EXCEPTION
114: when others then
115: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

117: statusStr := 'FAILURE';
118: errStr := sqlerrm ||' occurred in script Exception handled';
119: fixInfo := 'Unexpected Exception in INVDOH4B.pls';
120: isFatal := 'FALSE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123: END runTest;
124:
125: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

118: errStr := sqlerrm ||' occurred in script Exception handled';
119: fixInfo := 'Unexpected Exception in INVDOH4B.pls';
120: isFatal := 'FALSE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123: END runTest;
124:
125: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
126: BEGIN

Line 145: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

141: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
142: tempDependencies JTF_DIAG_DEPENDTBL;
143:
144: BEGIN
145: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
146: END getDependencies;
147:
148: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
149: BEGIN

Line 156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

152:
153: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
154: tempOutput JTF_DIAG_OUTPUTTBL;
155: BEGIN
156: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
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.initOutputTable;
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: defaultInputValues := tempInput;
170:
171: EXCEPTION

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: defaultInputValues := tempInput;
170:
171: EXCEPTION
172: when others then

Line 173: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

169: defaultInputValues := tempInput;
170:
171: EXCEPTION
172: when others then
173: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
174: END getDefaultTestParams;
175:
176: Function getTestMode return INTEGER IS
177: BEGIN

Line 178: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

174: END getDefaultTestParams;
175:
176: Function getTestMode return INTEGER IS
177: BEGIN
178: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
179: END getTestMode;
180: END INV_DIAG_OH_COMINGLING;