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_NOREV_ITMREV 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 86: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the revision mismatch for an organization.');

82: ' mif.item_number|| '' (''||t.inventory_item_id||'')'',' ||
83: ' t.inventory_item_id, t.subinventory_code, t.locator_id, t.lot_number, t.revision' ;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand without Revision for item revision controlled.');
86: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the revision mismatch for an organization.');
87: 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 revision mismatches across organization.');
88:
89: END IF;
90:

Line 87: 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 revision mismatches across organization.');

83: ' t.inventory_item_id, t.subinventory_code, t.locator_id, t.lot_number, t.revision' ;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand without Revision for item revision controlled.');
86: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the revision mismatch for an organization.');
87: 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 revision mismatches across organization.');
88:
89: END IF;
90:
91: reportStr := 'The test completed as expected.';

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

88:
89: END IF;
90:
91: reportStr := 'The test completed as expected.';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:

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

90:
91: reportStr := 'The test completed as expected.';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: when others then

Line 95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

91: reportStr := 'The test completed as expected.';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: when others then
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDO04B.pls';
104: isFatal := 'FALSE';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107: END runTest;
108:
109:

Line 106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDO04B.pls';
104: isFatal := 'FALSE';
105: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
106: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
107: END runTest;
108:
109:
110: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 129: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

125: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
126: tempDependencies JTF_DIAG_DEPENDTBL;
127:
128: BEGIN
129: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
130: END getDependencies;
131:
132: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
133: BEGIN

Line 140: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

136:
137: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
138: tempOutput JTF_DIAG_OUTPUTTBL;
139: BEGIN
140: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
141: outputValues := tempOutput;
142: EXCEPTION
143: when others then
144: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 144: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

140: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
141: outputValues := tempOutput;
142: EXCEPTION
143: when others then
144: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
145: END getOutputValues;
146:
147: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
148: tempInput JTF_DIAG_INPUTTBL;

Line 150: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

146:
147: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
148: tempInput JTF_DIAG_INPUTTBL;
149: BEGIN
150: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
151: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
152: defaultInputValues := tempInput;
153: EXCEPTION
154: when others then

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

147: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
148: tempInput JTF_DIAG_INPUTTBL;
149: BEGIN
150: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
151: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
152: defaultInputValues := tempInput;
153: EXCEPTION
154: when others then
155: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 155: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

151: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
152: defaultInputValues := tempInput;
153: EXCEPTION
154: when others then
155: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
156: END getDefaultTestParams;
157:
158: Function getTestMode return INTEGER IS
159: BEGIN

Line 160: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

156: END getDefaultTestParams;
157:
158: Function getTestMode return INTEGER IS
159: BEGIN
160: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
161:
162: END getTestMode;
163:
164: END INV_DIAG_OH_NOREV_ITMREV;