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_NOLOC_SKULOC dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

29: sqltxt VARCHAR2 (9999);
30: l_org_id NUMBER;
31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
37:

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

30: l_org_id NUMBER;
31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
37:
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

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

34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
37:
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
39:
40:
41: IF l_org_id IS NOT NULL THEN
42:

Line 97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the locator mismatch for an organization.');

93: ' mif.item_number|| '' (''||t.inventory_item_id||'')'',' ||
94: ' t.subinventory_code, t.locator_id, t.lot_number, t.revision' ;
95:
96: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand without locator for SKU not locator controlled.');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the locator mismatch for an organization.');
98: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Alternatively user can execute the mismatch script mentioned in Note 279205.1 and then this script without organization identifier to identify locator mismatches across organization.');
99:
100: END IF;
101:

Line 98: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Alternatively user can execute the mismatch script mentioned in Note 279205.1 and then this script without organization identifier to identify locator mismatches across organization.');

94: ' t.subinventory_code, t.locator_id, t.lot_number, t.revision' ;
95:
96: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand without locator for SKU not locator controlled.');
97: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the locator mismatch for an organization.');
98: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Alternatively user can execute the mismatch script mentioned in Note 279205.1 and then this script without organization identifier to identify locator mismatches across organization.');
99:
100: END IF;
101:
102: reportStr := 'The test completed as expected';

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

99:
100: END IF;
101:
102: reportStr := 'The test completed as expected';
103: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
104: statusStr := 'SUCCESS';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107:

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

101:
102: reportStr := 'The test completed as expected';
103: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
104: statusStr := 'SUCCESS';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107:
108: EXCEPTION
109: when others then

Line 106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

102: reportStr := 'The test completed as expected';
103: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
104: statusStr := 'SUCCESS';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107:
108: EXCEPTION
109: when others then
110: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

112: statusStr := 'FAILURE';
113: errStr := sqlerrm ||' occurred in script Exception handled';
114: fixInfo := 'Unexpected Exception in INVDO06B.pls';
115: isFatal := 'FALSE';
116: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
117: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
118: END runTest;
119:
120:

Line 117: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

113: errStr := sqlerrm ||' occurred in script Exception handled';
114: fixInfo := 'Unexpected Exception in INVDO06B.pls';
115: isFatal := 'FALSE';
116: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
117: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
118: END runTest;
119:
120:
121: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 140: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

136: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
137: tempDependencies JTF_DIAG_DEPENDTBL;
138:
139: BEGIN
140: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
141: END getDependencies;
142:
143: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
144: BEGIN

Line 152: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

148:
149: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
150: tempOutput JTF_DIAG_OUTPUTTBL;
151: BEGIN
152: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
153: outputValues := tempOutput;
154: EXCEPTION
155: when others then
156: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 156: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

152: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
153: outputValues := tempOutput;
154: EXCEPTION
155: when others then
156: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
157: END getOutputValues;
158:
159:
160: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 163: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

159:
160: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
161: tempInput JTF_DIAG_INPUTTBL;
162: BEGIN
163: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
164: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
165: defaultInputValues := tempInput;
166: EXCEPTION
167: when others then

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

160: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
161: tempInput JTF_DIAG_INPUTTBL;
162: BEGIN
163: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
164: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
165: defaultInputValues := tempInput;
166: EXCEPTION
167: when others then
168: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 168: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

164: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
165: defaultInputValues := tempInput;
166: EXCEPTION
167: when others then
168: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
169: END getDefaultTestParams;
170:
171: Function getTestMode return INTEGER IS
172: BEGIN

Line 173: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

169: END getDefaultTestParams;
170:
171: Function getTestMode return INTEGER IS
172: BEGIN
173: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
174:
175: END getTestMode;
176:
177: END INV_DIAG_OH_NOLOC_SKULOC;