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_RMA 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:
62: /* Bug#6828508:
63: * OperatingLov is wrongly referenced as 'OperatingUnit Id'.
64: * So, changed 'OperatingUnit Id' to 'Operating Unit Id' as mentioned

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

63: * OperatingLov is wrongly referenced as 'OperatingUnit Id'.
64: * So, changed 'OperatingUnit Id' to 'Operating Unit Id' as mentioned
65: * in OperatingLov.
66: */
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');--Bug#6828508
68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');
69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');
70: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
71: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.RMAReceiptLov');

Line 68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');

64: * So, changed 'OperatingUnit Id' to 'Operating Unit Id' as mentioned
65: * in OperatingLov.
66: */
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');--Bug#6828508
68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');
69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');
70: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
71: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.RMAReceiptLov');
72: defaultInputValues := tempInput;

Line 69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');

65: * in OperatingLov.
66: */
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');--Bug#6828508
68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');
69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');
70: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
71: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.RMAReceiptLov');
72: defaultInputValues := tempInput;
73: END getDefaultTestParams;

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

66: */
67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');--Bug#6828508
68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');
69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');
70: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
71: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.RMAReceiptLov');
72: defaultInputValues := tempInput;
73: END getDefaultTestParams;
74:

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

67: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Operating Unit Id','LOV-oracle.apps.inv.diag.lov.OperatingLov');--Bug#6828508
68: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Number','LOV-oracle.apps.inv.diag.lov.RMANumberLov');
69: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'RMA Line Number','LOV-oracle.apps.inv.diag.lov.RMAlineLov');
70: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Organization Id','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
71: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Receipt Number','LOV-oracle.apps.inv.diag.lov.RMAReceiptLov');
72: defaultInputValues := tempInput;
73: END getDefaultTestParams;
74:
75: ------------------------------------------------------------

Line 80: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

76: -- procedure to report test mode back to the framework
77: ------------------------------------------------------------
78: FUNCTION getTestMode RETURN NUMBER IS
79: BEGIN
80: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
81: END getTestMode;
82:
83: ------------------------------------------------------------
84: -- procedure to execute the PLSQL test

Line 112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

108: l_org_id rcv_shipment_headers.organization_id%TYPE;
109: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
111: BEGIN
112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));

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

109: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
111: BEGIN
112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508

Line 116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));

112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));
119: l_receipt_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
120: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));

Line 117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508

113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));
119: l_receipt_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
120: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
121:

Line 118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));

114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));
119: l_receipt_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
120: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
121:
122: IF l_rma_number IS NULL THEN

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

115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));
119: l_receipt_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
120: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
121:
122: IF l_rma_number IS NULL THEN
123:

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

116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));
119: l_receipt_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Receipt Number',inputs));
120: l_org_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs));
121:
122: IF l_rma_number IS NULL THEN
123:
124: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN

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

128: statusStr := 'FAILURE';
129: --errStr := 'Some of the Required inputs are missing';
130: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
131: --isFatal := 'SUCCESS';
132: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
134: skip_execution := 1;
135: RETURN;
136: END IF;

Line 133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

129: --errStr := 'Some of the Required inputs are missing';
130: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
131: --isFatal := 'SUCCESS';
132: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
133: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
134: skip_execution := 1;
135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN

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

142: statusStr := 'FAILURE';
143: --errStr := 'Some of the Required inputs are missing';
144: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
145: --isFatal := 'SUCCESS';
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148: skip_execution := 1;
149: RETURN;
150:

Line 147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

143: --errStr := 'Some of the Required inputs are missing';
144: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
145: --isFatal := 'SUCCESS';
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148: skip_execution := 1;
149: RETURN;
150:
151: ELSE

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

156: statusStr := 'FAILURE';
157: --errStr := 'Some of the Required inputs are missing';
158: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
159: --isFatal := 'SUCCESS';
160: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
161: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
162: skip_execution := 1;
163: RETURN;
164: END IF;

Line 161: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

157: --errStr := 'Some of the Required inputs are missing';
158: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';
159: --isFatal := 'SUCCESS';
160: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
161: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
162: skip_execution := 1;
163: RETURN;
164: END IF;
165: END IF;

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

177: WHEN No_Data_Found THEN
178: statusStr := 'FAILURE';
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid RMA number and Operating unit id');
181: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
182: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
183: RETURN;
184: skip_execution := 1;
185: end;

Line 182: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

178: statusStr := 'FAILURE';
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid RMA number and Operating unit id');
181: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
182: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
183: RETURN;
184: skip_execution := 1;
185: end;
186: end if;

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

196: WHEN No_Data_Found THEN
197: statusStr := 'FAILURE';
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid Receipt number and Organization id');
200: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
201: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
202: RETURN;
203: skip_execution := 1;
204: end;

Line 201: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

197: statusStr := 'FAILURE';
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid Receipt number and Organization id');
200: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
201: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
202: RETURN;
203: skip_execution := 1;
204: end;
205: end if;

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

545: END IF;
546:
547: ------------------------- Submit the sql to fwk
548: if skip_execution <> 1 then
549: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
550: statusStr := 'SUCCESS';
551: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
552: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
553: end if;

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

547: ------------------------- Submit the sql to fwk
548: if skip_execution <> 1 then
549: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
550: statusStr := 'SUCCESS';
551: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
552: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
553: end if;
554:
555: EXCEPTION

Line 552: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

548: if skip_execution <> 1 then
549: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
550: statusStr := 'SUCCESS';
551: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
552: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
553: end if;
554:
555: EXCEPTION
556: when others then

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

558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';
562: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
563: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
564: END runTest;
565:
566:

Line 563: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';
562: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
563: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
564: END runTest;
565:
566:
567: END INV_DIAG_RCV_RMA;