[Home] [Help]
44: END check_unique;
45:
46: FUNCTION get_unique_id RETURN NUMBER IS
47: CURSOR get_new_id IS
48: SELECT gl_je_batches_s.NEXTVAL
49: FROM dual;
50: new_id number;
51: BEGIN
52: OPEN get_new_id;
57: return(new_id);
58: ELSE
59: CLOSE get_new_id;
60: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
61: fnd_message.set_token('SEQUENCE', 'GL_JE_BATCHES_S');
62: app_exception.raise_exception;
63: END IF;
64:
65: EXCEPTION