APPS.GL_JE_BATCHES_PKG dependencies on APP_EXCEPTION

Line 32: app_exception.raise_exception;

28:
29: IF chk_duplicates%FOUND THEN
30: CLOSE chk_duplicates;
31: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_BATCH_NAME');
32: app_exception.raise_exception;
33: END IF;
34:
35: CLOSE chk_duplicates;
36:

Line 38: WHEN app_exceptions.application_exception THEN

34:
35: CLOSE chk_duplicates;
36:
37: EXCEPTION
38: WHEN app_exceptions.application_exception THEN
39: RAISE;
40: WHEN OTHERS THEN
41: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
42: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.check_unique');

Line 62: app_exception.raise_exception;

58: ELSE
59: CLOSE get_new_id;
60: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
61: fnd_message.set_token('SEQUENCE', 'GL_JE_BATCHES_S');
62: app_exception.raise_exception;
63: END IF;
64:
65: EXCEPTION
66: WHEN app_exceptions.application_exception THEN

Line 66: WHEN app_exceptions.application_exception THEN

62: app_exception.raise_exception;
63: END IF;
64:
65: EXCEPTION
66: WHEN app_exceptions.application_exception THEN
67: RAISE;
68: WHEN OTHERS THEN
69: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
70: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.get_unique_id');

Line 97: WHEN app_exceptions.application_exception THEN

93: return(FALSE);
94: END IF;
95:
96: EXCEPTION
97: WHEN app_exceptions.application_exception THEN
98: RAISE;
99: WHEN OTHERS THEN
100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
101: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.has_lines');

Line 132: WHEN app_exceptions.application_exception THEN

128: return(FALSE);
129: END IF;
130:
131: EXCEPTION
132: WHEN app_exceptions.application_exception THEN
133: RAISE;
134: WHEN OTHERS THEN
135: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
136: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_approval');

Line 164: WHEN app_exceptions.application_exception THEN

160: return(FALSE);
161: END IF;
162:
163: EXCEPTION
164: WHEN app_exceptions.application_exception THEN
165: RAISE;
166: WHEN OTHERS THEN
167: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
168: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_tax');

Line 314: app_exception.raise_exception;

310: END IF;
311:
312: IF (has_je = 'N') THEN
313: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
314: app_exception.raise_exception;
315: END IF;
316:
317: INSERT INTO GL_JE_BATCHES(
318: je_batch_id,

Line 427: APP_EXCEPTION.RAISE_EXCEPTION;

423: FETCH C INTO Recinfo;
424: if (C%NOTFOUND) then
425: CLOSE C;
426: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
427: APP_EXCEPTION.RAISE_EXCEPTION;
428: end if;
429: CLOSE C;
430:
431: if (

Line 523: app_exception.raise_exception;

519: END;
520: END IF;
521: IF (nvl(dev_request_phase, 'COMPLETE') <> 'COMPLETE') THEN
522: FND_MESSAGE.set_name('SQLGL', 'GL_MJE_BATCH_BEING_PROCESSED');
523: app_exception.raise_exception;
524: END IF;
525: END IF;
526: else
527: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 528: APP_EXCEPTION.RAISE_EXCEPTION;

524: END IF;
525: END IF;
526: else
527: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
528: APP_EXCEPTION.RAISE_EXCEPTION;
529: end if;
530: END Lock_Row;
531:
532: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 583: app_exception.raise_exception;

579: END IF;
580:
581: IF (has_je = 'N') THEN
582: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
583: app_exception.raise_exception;
584: END IF;
585:
586: -- If the user changes the average journal flag to 'Y', then
587: -- we need to reinitialize all of the journals effective dates.

Line 763: app_exception.raise_exception;

759: END IF;
760:
761: IF (has_je = 'N') THEN
762: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
763: app_exception.raise_exception;
764: END IF;
765:
766: INSERT INTO GL_JE_BATCHES(
767: je_batch_id,

Line 995: APP_EXCEPTION.RAISE_EXCEPTION;

991: FETCH C INTO Recinfo;
992: if (C%NOTFOUND) then
993: CLOSE C;
994: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
995: APP_EXCEPTION.RAISE_EXCEPTION;
996: end if;
997: CLOSE C;
998:
999:

Line 1211: app_exception.raise_exception;

1207: END;
1208: END IF;
1209: IF (nvl(dev_request_phase, 'COMPLETE') <> 'COMPLETE') THEN
1210: FND_MESSAGE.set_name('SQLGL', 'GL_MJE_BATCH_BEING_PROCESSED');
1211: app_exception.raise_exception;
1212: END IF;
1213: END IF;
1214: else
1215: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 1216: APP_EXCEPTION.RAISE_EXCEPTION;

1212: END IF;
1213: END IF;
1214: else
1215: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1216: APP_EXCEPTION.RAISE_EXCEPTION;
1217: end if;
1218: END Lock_Row;
1219:
1220: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 1311: app_exception.raise_exception;

1307: END IF;
1308:
1309: IF (has_je = 'N') THEN
1310: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
1311: app_exception.raise_exception;
1312: END IF;
1313:
1314: -- If the user changes the average journal flag to 'Y', then
1315: -- we need to reinitialize all of the journals effective dates.