68: x_per_number, x_per_year;
69:
70: IF (find_period%NOTFOUND) THEN
71: CLOSE find_period;
72: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
73: app_exception.raise_exception;
74: END IF;
75:
76: CLOSE find_period;
151: x_per_number, x_per_year;
152:
153: IF (find_period%NOTFOUND) THEN
154: CLOSE find_period;
155: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_ENC_YEAR');
156: app_exception.raise_exception;
157: END IF;
158:
159: CLOSE find_period;
252: x_per_number, x_per_year;
253:
254: IF (find_period%NOTFOUND) THEN
255: CLOSE find_period;
256: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_ENC_YEAR');
257: app_exception.raise_exception;
258: END IF;
259:
260: CLOSE find_period;
366: period_year := tmp_year;
367: period_num := tmp_num;
368:
369: IF (period_status NOT IN ('O', 'F')) THEN
370: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374: EXCEPTION
380: IF find_period%FOUND THEN
381: CLOSE find_period;
382: ELSE
383: CLOSE find_period;
384: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
385: app_exception.raise_exception;
386: END IF;
387:
388: period_name := x_period_name;
403: IF (business_day = 'Y') THEN
404: rolled_accounting_date := initial_accounting_date;
405: RETURN;
406: ELSIF (roll_date <> 'Y') THEN
407: fnd_message.set_name('SQLGL', 'GL_JE_NOT_BUSINESS_DAY');
408: app_exception.raise_exception;
409: END IF;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
408: app_exception.raise_exception;
409: END IF;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
413: app_exception.raise_exception;
414: END;
415:
416: -- Roll the date back to a business day
589: period_year := tmp_year;
590: period_num := tmp_num;
591:
592: IF (period_status NOT IN ('O', 'F')) THEN
593: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
594: app_exception.raise_exception;
595: END IF;
596: END IF;
597: EXCEPTION
603: IF find_period%FOUND THEN
604: CLOSE find_period;
605: ELSE
606: CLOSE find_period;
607: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
608: app_exception.raise_exception;
609: END IF;
610:
611: period_name := x_period_name;
649: IF (business_day = 'Y') THEN
650: rolled_accounting_date := initial_accounting_date;
651: RETURN;
652: ELSIF (roll_date <> 'Y') THEN
653: fnd_message.set_name('SQLGL', 'GL_JE_NOT_BUSINESS_DAY');
654: app_exception.raise_exception;
655: END IF;
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
654: app_exception.raise_exception;
655: END IF;
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');
659: app_exception.raise_exception;
660: END;
661:
662: -- Roll the date back to a business day
786: x_per_number, x_per_year;
787:
788: IF (find_period%NOTFOUND) THEN
789: CLOSE find_period;
790: fnd_message.set_name('SQLGL', 'GL_CONS_DATE_NOT_OPEN_CLOSED');
791: app_exception.raise_exception;
792: END IF;
793:
794: CLOSE find_period;