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 315: app_exception.raise_exception;

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

Line 428: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 524: app_exception.raise_exception;

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

Line 529: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 584: app_exception.raise_exception;

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

Line 764: app_exception.raise_exception;

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

Line 996: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1212: app_exception.raise_exception;

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

Line 1217: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1312: app_exception.raise_exception;

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