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

429:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
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',

Line 480: WHEN app_exceptions.application_exception THEN

476:
477: exception
478: WHEN NO_DATA_FOUND THEN
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',

Line 504: WHEN app_exceptions.application_exception THEN

500:
501: exception
502: WHEN NO_DATA_FOUND THEN
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',

Line 525: WHEN app_exceptions.application_exception THEN

521: AND period_name = recinfo.period_name ;
522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
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',

Line 558: WHEN app_exceptions.application_exception THEN

554: x_period_year := recinfo.period_year;
555: EXCEPTION
556: WHEN NO_DATA_FOUND THEN
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',

Line 626: WHEN app_exceptions.application_exception THEN

622: RAISE NO_DATA_FOUND;
623: END IF;
624:
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',

Line 679: WHEN app_exceptions.application_exception THEN

675:
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
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',

Line 716: WHEN app_exceptions.application_exception THEN

712:
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN
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',

Line 756: WHEN app_exceptions.application_exception THEN

752:
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
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',

Line 813: WHEN app_exceptions.application_exception THEN

809:
810: EXCEPTION
811: WHEN NO_DATA_FOUND THEN
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',

Line 861: WHEN app_exceptions.application_exception THEN

857:
858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
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',

Line 1005: APP_EXCEPTION.Raise_Exception;

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

Line 1043: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1257: APP_EXCEPTION.Raise_Exception;

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
1260: RAISE;
1261: WHEN OTHERS THEN

Line 1259: WHEN app_exceptions.application_exception THEN

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
1260: RAISE;
1261: WHEN OTHERS THEN
1262: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1263: fnd_message.set_token('PROCEDURE',

Line 1290: WHEN app_exceptions.application_exception THEN

1286: WHEN NO_DATA_FOUND THEN
1287: x_start_date := NULL;
1288: x_end_date := NULL;
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',

Line 1321: WHEN app_exceptions.application_exception THEN

1317: WHEN NO_DATA_FOUND THEN
1318: x_start_date := NULL;
1319: x_end_date := NULL;
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',

Line 1352: WHEN app_exceptions.application_exception THEN

1348: WHEN NO_DATA_FOUND THEN
1349: x_start_date := NULL;
1350: x_end_date := NULL;
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',