12: END get_access_set_id;
13:
14: FUNCTION get_unique_id RETURN NUMBER IS
15: CURSOR get_new_id IS
16: SELECT gl_je_posting_s.NEXTVAL
17: FROM dual;
18: new_id number;
19: BEGIN
20: OPEN get_new_id;
24: return(new_id);
25: ELSE
26: CLOSE get_new_id;
27: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
28: fnd_message.set_token('SEQUENCE', 'GL_JE_POSTING_S');
29: app_exception.raise_exception;
30: END IF;
31: EXCEPTION
32: WHEN app_exceptions.application_exception THEN