35: CLOSE get_new_id;
36: return(new_id);
37: ELSE
38: CLOSE get_new_id;
39: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');
41: app_exception.raise_exception;
42: END IF;
43:
36: return(new_id);
37: ELSE
38: CLOSE get_new_id;
39: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');
41: app_exception.raise_exception;
42: END IF;
43:
44: EXCEPTION
46: WHEN app_exceptions.application_exception THEN
47: RAISE;
48:
49: WHEN OTHERS THEN
50: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
51: fnd_message.set_token(
52: 'PROCEDURE',
53: 'gl_elimination_sets_pkg.get_unique_id');
54: RAISE;
47: RAISE;
48:
49: WHEN OTHERS THEN
50: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
51: fnd_message.set_token(
52: 'PROCEDURE',
53: 'gl_elimination_sets_pkg.get_unique_id');
54: RAISE;
55: END get_unique_id;
136: FETCH name_count INTO counter;
137:
138: IF name_count%FOUND THEN
139: CLOSE name_count;
140: FND_MESSAGE.set_name('SQLGL', 'GL_DUPLICATE_NAME');
141: APP_EXCEPTION.raise_exception;
142:
143: ELSE
144: CLOSE name_count;
147: EXCEPTION
148: WHEN app_exceptions.application_exception THEN
149: RAISE;
150: WHEN OTHERS THEN
151: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
152: fnd_message.set_token(
153: 'PROCEDURE',
154: 'gl_elimination_sets_pkg.check_unique_name');
155: RAISE;
148: WHEN app_exceptions.application_exception THEN
149: RAISE;
150: WHEN OTHERS THEN
151: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
152: fnd_message.set_token(
153: 'PROCEDURE',
154: 'gl_elimination_sets_pkg.check_unique_name');
155: RAISE;
156: END check_unique_name;
199: EXCEPTION
200: WHEN app_exceptions.application_exception THEN
201: RAISE;
202: WHEN OTHERS THEN
203: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
204: fnd_message.set_token(
205: 'PROCEDURE',
206: 'gl_elimination_sets_pkg.allow_delete_record');
207: RAISE;
200: WHEN app_exceptions.application_exception THEN
201: RAISE;
202: WHEN OTHERS THEN
203: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
204: fnd_message.set_token(
205: 'PROCEDURE',
206: 'gl_elimination_sets_pkg.allow_delete_record');
207: RAISE;
208: END allow_delete_record;
284: OPEN C;
285: FETCH C INTO recinfo;
286: IF (C%NOTFOUND) THEN
287: CLOSE C;
288: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
289: app_exception.raise_exception;
290: END IF;
291: CLOSE C;
292:
382: AND (x_attribute15 is null)))
383: ) THEN
384: return;
385: ELSE
386: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
387: app_exception.raise_exception;
388: END IF;
389:
390: END lock_row;