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_PHY_INV_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 = 'MPA_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 = 'MPA_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 = 'MPA_DUMP' THEN
50:
51: sqltxt := ' SELECT' ||

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

232:
233: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags without onhand');
234:
235: ELSE
236: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
237: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
238: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
239: statusStr := 'FAILURE';
240: errStr := 'Invalid Script Name';

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

239: statusStr := 'FAILURE';
240: errStr := 'Invalid Script Name';
241: fixInfo := 'Please choose correct Script Name';
242: isFatal := 'FALSE';
243: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
244: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
245: RETURN;
246: END IF;
247:

Line 244: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

240: errStr := 'Invalid Script Name';
241: fixInfo := 'Please choose correct Script Name';
242: isFatal := 'FALSE';
243: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
244: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
245: RETURN;
246: END IF;
247:
248: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';

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

245: RETURN;
246: END IF;
247:
248: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
249: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
250: statusStr := 'SUCCESS';
251: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
252: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
253:

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

247:
248: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
249: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
250: statusStr := 'SUCCESS';
251: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
252: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
253:
254: EXCEPTION
255: when others then

Line 252: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

248: reportStr := ' Note: Only first 199 rows are returned by this script. The test completed as expected';
249: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
250: statusStr := 'SUCCESS';
251: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
252: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
253:
254: EXCEPTION
255: when others then
256: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

258: statusStr := 'FAILURE';
259: errStr := sqlerrm ||' occurred in script Exception handled';
260: fixInfo := 'Unexpected Exception in INVDA07B.pls';
261: isFatal := 'FALSE';
262: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
263: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
264: END runTest;
265:
266:

Line 263: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

259: errStr := sqlerrm ||' occurred in script Exception handled';
260: fixInfo := 'Unexpected Exception in INVDA07B.pls';
261: isFatal := 'FALSE';
262: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
263: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
264: END runTest;
265:
266:
267: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 286: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

282: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
283: tempDependencies JTF_DIAG_DEPENDTBL;
284:
285: BEGIN
286: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
287: END getDependencies;
288:
289: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
290: BEGIN

Line 297: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

293:
294: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
295: tempOutput JTF_DIAG_OUTPUTTBL;
296: BEGIN
297: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
298: outputValues := tempOutput;
299: EXCEPTION
300: when others then
301: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 301: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

297: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
298: outputValues := tempOutput;
299: EXCEPTION
300: when others then
301: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
302: END getOutputValues;
303:
304: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
305: tempInput JTF_DIAG_INPUTTBL;

Line 307: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

303:
304: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
305: tempInput JTF_DIAG_INPUTTBL;
306: BEGIN
307: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
308: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
309: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
310: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PhyInvDumpScriptsLov');
311: defaultInputValues := tempInput;

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

304: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
305: tempInput JTF_DIAG_INPUTTBL;
306: BEGIN
307: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
308: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
309: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
310: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PhyInvDumpScriptsLov');
311: defaultInputValues := tempInput;
312: EXCEPTION

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

305: tempInput JTF_DIAG_INPUTTBL;
306: BEGIN
307: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
308: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
309: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
310: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PhyInvDumpScriptsLov');
311: defaultInputValues := tempInput;
312: EXCEPTION
313: when others then

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

306: BEGIN
307: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
308: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
309: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
310: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PhyInvDumpScriptsLov');
311: defaultInputValues := tempInput;
312: EXCEPTION
313: when others then
314: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 314: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

310: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.PhyInvDumpScriptsLov');
311: defaultInputValues := tempInput;
312: EXCEPTION
313: when others then
314: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
315: END getDefaultTestParams;
316:
317: Function getTestMode return INTEGER IS
318: BEGIN

Line 319: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

315: END getDefaultTestParams;
316:
317: Function getTestMode return INTEGER IS
318: BEGIN
319: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
320: END getTestMode;
321:
322: END INV_DIAG_PHY_INV_DUMP;