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

432: RETURN;
433: WHEN app_exceptions.application_exception THEN
434: RAISE;
435: WHEN OTHERS THEN
436: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
437: fnd_message.set_token('PROCEDURE',
438: 'gl_period_statuses_pkg.insert_period');
439: RAISE;
440: END insert_period;

Line 437: fnd_message.set_token('PROCEDURE',

433: WHEN app_exceptions.application_exception THEN
434: RAISE;
435: WHEN OTHERS THEN
436: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
437: fnd_message.set_token('PROCEDURE',
438: 'gl_period_statuses_pkg.insert_period');
439: RAISE;
440: END insert_period;
441:

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

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

Line 484: fnd_message.set_token('PROCEDURE',

480: WHEN app_exceptions.application_exception THEN
481: RAISE;
482: WHEN OTHERS THEN
483: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
484: fnd_message.set_token('PROCEDURE',
485: 'gl_period_statuses_pkg.update_period');
486: RAISE;
487: END update_period;
488:

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

503: RETURN;
504: WHEN app_exceptions.application_exception THEN
505: RAISE;
506: WHEN OTHERS THEN
507: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
508: fnd_message.set_token('PROCEDURE',
509: 'gl_period_statuses_pkg.delete_period');
510: RAISE;
511: END delete_period;

Line 508: fnd_message.set_token('PROCEDURE',

504: WHEN app_exceptions.application_exception THEN
505: RAISE;
506: WHEN OTHERS THEN
507: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
508: fnd_message.set_token('PROCEDURE',
509: 'gl_period_statuses_pkg.delete_period');
510: RAISE;
511: END delete_period;
512:

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

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

Line 529: fnd_message.set_token('PROCEDURE',

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

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

557: RETURN;
558: WHEN app_exceptions.application_exception THEN
559: RAISE;
560: WHEN OTHERS THEN
561: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
562: fnd_message.set_token('PROCEDURE',
563: 'gl_period_statuses_pkg.select_columns');
564: RAISE;
565: END select_columns;

Line 562: fnd_message.set_token('PROCEDURE',

558: WHEN app_exceptions.application_exception THEN
559: RAISE;
560: WHEN OTHERS THEN
561: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
562: fnd_message.set_token('PROCEDURE',
563: 'gl_period_statuses_pkg.select_columns');
564: RAISE;
565: END select_columns;
566:

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

617:
618: -- If some future enterable periods are not yet defined,
619: -- raise an error
620: IF (v_num_periods_updated <> (v_fut_ent_periods_limit + 1)) THEN
621: fnd_message.set_name('SQLGL', 'GL_MISSING_FUT_ENT_PERIODS');
622: RAISE NO_DATA_FOUND;
623: END IF;
624:
625: EXCEPTION

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

625: EXCEPTION
626: WHEN app_exceptions.application_exception THEN
627: RAISE;
628: WHEN OTHERS THEN
629: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
630: fnd_message.set_token('PROCEDURE',
631: 'gl_period_statuses_pkg.initialize_period_statuses');
632: RAISE;
633: END initialize_period_statuses;

Line 630: fnd_message.set_token('PROCEDURE',

626: WHEN app_exceptions.application_exception THEN
627: RAISE;
628: WHEN OTHERS THEN
629: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
630: fnd_message.set_token('PROCEDURE',
631: 'gl_period_statuses_pkg.initialize_period_statuses');
632: RAISE;
633: END initialize_period_statuses;
634:

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

678: RETURN;
679: WHEN app_exceptions.application_exception THEN
680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
683: fnd_message.set_token('PROCEDURE',
684: 'gl_period_statuses_pkg.select_encumbrance_periods');
685: RAISE;
686:

Line 683: fnd_message.set_token('PROCEDURE',

679: WHEN app_exceptions.application_exception THEN
680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
683: fnd_message.set_token('PROCEDURE',
684: 'gl_period_statuses_pkg.select_encumbrance_periods');
685: RAISE;
686:
687: END select_encumbrance_periods;

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

715: RETURN;
716: WHEN app_exceptions.application_exception THEN
717: RAISE;
718: WHEN OTHERS THEN
719: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
720: fnd_message.set_token('PROCEDURE',
721: 'gl_period_statuses_pkg.select_prior_year_1st_period');
722: RAISE;
723: END select_prior_year_1st_period;

Line 720: fnd_message.set_token('PROCEDURE',

716: WHEN app_exceptions.application_exception THEN
717: RAISE;
718: WHEN OTHERS THEN
719: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
720: fnd_message.set_token('PROCEDURE',
721: 'gl_period_statuses_pkg.select_prior_year_1st_period');
722: RAISE;
723: END select_prior_year_1st_period;
724:

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

755: RETURN;
756: WHEN app_exceptions.application_exception THEN
757: RAISE;
758: WHEN OTHERS THEN
759: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
760: fnd_message.set_token('PROCEDURE',
761: 'gl_period_statuses_pkg.select_year_1st_period');
762: RAISE;
763: END select_year_1st_period;

Line 760: fnd_message.set_token('PROCEDURE',

756: WHEN app_exceptions.application_exception THEN
757: RAISE;
758: WHEN OTHERS THEN
759: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
760: fnd_message.set_token('PROCEDURE',
761: 'gl_period_statuses_pkg.select_year_1st_period');
762: RAISE;
763: END select_year_1st_period;
764:

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

812: RETURN;
813: WHEN app_exceptions.application_exception THEN
814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
817: fnd_message.set_token('PROCEDURE',
818: 'gl_period_statuses_pkg.get_extended_quarter');
819: RAISE;
820: END get_extended_quarter;

Line 817: fnd_message.set_token('PROCEDURE',

813: WHEN app_exceptions.application_exception THEN
814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
817: fnd_message.set_token('PROCEDURE',
818: 'gl_period_statuses_pkg.get_extended_quarter');
819: RAISE;
820: END get_extended_quarter;
821:

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

860: RETURN;
861: WHEN app_exceptions.application_exception THEN
862: RAISE;
863: WHEN OTHERS THEN
864: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
865: fnd_message.set_token('PROCEDURE',
866: 'gl_period_statuses_pkg.get_extended_year');
867: RAISE;
868: END get_extended_year;

Line 865: fnd_message.set_token('PROCEDURE',

861: WHEN app_exceptions.application_exception THEN
862: RAISE;
863: WHEN OTHERS THEN
864: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
865: fnd_message.set_token('PROCEDURE',
866: 'gl_period_statuses_pkg.get_extended_year');
867: RAISE;
868: END get_extended_year;
869:

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

1000: OPEN C;
1001: FETCH C INTO Recinfo;
1002: if (C%NOTFOUND) then
1003: CLOSE C;
1004: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1005: APP_EXCEPTION.Raise_Exception;
1006: end if;
1007: CLOSE C;
1008: if (

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

1038:
1039: ) then
1040: return;
1041: else
1042: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1043: APP_EXCEPTION.RAISE_EXCEPTION;
1044: end if;
1045: END Lock_Row;
1046:

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

1250: x_period_name := NULL;
1251: x_closing_status := NULL;
1252: RETURN;
1253: /*
1254: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');
1255: fnd_message.set_token('PROCEDURE',
1256: 'gl_period_statuses_pkg.get_period_by_date');
1257: APP_EXCEPTION.Raise_Exception;
1258: */

Line 1255: fnd_message.set_token('PROCEDURE',

1251: x_closing_status := NULL;
1252: RETURN;
1253: /*
1254: fnd_message.set_name('SQLGL', 'GL_IEA_NOT_IN_OPEN_FUTURE_PER');
1255: fnd_message.set_token('PROCEDURE',
1256: 'gl_period_statuses_pkg.get_period_by_date');
1257: APP_EXCEPTION.Raise_Exception;
1258: */
1259: WHEN app_exceptions.application_exception THEN

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

1258: */
1259: WHEN app_exceptions.application_exception THEN
1260: RAISE;
1261: WHEN OTHERS THEN
1262: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1263: fnd_message.set_token('PROCEDURE',
1264: 'gl_period_statuses_pkg.get_period_by_date');
1265: RAISE;
1266: END get_period_by_date;

Line 1263: fnd_message.set_token('PROCEDURE',

1259: WHEN app_exceptions.application_exception THEN
1260: RAISE;
1261: WHEN OTHERS THEN
1262: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1263: fnd_message.set_token('PROCEDURE',
1264: 'gl_period_statuses_pkg.get_period_by_date');
1265: RAISE;
1266: END get_period_by_date;
1267:

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

1289: RETURN;
1290: WHEN app_exceptions.application_exception THEN
1291: RAISE;
1292: WHEN OTHERS THEN
1293: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1294: fnd_message.set_token('PROCEDURE',
1295: 'gl_period_statuses_pkg.get_calendar_range');
1296: RAISE;
1297: END get_calendar_range;

Line 1294: fnd_message.set_token('PROCEDURE',

1290: WHEN app_exceptions.application_exception THEN
1291: RAISE;
1292: WHEN OTHERS THEN
1293: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1294: fnd_message.set_token('PROCEDURE',
1295: 'gl_period_statuses_pkg.get_calendar_range');
1296: RAISE;
1297: END get_calendar_range;
1298:

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

1320: RETURN;
1321: WHEN app_exceptions.application_exception THEN
1322: RAISE;
1323: WHEN OTHERS THEN
1324: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1325: fnd_message.set_token('PROCEDURE',
1326: 'gl_period_statuses_pkg.get_open_closed_calendar_range');
1327: RAISE;
1328: END get_open_closed_calendar_range;

Line 1325: fnd_message.set_token('PROCEDURE',

1321: WHEN app_exceptions.application_exception THEN
1322: RAISE;
1323: WHEN OTHERS THEN
1324: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1325: fnd_message.set_token('PROCEDURE',
1326: 'gl_period_statuses_pkg.get_open_closed_calendar_range');
1327: RAISE;
1328: END get_open_closed_calendar_range;
1329:

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

1351: RETURN;
1352: WHEN app_exceptions.application_exception THEN
1353: RAISE;
1354: WHEN OTHERS THEN
1355: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1356: fnd_message.set_token('PROCEDURE',
1357: 'gl_period_statuses_pkg.get_journal_range');
1358: RAISE;
1359: END get_journal_range;

Line 1356: fnd_message.set_token('PROCEDURE',

1352: WHEN app_exceptions.application_exception THEN
1353: RAISE;
1354: WHEN OTHERS THEN
1355: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1356: fnd_message.set_token('PROCEDURE',
1357: 'gl_period_statuses_pkg.get_journal_range');
1358: RAISE;
1359: END get_journal_range;
1360: