52:
53:
54:
55: BEGIN
56: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
57: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
59:
60: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
53:
54:
55: BEGIN
56: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
57: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
59:
60: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
61: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
56: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
57: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
59:
60: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
61: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
62: l_count := 0;
63:
64: sqltxt := ' SELECT o.name "Name" ' ||
57: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
59:
60: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
61: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
62: l_count := 0;
63:
64: sqltxt := ' SELECT o.name "Name" ' ||
65: ' , DECODE( o.type#, 9, ''Spec'', 11, ''Body'', o.type# ) "Type" ' ||
85: ' ORDER BY o.name, o.type# ';
86:
87: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of Inventory Key Packages');
88:
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
86:
87: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of Inventory Key Packages');
88:
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
87: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of Inventory Key Packages');
88:
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
88:
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 66957.1, : Oracle Inventory Users Guide, Release 11i
');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 66957.1, : Oracle Inventory Users Guide, Release 11i
');
98:
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 66957.1, : Oracle Inventory Users Guide, Release 11i
');
98:
99:
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 204946.1, : Manufacturing And Distribution Recommended Patch Strategy ');
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 66957.1, : Oracle Inventory Users Guide, Release 11i
');
98:
99:
100: IF l_org_id IS NOT NULL AND l_phy_inv_id IS NOT NULL THEN
93: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 246934.1, : White Paper: Understanding Physical Inventory ');
94: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 146869.1, : How To Create Physical Inventory TAGs ');
95: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 105286.1, : Steps to define and complete a Physical Inventory ');
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 114296.1, : Physical Inventory FAQ ');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 66957.1, : Oracle Inventory Users Guide, Release 11i
');
98:
99:
100: IF l_org_id IS NOT NULL AND l_phy_inv_id IS NOT NULL THEN
101:
105:
106: END IF;
107:
108: IF l_count IS NULL OR l_count <> 1 THEN
109: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization and physical inventory information');
110: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Physical Inventory Item and Organization Combination');
111: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct physical inventory and organization ids');
112: statusStr := 'FAILURE';
113: errStr := 'Invalid Physical Inventory Item and Organization Combination';
112: statusStr := 'FAILURE';
113: errStr := 'Invalid Physical Inventory Item and Organization Combination';
114: fixInfo := 'Please enter right combination of Physical Inventory Item and Organization';
115: isFatal := 'FALSE';
116: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
117: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
118: RETURN;
119: END IF;
120:
113: errStr := 'Invalid Physical Inventory Item and Organization Combination';
114: fixInfo := 'Please enter right combination of Physical Inventory Item and Organization';
115: isFatal := 'FALSE';
116: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
117: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
118: RETURN;
119: END IF;
120:
121: sqltxt := ' SELECT mif.item_number "Item" ' ||
656:
657: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Subinventories restricted to physical inventory');
658:
659: reportStr := 'The test completed as expected';
660: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
661: statusStr := 'SUCCESS';
662: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
663: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
664:
658:
659: reportStr := 'The test completed as expected';
660: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
661: statusStr := 'SUCCESS';
662: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
663: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
659: reportStr := 'The test completed as expected';
660: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
661: statusStr := 'SUCCESS';
662: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
663: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
669: statusStr := 'FAILURE';
670: errStr := sqlerrm ||' occurred in script Exception handled';
671: fixInfo := 'Unexpected Exception in INVDA06B.pls';
672: isFatal := 'FALSE';
673: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
674: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
675: END runTest;
676:
677: ------------------------------------------------------------
670: errStr := sqlerrm ||' occurred in script Exception handled';
671: fixInfo := 'Unexpected Exception in INVDA06B.pls';
672: isFatal := 'FALSE';
673: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
674: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
675: END runTest;
676:
677: ------------------------------------------------------------
678: -- procedure to report name back to framework
707: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
708: tempInput JTF_DIAG_INPUTTBL;
709: BEGIN
710:
711: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
712: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
713: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
714: defaultInputValues := tempInput;
715: EXCEPTION
708: tempInput JTF_DIAG_INPUTTBL;
709: BEGIN
710:
711: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
712: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
713: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
714: defaultInputValues := tempInput;
715: EXCEPTION
716: when others then
709: BEGIN
710:
711: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
712: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
713: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
714: defaultInputValues := tempInput;
715: EXCEPTION
716: when others then
717: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
713: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
714: defaultInputValues := tempInput;
715: EXCEPTION
716: when others then
717: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
718: END getDefaultTestParams;
719: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
720: tempDependencies JTF_DIAG_DEPENDTBL;
721:
719: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
720: tempDependencies JTF_DIAG_DEPENDTBL;
721:
722: BEGIN
723: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
724: END getDependencies;
725:
726: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
727: BEGIN
730:
731: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
732: tempOutput JTF_DIAG_OUTPUTTBL;
733: BEGIN
734: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
735: outputValues := tempOutput;
736: EXCEPTION
737: when others then
738: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
734: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
735: outputValues := tempOutput;
736: EXCEPTION
737: when others then
738: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
739: END getOutputValues;
740:
741: Function getTestMode return INTEGER IS
742: BEGIN
739: END getOutputValues;
740:
741: Function getTestMode return INTEGER IS
742: BEGIN
743: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
744:
745: END getTestMode;
746:
747: END INV_DIAG_PI_GEN;