DBA Data[Home] [Help]

APPS.GL_JE_SOURCES_PKG dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_NAME');

55: OPEN chk_duplicates_name;
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

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

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');
69: RAISE;
70: END check_unique_name;
71:

Line 68: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.check_unique_name');

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');
69: RAISE;
70: END check_unique_name;
71:
72: PROCEDURE check_unique_user_name(x_user_je_source_name VARCHAR2,

Line 86: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_NAME');

82: OPEN chk_duplicates_user_name;
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:

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

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',
97: 'gl_je_sources_pkg.check_unique_user_name');
98: RAISE;
99: END check_unique_user_name;

Line 96: fnd_message.set_token('PROCEDURE',

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',
97: 'gl_je_sources_pkg.check_unique_user_name');
98: RAISE;
99: END check_unique_user_name;
100:

Line 115: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_SOURCE_KEY');

111: OPEN chk_duplicates_key;
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:

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

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',
126: 'gl_je_sources_pkg.check_unique_key');
127: RAISE;
128: END check_unique_key;

Line 125: fnd_message.set_token('PROCEDURE',

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',
126: 'gl_je_sources_pkg.check_unique_key');
127: RAISE;
128: END check_unique_key;
129:

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

140: CLOSE get_new_id;
141: return(new_id);
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:

Line 145: fnd_message.set_token('SEQUENCE', 'GL_JE_SOURCES_S');

141: return(new_id);
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

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

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');
155: RAISE;
156: END get_unique_id;
157:

Line 154: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.get_unique_id');

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');
155: RAISE;
156: END get_unique_id;
157:
158: FUNCTION is_sla_source( X_je_source VARCHAR2) RETURN BOOLEAN IS

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

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

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

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

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

474: or X_User_Je_Source_Name is NULL
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