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;
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
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',
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';
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
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',
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;
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
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',
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
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',
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
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',
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
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',
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
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',
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
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',
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
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',