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 313: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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