DBA Data[Home] [Help]

APPS.GL_BUDGETS_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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;
56: END IF;
57: END check_detail_budgets;

Line 105: app_exception.raise_exception;

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:
109:

Line 131: app_exception.raise_exception;

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;
135:

Line 137: WHEN app_exceptions.application_exception THEN

133:
134: CLOSE chk_duplicates;
135:
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');

Line 161: app_exception.raise_exception;

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
165: WHEN app_exceptions.application_exception THEN

Line 165: WHEN app_exceptions.application_exception THEN

161: app_exception.raise_exception;
162: END IF;
163:
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');

Line 199: WHEN app_exceptions.application_exception THEN

195: RETURN( FALSE );
196: END IF;
197:
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',

Line 220: WHEN app_exceptions.application_exception THEN

216: AND budget_name = recinfo.budget_name ;
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
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',

Line 256: WHEN app_exceptions.application_exception THEN

252:
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
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',

Line 315: app_exception.raise_exception;

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;
319: END IF;

Line 459: app_exception.raise_exception;

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:
463: if (

Line 547: APP_EXCEPTION.RAISE_EXCEPTION;

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:
551: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 599: app_exception.raise_exception;

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;
603: END IF;

Line 660: WHEN app_exceptions.application_exception THEN

656: x_user_id,
657: x_login_id);
658:
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',