64: CLOSE get_acct_seg;
65: RETURN(segname);
66: ELSE
67: CLOSE get_acct_seg;
68: fnd_message.set_name('SQLGL', 'GL_MISSING_ACCOUNT_SEGMENT');
69: app_exception.raise_exception;
70: END IF;
71:
72: EXCEPTION
72: EXCEPTION
73: WHEN app_exceptions.application_exception THEN
74: RAISE;
75: WHEN OTHERS THEN
76: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
77: fnd_message.set_token('PROCEDURE',
78: 'gl_flexfields_pkg.get_account_segment');
79: RAISE;
80: END get_account_segment;
73: WHEN app_exceptions.application_exception THEN
74: RAISE;
75: WHEN OTHERS THEN
76: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
77: fnd_message.set_token('PROCEDURE',
78: 'gl_flexfields_pkg.get_account_segment');
79: RAISE;
80: END get_account_segment;
81: