47:
48: IF chk_duplicates%FOUND THEN
49: CLOSE chk_duplicates;
50: IF (x_group_id IS NULL) THEN
51: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JI_SOURCE');
52: ELSE
53: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JI_SOURCE_COMBO');
54: END IF;
55: app_exception.raise_exception;
49: CLOSE chk_duplicates;
50: IF (x_group_id IS NULL) THEN
51: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JI_SOURCE');
52: ELSE
53: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JI_SOURCE_COMBO');
54: END IF;
55: app_exception.raise_exception;
56: END IF;
57:
60: EXCEPTION
61: WHEN app_exceptions.application_exception THEN
62: RAISE;
63: WHEN OTHERS THEN
64: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
65: fnd_message.set_token('PROCEDURE',
66: 'gl_interface_pkg.check_unique');
67: RAISE;
68: END check_unique;
61: WHEN app_exceptions.application_exception THEN
62: RAISE;
63: WHEN OTHERS THEN
64: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
65: fnd_message.set_token('PROCEDURE',
66: 'gl_interface_pkg.check_unique');
67: RAISE;
68: END check_unique;
69:
96: EXCEPTION
97: WHEN app_exceptions.application_exception THEN
98: RAISE;
99: WHEN OTHERS THEN
100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
101: fnd_message.set_token('PROCEDURE',
102: 'gl_interface_control_pkg.used_in_alternate_table');
103: RAISE;
104: END used_in_alternate_table;
97: WHEN app_exceptions.application_exception THEN
98: RAISE;
99: WHEN OTHERS THEN
100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
101: fnd_message.set_token('PROCEDURE',
102: 'gl_interface_control_pkg.used_in_alternate_table');
103: RAISE;
104: END used_in_alternate_table;
105:
133: EXCEPTION
134: WHEN app_exceptions.application_exception THEN
135: RAISE;
136: WHEN OTHERS THEN
137: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
138: fnd_message.set_token('PROCEDURE',
139: 'gl_interface_control_pkg.get_interface_table');
140: RAISE;
141: END get_interface_table;
134: WHEN app_exceptions.application_exception THEN
135: RAISE;
136: WHEN OTHERS THEN
137: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
138: fnd_message.set_token('PROCEDURE',
139: 'gl_interface_control_pkg.get_interface_table');
140: RAISE;
141: END get_interface_table;
142: