DBA Data[Home] [Help]

APPS.INV_DIAG_RCV_IO dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 61: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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');

Line 62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');

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');

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

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');

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

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;

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

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;

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

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:

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

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: ------------------------------------------------------------

Line 76: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

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

Line 109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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:

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

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));

Line 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));

Line 115: l_ou_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',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:

Line 116: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Requisition Line Number',inputs));

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

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

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'.

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

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

Line 125: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));--Bug#6828508

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

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

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:

Line 171: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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;

Line 181: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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:

Line 192: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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:

Line 202: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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:

Line 211: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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:

Line 221: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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:

Line 231: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 260: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 287: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 308: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 328: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 348: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 367: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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;

Line 386: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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:

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

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

Line 813: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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:

Line 825: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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;