APPS.GL_JE_CATEGORIES_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

49:
50: IF c_dup%FOUND THEN
51: CLOSE c_dup;
52: fnd_message.set_name( 'SQLGL', 'GL_DUPLICATE_JE_CATEGORY' );
53: app_exception.raise_exception;
54: END IF;
55:
56: CLOSE c_dup;
57:

Line 59: WHEN app_exceptions.application_exception THEN

55:
56: CLOSE c_dup;
57:
58: EXCEPTION
59: WHEN app_exceptions.application_exception THEN
60: RAISE;
61: WHEN OTHERS THEN
62: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
63: fnd_message.set_token('PROCEDURE',

Line 88: app_exception.raise_exception;

84:
85: IF c_dup%FOUND THEN
86: CLOSE c_dup;
87: fnd_message.set_name( 'SQLGL', 'GL_DUPLICATE_JE_CATEGORY_KEY' );
88: app_exception.raise_exception;
89: END IF;
90:
91: CLOSE c_dup;
92:

Line 94: WHEN app_exceptions.application_exception THEN

90:
91: CLOSE c_dup;
92:
93: EXCEPTION
94: WHEN app_exceptions.application_exception THEN
95: RAISE;
96: WHEN OTHERS THEN
97: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
98: fnd_message.set_token('PROCEDURE',

Line 123: app_exception.raise_exception;

119: ELSE
120: CLOSE c_getid;
121: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');
123: app_exception.raise_exception;
124: END IF;
125:
126: EXCEPTION
127: WHEN app_exceptions.application_exception THEN

Line 127: WHEN app_exceptions.application_exception THEN

123: app_exception.raise_exception;
124: END IF;
125:
126: EXCEPTION
127: WHEN app_exceptions.application_exception THEN
128: RAISE;
129: WHEN OTHERS THEN
130: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
131: fnd_message.set_token('PROCEDURE',

Line 172: WHEN app_exceptions.application_exception THEN

168:
169: CLOSE c_dup;
170:
171: EXCEPTION
172: WHEN app_exceptions.application_exception THEN
173: RAISE;
174: WHEN OTHERS THEN
175: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
176: fnd_message.set_token('PROCEDURE',

Line 212: WHEN app_exceptions.application_exception THEN

208:
209: CLOSE c_dup;
210:
211: EXCEPTION
212: WHEN app_exceptions.application_exception THEN
213: RAISE;
214: WHEN OTHERS THEN
215: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
216: fnd_message.set_token('PROCEDURE',

Line 252: WHEN app_exceptions.application_exception THEN

248: AND ( gcat2.user_je_category_name <> fcat2.name
249: or gcat2.description <> fcat2.description ) );
250:
251: EXCEPTION
252: WHEN app_exceptions.application_exception THEN
253: RAISE;
254: WHEN OTHERS THEN
255: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
256: fnd_message.set_token('PROCEDURE',

Line 332: -- app_exception.raise_exception;

328: and Language = userenv('LANG');
329: BEGIN
330:
331: if (X_Je_Category_Name is NULL) then
332: -- app_exception.raise_exception;
333: RAISE NO_DATA_FOUND;
334: end if;
335:
336: -- update previously existing columns

Line 432: APP_EXCEPTION.RAISE_EXCEPTION;

428: FETCH C INTO Recinfo;
429: if (C%NOTFOUND) then
430: CLOSE C;
431: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
432: APP_EXCEPTION.RAISE_EXCEPTION;
433: end if;
434: CLOSE C;
435: if (
436: ( ( (Recinfo.je_category_name = X_je_category_name)

Line 482: APP_EXCEPTION.RAISE_EXCEPTION;

478: AND (UPPER(X_consolidation_flag) IS NULL))))) THEN
479: return;
480: ELSE
481: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
482: APP_EXCEPTION.RAISE_EXCEPTION;
483: end if;
484: END Lock_Row;
485:
486: -- ************************************************************************

Line 566: app_exception.raise_exception;

562:
563: -- validate input parameters
564: if ( X_User_Je_Category_Name is NULL ) then
565: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
566: app_exception.raise_exception;
567: end if;
568:
569: if (X_OWNER = 'SEED') then
570: user_id := 1;