APPS.GL_JE_SOURCES_PKG dependencies on APP_EXCEPTION

Line 60: app_exception.raise_exception;

56: FETCH chk_duplicates_name INTO dummy;
57: IF chk_duplicates_name%FOUND THEN
58: CLOSE chk_duplicates_name;
59: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_NAME');
60: app_exception.raise_exception;
61: END IF;
62: CLOSE chk_duplicates_name;
63: EXCEPTION
64: WHEN app_exceptions.application_exception THEN

Line 64: WHEN app_exceptions.application_exception THEN

60: app_exception.raise_exception;
61: END IF;
62: CLOSE chk_duplicates_name;
63: EXCEPTION
64: WHEN app_exceptions.application_exception THEN
65: RAISE;
66: WHEN OTHERS THEN
67: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
68: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.check_unique_name');

Line 87: app_exception.raise_exception;

83: FETCH chk_duplicates_user_name INTO dummy;
84: IF chk_duplicates_user_name%FOUND THEN
85: CLOSE chk_duplicates_user_name;
86: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_NAME');
87: app_exception.raise_exception;
88: END IF;
89: CLOSE chk_duplicates_user_name;
90:
91: EXCEPTION

Line 92: WHEN app_exceptions.application_exception THEN

88: END IF;
89: CLOSE chk_duplicates_user_name;
90:
91: EXCEPTION
92: WHEN app_exceptions.application_exception THEN
93: RAISE;
94: WHEN OTHERS THEN
95: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
96: fnd_message.set_token('PROCEDURE',

Line 116: app_exception.raise_exception;

112: FETCH chk_duplicates_key INTO dummy;
113: IF chk_duplicates_key%FOUND THEN
114: CLOSE chk_duplicates_key;
115: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_KEY');
116: app_exception.raise_exception;
117: END IF;
118: CLOSE chk_duplicates_key;
119:
120: EXCEPTION

Line 121: WHEN app_exceptions.application_exception THEN

117: END IF;
118: CLOSE chk_duplicates_key;
119:
120: EXCEPTION
121: WHEN app_exceptions.application_exception THEN
122: RAISE;
123: WHEN OTHERS THEN
124: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
125: fnd_message.set_token('PROCEDURE',

Line 146: app_exception.raise_exception;

142: ELSE
143: CLOSE get_new_id;
144: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
145: fnd_message.set_token('SEQUENCE', 'GL_JE_SOURCES_S');
146: app_exception.raise_exception;
147: END IF;
148:
149: EXCEPTION
150: WHEN app_exceptions.application_exception THEN

Line 150: WHEN app_exceptions.application_exception THEN

146: app_exception.raise_exception;
147: END IF;
148:
149: EXCEPTION
150: WHEN app_exceptions.application_exception THEN
151: RAISE;
152: WHEN OTHERS THEN
153: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
154: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.get_unique_id');

Line 305: APP_EXCEPTION.RAISE_EXCEPTION;

301: FETCH C INTO Recinfo;
302: if (C%NOTFOUND) then
303: CLOSE C;
304: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
305: APP_EXCEPTION.RAISE_EXCEPTION;
306: end if;
307: CLOSE C;
308: if (
309: ( ( (Recinfo.je_source_name = X_je_source_name)

Line 371: APP_EXCEPTION.RAISE_EXCEPTION;

367: AND (X_context IS NULL))))) THEN
368: return;
369: ELSE
370: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
371: APP_EXCEPTION.RAISE_EXCEPTION;
372: end if;
373: END Lock_Row;
374:
375:

Line 479: app_exception.raise_exception;

475: or X_Journal_Reference_Flag is NULL
476: or X_Effective_Date_Rule_Code is NULL
477: or X_Journal_Approval_Flag is NULL) then
478: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
479: app_exception.raise_exception;
480: end if;
481:
482: if (X_OWNER = 'SEED') then
483: user_id := 1;