26:
27: CLOSE chk_duplicates;
28:
29: EXCEPTION
30: WHEN app_exceptions.application_exception THEN
31: RAISE;
32: WHEN OTHERS THEN
33: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
34: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.check_unique');
54: app_exception.raise_exception;
55: END IF;
56:
57: EXCEPTION
58: WHEN app_exceptions.application_exception THEN
59: RAISE;
60: WHEN OTHERS THEN
61: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
62: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.get_unique_id');
412: );
413:
414:
415: EXCEPTION
416: WHEN app_exceptions.application_exception THEN
417: RAISE;
418: WHEN OTHERS THEN
419: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
420: fnd_message.set_token('PROCEDURE',