DBA Data[Home] [Help]

APPS.GL_BUDGETS_PKG dependencies on FND_MESSAGE

Line 51: fnd_message.set_name('SQLGL',

47: FETCH chk_details INTO dummy;
48:
49: IF chk_details%FOUND THEN
50: CLOSE chk_details;
51: fnd_message.set_name('SQLGL',
52: 'GL_BUD_NOT_W_MASTER_DETAIL');
53: app_exception.raise_exception;
54: ELSE
55: CLOSE chk_details;

Line 104: fnd_message.set_name('SQLGL', 'GL_BUD_MASTER_CHANGED');

100: IF lock_master%FOUND THEN
101: CLOSE lock_master;
102: ELSE
103: CLOSE lock_master;
104: fnd_message.set_name('SQLGL', 'GL_BUD_MASTER_CHANGED');
105: app_exception.raise_exception;
106: END IF;
107: END lock_master_budget;
108:

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

126: FETCH chk_duplicates INTO dummy;
127:
128: IF chk_duplicates%FOUND THEN
129: CLOSE chk_duplicates;
130: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_BUDGET_NAME');
131: app_exception.raise_exception;
132: END IF;
133:
134: CLOSE chk_duplicates;

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

136: EXCEPTION
137: WHEN app_exceptions.application_exception THEN
138: RAISE;
139: WHEN OTHERS THEN
140: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
141: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.check_unique');
142: RAISE;
143: END check_unique;
144:

Line 141: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.check_unique');

137: WHEN app_exceptions.application_exception THEN
138: RAISE;
139: WHEN OTHERS THEN
140: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
141: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.check_unique');
142: RAISE;
143: END check_unique;
144:
145: FUNCTION get_unique_id RETURN NUMBER IS

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

155: CLOSE get_new_id;
156: return(new_id);
157: ELSE
158: CLOSE get_new_id;
159: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
160: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_VERSIONS_S');
161: app_exception.raise_exception;
162: END IF;
163:

Line 160: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_VERSIONS_S');

156: return(new_id);
157: ELSE
158: CLOSE get_new_id;
159: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
160: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_VERSIONS_S');
161: app_exception.raise_exception;
162: END IF;
163:
164: EXCEPTION

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

164: EXCEPTION
165: WHEN app_exceptions.application_exception THEN
166: RAISE;
167: WHEN OTHERS THEN
168: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
169: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.get_unique_id');
170: RAISE;
171: END get_unique_id;
172:

Line 169: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.get_unique_id');

165: WHEN app_exceptions.application_exception THEN
166: RAISE;
167: WHEN OTHERS THEN
168: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
169: fnd_message.set_token('PROCEDURE', 'gl_budgets_pkg.get_unique_id');
170: RAISE;
171: END get_unique_id;
172:
173:

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

198: EXCEPTION
199: WHEN app_exceptions.application_exception THEN
200: RAISE;
201: WHEN OTHERS THEN
202: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
203: fnd_message.set_token('PROCEDURE',
204: 'GL_BUDGET_ASGM_RNG_PKG.is_budget_journals_not_req');
205: RAISE;
206:

Line 203: fnd_message.set_token('PROCEDURE',

199: WHEN app_exceptions.application_exception THEN
200: RAISE;
201: WHEN OTHERS THEN
202: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
203: fnd_message.set_token('PROCEDURE',
204: 'GL_BUDGET_ASGM_RNG_PKG.is_budget_journals_not_req');
205: RAISE;
206:
207: END is_budget_journals_not_req;

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

219: RETURN;
220: WHEN app_exceptions.application_exception THEN
221: RAISE;
222: WHEN OTHERS THEN
223: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
224: fnd_message.set_token('PROCEDURE',
225: 'gl_budgets.select_row');
226: RAISE;
227: END select_row;

Line 224: fnd_message.set_token('PROCEDURE',

220: WHEN app_exceptions.application_exception THEN
221: RAISE;
222: WHEN OTHERS THEN
223: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
224: fnd_message.set_token('PROCEDURE',
225: 'gl_budgets.select_row');
226: RAISE;
227: END select_row;
228:

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

255: RETURN;
256: WHEN app_exceptions.application_exception THEN
257: RAISE;
258: WHEN OTHERS THEN
259: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
260: fnd_message.set_token('PROCEDURE',
261: 'gl_budgets.select_columns');
262: RAISE;
263: END select_columns;

Line 260: fnd_message.set_token('PROCEDURE',

256: WHEN app_exceptions.application_exception THEN
257: RAISE;
258: WHEN OTHERS THEN
259: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
260: fnd_message.set_token('PROCEDURE',
261: 'gl_budgets.select_columns');
262: RAISE;
263: END select_columns;
264:

Line 314: fnd_message.set_name('SQLGL', 'GL_BUD_MULTIPLE_CURRENT_BUDGET');

310: bj_required);
311:
312: IF ( (bvid IS NOT NULL)
313: AND (bvid <> X_Budget_Version_Id)) THEN
314: fnd_message.set_name('SQLGL', 'GL_BUD_MULTIPLE_CURRENT_BUDGET');
315: app_exception.raise_exception;
316:
317: END IF;
318: END;

Line 458: FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');

454: OPEN C;
455: FETCH C INTO Recinfo;
456: if (C%NOTFOUND) then
457: CLOSE C;
458: FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');
459: app_exception.raise_exception;
460: end if;
461: CLOSE C;
462:

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

542: AND (X_Context IS NULL)))
543: ) then
544: return;
545: else
546: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: end if;
549: END Lock_Row;
550:

Line 598: fnd_message.set_name('SQLGL', 'GL_BUD_MULTIPLE_CURRENT_BUDGET');

594: bj_required);
595:
596: IF ( (bvid IS NOT NULL)
597: AND (bvid <> X_Budget_Version_Id)) THEN
598: fnd_message.set_name('SQLGL', 'GL_BUD_MULTIPLE_CURRENT_BUDGET');
599: app_exception.raise_exception;
600:
601: END IF;
602: END;

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

659: exception
660: WHEN app_exceptions.application_exception THEN
661: RAISE;
662: WHEN OTHERS THEN
663: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
664: fnd_message.set_token('PROCEDURE',
665: 'gl_budgets_pkg.update_row');
666: RAISE;
667:

Line 664: fnd_message.set_token('PROCEDURE',

660: WHEN app_exceptions.application_exception THEN
661: RAISE;
662: WHEN OTHERS THEN
663: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
664: fnd_message.set_token('PROCEDURE',
665: 'gl_budgets_pkg.update_row');
666: RAISE;
667:
668: END Update_Row;