DBA Data[Home] [Help]

APPS.INV_DIAG_OH_QTY_ZERO dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 46: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

42: ORDER BY moqd.create_transaction_id;
43:
44: BEGIN
45:
46: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
47: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:

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

43:
44: BEGIN
45:
46: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
47: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

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

47: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
53:
54:
55: sqltxt := ' select mif.item_number||''(''||mif.inventory_item_id||'')'' "Item (Id)"' ||

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

48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
53:
54:
55: sqltxt := ' select mif.item_number||''(''||mif.inventory_item_id||'')'' "Item (Id)"' ||
56: ' , mp.organization_code|| '' (''||moqd.organization_id ||'')'' "Organization|Code (Id)"' ||

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

115: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Create Transaction Details for transaction_id ' || rec_tnx.create_transaction_id );
116: END LOOP;
117:
118: reportStr := 'The test completed as expected';
119: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
120: statusStr := 'SUCCESS';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123:

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

117:
118: reportStr := 'The test completed as expected';
119: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
120: statusStr := 'SUCCESS';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123:
124: EXCEPTION
125: when others then

Line 122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

118: reportStr := 'The test completed as expected';
119: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
120: statusStr := 'SUCCESS';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123:
124: EXCEPTION
125: when others then
126: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

128: statusStr := 'FAILURE';
129: errStr := sqlerrm ||' occurred in script Exception handled';
130: fixInfo := 'Unexpected Exception in INVDO08B.pls';
131: isFatal := 'FALSE';
132: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
134: END runTest;
135:
136:

Line 133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

129: errStr := sqlerrm ||' occurred in script Exception handled';
130: fixInfo := 'Unexpected Exception in INVDO08B.pls';
131: isFatal := 'FALSE';
132: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
134: END runTest;
135:
136:
137: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 156: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

152: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
153: tempDependencies JTF_DIAG_DEPENDTBL;
154:
155: BEGIN
156: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
157: END getDependencies;
158:
159: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
160: BEGIN

Line 168: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

164:
165: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
166: tempOutput JTF_DIAG_OUTPUTTBL;
167: BEGIN
168: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
169: outputValues := tempOutput;
170: EXCEPTION
171: when others then
172: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 172: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

168: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
169: outputValues := tempOutput;
170: EXCEPTION
171: when others then
172: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
173: END getOutputValues;
174:
175:
176: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 179: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

175:
176: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
177: tempInput JTF_DIAG_INPUTTBL;
178: BEGIN
179: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
180: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
181: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
182: -- tempInput := JTF_DIAGNOSTIC_
183: defaultInputValues := tempInput;

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

176: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
177: tempInput JTF_DIAG_INPUTTBL;
178: BEGIN
179: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
180: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
181: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
182: -- tempInput := JTF_DIAGNOSTIC_
183: defaultInputValues := tempInput;
184: EXCEPTION

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

177: tempInput JTF_DIAG_INPUTTBL;
178: BEGIN
179: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
180: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
181: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
182: -- tempInput := JTF_DIAGNOSTIC_
183: defaultInputValues := tempInput;
184: EXCEPTION
185: when others then

Line 186: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

182: -- tempInput := JTF_DIAGNOSTIC_
183: defaultInputValues := tempInput;
184: EXCEPTION
185: when others then
186: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
187: END getDefaultTestParams;
188:
189: Function getTestMode return INTEGER IS
190: BEGIN

Line 191: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

187: END getDefaultTestParams;
188:
189: Function getTestMode return INTEGER IS
190: BEGIN
191: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
192: END getTestMode;
193:
194: END INV_DIAG_OH_QTY_ZERO;