eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_OH_LOT_ITMNOLOT 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 63: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

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:

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

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

Line 66: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

Line 77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

Line 100: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

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

Line 111: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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;

Line 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

Line 122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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

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

Line 128: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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