DBA Data[Home] [Help]

APPS.INV_DIAG_PI_SUBLOC dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 66: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

62: WHERE (mmt.transaction_id = cp_n_cre_trx_id OR mmt.transaction_id = cp_upd_trx_id)
63: AND mmt.physical_adjustment_id IS NOT NULL;
64:
65: BEGIN
66: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
67: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
68: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
69:
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

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

63: AND mmt.physical_adjustment_id IS NOT NULL;
64:
65: BEGIN
66: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
67: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
68: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
69:
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71:

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

66: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
67: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
68: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
69:
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71:
72: sqltxt := ' select mif.item_number||''(''||mif.inventory_item_id||'')'' "Item (Id)"' ||
73: ' , moqd.subinventory_code "Subinv" ' ||
74: ' , moqd.locator_id "Stock Locator" ' ||

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

207: END LOOP;
208:
209:
210: reportStr := 'The test completed as expected';
211: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
212: statusStr := 'SUCCESS';
213: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
214: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
215:

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

209:
210: reportStr := 'The test completed as expected';
211: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
212: statusStr := 'SUCCESS';
213: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
214: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
215:
216: EXCEPTION
217: when others then

Line 214: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

210: reportStr := 'The test completed as expected';
211: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
212: statusStr := 'SUCCESS';
213: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
214: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
215:
216: EXCEPTION
217: when others then
218: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

220: statusStr := 'FAILURE';
221: errStr := sqlerrm ||' occurred in script Exception handled';
222: fixInfo := 'Unexpected Exception in INVDA02B.pls';
223: isFatal := 'FALSE';
224: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
225: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
226: END runTest;
227:
228: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 225: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

221: errStr := sqlerrm ||' occurred in script Exception handled';
222: fixInfo := 'Unexpected Exception in INVDA02B.pls';
223: isFatal := 'FALSE';
224: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
225: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
226: END runTest;
227:
228: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
229: BEGIN

Line 247: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

243: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
244: tempDependencies JTF_DIAG_DEPENDTBL;
245:
246: BEGIN
247: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
248: END getDependencies;
249:
250: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
251: BEGIN

Line 259: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

255:
256: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
257: tempOutput JTF_DIAG_OUTPUTTBL;
258: BEGIN
259: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
260: outputValues := tempOutput;
261: EXCEPTION
262: when others then
263: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 263: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

259: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
260: outputValues := tempOutput;
261: EXCEPTION
262: when others then
263: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
264: END getOutputValues;
265:
266: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
267: tempInput JTF_DIAG_INPUTTBL;

Line 269: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

265:
266: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
267: tempInput JTF_DIAG_INPUTTBL;
268: BEGIN
269: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
270: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
271: defaultInputValues := tempInput;
272: EXCEPTION
273: when others then

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

266: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
267: tempInput JTF_DIAG_INPUTTBL;
268: BEGIN
269: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
270: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
271: defaultInputValues := tempInput;
272: EXCEPTION
273: when others then
274: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 274: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

270: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
271: defaultInputValues := tempInput;
272: EXCEPTION
273: when others then
274: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
275: END getDefaultTestParams;
276:
277: Function getTestMode return INTEGER IS
278: BEGIN

Line 279: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

275: END getDefaultTestParams;
276:
277: Function getTestMode return INTEGER IS
278: BEGIN
279: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
280:
281: END getTestMode;
282:
283: END INV_DIAG_PI_SUBLOC;