32:
33: EXCEPTION
34: WHEN NO_DATA_FOUND THEN
35: RETURN;
36: WHEN app_exceptions.application_exception THEN
37: RAISE;
38: WHEN OTHERS THEN
39: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
40: fnd_message.set_token(
59: WHERE chart_of_accounts_id = x_chart_of_accounts_id
60: AND event_code = x_event_code;
61:
62: EXCEPTION
63: WHEN app_exceptions.application_exception THEN
64: RAISE;
65: WHEN OTHERS THEN
66: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
67: fnd_message.set_token(
87:
88: IF NOT lock_stamp%FOUND THEN
89: CLOSE lock_stamp;
90: fnd_message.set_name('SQLGL', 'GL_BC_CANNOT_LOCK_STAMP');
91: app_exception.raise_exception;
92: END IF;
93:
94: EXCEPTION
95: WHEN app_exceptions.application_exception THEN
91: app_exception.raise_exception;
92: END IF;
93:
94: EXCEPTION
95: WHEN app_exceptions.application_exception THEN
96: RAISE;
97: WHEN OTHERS THEN
98: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
99: fnd_message.set_token(