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_REPLENISH_COUNT_PVT dependencies on FND_API

Line 79: x_return_status := fnd_api.g_ret_sts_success;

75: ) IS
76: l_proc CONSTANT VARCHAR2(30) := 'INSERT_ROW';
77: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
78: BEGIN
79: x_return_status := fnd_api.g_ret_sts_success;
80:
81: IF l_trace_on = 1 THEN
82: print_debug(
83: 'The input parameters are: '

Line 179: x_return_status := fnd_api.g_ret_sts_error;

175: -- INCVONV, NSRIVAST
176: );
177:
178: IF (SQL%NOTFOUND) THEN
179: x_return_status := fnd_api.g_ret_sts_error;
180: ELSE
181: x_return_status := fnd_api.g_ret_sts_success;
182: END IF;
183: EXCEPTION

Line 181: x_return_status := fnd_api.g_ret_sts_success;

177:
178: IF (SQL%NOTFOUND) THEN
179: x_return_status := fnd_api.g_ret_sts_error;
180: ELSE
181: x_return_status := fnd_api.g_ret_sts_success;
182: END IF;
183: EXCEPTION
184: WHEN OTHERS THEN
185: x_return_status := fnd_api.g_ret_sts_error;

Line 185: x_return_status := fnd_api.g_ret_sts_error;

181: x_return_status := fnd_api.g_ret_sts_success;
182: END IF;
183: EXCEPTION
184: WHEN OTHERS THEN
185: x_return_status := fnd_api.g_ret_sts_error;
186: END insert_row;
187:
188: /**
189: * This Procedure is used to update table mtl_replenish_lines.

Line 214: x_return_status := fnd_api.g_ret_sts_success;

210: ) IS
211: l_proc CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
212: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
213: BEGIN
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: IF l_trace_on = 1 THEN
217: print_debug(
218: 'The input parameters are: '

Line 251: x_return_status := fnd_api.g_ret_sts_error;

247: WHERE replenishment_header_id = p_replenish_header_id
248: AND replenishment_line_id = p_replenish_line_id;
249:
250: IF (SQL%NOTFOUND) THEN
251: x_return_status := fnd_api.g_ret_sts_error;
252: ELSE
253: x_return_status := fnd_api.g_ret_sts_success;
254: END IF;
255: EXCEPTION

Line 253: x_return_status := fnd_api.g_ret_sts_success;

249:
250: IF (SQL%NOTFOUND) THEN
251: x_return_status := fnd_api.g_ret_sts_error;
252: ELSE
253: x_return_status := fnd_api.g_ret_sts_success;
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: x_return_status := fnd_api.g_ret_sts_error;

Line 257: x_return_status := fnd_api.g_ret_sts_error;

253: x_return_status := fnd_api.g_ret_sts_success;
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: x_return_status := fnd_api.g_ret_sts_error;
258: END update_row;
259:
260: /** This Procedure is used to fetch the Replenishment Count lines for the user input.
261: * @param x_return_status Return Status

Line 288: x_return_status := fnd_api.g_ret_sts_success;

284: l_proc CONSTANT VARCHAR2(30) := 'FETCH_COUNT_LINES';
285: l_count NUMBER := 0;
286: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
287: BEGIN
288: x_return_status := fnd_api.g_ret_sts_success;
289:
290: IF l_trace_on = 1 THEN
291: print_debug(
292: 'The input parameters are: '

Line 392: x_return_status := fnd_api.g_ret_sts_error;

388: ORDER BY replenishment_line_id;
389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: x_return_status := fnd_api.g_ret_sts_error;
393: END fetch_count_lines;
394:
395: /** This procedure is used to get the Replenishment Count Name if the Subinventory and Organization passed
396: * as input has only one active Replenishment Count.

Line 419: x_return_status := fnd_api.g_ret_sts_success;

415: ) IS
416: l_func_name CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_NAME';
417: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
418: BEGIN
419: x_return_status := fnd_api.g_ret_sts_success;
420:
421: IF l_trace_on = 1 THEN
422: print_debug(
423: 'The input parameters are: '

Line 468: x_return_status := fnd_api.g_ret_sts_error;

464: WHEN TOO_MANY_ROWS THEN
465: x_replenish_count_name := NULL;
466: WHEN OTHERS THEN
467: x_replenish_count_name := NULL;
468: x_return_status := fnd_api.g_ret_sts_error;
469: END get_replenish_count_name;
470:
471:
472:

Line 501: x_return_status := fnd_api.g_ret_sts_success;

497: l_record_exists NUMBER := 0;
498: l_error_record_exists NUMBER := 0;
499: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
500: BEGIN
501: x_return_status := fnd_api.g_ret_sts_success;
502:
503: IF l_trace_on = 1 THEN
504: print_debug(
505: 'The input parameters are: '

Line 537: x_return_status := fnd_api.g_ret_sts_error;

533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_record_exists := 0;
536: WHEN OTHERS THEN
537: x_return_status := fnd_api.g_ret_sts_error;
538: END;
539:
540: BEGIN
541: SELECT 1

Line 627: x_return_status := fnd_api.g_ret_sts_error;

623: EXCEPTION
624: WHEN NO_DATA_FOUND THEN
625: l_error_record_exists := 0;
626: WHEN OTHERS THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: END;
629:
630: IF l_trace_on = 1 THEN
631: print_debug('Error record exists : ' || l_error_record_exists, l_func_name, 9);

Line 671: x_return_status := fnd_api.g_ret_sts_success;

667: l_func_name CONSTANT VARCHAR2(30) := 'IS_COUNT_VALID';
668: l_count_valid NUMBER := 1;
669: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
670: BEGIN
671: x_return_status := fnd_api.g_ret_sts_success;
672:
673: IF l_trace_on = 1 THEN
674: print_debug(
675: 'The input parameters are: '

Line 705: x_return_status := fnd_api.g_ret_sts_error;

701: EXCEPTION
702: WHEN NO_DATA_FOUND THEN
703: RETURN l_count_valid;
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_error;
706: END is_count_valid;
707:
708: /** This procedure submits the passed in Replenishment Count
709: * for processing and Reporting.

Line 728: x_return_status := fnd_api.g_ret_sts_success;

724: ) IS
725: l_proc CONSTANT VARCHAR2(30) := 'PROCESS_REPORT_COUNT';
726: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
727: BEGIN
728: x_return_status := fnd_api.g_ret_sts_success;
729:
730: IF l_trace_on = 1 THEN
731: print_debug(
732: 'The input parameters are: '

Line 748: x_return_status := fnd_api.g_ret_sts_error;

744:
745: x_process_request_id := fnd_request.submit_request('INV', 'INCRPR', '', '', FALSE, TO_CHAR(2), TO_CHAR(p_replenish_header_id),'4', CHR(0));
746:
747: IF x_process_request_id <= 0 THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: ELSE
750: UPDATE mtl_replenish_headers
751: SET process_status = 2
752: WHERE replenishment_header_id = p_replenish_header_id;

Line 754: x_return_status := fnd_api.g_ret_sts_success;

750: UPDATE mtl_replenish_headers
751: SET process_status = 2
752: WHERE replenishment_header_id = p_replenish_header_id;
753:
754: x_return_status := fnd_api.g_ret_sts_success;
755:
756: IF l_trace_on = 1 THEN
757: print_debug('Process Request Id : ' || x_process_request_id, l_proc, 9);
758: END IF;

Line 765: x_return_status := fnd_api.g_ret_sts_error;

761: COMMIT;
762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: x_return_status := fnd_api.g_ret_sts_error;
766: END process_report_count;
767: END inv_replenish_count_pvt;