DBA Data[Home] [Help]

APPS.INV_DIAG_ITEM dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 53: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

49: l_item c_item_info%ROWTYPE;
50:
51: BEGIN
52:
53: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
56:
57: /* -- check whether user has 'Inventory' responsibilty to execute diagnostics script.

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

50:
51: BEGIN
52:
53: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
56:
57: /* -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
58: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'

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

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

Line 65: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

65: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
66: RETURN;
67: END IF; */
68:
69: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71: l_count := 0 ;
72: l_row_limit := INV_DIAG_GRP.g_max_row;
73:

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

66: RETURN;
67: END IF; */
68:
69: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71: l_count := 0 ;
72: l_row_limit := INV_DIAG_GRP.g_max_row;
73:
74: IF l_item_id IS NOT NULL AND l_org_id IS NOT NULL THEN

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

83: statusStr := 'FAILURE';
84: errStr := 'Invalid Item and Organization Combination';
85: fixInfo := 'Please enter right combination of Item and Organization';
86: isFatal := 'FALSE';
87: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
89: RETURN;
90: END IF;
91:

Line 88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

84: errStr := 'Invalid Item and Organization Combination';
85: fixInfo := 'Please enter right combination of Item and Organization';
86: isFatal := 'FALSE';
87: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
89: RETURN;
90: END IF;
91:
92: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;

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

626:
627:
628:
629: reportStr := 'The test completed as expected';
630: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
631: statusStr := 'SUCCESS';
632: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
633: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
634:

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

628:
629: reportStr := 'The test completed as expected';
630: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
631: statusStr := 'SUCCESS';
632: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
633: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
634:
635: else
636:

Line 633: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

629: reportStr := 'The test completed as expected';
630: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
631: statusStr := 'SUCCESS';
632: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
633: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
634:
635: else
636:
637: -- if no item input, do nothing

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

649: statusStr := 'FAILURE';
650: errStr := sqlerrm ||' occurred in script Exception handled';
651: fixInfo := 'Unexpected Exception in INVDI01B.pls';
652: isFatal := 'FALSE';
653: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
654: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
655: END runTest;
656:
657:

Line 654: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

650: errStr := sqlerrm ||' occurred in script Exception handled';
651: fixInfo := 'Unexpected Exception in INVDI01B.pls';
652: isFatal := 'FALSE';
653: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
654: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
655: END runTest;
656:
657:
658: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 678: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

674: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
675: tempDependencies JTF_DIAG_DEPENDTBL;
676:
677: BEGIN
678: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
679: END getDependencies;
680:
681: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
682: BEGIN

Line 690: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

686:
687: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
688: tempOutput JTF_DIAG_OUTPUTTBL;
689: BEGIN
690: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
691: outputValues := tempOutput;
692: EXCEPTION
693: when others then
694: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 694: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

690: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
691: outputValues := tempOutput;
692: EXCEPTION
693: when others then
694: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
695: END getOutputValues;
696:
697:
698: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 701: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

697:
698: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
699: tempInput JTF_DIAG_INPUTTBL;
700: BEGIN
701: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
702: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
703: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
704: defaultInputValues := tempInput;
705: EXCEPTION

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

698: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
699: tempInput JTF_DIAG_INPUTTBL;
700: BEGIN
701: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
702: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
703: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
704: defaultInputValues := tempInput;
705: EXCEPTION
706: when others then

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

699: tempInput JTF_DIAG_INPUTTBL;
700: BEGIN
701: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
702: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
703: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
704: defaultInputValues := tempInput;
705: EXCEPTION
706: when others then
707: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 707: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

703: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
704: defaultInputValues := tempInput;
705: EXCEPTION
706: when others then
707: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
708: END getDefaultTestParams;
709:
710: Function getTestMode return INTEGER IS
711: BEGIN

Line 712: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

708: END getDefaultTestParams;
709:
710: Function getTestMode return INTEGER IS
711: BEGIN
712: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
713:
714: END getTestMode;
715:
716: END INV_DIAG_ITEM;