APPS.SERIAL_CHECK dependencies on MTL_RESERVATIONS

Line 237: update mtl_reservations

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;
240:
241: EXCEPTION

Line 244: inv_log_util.trace('Error updating serial_reservation_quantity in mtl_reservations', 'INV_MARK_SERIAL');

240:
241: EXCEPTION
242: WHEN others THEN
243: IF (l_debug = 1) THEN
244: inv_log_util.trace('Error updating serial_reservation_quantity in mtl_reservations', 'INV_MARK_SERIAL');
245: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'INV_MARK_SERIAL');
246: END IF;
247: END;
248: END IF;

Line 752: UPDATE mtl_reservations

748: IF (p_update_reservation = fnd_api.g_true) THEN
749: FOR i IN 1 .. l_rsv_id_tbl.COUNT LOOP
750: l_update_count := l_rsv_count_tbl(i) * -1;
751: BEGIN
752: UPDATE mtl_reservations
753: SET serial_reservation_quantity = serial_reservation_quantity + l_update_count
754: WHERE reservation_id = l_rsv_id_tbl(i);
755: EXCEPTION
756: WHEN OTHERS THEN

Line 758: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');

754: WHERE reservation_id = l_rsv_id_tbl(i);
755: EXCEPTION
756: WHEN OTHERS THEN
757: IF (l_debug = 1) THEN
758: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');
759: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');
760: END IF;
761: END;
762: END LOOP;