APPS.INV_DIAG_OH_SERIAL_STATUS 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: ' ||moqd.organization_id' ||

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

77:
78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with status populated for Onhand material status tracked organization for serial controlled Item');
79:
80: reportStr := 'The test completed as expected';
81: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
82: statusStr := 'SUCCESS';
83: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
84: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
85:

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

79:
80: reportStr := 'The test completed as expected';
81: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
82: statusStr := 'SUCCESS';
83: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
84: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
85:
86: EXCEPTION
87: when others then

Line 84: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

80: reportStr := 'The test completed as expected';
81: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
82: statusStr := 'SUCCESS';
83: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
84: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
85:
86: EXCEPTION
87: when others then
88: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

90: statusStr := 'FAILURE';
91: errStr := sqlerrm ||' occurred in script Exception handled';
92: fixInfo := 'Unexpected Exception in INVDOH2B.pls';
93: isFatal := 'FALSE';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96: END runTest;
97:
98: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

91: errStr := sqlerrm ||' occurred in script Exception handled';
92: fixInfo := 'Unexpected Exception in INVDOH2B.pls';
93: isFatal := 'FALSE';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96: END runTest;
97:
98: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
99: BEGIN

Line 118: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

114: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
115: tempDependencies JTF_DIAG_DEPENDTBL;
116:
117: BEGIN
118: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
119: END getDependencies;
120:
121: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
122: BEGIN

Line 129: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

125:
126: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
127: tempOutput JTF_DIAG_OUTPUTTBL;
128: BEGIN
129: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
130: outputValues := tempOutput;
131: EXCEPTION
132: when others then
133: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 133: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

129: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
130: outputValues := tempOutput;
131: EXCEPTION
132: when others then
133: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
134: END getOutputValues;
135:
136:
137: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

136:
137: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
138: tempInput JTF_DIAG_INPUTTBL;
139: BEGIN
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
141: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
142: defaultInputValues := tempInput;
143:
144: EXCEPTION

Line 141: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');

137: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
138: tempInput JTF_DIAG_INPUTTBL;
139: BEGIN
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
141: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
142: defaultInputValues := tempInput;
143:
144: EXCEPTION
145: when others then

Line 146: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

142: defaultInputValues := tempInput;
143:
144: EXCEPTION
145: when others then
146: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
147: END getDefaultTestParams;
148:
149: Function getTestMode return INTEGER IS
150: BEGIN

Line 151: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

147: END getDefaultTestParams;
148:
149: Function getTestMode return INTEGER IS
150: BEGIN
151: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
152: END getTestMode;
153: END INV_DIAG_OH_SERIAL_STATUS;