DBA Data[Home] [Help]

APPS.INV_DIAG_OH_NOLOT_ITMLOT dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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);

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

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:

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

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" ' ||

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

60:
61: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand without Lot number for Lot controlled Item');
62:
63: reportStr := 'The test completed as expected';
64: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
65: statusStr := 'SUCCESS';
66: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
68:

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

62:
63: reportStr := 'The test completed as expected';
64: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
65: statusStr := 'SUCCESS';
66: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
68:
69: EXCEPTION
70: when others then

Line 67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

63: reportStr := 'The test completed as expected';
64: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
65: statusStr := 'SUCCESS';
66: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
67: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
68:
69: EXCEPTION
70: when others then
71: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

73: statusStr := 'FAILURE';
74: errStr := sqlerrm ||' occurred in script Exception handled';
75: fixInfo := 'Unexpected Exception in INVDO02B.pls';
76: isFatal := 'FALSE';
77: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
79: END runTest;
80:
81: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

74: errStr := sqlerrm ||' occurred in script Exception handled';
75: fixInfo := 'Unexpected Exception in INVDO02B.pls';
76: isFatal := 'FALSE';
77: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
79: END runTest;
80:
81: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
82: BEGIN

Line 101: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

97: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
98: tempDependencies JTF_DIAG_DEPENDTBL;
99:
100: BEGIN
101: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
102: END getDependencies;
103:
104: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
105: BEGIN

Line 113: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

109:
110: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
111: tempOutput JTF_DIAG_OUTPUTTBL;
112: BEGIN
113: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
114: outputValues := tempOutput;
115: EXCEPTION
116: when others then
117: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 117: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

113: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
114: outputValues := tempOutput;
115: EXCEPTION
116: when others then
117: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
118: END getOutputValues;
119:
120: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
121: tempInput JTF_DIAG_INPUTTBL;

Line 123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

119:
120: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
121: tempInput JTF_DIAG_INPUTTBL;
122: BEGIN
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
125: defaultInputValues := tempInput;
126: EXCEPTION
127: when others then

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

120: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
121: tempInput JTF_DIAG_INPUTTBL;
122: BEGIN
123: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
125: defaultInputValues := tempInput;
126: EXCEPTION
127: when others then
128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

124: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
125: defaultInputValues := tempInput;
126: EXCEPTION
127: when others then
128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
129: END getDefaultTestParams;
130:
131: Function getTestMode return INTEGER IS
132: BEGIN

Line 133: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

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_NOLOT_ITMLOT;