APPS.GL_JE_CATEGORIES_PKG dependencies on FND_MESSAGE

Line 52: fnd_message.set_name( 'SQLGL', 'GL_DUPLICATE_JE_CATEGORY' );

48: FETCH c_dup INTO dummy;
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;

Line 62: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
64: 'GL_JE_CATEGORIES_PKG.check_unique');
65: RAISE;
66:

Line 63: fnd_message.set_token('PROCEDURE',

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',
64: 'GL_JE_CATEGORIES_PKG.check_unique');
65: RAISE;
66:
67: END check_unique;

Line 87: fnd_message.set_name( 'SQLGL', 'GL_DUPLICATE_JE_CATEGORY_KEY' );

83: FETCH c_dup INTO dummy;
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;

Line 97: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
99: 'GL_JE_CATEGORIES_PKG.check_unique_key');
100: RAISE;
101:

Line 98: fnd_message.set_token('PROCEDURE',

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',
99: 'GL_JE_CATEGORIES_PKG.check_unique_key');
100: RAISE;
101:
102: END check_unique_key;

Line 121: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

117: CLOSE c_getid;
118: RETURN( id );
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:

Line 122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');

118: RETURN( id );
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

Line 130: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
132: 'GL_JE_CATEGORIES_PKG.get_unique_id');
133: RAISE;
134:

Line 131: fnd_message.set_token('PROCEDURE',

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',
132: 'GL_JE_CATEGORIES_PKG.get_unique_id');
133: RAISE;
134:
135: END get_unique_id;

Line 175: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
177: 'GL_JE_CATEGORIES_PKG.insert_fnd_cat');
178: RAISE;
179:

Line 176: fnd_message.set_token('PROCEDURE',

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',
177: 'GL_JE_CATEGORIES_PKG.insert_fnd_cat');
178: RAISE;
179:
180: END insert_fnd_cat;

Line 215: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
217: 'GL_JE_CATEGORIES_PKG.update_fnd_cat');
218: RAISE;
219:

Line 216: fnd_message.set_token('PROCEDURE',

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',
217: 'GL_JE_CATEGORIES_PKG.update_fnd_cat');
218: RAISE;
219:
220: END update_fnd_cat;

Line 255: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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',
257: 'GL_JE_CATEGORIES_PKG.update_fnd_cat_all');
258: RAISE;
259:

Line 256: fnd_message.set_token('PROCEDURE',

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',
257: 'GL_JE_CATEGORIES_PKG.update_fnd_cat_all');
258: RAISE;
259:
260: END update_fnd_cat_all;

Line 431: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

427: OPEN C;
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 (

Line 481: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

477: OR ( (Recinfo.consolidation_flag IS NULL)
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:

Line 565: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');

561: BEGIN
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