DBA Data[Home] [Help]

APPS.INV_DIAG_RSV_HDR_ZERO 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:

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:
49: sqltxt := ' SELECT MR.RESERVATION_ID RSV_ID,' ||

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

70:
71: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Demand details with DEMAND_SOURCE_HEADER_ID as 0');
72:
73: reportStr := 'The test completed as expected';
74: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
75: statusStr := 'SUCCESS';
76: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78:

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

72:
73: reportStr := 'The test completed as expected';
74: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
75: statusStr := 'SUCCESS';
76: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78:
79: EXCEPTION
80: WHEN OTHERS THEN

Line 77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

73: reportStr := 'The test completed as expected';
74: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
75: statusStr := 'SUCCESS';
76: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

83: statusStr := 'FAILURE';
84: errStr := sqlerrm ||' occurred in script Exception handled';
85: fixInfo := 'Unexpected Exception in INVDP02B.pls';
86: isFatal := 'FALSE';
87: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
89: END runTest;
90:
91: ------------------------------------------------------------

Line 88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

84: errStr := sqlerrm ||' occurred in script Exception handled';
85: fixInfo := 'Unexpected Exception in INVDP02B.pls';
86: isFatal := 'FALSE';
87: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
89: END runTest;
90:
91: ------------------------------------------------------------
92: -- procedure to report name back to framework

Line 124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

120: ------------------------------------------------------------
121: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
122: tempInput JTF_DIAG_INPUTTBL;
123: BEGIN
124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
125: EXCEPTION
126: when others then
127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
128: END getDefaultTestParams;

Line 127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

123: BEGIN
124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
125: EXCEPTION
126: when others then
127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
128: END getDefaultTestParams;
129:
130: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
131: tempDependencies JTF_DIAG_DEPENDTBL;

Line 134: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

130: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
131: tempDependencies JTF_DIAG_DEPENDTBL;
132:
133: BEGIN
134: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
135: END getDependencies;
136:
137: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
138: BEGIN

Line 145: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

141:
142: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
143: tempOutput JTF_DIAG_OUTPUTTBL;
144: BEGIN
145: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
146: outputValues := tempOutput;
147: EXCEPTION
148: when others then
149: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 149: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

145: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
146: outputValues := tempOutput;
147: EXCEPTION
148: when others then
149: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
150: END getOutputValues;
151:
152: Function getTestMode return INTEGER IS
153: BEGIN

Line 154: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

150: END getOutputValues;
151:
152: Function getTestMode return INTEGER IS
153: BEGIN
154: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
155:
156: END getTestMode;
157:
158: END INV_DIAG_RSV_HDR_ZERO;