[Home] [Help]
38: fnd_message.set_token('SEQUENCE', 'GL_MOVEMERGE_REQUESTS_S');
39: app_exception.raise_exception;
40: END IF;
41: EXCEPTION
42: WHEN app_exceptions.application_exception THEN
43: RAISE;
44: WHEN OTHERS THEN
45: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
46: fnd_message.set_token(
70: ELSE
71: CLOSE count_rows;
72: END IF;
73: EXCEPTION
74: WHEN app_exceptions.application_exception THEN
75: RAISE;
76: WHEN OTHERS THEN
77: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
78: fnd_message.set_token('PROCEDURE', 'gl_mmwkb_pkg.must_have_accounts');
84: BEGIN
85: DELETE FROM gl_movemerge_accounts
86: WHERE movemerge_request_id = mm_id;
87: EXCEPTION
88: WHEN app_exceptions.application_exception THEN
89: RAISE;
90: WHEN OTHERS THEN
91: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
92: fnd_message.set_token(
143: CLOSE name_count_old_row;
144: END IF;
145: END IF;
146: EXCEPTION
147: WHEN app_exceptions.application_exception THEN
148: RAISE;
149: WHEN OTHERS THEN
150: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
151: fnd_message.set_token(
221: END LOOP;
222: CLOSE ledger_id_cur;
223:
224: EXCEPTION
225: WHEN app_exceptions.application_exception THEN
226: RAISE;
227: WHEN OTHERS THEN
228: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
229: fnd_message.set_token(
266: mm_ledger_id := ledgerid;
267: END IF;
268:
269: EXCEPTION
270: WHEN app_exceptions.application_exception THEN
271: RAISE;
272: WHEN OTHERS THEN
273: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
274: fnd_message.set_token(