DBA Data[Home] [Help]

APPS.GL_DATE_HANDLER_PKG dependencies on APP_EXCEPTION

Line 73: app_exception.raise_exception;

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;
77:

Line 156: app_exception.raise_exception;

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;
160:

Line 257: app_exception.raise_exception;

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;
261:

Line 371: app_exception.raise_exception;

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
375: WHEN NO_DATA_FOUND THEN

Line 385: app_exception.raise_exception;

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;
389: start_date := period_start_date;

Line 408: app_exception.raise_exception;

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
412: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

Line 413: 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
417: BEGIN

Line 594: app_exception.raise_exception;

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
598: WHEN NO_DATA_FOUND THEN

Line 608: app_exception.raise_exception;

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;
612: start_date := period_start_date;

Line 654: app_exception.raise_exception;

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
658: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

Line 659: 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
663: BEGIN

Line 791: app_exception.raise_exception;

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;
795: