APPS.INV_DIAG_WDD_STAGED dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 44: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

40: isFatal VARCHAR2(50);
41: dummy_num NUMBER;
42: sqltxt VARCHAR2 (2000);
43: BEGIN
44: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
48: sqltxt := ' select' ||

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

41: dummy_num NUMBER;
42: sqltxt VARCHAR2 (2000);
43: BEGIN
44: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
48: sqltxt := ' select' ||
49: ' mp.organization_code || '' ('' ||mr.organization_id|| '')'' "Organization Code (Id)"' ||

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

88:
89: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inv interfaced) serials not marked');
90:
91: reportStr := 'The test completed as expected';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:

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

90:
91: reportStr := 'The test completed as expected';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: WHEN OTHERS THEN

Line 95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

91: reportStr := 'The test completed as expected';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP04B.pls';
104: isFatal := 'FALSE';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107: END runTest;
108:
109: ------------------------------------------------------------

Line 106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP04B.pls';
104: isFatal := 'FALSE';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107: END runTest;
108:
109: ------------------------------------------------------------
110: -- procedure to report name back to framework

Line 142: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

138: ------------------------------------------------------------
139: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
140: tempInput JTF_DIAG_INPUTTBL;
141: BEGIN
142: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
143: EXCEPTION
144: when others then
145: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
146: END getDefaultTestParams;

Line 145: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

141: BEGIN
142: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
143: EXCEPTION
144: when others then
145: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
146: END getDefaultTestParams;
147: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
148: tempDependencies JTF_DIAG_DEPENDTBL;
149:

Line 151: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

147: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
148: tempDependencies JTF_DIAG_DEPENDTBL;
149:
150: BEGIN
151: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
152: END getDependencies;
153:
154: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
155: BEGIN

Line 162: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

158:
159: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
160: tempOutput JTF_DIAG_OUTPUTTBL;
161: BEGIN
162: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
163: outputValues := tempOutput;
164: EXCEPTION
165: when others then
166: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 166: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

162: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
163: outputValues := tempOutput;
164: EXCEPTION
165: when others then
166: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
167: END getOutputValues;
168:
169: Function getTestMode return INTEGER IS
170: BEGIN

Line 171: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

167: END getOutputValues;
168:
169: Function getTestMode return INTEGER IS
170: BEGIN
171: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
172:
173: END getTestMode;
174:
175: END INV_DIAG_WDD_STAGED;