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_LOC_SKUNOLOC 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 with 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 with 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 INVDO05B.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 INVDO05B.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 151: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 155: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 161: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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

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

Line 166: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

Line 171: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

167: END getDefaultTestParams;
168:
169: Function getTestMode return INTEGER IS
170: BEGIN
171: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
172:
173: END getTestMode;
174:
175: END INV_DIAG_OH_LOC_SKUNOLOC;