26: row_limit NUMBER;
27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
36: sqltxt :='select mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)"' ||
37: ' ,mif.item_number|| '' (''||moqd.inventory_item_id||'')'' "Item (Id)" ' ||
38: ' ,moqd.locator_id "Loc id",moqd.lot_number "Lot number",moqd.revision "Rev", moqd.subinventory_code "Subinv" ' ||
59:
60: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with Lot number for Item Not Lot Controlled');
61:
62: reportStr := 'The test completed as expected';
63: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
64: statusStr := 'SUCCESS';
65: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
66: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
67:
61:
62: reportStr := 'The test completed as expected';
63: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
64: statusStr := 'SUCCESS';
65: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
66: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
67:
68: EXCEPTION
69: when others then
62: reportStr := 'The test completed as expected';
63: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
64: statusStr := 'SUCCESS';
65: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
66: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
67:
68: EXCEPTION
69: when others then
70: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
72: statusStr := 'FAILURE';
73: errStr := sqlerrm ||' occurred in script Exception handled';
74: fixInfo := 'Unexpected Exception in INVDO01B.pls';
75: isFatal := 'FALSE';
76: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78: END runTest;
79:
80: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
73: errStr := sqlerrm ||' occurred in script Exception handled';
74: fixInfo := 'Unexpected Exception in INVDO01B.pls';
75: isFatal := 'FALSE';
76: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78: END runTest;
79:
80: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
81: BEGIN
96: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
97: tempDependencies JTF_DIAG_DEPENDTBL;
98:
99: BEGIN
100: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
101: END getDependencies;
102:
103: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
104: BEGIN
107:
108: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
109: tempOutput JTF_DIAG_OUTPUTTBL;
110: BEGIN
111: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
112: outputValues := tempOutput;
113: EXCEPTION
114: when others then
115: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
111: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
112: outputValues := tempOutput;
113: EXCEPTION
114: when others then
115: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
116: END getOutputValues;
117:
118:
119: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
118:
119: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
120: tempInput JTF_DIAG_INPUTTBL;
121: BEGIN
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
119: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
120: tempInput JTF_DIAG_INPUTTBL;
121: BEGIN
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
127: when others then
124: defaultInputValues := tempInput;
125:
126: EXCEPTION
127: when others then
128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
129: END getDefaultTestParams;
130:
131: Function getTestMode return INTEGER IS
132: BEGIN
129: END getDefaultTestParams;
130:
131: Function getTestMode return INTEGER IS
132: BEGIN
133: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
134: END getTestMode;
135: END INV_DIAG_OH_LOT_ITMNOLOT;