[Home] [Help]
23:
24: CLOSE chk_duplicates;
25:
26: EXCEPTION
27: WHEN app_exceptions.application_exception THEN
28: RAISE;
29: WHEN OTHERS THEN
30: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
31: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.check_unique');
51: app_exception.raise_exception;
52: END IF;
53:
54: EXCEPTION
55: WHEN app_exceptions.application_exception THEN
56: RAISE;
57: WHEN OTHERS THEN
58: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
59: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.get_unique_id');
115: WHERE je_batch_id = batch_id;
116:
117:
118: EXCEPTION
119: WHEN app_exceptions.application_exception THEN
120: RAISE;
121: WHEN OTHERS THEN
122: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
123: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');
154: and ps.period_name = jeh.accrual_rev_period_name)
155: WHERE je_batch_id = batch_id;
156:
157: EXCEPTION
158: WHEN app_exceptions.application_exception THEN
159: RAISE;
160: WHEN OTHERS THEN
161: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
162: fnd_message.set_token('PROCEDURE',