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

Line 60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

56: ------------------------------------------------------------
57: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
58: tempInput JTF_DIAG_INPUTTBL;
59: BEGIN
60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');

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

57: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
58: tempInput JTF_DIAG_INPUTTBL;
59: BEGIN
60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');
65: defaultInputValues := tempInput;

Line 62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');

58: tempInput JTF_DIAG_INPUTTBL;
59: BEGIN
60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');
65: defaultInputValues := tempInput;
66: END getDefaultTestParams;

Line 63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');

59: BEGIN
60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');
65: defaultInputValues := tempInput;
66: END getDefaultTestParams;
67:

Line 64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');

60: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.IOTNumberLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Line Number','LOV-oracle.apps.inv.diag.lov.IOTlineLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.IOTReceiptLov');
65: defaultInputValues := tempInput;
66: END getDefaultTestParams;
67:
68: ------------------------------------------------------------

Line 73: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

69: -- procedure to report test mode back to the framework
70: ------------------------------------------------------------
71: FUNCTION getTestMode RETURN NUMBER IS
72: BEGIN
73: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
74: END getTestMode;
75:
76: ------------------------------------------------------------
77: -- procedure to execute the PLSQL test

Line 104: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

100: l_makecall NUMBER := 0;
101: l_count NUMBER := 1;
102:
103: BEGIN
104: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
105: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
107:
108: -- accept input

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

101: l_count NUMBER := 1;
102:
103: BEGIN
104: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
105: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
107:
108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));

Line 109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));

105: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
107:
108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
111: l_shipment_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Line Number',inputs));
112: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
113:

Line 110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));

106: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
107:
108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
111: l_shipment_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Line Number',inputs));
112: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
113:
114:

Line 111: l_shipment_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Line Number',inputs));

107:
108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
111: l_shipment_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Line Number',inputs));
112: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
113:
114:
115: IF (l_shipment_num is NULL AND l_receipt_num is NULL AND l_shipment_line_num IS NULL AND l_org_id is NULL ) THEN

Line 112: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));

108: -- accept input
109: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
110: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
111: l_shipment_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Line Number',inputs));
112: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
113:
114:
115: IF (l_shipment_num is NULL AND l_receipt_num is NULL AND l_shipment_line_num IS NULL AND l_org_id is NULL ) THEN
116:

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

117: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
119: test');
120: statusStr := 'FAILURE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123: l_makecall := 1;
124: RETURN;
125: END IF;

Line 122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

118: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
119: test');
120: statusStr := 'FAILURE';
121: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123: l_makecall := 1;
124: RETURN;
125: END IF;
126:

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

130: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
132: test');
133: statusStr := 'FAILURE';
134: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
135: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
136: l_makecall := 1;
137: RETURN;
138: END IF;

Line 135: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
132: test');
133: statusStr := 'FAILURE';
134: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
135: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
136: l_makecall := 1;
137: RETURN;
138: END IF;
139:

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

142: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
143: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
144: test');
145: statusStr := 'FAILURE';
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148: l_makecall := 1;
149: RETURN;
150: END IF;

Line 147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

143: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
144: test');
145: statusStr := 'FAILURE';
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148: l_makecall := 1;
149: RETURN;
150: END IF;
151:

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

155: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
157: test');
158: statusStr := 'FAILURE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
161: l_makecall := 1;
162: RETURN;
163: END IF;

Line 160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

156: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
157: test');
158: statusStr := 'FAILURE';
159: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
160: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
161: l_makecall := 1;
162: RETURN;
163: END IF;
164:

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

167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
169: test');
170: statusStr := 'FAILURE';
171: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
172: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
173: l_makecall := 1;
174: RETURN;
175: END IF;

Line 172: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

168: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
169: test');
170: statusStr := 'FAILURE';
171: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
172: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
173: l_makecall := 1;
174: RETURN;
175: END IF;
176:

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

179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
181: test');
182: statusStr := 'FAILURE';
183: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
184: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
185: l_makecall := 1;
186: RETURN;
187: END IF;

Line 184: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
181: test');
182: statusStr := 'FAILURE';
183: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
184: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
185: l_makecall := 1;
186: RETURN;
187: END IF;
188:

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

270: IF (l_count = 0) THEN
271: statusStr := 'FAILURE';
272: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');
274: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
275: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
276: RETURN;
277: END IF;
278:

Line 275: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

271: statusStr := 'FAILURE';
272: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
273: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid combination of data');
274: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
275: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
276: RETURN;
277: END IF;
278:
279:

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

628: END IF;
629:
630: ------------------------- Submit the sql to fwk
631:
632: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
633: statusStr := 'SUCCESS';
634: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
635: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
636:

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

630: ------------------------- Submit the sql to fwk
631:
632: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
633: statusStr := 'SUCCESS';
634: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
635: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
636:
637: EXCEPTION
638: when others then

Line 635: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

631:
632: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
633: statusStr := 'SUCCESS';
634: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
635: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
636:
637: EXCEPTION
638: when others then
639: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

641: statusStr := 'FAILURE';
642: errStr := sqlerrm ||' occurred in script Exception handled';
643: fixInfo := 'Unexpected Exception in INVDR01B.pls';
644: isFatal := 'FALSE';
645: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
646: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
647: END runTest;
648:
649:

Line 646: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

642: errStr := sqlerrm ||' occurred in script Exception handled';
643: fixInfo := 'Unexpected Exception in INVDR01B.pls';
644: isFatal := 'FALSE';
645: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
646: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
647: END runTest;
648:
649:
650: END INV_DIAG_RCV_IOT;