DBA Data[Home] [Help]

APPS.GL_PERIOD_STATUSES_PKG dependencies on APP_EXCEPTION

Line 73: RAISE app_exceptions.application_exception;

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
77: WHEN app_exceptions.application_exception THEN

Line 77: WHEN app_exceptions.application_exception THEN

73: RAISE app_exceptions.application_exception;
74: END IF;
75:
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',

Line 145: WHEN app_exceptions.application_exception THEN

141: END IF;
142: END IF;
143:
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',

Line 184: WHEN app_exceptions.application_exception THEN

180:
181: EXCEPTION
182: WHEN NO_DATA_FOUND THEN
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',

Line 269: WHEN app_exceptions.application_exception THEN

265:
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
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',

Line 349: WHEN app_exceptions.application_exception THEN

345: WHEN NO_DATA_FOUND THEN
346: RAISE;
347: WHEN DUP_VAL_ON_INDEX THEN
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',

Line 477: WHEN app_exceptions.application_exception THEN

473:
474: EXCEPTION
475: WHEN NO_DATA_FOUND THEN
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',

Line 524: WHEN app_exceptions.application_exception THEN

520:
521: exception
522: WHEN NO_DATA_FOUND THEN
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',

Line 548: WHEN app_exceptions.application_exception THEN

544:
545: exception
546: WHEN NO_DATA_FOUND THEN
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',

Line 569: WHEN app_exceptions.application_exception THEN

565: AND period_name = recinfo.period_name ;
566: EXCEPTION
567: WHEN NO_DATA_FOUND THEN
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',

Line 602: WHEN app_exceptions.application_exception THEN

598: x_period_year := recinfo.period_year;
599: EXCEPTION
600: WHEN NO_DATA_FOUND THEN
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',

Line 670: WHEN app_exceptions.application_exception THEN

666: RAISE NO_DATA_FOUND;
667: END IF;
668:
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',

Line 723: WHEN app_exceptions.application_exception THEN

719:
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN
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',

Line 760: WHEN app_exceptions.application_exception THEN

756:
757: EXCEPTION
758: WHEN NO_DATA_FOUND THEN
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',

Line 800: WHEN app_exceptions.application_exception THEN

796:
797: EXCEPTION
798: WHEN NO_DATA_FOUND THEN
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',

Line 857: WHEN app_exceptions.application_exception THEN

853:
854: EXCEPTION
855: WHEN NO_DATA_FOUND THEN
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',

Line 905: WHEN app_exceptions.application_exception THEN

901:
902: EXCEPTION
903: WHEN NO_DATA_FOUND THEN
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',

Line 1049: APP_EXCEPTION.Raise_Exception;

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 (
1053: (Recinfo.application_id = X_Application_Id)

Line 1087: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1301: APP_EXCEPTION.Raise_Exception;

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
1304: RAISE;
1305: WHEN OTHERS THEN

Line 1303: WHEN app_exceptions.application_exception THEN

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
1304: RAISE;
1305: WHEN OTHERS THEN
1306: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1307: fnd_message.set_token('PROCEDURE',

Line 1334: WHEN app_exceptions.application_exception THEN

1330: WHEN NO_DATA_FOUND THEN
1331: x_start_date := NULL;
1332: x_end_date := NULL;
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',

Line 1365: WHEN app_exceptions.application_exception THEN

1361: WHEN NO_DATA_FOUND THEN
1362: x_start_date := NULL;
1363: x_end_date := NULL;
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',

Line 1396: WHEN app_exceptions.application_exception THEN

1392: WHEN NO_DATA_FOUND THEN
1393: x_start_date := NULL;
1394: x_end_date := NULL;
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',