eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_RSV_MS_DUMP dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

34:
35:
36: BEGIN
37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:

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

35:
36: BEGIN
37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;

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

41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
46: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
47: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
48:
49: IF l_script = 'MR_DUMP' THEN

Line 46: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
46: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
47: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
48:
49: IF l_script = 'MR_DUMP' THEN
50:

Line 47: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);

43: row_limit := INV_DIAG_GRP.g_max_row;
44:
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
46: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
47: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
48:
49: IF l_script = 'MR_DUMP' THEN
50:
51: sqltxt := 'SELECT ' ||

Line 218: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');

214:
215: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of MTL_SUPPLY');
216:
217: ELSE
218: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
219: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
220: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
221: statusStr := 'FAILURE';
222: errStr := 'Invalid Script Name';

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

221: statusStr := 'FAILURE';
222: errStr := 'Invalid Script Name';
223: fixInfo := 'Please choose correct Script Name';
224: isFatal := 'FALSE';
225: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
226: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
227: RETURN;
228: END IF;
229:

Line 226: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

222: errStr := 'Invalid Script Name';
223: fixInfo := 'Please choose correct Script Name';
224: isFatal := 'FALSE';
225: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
226: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
227: RETURN;
228: END IF;
229:
230: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';

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

227: RETURN;
228: END IF;
229:
230: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
231: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
232: statusStr := 'SUCCESS';
233: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
234: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
235:

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

229:
230: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
231: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
232: statusStr := 'SUCCESS';
233: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
234: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
235:
236: EXCEPTION
237: when others then

Line 234: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

230: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
231: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
232: statusStr := 'SUCCESS';
233: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
234: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
235:
236: EXCEPTION
237: when others then
238: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

240: statusStr := 'FAILURE';
241: errStr := sqlerrm ||' occurred in script Exception handled';
242: fixInfo := 'Unexpected Exception in INVDP08B.pls';
243: isFatal := 'FALSE';
244: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
245: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
246: END runTest;
247:
248:

Line 245: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

241: errStr := sqlerrm ||' occurred in script Exception handled';
242: fixInfo := 'Unexpected Exception in INVDP08B.pls';
243: isFatal := 'FALSE';
244: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
245: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
246: END runTest;
247:
248:
249: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 268: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

264: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
265: tempDependencies JTF_DIAG_DEPENDTBL;
266:
267: BEGIN
268: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
269: END getDependencies;
270:
271: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
272: BEGIN

Line 279: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

275:
276: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
277: tempOutput JTF_DIAG_OUTPUTTBL;
278: BEGIN
279: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
280: outputValues := tempOutput;
281: EXCEPTION
282: when others then
283: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 283: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

279: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
280: outputValues := tempOutput;
281: EXCEPTION
282: when others then
283: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
284: END getOutputValues;
285:
286: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
287: tempInput JTF_DIAG_INPUTTBL;

Line 289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

285:
286: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
287: tempInput JTF_DIAG_INPUTTBL;
288: BEGIN
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
291: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');
293: defaultInputValues := tempInput;

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

286: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
287: tempInput JTF_DIAG_INPUTTBL;
288: BEGIN
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
291: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');
293: defaultInputValues := tempInput;
294: EXCEPTION

Line 291: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');

287: tempInput JTF_DIAG_INPUTTBL;
288: BEGIN
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
291: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');
293: defaultInputValues := tempInput;
294: EXCEPTION
295: when others then

Line 292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');

288: BEGIN
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
291: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');
293: defaultInputValues := tempInput;
294: EXCEPTION
295: when others then
296: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 296: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

292: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PickRelRsvDiagScriptsLov');
293: defaultInputValues := tempInput;
294: EXCEPTION
295: when others then
296: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
297: END getDefaultTestParams;
298:
299: Function getTestMode return INTEGER IS
300: BEGIN

Line 301: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

297: END getDefaultTestParams;
298:
299: Function getTestMode return INTEGER IS
300: BEGIN
301: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
302: END getTestMode;
303:
304: END INV_DIAG_RSV_MS_DUMP;