DBA Data[Home] [Help]

APPS.INV_DIAG_SER_NOT_MRK dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

44: l_item_id NUMBER;
45: l_resp fnd_responsibility_tl.Responsibility_Name%type :='Inventory';
46:
47: BEGIN
48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
50: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
51: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
52:

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

45: l_resp fnd_responsibility_tl.Responsibility_Name%type :='Inventory';
46:
47: BEGIN
48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
50: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
51: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
52:
53: /*

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

57: statusStr := 'FAILURE';
58: errStr := 'This test requires Inventory Responsibility Role';
59: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';
60: isFatal := 'FALSE';
61: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
63: RETURN;
64: END IF;
65:

Line 62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

58: errStr := 'This test requires Inventory Responsibility Role';
59: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';
60: isFatal := 'FALSE';
61: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
63: RETURN;
64: END IF;
65:
66: */

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

64: END IF;
65:
66: */
67:
68: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
69: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
70:
71:
72: sqltxt := ' SELECT count(*) ' ||

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

65:
66: */
67:
68: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
69: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
70:
71:
72: sqltxt := ' SELECT count(*) ' ||
73: ' FROM' ||

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

263:
264: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serials in delivered serials');
265:
266: reportStr := 'The test completed as expected';
267: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
268: statusStr := 'SUCCESS';
269: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
270: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
271:

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

265:
266: reportStr := 'The test completed as expected';
267: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
268: statusStr := 'SUCCESS';
269: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
270: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
271:
272: EXCEPTION
273: WHEN OTHERS THEN

Line 270: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

266: reportStr := 'The test completed as expected';
267: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
268: statusStr := 'SUCCESS';
269: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
270: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
271:
272: EXCEPTION
273: WHEN OTHERS THEN
274: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

276: statusStr := 'FAILURE';
277: errStr := sqlerrm ||' occurred in script Exception handled';
278: fixInfo := 'Unexpected Exception in INVDP05B.pls';
279: isFatal := 'FALSE';
280: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
281: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
282: END runTest;
283:
284: ------------------------------------------------------------

Line 281: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

277: errStr := sqlerrm ||' occurred in script Exception handled';
278: fixInfo := 'Unexpected Exception in INVDP05B.pls';
279: isFatal := 'FALSE';
280: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
281: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
282: END runTest;
283:
284: ------------------------------------------------------------
285: -- procedure to report name back to framework

Line 318: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

314: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
315: tempInput JTF_DIAG_INPUTTBL;
316: BEGIN
317:
318: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
319: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
320: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
321: defaultInputValues := tempInput;
322:

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

315: tempInput JTF_DIAG_INPUTTBL;
316: BEGIN
317:
318: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
319: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
320: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
321: defaultInputValues := tempInput;
322:
323: EXCEPTION

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

316: BEGIN
317:
318: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
319: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
320: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
321: defaultInputValues := tempInput;
322:
323: EXCEPTION
324: when others then

Line 325: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

321: defaultInputValues := tempInput;
322:
323: EXCEPTION
324: when others then
325: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
326: END getDefaultTestParams;
327: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
328: tempDependencies JTF_DIAG_DEPENDTBL;
329:

Line 331: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

327: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
328: tempDependencies JTF_DIAG_DEPENDTBL;
329:
330: BEGIN
331: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
332: END getDependencies;
333:
334: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
335: BEGIN

Line 342: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

338:
339: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
340: tempOutput JTF_DIAG_OUTPUTTBL;
341: BEGIN
342: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
343: outputValues := tempOutput;
344: EXCEPTION
345: when others then
346: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 346: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

342: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
343: outputValues := tempOutput;
344: EXCEPTION
345: when others then
346: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
347: END getOutputValues;
348:
349: Function getTestMode return INTEGER IS
350: BEGIN

Line 351: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

347: END getOutputValues;
348:
349: Function getTestMode return INTEGER IS
350: BEGIN
351: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
352:
353: END getTestMode;
354:
355: END INV_DIAG_SER_NOT_MRK;