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.SERIAL_CHECK dependencies on FND_API

Line 41: , p_update_reservation => fnd_api.g_false

37: , hdr_id => hdr_id
38: , temp_id => temp_id
39: , lot_temp_id => lot_temp_id
40: , p_reservation_id => null
41: , p_update_reservation => fnd_api.g_false
42: , success => l_success
43: );
44:
45: IF (l_debug = 1) THEN

Line 73: p_update_reservation VARCHAR2 DEFAULT fnd_api.g_true, /* {{ R12 Enhanced reservations code changes }} */

69: hdr_id NUMBER,
70: temp_id NUMBER,
71: lot_temp_id NUMBER,
72: p_reservation_id NUMBER DEFAULT NULL, /*** {{ R12 Enhanced reservations code changes }} ***/
73: p_update_reservation VARCHAR2 DEFAULT fnd_api.g_true, /*** {{ R12 Enhanced reservations code changes }} ***/
74: success IN OUT NOCOPY NUMBER)
75: IS
76: l_debug NUMBER := 0;
77: /*** {{ R12 Enhanced reservations code changes ***/

Line 78: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

74: success IN OUT NOCOPY NUMBER)
75: IS
76: l_debug NUMBER := 0;
77: /*** {{ R12 Enhanced reservations code changes ***/
78: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
79: l_msg_count NUMBER;
80: l_msg_data VARCHAR2(2000);
81: /*** End R12 }} ***/
82: BEGIN

Line 235: IF (p_update_reservation = fnd_api.g_true and p_reservation_id is not null) THEN

231: end if;
232: end if;
233:
234: /*** {{ R12 Enhanced reservations code changes ***/
235: IF (p_update_reservation = fnd_api.g_true and p_reservation_id is not null) THEN
236: BEGIN
237: update mtl_reservations
238: set serial_reservation_quantity = serial_reservation_quantity + l_update_count
239: where reservation_id = p_reservation_id;

Line 317: , p_update_reservation => fnd_api.g_false

313: , hdr_id => hdr_id
314: , temp_id => temp_id
315: , lot_temp_id => lot_temp_id
316: , p_inventory_item_id => p_inventory_item_id
317: , p_update_reservation => fnd_api.g_false
318: );
319:
320: /*** End R12 }} ***/
321:

Line 338: , p_update_reservation IN VARCHAR2 DEFAULT fnd_api.g_true

334: , hdr_id IN NUMBER
335: , temp_id IN NUMBER DEFAULT NULL
336: , lot_temp_id IN NUMBER DEFAULT NULL
337: , p_inventory_item_id IN NUMBER DEFAULT NULL
338: , p_update_reservation IN VARCHAR2 DEFAULT fnd_api.g_true
339: ) IS /*** {{ R12 Enhanced reservations code changes ***/
340: unmarked_value NUMBER := -1;
341: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
342: /*** {{ R12 Enhanced reservations code changes ***/

Line 343: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

339: ) IS /*** {{ R12 Enhanced reservations code changes ***/
340: unmarked_value NUMBER := -1;
341: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
342: /*** {{ R12 Enhanced reservations code changes ***/
343: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
344: l_msg_count NUMBER;
345: l_msg_data VARCHAR2(2000);
346:
347: TYPE rsv_table IS TABLE OF NUMBER

Line 457: IF (p_update_reservation = fnd_api.g_true) THEN

453: || 'inventory_item_id = ' || p_inventory_item_id, 'SERIAL_CHECK');
454: END IF;
455:
456: /*** {{ R12 Enhanced reservations code changes ***/
457: IF (p_update_reservation = fnd_api.g_true) THEN
458: OPEN serial_rsv1;
459:
460: FETCH serial_rsv1
461: BULK COLLECT

Line 468: IF (p_update_reservation = fnd_api.g_true) THEN

464: CLOSE serial_rsv1;
465: END IF;
466: /*** End R12 }} ***/
467:
468: IF (p_update_reservation = fnd_api.g_true) THEN
469: IF (l_debug = 1) THEN
470: inv_log_util.TRACE('Case 1 and p_update_reservation is T', 'inv_unmark_rsv_serial');
471: END IF;
472: UPDATE mtl_serial_numbers

Line 504: IF (p_update_reservation = fnd_api.g_true) THEN

500: || p_inventory_item_id, 'SERIAL_CHECK');
501: END IF;
502:
503: /*** {{ R12 Enhanced reservations code changes ***/
504: IF (p_update_reservation = fnd_api.g_true) THEN
505: OPEN serial_rsv2;
506: FETCH serial_rsv2
507: BULK COLLECT
508: INTO l_rsv_id_tbl

Line 514: IF (p_update_reservation = fnd_api.g_true) THEN

510: CLOSE serial_rsv2;
511: END IF;
512: /*** End R12 }} ***/
513:
514: IF (p_update_reservation = fnd_api.g_true) THEN
515: IF (l_debug = 1) THEN
516: inv_log_util.TRACE('Case 2 and p_update_reservation it T', 'inv_unmark_rsv_serial');
517: END IF;
518: UPDATE mtl_serial_numbers

Line 560: IF (p_update_reservation = fnd_api.g_true) THEN

556: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number)) ', 'SERIAL_CHECK');
557: END IF;
558:
559: /*** {{ R12 Enhanced reservations code changes ***/
560: IF (p_update_reservation = fnd_api.g_true) THEN
561: OPEN serial_rsv3;
562: FETCH serial_rsv3
563: BULK COLLECT
564: INTO l_rsv_id_tbl

Line 570: IF (p_update_reservation = fnd_api.g_true) THEN

566: CLOSE serial_rsv3;
567: END IF;
568: /*** End R12 }} ***/
569:
570: IF (p_update_reservation = fnd_api.g_true) THEN
571: IF (l_debug = 1) THEN
572: inv_log_util.TRACE('Case 3 and p_update_reservation it T', 'inv_unmark_rsv_serial');
573: END IF;
574: UPDATE mtl_serial_numbers

Line 628: IF (p_update_reservation = fnd_api.g_true) THEN

624: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number))', 'SERIAL_CHECK');
625: END IF;
626:
627: /*** {{ R12 Enhanced reservations code changes ***/
628: IF (p_update_reservation = fnd_api.g_true) THEN
629: OPEN serial_rsv4;
630: FETCH serial_rsv4
631: BULK COLLECT
632: INTO l_rsv_id_tbl

Line 638: IF (p_update_reservation = fnd_api.g_true) THEN

634: CLOSE serial_rsv4;
635: END IF;
636: /*** End R12 }} ***/
637:
638: IF (p_update_reservation = fnd_api.g_true) THEN
639: IF (l_debug = 1) THEN
640: inv_log_util.TRACE('Case 4 and p_update_reservation it T', 'inv_unmark_rsv_serial');
641: END IF;
642: UPDATE mtl_serial_numbers

Line 685: IF (p_update_reservation = fnd_api.g_true) THEN

681: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number))', 'SERIAL_CHECK');
682: END IF;
683:
684: /*** {{ R12 Enhanced reservations code changes ***/
685: IF (p_update_reservation = fnd_api.g_true) THEN
686: OPEN serial_rsv5;
687: FETCH serial_rsv5
688: BULK COLLECT
689: INTO l_rsv_id_tbl

Line 695: IF (p_update_reservation = fnd_api.g_true) THEN

691: CLOSE serial_rsv5;
692: END IF;
693: /*** End R12 }} ***/
694:
695: IF (p_update_reservation = fnd_api.g_true) THEN
696: IF (l_debug = 1) THEN
697: inv_log_util.TRACE('Case 5 and p_update_reservation it T', 'inv_unmark_rsv_serial');
698: END IF;
699: UPDATE mtl_serial_numbers

Line 732: IF (p_update_reservation = fnd_api.g_true) THEN

728: END IF; --END IF lote_temp_id IS NOT NULL
729: END IF; -- inventory_item_id is null
730:
731: /*** {{ R12 Enhanced reservations code changes ***/
732: IF (p_update_reservation = fnd_api.g_true) THEN
733: FOR i IN 1 .. l_rsv_id_tbl.COUNT LOOP
734: l_update_count := l_rsv_count_tbl(i) * -1;
735: BEGIN
736: UPDATE mtl_reservations