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.
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'
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:
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);
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:
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
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:
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;
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:
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:
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
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:
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
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
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;
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
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
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
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;
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
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;