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
73: WHEN app_exceptions.application_exception THEN
69: app_exception.raise_exception;
70: END IF;
71:
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',
97: structure_number => x_coa_id,
98: flex_qual_name => x_qual_text,
99: segment_number => seg_num)
100: ) THEN
101: app_exception.raise_exception;
102: END IF;
103:
104: last_coa_id := x_coa_id;
105: last_qual_text := x_qual_text;
242: END LOOP;
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: app_exception.raise_exception;
247: END get_coa_info;
248:
249:
250: FUNCTION get_sd_description_sql (