APPS.GL_ALLOC_BATCHES_PKG dependencies on APP_EXCEPTION

Line 24: app_exception.raise_exception;

20:
21: IF chk_duplicates%FOUND THEN
22: CLOSE chk_duplicates;
23: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_ALLOC_BATCH_NAME');
24: app_exception.raise_exception;
25: END IF;
26:
27: CLOSE chk_duplicates;
28:

Line 30: WHEN app_exceptions.application_exception THEN

26:
27: CLOSE chk_duplicates;
28:
29: EXCEPTION
30: WHEN app_exceptions.application_exception THEN
31: RAISE;
32: WHEN OTHERS THEN
33: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
34: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.check_unique');

Line 54: app_exception.raise_exception;

50: ELSE
51: CLOSE get_new_id;
52: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
53: fnd_message.set_token('SEQUENCE', 'GL_ALLOC_BATCHES_S');
54: app_exception.raise_exception;
55: END IF;
56:
57: EXCEPTION
58: WHEN app_exceptions.application_exception THEN

Line 58: WHEN app_exceptions.application_exception THEN

54: app_exception.raise_exception;
55: END IF;
56:
57: EXCEPTION
58: WHEN app_exceptions.application_exception THEN
59: RAISE;
60: WHEN OTHERS THEN
61: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
62: fnd_message.set_token('PROCEDURE', 'gl_alloc_batches_pkg.get_unique_id');

Line 150: APP_EXCEPTION.Raise_Exception;

146: FETCH C INTO Recinfo;
147: if (C%NOTFOUND) then
148: CLOSE C;
149: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
150: APP_EXCEPTION.Raise_Exception;
151: end if;
152: CLOSE C;
153: if (
154: (Recinfo.allocation_batch_id = X_Allocation_Batch_Id)

Line 167: APP_EXCEPTION.RAISE_EXCEPTION;

163: ) then
164: return;
165: else
166: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
167: APP_EXCEPTION.RAISE_EXCEPTION;
168: end if;
169: END Lock_Row;
170:
171:

Line 220: app_exception.raise_exception;

216:
217: IF chk_autoalloc_set%FOUND THEN
218: CLOSE chk_autoalloc_set;
219: fnd_message.set_name('SQLGL', 'GL_BATCH_USED_IN_ALLOC_SET');
220: app_exception.raise_exception;
221: END IF;
222:
223: CLOSE chk_autoalloc_set;
224:

Line 403: WHEN app_exceptions.application_exception THEN

399: );
400:
401:
402: EXCEPTION
403: WHEN app_exceptions.application_exception THEN
404: RAISE;
405: WHEN OTHERS THEN
406: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
407: fnd_message.set_token('PROCEDURE',

Line 430: app_exception.raise_exception;

426: ELSE
427: -- it is being used by some AutoAllocation sets, exit
428: CLOSE chk_autoalloc_set;
429: fnd_message.set_name('SQLGL', 'GL_BATCH_USED_IN_ALLOC_SET');
430: app_exception.raise_exception;
431: END IF;
432:
433: END check_batch;
434: