57: ------------------------------------------------------------
58: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
59: tempInput JTF_DIAG_INPUTTBL;
60: BEGIN
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
58: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
59: tempInput JTF_DIAG_INPUTTBL;
60: BEGIN
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
59: tempInput JTF_DIAG_INPUTTBL;
60: BEGIN
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ISOReceiptLov');
60: BEGIN
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ISOReceiptLov');
68: defaultInputValues := tempInput;
61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ISOReceiptLov');
68: defaultInputValues := tempInput;
69: END getDefaultTestParams;
62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ISOReceiptLov');
68: defaultInputValues := tempInput;
69: END getDefaultTestParams;
70:
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Number','LOV-oracle.apps.inv.diag.lov.ISOReqNumLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Requisition Line Number','LOV-oracle.apps.inv.diag.lov.InternalReqlineLov');
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Shipment Number','LOV-oracle.apps.inv.diag.lov.ISONumberLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ISOReceiptLov');
68: defaultInputValues := tempInput;
69: END getDefaultTestParams;
70:
71: ------------------------------------------------------------
72: -- procedure to report test mode back to the framework
73: ------------------------------------------------------------
74: FUNCTION getTestMode RETURN NUMBER IS
75: BEGIN
76: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
77: END getTestMode;
78:
79: ------------------------------------------------------------
80: -- procedure to execute the PLSQL test
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
107:
108: BEGIN
109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113:
106: l_execute NUMBER := 0;
107:
108: BEGIN
109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113:
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113:
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));
117: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
118: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113:
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));
117: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
118: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
119:
112: -- accept input
113:
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));
117: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
118: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
119:
120: /* Bug#6828508
113:
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));
117: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
118: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
119:
120: /* Bug#6828508
121: * OrganizationLov is wrongly referenced as 'Receiving Organization Id'.
114: l_req_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Number',inputs));
115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));
117: l_shipment_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Shipment Number',inputs));
118: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
119:
120: /* Bug#6828508
121: * OrganizationLov is wrongly referenced as 'Receiving Organization Id'.
122: * So, changed 'Receiving Organization Id' to 'Organization Id' as mentioned
121: * OrganizationLov is wrongly referenced as 'Receiving Organization Id'.
122: * So, changed 'Receiving Organization Id' to 'Organization Id' as mentioned
123: * in OrganizationLov.
124: */
125: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));--Bug#6828508
126:
127:
128:
129: IF (l_shipment_num IS NULL and l_receipt_num is NOT NULL and l_org_id is NOT NULL) THEN
166:
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 test.');
169: statusStr := 'FAILURE';
170: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
171: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
172: return;
173: END IF;
174:
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 test.');
169: statusStr := 'FAILURE';
170: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
171: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
172: return;
173: END IF;
174:
175: IF (l_req_num is NOT NULL and l_ou_id is NULL) THEN
176:
177: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
178: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
179: statusStr := 'FAILURE';
180: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
181: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
182: return;
183:
184: END IF;
177: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
178: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
179: statusStr := 'FAILURE';
180: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
181: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
182: return;
183:
184: END IF;
185:
187:
188: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
189: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
190: statusStr := 'FAILURE';
191: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
192: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
193: return;
194: END IF;
195:
188: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
189: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
190: statusStr := 'FAILURE';
191: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
192: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
193: return;
194: END IF;
195:
196: IF (l_req_num is NULL AND l_ou_id is NULL AND l_line_num IS NOT NULL) THEN
197:
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
200: statusStr := 'FAILURE';
201: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
202: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
203: return;
204: END IF;
205:
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
200: statusStr := 'FAILURE';
201: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
202: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
203: return;
204: END IF;
205:
206: IF (l_shipment_num is NOT NULL and l_org_id is NULL) THEN
206: IF (l_shipment_num is NOT NULL and l_org_id is NULL) THEN
207: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
208: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
209: statusStr := 'FAILURE';
210: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
211: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
212: return;
213: END IF;
214:
207: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
208: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
209: statusStr := 'FAILURE';
210: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
211: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
212: return;
213: END IF;
214:
215:
216: IF (l_receipt_num is NOT NULL and l_org_id is NULL) THEN
217: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
219: statusStr := 'FAILURE';
220: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
221: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
222: return;
223: END IF;
224:
217: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
219: statusStr := 'FAILURE';
220: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
221: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
222: return;
223: END IF;
224:
225:
226: IF (l_receipt_num is NULL and l_shipment_num is NULL and l_org_id is NOT NULL) THEN
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
229: statusStr := 'FAILURE';
230: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
231: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
232: return;
233: END IF;
234:
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
229: statusStr := 'FAILURE';
230: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
231: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
232: return;
233: END IF;
234:
235:
255: IF l_count = 0 THEN
256: statusStr := 'FAILURE';
257: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
258: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
259: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
260: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
261: RETURN;
262: END IF;
263: END IF;
256: statusStr := 'FAILURE';
257: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
258: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
259: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
260: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
261: RETURN;
262: END IF;
263: END IF;
264:
282: IF l_count = 0 THEN
283: statusStr := 'FAILURE';
284: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
285: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
286: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
287: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
288: RETURN;
289: END IF;
290: END IF;
283: statusStr := 'FAILURE';
284: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
285: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
286: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
287: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
288: RETURN;
289: END IF;
290: END IF;
291:
303: IF l_count = 0 THEN
304: statusStr := 'FAILURE';
305: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
306: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number,Operating unit id and Requisition line number.');
307: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
308: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
309: RETURN;
310: END IF;
311: END IF;
304: statusStr := 'FAILURE';
305: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
306: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number,Operating unit id and Requisition line number.');
307: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
308: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
309: RETURN;
310: END IF;
311: END IF;
312:
323: IF l_count = 0 THEN
324: statusStr := 'FAILURE';
325: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
326: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number,Shipment number and Organization id.');
327: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
328: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
329: RETURN;
330: END IF;
331: END IF;
324: statusStr := 'FAILURE';
325: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
326: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number,Shipment number and Organization id.');
327: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
328: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
329: RETURN;
330: END IF;
331: END IF;
332:
343: IF l_count = 0 THEN
344: statusStr := 'FAILURE';
345: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
346: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
347: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
348: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
349: RETURN;
350: END IF;
351: END IF;
344: statusStr := 'FAILURE';
345: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
346: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Requisition number and Operating unit id.');
347: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
348: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
349: RETURN;
350: END IF;
351: END IF;
352:
362: IF l_count = 0 THEN
363: statusStr := 'FAILURE';
364: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
366: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
367: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
368: RETURN;
369: END IF;
370: END IF;
363: statusStr := 'FAILURE';
364: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
366: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
367: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
368: RETURN;
369: END IF;
370: END IF;
371:
381: IF l_count = 0 THEN
382: statusStr := 'FAILURE';
383: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
384: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Shipment number and Organization id.');
385: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
386: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
387: RETURN;
388: END IF;
389: END IF;
382: statusStr := 'FAILURE';
383: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
384: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Shipment number and Organization id.');
385: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
386: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
387: RETURN;
388: END IF;
389: END IF;
390:
808:
809:
810: statusStr := 'SUCCESS';
811: isFatal := 'FALSE';
812: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
813: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
814:
815:
816: EXCEPTION
809:
810: statusStr := 'SUCCESS';
811: isFatal := 'FALSE';
812: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
813: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
814:
815:
816: EXCEPTION
817: when others then
820: statusStr := 'FAILURE';
821: errStr := sqlerrm ||' occurred in script Exception handled';
822: fixInfo := 'Unexpected Exception in INVDR01B.pls';
823: isFatal := 'FALSE';
824: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
825: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
826: END runTest;
827:
828:
821: errStr := sqlerrm ||' occurred in script Exception handled';
822: fixInfo := 'Unexpected Exception in INVDR01B.pls';
823: isFatal := 'FALSE';
824: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
825: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
826: END runTest;
827:
828:
829: END inv_diag_rcv_io;