DBA Data[Home] [Help]

APPS.GL_ALLOC_FORMULAS_PKG dependencies on APP_EXCEPTION

Line 32: app_exception.raise_exception;

28: IF (counts = 2) THEN
29: -- target and offset ledgers are both not null and are different
30: CLOSE to_ledger_selection;
31: fnd_message.set_name('SQLGL', 'GL_ALLOC_INTER_LEDGER');
32: app_exception.raise_exception;
33: END IF;
34: CLOSE to_ledger_selection;
35: EXCEPTION
36: WHEN app_exceptions.application_exception THEN

Line 36: WHEN app_exceptions.application_exception THEN

32: app_exception.raise_exception;
33: END IF;
34: CLOSE to_ledger_selection;
35: EXCEPTION
36: WHEN app_exceptions.application_exception THEN
37: RAISE;
38: END check_ledger_selection;
39:
40: --

Line 61: app_exception.raise_exception;

57:
58: IF chk_duplicates%FOUND THEN
59: CLOSE chk_duplicates;
60: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_ALLOC_FORMULA_NAM');
61: app_exception.raise_exception;
62: END IF;
63:
64: CLOSE chk_duplicates;
65:

Line 67: WHEN app_exceptions.application_exception THEN

63:
64: CLOSE chk_duplicates;
65:
66: EXCEPTION
67: WHEN app_exceptions.application_exception THEN
68: RAISE;
69: WHEN OTHERS THEN
70: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
71: fnd_message.set_token('PROCEDURE', 'gl_alloc_formulas_pkg.check_unique');

Line 92: app_exception.raise_exception;

88: ELSE
89: CLOSE get_new_id;
90: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
91: fnd_message.set_token('SEQUENCE', 'GL_ALLOC_FORMULAS_S');
92: app_exception.raise_exception;
93: END IF;
94:
95: EXCEPTION
96: WHEN app_exceptions.application_exception THEN

Line 96: WHEN app_exceptions.application_exception THEN

92: app_exception.raise_exception;
93: END IF;
94:
95: EXCEPTION
96: WHEN app_exceptions.application_exception THEN
97: RAISE;
98: WHEN OTHERS THEN
99: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
100: fnd_message.set_token('PROCEDURE',

Line 156: app_exception.raise_exception;

152: X_allocation_formula_id,
153: X_actual_flag)) THEN
154: IF (X_actual_flag = 'B') THEN
155: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');
156: app_exception.raise_exception;
157: ELSE
158: fnd_message.set_name('SQLGL', 'GL_COMPLETE_ALL_FORMULA_LINES');
159: app_exception.raise_exception;
160: END IF;

Line 159: app_exception.raise_exception;

155: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');
156: app_exception.raise_exception;
157: ELSE
158: fnd_message.set_name('SQLGL', 'GL_COMPLETE_ALL_FORMULA_LINES');
159: app_exception.raise_exception;
160: END IF;
161: END IF;
162:
163: -- Make sure the ledger segment of target and offset lines are the same

Line 236: APP_EXCEPTION.RAISE_EXCEPTION;

232: FETCH C INTO Recinfo;
233: if (C%NOTFOUND) then
234: CLOSE C;
235: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: end if;
238: CLOSE C;
239: if (
240: ( (Recinfo.allocation_formula_id = X_Allocation_Formula_Id)

Line 274: APP_EXCEPTION.RAISE_EXCEPTION;

270: ) then
271: return;
272: else
273: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
274: APP_EXCEPTION.RAISE_EXCEPTION;
275: end if;
276: END Lock_Row;
277:
278: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 304: app_exception.raise_exception;

300: X_allocation_formula_id,
301: X_actual_flag)) THEN
302: IF (X_actual_flag = 'B') THEN
303: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');
304: app_exception.raise_exception;
305: ELSE
306: fnd_message.set_name('SQLGL', 'GL_COMPLETE_ALL_FORMULA_LINES');
307: app_exception.raise_exception;
308: END IF;

Line 307: app_exception.raise_exception;

303: fnd_message.set_name('SQLGL', 'GL_COMPLETE_FOUR_FORMULA_LINES');
304: app_exception.raise_exception;
305: ELSE
306: fnd_message.set_name('SQLGL', 'GL_COMPLETE_ALL_FORMULA_LINES');
307: app_exception.raise_exception;
308: END IF;
309: END IF;
310:
311: -- If the user has changed the currency, then update the lines