[Home] [Help]
152:
153: PROCEDURE Get_New_Id(next_val IN OUT NOCOPY NUMBER) IS
154:
155: BEGIN
156: select GL_CONS_FLEXFIELD_MAP_S.NEXTVAL
157: into next_val
158: from dual;
159:
160: IF (next_val is NULL) THEN
158: from dual;
159:
160: IF (next_val is NULL) THEN
161: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
162: fnd_message.set_token('TAB_S', 'GL_CONS_FLEXFIELD_MAP_S');
163: app_exception.raise_exception;
164: END IF;
165: END Get_New_Id;
166: