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_PO 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,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov

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,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');

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

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,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ReceiptNumLov');

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

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,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ReceiptNumLov');
68: defaultInputValues := tempInput;

Line 65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov

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,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ReceiptNumLov');
68: defaultInputValues := tempInput;
69: END getDefaultTestParams;

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

62: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');
63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ReceiptNumLov');
68: defaultInputValues := tempInput;
69: END getDefaultTestParams;
70:

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

63: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Number','LOV-oracle.apps.inv.diag.lov.PONumberLov');
64: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Number','LOV-oracle.apps.inv.diag.lov.POlineLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
65: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PO Line Location Number','LOV-oracle.apps.inv.diag.lov.POlinelocLov'); -- LOV-oracle.apps.inv.diag.lov.ItemLov
66: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.ReceiptNumLov');
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_line_loc_num po_line_locations_all.shipment_num%TYPE;
106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
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: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));

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

106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
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: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));

Line 113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));

109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));

Line 114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));

110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
118: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));

Line 115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));

111: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
112: -- accept input
113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
118: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
119:

Line 116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));

112: -- accept input
113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
118: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
119:
120: -----------------------------------------

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

113: l_po_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Number',inputs));
114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
118: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
119:
120: -----------------------------------------
121: -- Validation part.

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

114: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));
115: l_line_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Number',inputs));
116: l_line_loc_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PO Line Location Number',inputs));
117: l_receipt_num := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
118: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
119:
120: -----------------------------------------
121: -- Validation part.
122: -----------------------------------------

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

129: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN
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 test.');
132: statusStr := 'FAILURE';
133: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN

Line 134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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 test.');
132: statusStr := 'FAILURE';
133: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
134: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN
138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');

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

137: ELSIF l_operating_id IS NULL THEN
138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
139: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
140: statusStr := 'FAILURE';
141: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
143: RETURN;
144: ELSE
145: IF (l_receipt_num IS NOT NULL AND l_po_number IS NULL AND l_org_id IS NULL) THEN

Line 142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

138: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
139: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
140: statusStr := 'FAILURE';
141: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
142: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
143: RETURN;
144: ELSE
145: IF (l_receipt_num IS NOT NULL AND l_po_number IS NULL AND l_org_id IS NULL) THEN
146: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');

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

145: IF (l_receipt_num IS NOT NULL AND l_po_number IS NULL AND l_org_id IS NULL) THEN
146: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing.');
147: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this test.');
148: statusStr := 'FAILURE';
149: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
150: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
151: RETURN;
152: END IF;
153: END IF;

Line 150: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

180: IF l_count = 0 THEN
181: statusStr := 'FAILURE';
182: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
183: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
184: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
185: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
186: RETURN;
187: END IF;
188: END IF;

Line 185: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

181: statusStr := 'FAILURE';
182: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
183: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid data for all the input parameters.');
184: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
185: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
186: RETURN;
187: END IF;
188: END IF;
189:

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

203: IF l_count = 0 THEN
204: statusStr := 'FAILURE';
205: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number,Operating unit id,Receipt num and Organization_id.');
207: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
208: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
209: RETURN;
210: END IF;
211: END IF;

Line 208: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

204: statusStr := 'FAILURE';
205: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
206: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number,Operating unit id,Receipt num and Organization_id.');
207: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
208: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
209: RETURN;
210: END IF;
211: END IF;
212:

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

219: IF l_count = 0 THEN
220: statusStr := 'FAILURE';
221: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
222: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number and Operating unit id.');
223: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
225: RETURN;
226: END IF;
227: END IF;

Line 224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

220: statusStr := 'FAILURE';
221: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
222: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Purchase order number and Operating unit id.');
223: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
224: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
225: RETURN;
226: END IF;
227: END IF;
228:

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

236: IF l_count = 0 THEN
237: statusStr := 'FAILURE';
238: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
240: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
241: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
242: RETURN;
243: END IF;
244: END IF;

Line 241: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

237: statusStr := 'FAILURE';
238: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter a valid Receipt number and Organization id.');
240: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
241: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
242: RETURN;
243: END IF;
244: END IF;
245:

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

661:
662: -- Test Completed successfully.
663: statusStr := 'SUCCESS';
664: isFatal := 'FALSE';
665: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
666: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
667:
668: EXCEPTION
669: when others then

Line 666: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

662: -- Test Completed successfully.
663: statusStr := 'SUCCESS';
664: isFatal := 'FALSE';
665: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
666: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
667:
668: EXCEPTION
669: when others then
670: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

672: statusStr := 'FAILURE';
673: errStr := sqlerrm ||' occurred in script Exception handled';
674: fixInfo := 'Unexpected Exception in INVDPO1B.pls';
675: isFatal := 'SUCCESS';
676: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
677: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
678: END runTest;
679:
680:

Line 677: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

673: errStr := sqlerrm ||' occurred in script Exception handled';
674: fixInfo := 'Unexpected Exception in INVDPO1B.pls';
675: isFatal := 'SUCCESS';
676: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
677: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
678: END runTest;
679:
680:
681: END INV_DIAG_RCV_PO;