DBA Data[Home] [Help]

APPS.GL_ARCH_PRG_FROM_PRD_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

48: IF get_from_period%FOUND THEN
49: CLOSE get_from_period;
50: IF (x_closing_status <> 'P') THEN
51: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
52: app_exception.raise_exception;
53: END IF;
54: ELSE
55: x_closing_status := 'N';
56: CLOSE get_from_period;

Line 58: app_exception.raise_exception;

54: ELSE
55: x_closing_status := 'N';
56: CLOSE get_from_period;
57: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
58: app_exception.raise_exception;
59: END IF;
60:
61: EXCEPTION
62: WHEN app_exceptions.application_exception THEN

Line 62: WHEN app_exceptions.application_exception THEN

58: app_exception.raise_exception;
59: END IF;
60:
61: EXCEPTION
62: WHEN app_exceptions.application_exception THEN
63: RAISE;
64: WHEN OTHERS THEN
65: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
66: fnd_message.set_token('PROCEDURE',

Line 128: app_exception.raise_exception;

124: IF get_from_period%FOUND THEN
125: CLOSE get_from_period;
126: IF (x_closing_status <> 'P') THEN
127: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
128: app_exception.raise_exception;
129: END IF;
130: ELSE
131: CLOSE get_from_period;
132: x_closing_status := 'N';

Line 134: app_exception.raise_exception;

130: ELSE
131: CLOSE get_from_period;
132: x_closing_status := 'N';
133: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
134: app_exception.raise_exception;
135: END IF;
136:
137: EXCEPTION
138: WHEN app_exceptions.application_exception THEN

Line 138: WHEN app_exceptions.application_exception THEN

134: app_exception.raise_exception;
135: END IF;
136:
137: EXCEPTION
138: WHEN app_exceptions.application_exception THEN
139: RAISE;
140: WHEN OTHERS THEN
141: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
142: fnd_message.set_token('PROCEDURE',

Line 194: app_exception.raise_exception;

190: IF get_from_period%FOUND THEN
191: CLOSE get_from_period;
192: IF (x_closing_status <> 'P') THEN
193: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
194: app_exception.raise_exception;
195: END IF;
196: ELSE
197: x_closing_status := 'N';
198: CLOSE get_from_period;

Line 200: app_exception.raise_exception;

196: ELSE
197: x_closing_status := 'N';
198: CLOSE get_from_period;
199: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
200: app_exception.raise_exception;
201: END IF;
202:
203: EXCEPTION
204: WHEN app_exceptions.application_exception THEN

Line 204: WHEN app_exceptions.application_exception THEN

200: app_exception.raise_exception;
201: END IF;
202:
203: EXCEPTION
204: WHEN app_exceptions.application_exception THEN
205: RAISE;
206: WHEN OTHERS THEN
207: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
208: fnd_message.set_token('PROCEDURE',

Line 262: app_exception.raise_exception;

258: ELSE
259: x_closing_status := 'N';
260: CLOSE get_from_period;
261: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
262: app_exception.raise_exception;
263: END IF;
264:
265: EXCEPTION
266: WHEN app_exceptions.application_exception THEN

Line 266: WHEN app_exceptions.application_exception THEN

262: app_exception.raise_exception;
263: END IF;
264:
265: EXCEPTION
266: WHEN app_exceptions.application_exception THEN
267: RAISE;
268: WHEN OTHERS THEN
269: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
270: fnd_message.set_token('PROCEDURE',

Line 335: app_exception.raise_exception;

331: ELSE
332: x_closing_status := 'N';
333: CLOSE get_from_period;
334: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
335: app_exception.raise_exception;
336: END IF;
337:
338: EXCEPTION
339: WHEN app_exceptions.application_exception THEN

Line 339: WHEN app_exceptions.application_exception THEN

335: app_exception.raise_exception;
336: END IF;
337:
338: EXCEPTION
339: WHEN app_exceptions.application_exception THEN
340: RAISE;
341: WHEN OTHERS THEN
342: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
343: fnd_message.set_token('PROCEDURE',

Line 397: app_exception.raise_exception;

393: ELSE
394: x_closing_status := 'N';
395: CLOSE get_from_period;
396: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
397: app_exception.raise_exception;
398: END IF;
399:
400: EXCEPTION
401: WHEN app_exceptions.application_exception THEN

Line 401: WHEN app_exceptions.application_exception THEN

397: app_exception.raise_exception;
398: END IF;
399:
400: EXCEPTION
401: WHEN app_exceptions.application_exception THEN
402: RAISE;
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
405: fnd_message.set_token('PROCEDURE',

Line 460: app_exception.raise_exception;

456: ELSE
457: x_closing_status := 'N';
458: CLOSE get_to_period;
459: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
460: app_exception.raise_exception;
461: END IF;
462:
463: EXCEPTION
464: WHEN app_exceptions.application_exception THEN

Line 464: WHEN app_exceptions.application_exception THEN

460: app_exception.raise_exception;
461: END IF;
462:
463: EXCEPTION
464: WHEN app_exceptions.application_exception THEN
465: RAISE;
466: WHEN OTHERS THEN
467: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
468: fnd_message.set_token('PROCEDURE',

Line 524: app_exception.raise_exception;

520: ELSE
521: x_closing_status := 'N';
522: CLOSE get_to_period;
523: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
524: app_exception.raise_exception;
525: END IF;
526:
527: EXCEPTION
528: WHEN app_exceptions.application_exception THEN

Line 528: WHEN app_exceptions.application_exception THEN

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

Line 588: app_exception.raise_exception;

584: ELSE
585: x_closing_status := 'N';
586: CLOSE get_to_period;
587: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
588: app_exception.raise_exception;
589: END IF;
590:
591: EXCEPTION
592: WHEN app_exceptions.application_exception THEN

Line 592: WHEN app_exceptions.application_exception THEN

588: app_exception.raise_exception;
589: END IF;
590:
591: EXCEPTION
592: WHEN app_exceptions.application_exception THEN
593: RAISE;
594: WHEN OTHERS THEN
595: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
596: fnd_message.set_token('PROCEDURE',