APPS.SERIAL_CHECK dependencies on APP_EXCEPTIONS

Line 251: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION then

247: END;
248: END IF;
249: /*** End R12 }} ***/
250: EXCEPTION
251: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION then
252: IF success = 1 then
253: CLOSE serial_lock1;
254: else
255: CLOSE serial_lock2;

Line 260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');

256: end if;
257: success := -2;
258: if( l_debug = 1 ) then
259: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');
261: end if;
262: WHEN OTHERS then
263: IF success = 1 then
264: CLOSE serial_lock1;

Line 797: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

793: WHERE inventory_item_id = item_id
794: AND current_organization_id = org_id
795: AND serial_number = from_serial_number ;
796: EXCEPTION
797: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
798: success := FALSE;
799: IF (l_debug = 1) THEN
800: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
801: END IF;

Line 800: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

796: EXCEPTION
797: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
798: success := FALSE;
799: IF (l_debug = 1) THEN
800: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
801: END IF;
802: END;
803:
804: success := TRUE;

Line 819: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

815: AND current_organization_id = org_id
816: AND serial_number between from_serial_number AND to_serial_number
817: AND LENGTH(serial_number) = LENGTH(from_serial_number) ;
818: EXCEPTION
819: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
820: success := FALSE;
821: IF (l_debug = 1) THEN
822: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
823: END IF;

Line 822: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

818: EXCEPTION
819: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
820: success := FALSE;
821: IF (l_debug = 1) THEN
822: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
823: END IF;
824: END;
825:
826: success := TRUE;