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

Line 31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

27: l_org_id NUMBER;
28: l_item_id NUMBER;
29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);

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

28: l_item_id NUMBER;
29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

Line 35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);

31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
38:
39: -- accept input

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

32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
38:
39: -- accept input
40: sqltxt := ' SELECT org "OrganizationCode (Id)"' ||

Line 37: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
38:
39: -- accept input
40: sqltxt := ' SELECT org "OrganizationCode (Id)"' ||
41: ' ,item "Item (Id)",rev "Rev",' ||

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

76: ' where abs(adj_qty) > qty_avail ';
77:
78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory Tags without onhand');
79: reportStr := 'The test completed as expected';
80: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
81: statusStr := 'SUCCESS';
82: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
83: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
84:

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

78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory Tags without onhand');
79: reportStr := 'The test completed as expected';
80: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
81: statusStr := 'SUCCESS';
82: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
83: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
84:
85: EXCEPTION
86: when others then

Line 83: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

79: reportStr := 'The test completed as expected';
80: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
81: statusStr := 'SUCCESS';
82: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
83: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
84:
85: EXCEPTION
86: when others then
87: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

89: statusStr := 'FAILURE';
90: errStr := sqlerrm ||' occurred in script Exception handled';
91: fixInfo := 'Unexpected Exception in INVDA01B.pls';
92: isFatal := 'FALSE';
93: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
94: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
95: END runTest;
96:
97: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 94: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

90: errStr := sqlerrm ||' occurred in script Exception handled';
91: fixInfo := 'Unexpected Exception in INVDA01B.pls';
92: isFatal := 'FALSE';
93: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
94: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
95: END runTest;
96:
97: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
98: BEGIN

Line 116: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

112: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
113: tempDependencies JTF_DIAG_DEPENDTBL;
114:
115: BEGIN
116: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
117: END getDependencies;
118:
119: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
120: BEGIN

Line 127: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

123:
124: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
125: tempOutput JTF_DIAG_OUTPUTTBL;
126: BEGIN
127: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
128: outputValues := tempOutput;
129: EXCEPTION
130: when others then
131: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 131: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

127: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
128: outputValues := tempOutput;
129: EXCEPTION
130: when others then
131: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
132: END getOutputValues;
133:
134: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
135: tempInput JTF_DIAG_INPUTTBL;

Line 137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

133:
134: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
135: tempInput JTF_DIAG_INPUTTBL;
136: BEGIN
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
138: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
139: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
141: defaultInputValues := tempInput;

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

134: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
135: tempInput JTF_DIAG_INPUTTBL;
136: BEGIN
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
138: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
139: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
141: defaultInputValues := tempInput;
142: EXCEPTION

Line 139: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');

135: tempInput JTF_DIAG_INPUTTBL;
136: BEGIN
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
138: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
139: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
141: defaultInputValues := tempInput;
142: EXCEPTION
143: when others then

Line 140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');

136: BEGIN
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
138: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
139: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
141: defaultInputValues := tempInput;
142: EXCEPTION
143: when others then
144: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 144: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

140: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PhyInvId','LOV-oracle.apps.inv.diag.lov.PhysInvLov');
141: defaultInputValues := tempInput;
142: EXCEPTION
143: when others then
144: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
145: END getDefaultTestParams;
146:
147: Function getTestMode return INTEGER IS
148: BEGIN

Line 149: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

145: END getDefaultTestParams;
146:
147: Function getTestMode return INTEGER IS
148: BEGIN
149: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
150:
151: END getTestMode;
152:
153: END INV_DIAG_PI_ONHAND;