DBA Data[Home] [Help]

APPS.GL_DATE_HANDLER_PKG dependencies on FND_MESSAGE

Line 72: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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;

Line 155: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_ENC_YEAR');

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;

Line 256: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_ENC_YEAR');

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;

Line 370: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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

Line 384: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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;

Line 407: fnd_message.set_name('SQLGL', 'GL_JE_NOT_BUSINESS_DAY');

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

Line 412: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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

Line 593: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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

Line 607: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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;

Line 653: fnd_message.set_name('SQLGL', 'GL_JE_NOT_BUSINESS_DAY');

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

Line 658: fnd_message.set_name('SQLGL', 'GL_JE_NOT_OPEN_OR_FUTURE_ENT');

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

Line 790: fnd_message.set_name('SQLGL', 'GL_CONS_DATE_NOT_OPEN_CLOSED');

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;