eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_PERIOD_STATUSES_PKG dependencies on FND_MESSAGE

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

65: OPEN gap_end;
66: FETCH gap_end INTO end_date;
67: CLOSE gap_end;
68: -- Tell the user
69: fnd_message.set_name('SQLGL', 'GL_GAP_IN_CALENDAR');
70: fnd_message.set_token('CALENDAR_NAME', x_periodsetname);
71: fnd_message.set_token('START_DATE', nvl(start_date, beginning));
72: fnd_message.set_token('END_DATE', nvl(end_date, ending));
73: RAISE app_exceptions.application_exception;

Line 70: fnd_message.set_token('CALENDAR_NAME', x_periodsetname);

66: FETCH gap_end INTO end_date;
67: CLOSE gap_end;
68: -- Tell the user
69: fnd_message.set_name('SQLGL', 'GL_GAP_IN_CALENDAR');
70: fnd_message.set_token('CALENDAR_NAME', x_periodsetname);
71: fnd_message.set_token('START_DATE', nvl(start_date, beginning));
72: fnd_message.set_token('END_DATE', nvl(end_date, ending));
73: RAISE app_exceptions.application_exception;
74: END IF;

Line 71: fnd_message.set_token('START_DATE', nvl(start_date, beginning));

67: CLOSE gap_end;
68: -- Tell the user
69: fnd_message.set_name('SQLGL', 'GL_GAP_IN_CALENDAR');
70: fnd_message.set_token('CALENDAR_NAME', x_periodsetname);
71: fnd_message.set_token('START_DATE', nvl(start_date, beginning));
72: fnd_message.set_token('END_DATE', nvl(end_date, ending));
73: RAISE app_exceptions.application_exception;
74: END IF;
75:

Line 72: fnd_message.set_token('END_DATE', nvl(end_date, ending));

68: -- Tell the user
69: fnd_message.set_name('SQLGL', 'GL_GAP_IN_CALENDAR');
70: fnd_message.set_token('CALENDAR_NAME', x_periodsetname);
71: fnd_message.set_token('START_DATE', nvl(start_date, beginning));
72: fnd_message.set_token('END_DATE', nvl(end_date, ending));
73: RAISE app_exceptions.application_exception;
74: END IF;
75:
76: EXCEPTION

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

76: EXCEPTION
77: WHEN app_exceptions.application_exception THEN
78: RAISE;
79: WHEN OTHERS THEN
80: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
81: fnd_message.set_token('PROCEDURE',
82: 'gl_period_statuses_pkg.check_for_gap');
83: RAISE;
84: END check_for_gap;

Line 81: fnd_message.set_token('PROCEDURE',

77: WHEN app_exceptions.application_exception THEN
78: RAISE;
79: WHEN OTHERS THEN
80: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
81: fnd_message.set_token('PROCEDURE',
82: 'gl_period_statuses_pkg.check_for_gap');
83: RAISE;
84: END check_for_gap;
85:

Line 139: fnd_message.set_name('SQLGL', 'GL_NO_OPEN_OR_FUTURE_PERIODS');

135: CLOSE get_earliest_future_ent;
136: return(default_period);
137: ELSE
138: CLOSE get_earliest_future_ent;
139: fnd_message.set_name('SQLGL', 'GL_NO_OPEN_OR_FUTURE_PERIODS');
140: return(null);
141: END IF;
142: END IF;
143:

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

144: EXCEPTION
145: WHEN app_exceptions.application_exception THEN
146: RAISE;
147: WHEN OTHERS THEN
148: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
149: fnd_message.set_token('PROCEDURE',
150: 'gl_period_statuses_pkg.default_actual_period');
151: RAISE;
152: END default_actual_period;

Line 149: fnd_message.set_token('PROCEDURE',

145: WHEN app_exceptions.application_exception THEN
146: RAISE;
147: WHEN OTHERS THEN
148: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
149: fnd_message.set_token('PROCEDURE',
150: 'gl_period_statuses_pkg.default_actual_period');
151: RAISE;
152: END default_actual_period;
153:

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

183: RETURN;
184: WHEN app_exceptions.application_exception THEN
185: RAISE;
186: WHEN OTHERS THEN
187: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
188: fnd_message.set_token('PROCEDURE',
189: 'gl_period_statuses_pkg.get_next_period');
190: RAISE;
191:

Line 188: fnd_message.set_token('PROCEDURE',

184: WHEN app_exceptions.application_exception THEN
185: RAISE;
186: WHEN OTHERS THEN
187: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
188: fnd_message.set_token('PROCEDURE',
189: 'gl_period_statuses_pkg.get_next_period');
190: RAISE;
191:
192: END get_next_period;

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

268: RETURN;
269: WHEN app_exceptions.application_exception THEN
270: RAISE;
271: WHEN OTHERS THEN
272: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
273: fnd_message.set_token('PROCEDURE',
274: 'gl_period_statuses_pkg.insert_led_ps');
275: RAISE;
276:

Line 273: fnd_message.set_token('PROCEDURE',

269: WHEN app_exceptions.application_exception THEN
270: RAISE;
271: WHEN OTHERS THEN
272: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
273: fnd_message.set_token('PROCEDURE',
274: 'gl_period_statuses_pkg.insert_led_ps');
275: RAISE;
276:
277: END insert_led_ps;

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

348: NULL;
349: WHEN app_exceptions.application_exception THEN
350: RAISE;
351: WHEN OTHERS THEN
352: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
353: fnd_message.set_token('PROCEDURE',
354: 'gl_period_statuses_pkg.insert_ps_api');
355: RAISE;
356:

Line 353: fnd_message.set_token('PROCEDURE',

349: WHEN app_exceptions.application_exception THEN
350: RAISE;
351: WHEN OTHERS THEN
352: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
353: fnd_message.set_token('PROCEDURE',
354: 'gl_period_statuses_pkg.insert_ps_api');
355: RAISE;
356:
357: END insert_ps_api;

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

476: RETURN;
477: WHEN app_exceptions.application_exception THEN
478: RAISE;
479: WHEN OTHERS THEN
480: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
481: fnd_message.set_token('PROCEDURE',
482: 'gl_period_statuses_pkg.insert_period');
483: RAISE;
484: END insert_period;

Line 481: fnd_message.set_token('PROCEDURE',

477: WHEN app_exceptions.application_exception THEN
478: RAISE;
479: WHEN OTHERS THEN
480: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
481: fnd_message.set_token('PROCEDURE',
482: 'gl_period_statuses_pkg.insert_period');
483: RAISE;
484: END insert_period;
485:

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

523: RETURN;
524: WHEN app_exceptions.application_exception THEN
525: RAISE;
526: WHEN OTHERS THEN
527: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
528: fnd_message.set_token('PROCEDURE',
529: 'gl_period_statuses_pkg.update_period');
530: RAISE;
531: END update_period;

Line 528: fnd_message.set_token('PROCEDURE',

524: WHEN app_exceptions.application_exception THEN
525: RAISE;
526: WHEN OTHERS THEN
527: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
528: fnd_message.set_token('PROCEDURE',
529: 'gl_period_statuses_pkg.update_period');
530: RAISE;
531: END update_period;
532:

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

547: RETURN;
548: WHEN app_exceptions.application_exception THEN
549: RAISE;
550: WHEN OTHERS THEN
551: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
552: fnd_message.set_token('PROCEDURE',
553: 'gl_period_statuses_pkg.delete_period');
554: RAISE;
555: END delete_period;

Line 552: fnd_message.set_token('PROCEDURE',

548: WHEN app_exceptions.application_exception THEN
549: RAISE;
550: WHEN OTHERS THEN
551: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
552: fnd_message.set_token('PROCEDURE',
553: 'gl_period_statuses_pkg.delete_period');
554: RAISE;
555: END delete_period;
556:

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

568: RETURN;
569: WHEN app_exceptions.application_exception THEN
570: RAISE;
571: WHEN OTHERS THEN
572: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
573: fnd_message.set_token('PROCEDURE',
574: 'gl_period_statuses_pkg.select_row');
575: RAISE;
576: END select_row;

Line 573: fnd_message.set_token('PROCEDURE',

569: WHEN app_exceptions.application_exception THEN
570: RAISE;
571: WHEN OTHERS THEN
572: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
573: fnd_message.set_token('PROCEDURE',
574: 'gl_period_statuses_pkg.select_row');
575: RAISE;
576: END select_row;
577:

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

601: RETURN;
602: WHEN app_exceptions.application_exception THEN
603: RAISE;
604: WHEN OTHERS THEN
605: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
606: fnd_message.set_token('PROCEDURE',
607: 'gl_period_statuses_pkg.select_columns');
608: RAISE;
609: END select_columns;

Line 606: fnd_message.set_token('PROCEDURE',

602: WHEN app_exceptions.application_exception THEN
603: RAISE;
604: WHEN OTHERS THEN
605: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
606: fnd_message.set_token('PROCEDURE',
607: 'gl_period_statuses_pkg.select_columns');
608: RAISE;
609: END select_columns;
610:

Line 665: fnd_message.set_name('SQLGL', 'GL_MISSING_FUT_ENT_PERIODS');

661:
662: -- If some future enterable periods are not yet defined,
663: -- raise an error
664: IF (v_num_periods_updated <> (v_fut_ent_periods_limit + 1)) THEN
665: fnd_message.set_name('SQLGL', 'GL_MISSING_FUT_ENT_PERIODS');
666: RAISE NO_DATA_FOUND;
667: END IF;
668:
669: EXCEPTION

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

669: EXCEPTION
670: WHEN app_exceptions.application_exception THEN
671: RAISE;
672: WHEN OTHERS THEN
673: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
674: fnd_message.set_token('PROCEDURE',
675: 'gl_period_statuses_pkg.initialize_period_statuses');
676: RAISE;
677: END initialize_period_statuses;

Line 674: fnd_message.set_token('PROCEDURE',

670: WHEN app_exceptions.application_exception THEN
671: RAISE;
672: WHEN OTHERS THEN
673: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
674: fnd_message.set_token('PROCEDURE',
675: 'gl_period_statuses_pkg.initialize_period_statuses');
676: RAISE;
677: END initialize_period_statuses;
678:

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

722: RETURN;
723: WHEN app_exceptions.application_exception THEN
724: RAISE;
725: WHEN OTHERS THEN
726: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
727: fnd_message.set_token('PROCEDURE',
728: 'gl_period_statuses_pkg.select_encumbrance_periods');
729: RAISE;
730:

Line 727: fnd_message.set_token('PROCEDURE',

723: WHEN app_exceptions.application_exception THEN
724: RAISE;
725: WHEN OTHERS THEN
726: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
727: fnd_message.set_token('PROCEDURE',
728: 'gl_period_statuses_pkg.select_encumbrance_periods');
729: RAISE;
730:
731: END select_encumbrance_periods;

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

759: RETURN;
760: WHEN app_exceptions.application_exception THEN
761: RAISE;
762: WHEN OTHERS THEN
763: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
764: fnd_message.set_token('PROCEDURE',
765: 'gl_period_statuses_pkg.select_prior_year_1st_period');
766: RAISE;
767: END select_prior_year_1st_period;

Line 764: fnd_message.set_token('PROCEDURE',

760: WHEN app_exceptions.application_exception THEN
761: RAISE;
762: WHEN OTHERS THEN
763: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
764: fnd_message.set_token('PROCEDURE',
765: 'gl_period_statuses_pkg.select_prior_year_1st_period');
766: RAISE;
767: END select_prior_year_1st_period;
768:

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

799: RETURN;
800: WHEN app_exceptions.application_exception THEN
801: RAISE;
802: WHEN OTHERS THEN
803: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
804: fnd_message.set_token('PROCEDURE',
805: 'gl_period_statuses_pkg.select_year_1st_period');
806: RAISE;
807: END select_year_1st_period;

Line 804: fnd_message.set_token('PROCEDURE',

800: WHEN app_exceptions.application_exception THEN
801: RAISE;
802: WHEN OTHERS THEN
803: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
804: fnd_message.set_token('PROCEDURE',
805: 'gl_period_statuses_pkg.select_year_1st_period');
806: RAISE;
807: END select_year_1st_period;
808:

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

856: RETURN;
857: WHEN app_exceptions.application_exception THEN
858: RAISE;
859: WHEN OTHERS THEN
860: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
861: fnd_message.set_token('PROCEDURE',
862: 'gl_period_statuses_pkg.get_extended_quarter');
863: RAISE;
864: END get_extended_quarter;

Line 861: fnd_message.set_token('PROCEDURE',

857: WHEN app_exceptions.application_exception THEN
858: RAISE;
859: WHEN OTHERS THEN
860: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
861: fnd_message.set_token('PROCEDURE',
862: 'gl_period_statuses_pkg.get_extended_quarter');
863: RAISE;
864: END get_extended_quarter;
865:

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

904: RETURN;
905: WHEN app_exceptions.application_exception THEN
906: RAISE;
907: WHEN OTHERS THEN
908: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
909: fnd_message.set_token('PROCEDURE',
910: 'gl_period_statuses_pkg.get_extended_year');
911: RAISE;
912: END get_extended_year;

Line 909: fnd_message.set_token('PROCEDURE',

905: WHEN app_exceptions.application_exception THEN
906: RAISE;
907: WHEN OTHERS THEN
908: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
909: fnd_message.set_token('PROCEDURE',
910: 'gl_period_statuses_pkg.get_extended_year');
911: RAISE;
912: END get_extended_year;
913:

Line 1048: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

1044: OPEN C;
1045: FETCH C INTO Recinfo;
1046: if (C%NOTFOUND) then
1047: CLOSE C;
1048: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1049: APP_EXCEPTION.Raise_Exception;
1050: end if;
1051: CLOSE C;
1052: if (

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

1082:
1083: ) then
1084: return;
1085: else
1086: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1087: APP_EXCEPTION.RAISE_EXCEPTION;
1088: end if;
1089: END Lock_Row;
1090:

Line 1298: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');

1294: x_period_name := NULL;
1295: x_closing_status := NULL;
1296: RETURN;
1297: /*
1298: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');
1299: fnd_message.set_token('PROCEDURE',
1300: 'gl_period_statuses_pkg.get_period_by_date');
1301: APP_EXCEPTION.Raise_Exception;
1302: */

Line 1299: fnd_message.set_token('PROCEDURE',

1295: x_closing_status := NULL;
1296: RETURN;
1297: /*
1298: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');
1299: fnd_message.set_token('PROCEDURE',
1300: 'gl_period_statuses_pkg.get_period_by_date');
1301: APP_EXCEPTION.Raise_Exception;
1302: */
1303: WHEN app_exceptions.application_exception THEN

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

1302: */
1303: WHEN app_exceptions.application_exception THEN
1304: RAISE;
1305: WHEN OTHERS THEN
1306: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1307: fnd_message.set_token('PROCEDURE',
1308: 'gl_period_statuses_pkg.get_period_by_date');
1309: RAISE;
1310: END get_period_by_date;

Line 1307: fnd_message.set_token('PROCEDURE',

1303: WHEN app_exceptions.application_exception THEN
1304: RAISE;
1305: WHEN OTHERS THEN
1306: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1307: fnd_message.set_token('PROCEDURE',
1308: 'gl_period_statuses_pkg.get_period_by_date');
1309: RAISE;
1310: END get_period_by_date;
1311:

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

1333: RETURN;
1334: WHEN app_exceptions.application_exception THEN
1335: RAISE;
1336: WHEN OTHERS THEN
1337: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1338: fnd_message.set_token('PROCEDURE',
1339: 'gl_period_statuses_pkg.get_calendar_range');
1340: RAISE;
1341: END get_calendar_range;

Line 1338: fnd_message.set_token('PROCEDURE',

1334: WHEN app_exceptions.application_exception THEN
1335: RAISE;
1336: WHEN OTHERS THEN
1337: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1338: fnd_message.set_token('PROCEDURE',
1339: 'gl_period_statuses_pkg.get_calendar_range');
1340: RAISE;
1341: END get_calendar_range;
1342:

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

1364: RETURN;
1365: WHEN app_exceptions.application_exception THEN
1366: RAISE;
1367: WHEN OTHERS THEN
1368: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1369: fnd_message.set_token('PROCEDURE',
1370: 'gl_period_statuses_pkg.get_open_closed_calendar_range');
1371: RAISE;
1372: END get_open_closed_calendar_range;

Line 1369: fnd_message.set_token('PROCEDURE',

1365: WHEN app_exceptions.application_exception THEN
1366: RAISE;
1367: WHEN OTHERS THEN
1368: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1369: fnd_message.set_token('PROCEDURE',
1370: 'gl_period_statuses_pkg.get_open_closed_calendar_range');
1371: RAISE;
1372: END get_open_closed_calendar_range;
1373:

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

1395: RETURN;
1396: WHEN app_exceptions.application_exception THEN
1397: RAISE;
1398: WHEN OTHERS THEN
1399: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1400: fnd_message.set_token('PROCEDURE',
1401: 'gl_period_statuses_pkg.get_journal_range');
1402: RAISE;
1403: END get_journal_range;

Line 1400: fnd_message.set_token('PROCEDURE',

1396: WHEN app_exceptions.application_exception THEN
1397: RAISE;
1398: WHEN OTHERS THEN
1399: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1400: fnd_message.set_token('PROCEDURE',
1401: 'gl_period_statuses_pkg.get_journal_range');
1402: RAISE;
1403: END get_journal_range;
1404: