DBA Data[Home] [Help]

APPS.GL_JE_BATCHES_PKG dependencies on FND_MESSAGE

Line 31: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_BATCH_NAME');

27: FETCH chk_duplicates INTO dummy;
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;

Line 41: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
43: RAISE;
44: END check_unique;
45:

Line 42: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.check_unique');

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');
43: RAISE;
44: END check_unique;
45:
46: FUNCTION get_unique_id RETURN NUMBER IS

Line 60: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

56: CLOSE get_new_id;
57: return(new_id);
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:

Line 61: fnd_message.set_token('SEQUENCE', 'GL_JE_BATCHES_S');

57: return(new_id);
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

Line 69: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
71: RAISE;
72: END get_unique_id;
73:

Line 70: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.get_unique_id');

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');
71: RAISE;
72: END get_unique_id;
73:
74:

Line 100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
102: RAISE;
103: END has_lines;
104:

Line 101: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.has_lines');

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');
102: RAISE;
103: END has_lines;
104:
105:

Line 135: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
137: RAISE;
138: END needs_approval;
139:

Line 136: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_approval');

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');
137: RAISE;
138: END needs_approval;
139:
140: FUNCTION needs_tax(batch_id NUMBER) RETURN BOOLEAN IS

Line 167: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
169: RAISE;
170: END needs_tax;
171:

Line 168: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_tax');

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');
169: RAISE;
170: END needs_tax;
171:
172:

Line 314: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');

310: END;
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(

Line 427: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

423: OPEN C;
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:

Line 523: FND_MESSAGE.set_name('SQLGL', 'GL_MJE_BATCH_BEING_PROCESSED');

519: request_status_mesg );
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

Line 528: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

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

Line 583: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');

579: END;
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

Line 763: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');

759: END;
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(

Line 995: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

991: OPEN C;
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:

Line 1211: FND_MESSAGE.set_name('SQLGL', 'GL_MJE_BATCH_BEING_PROCESSED');

1207: request_status_mesg );
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

Line 1216: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

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

Line 1311: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');

1307: END;
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