66: mth_util_pkg.log_msg('VALIDATE_GREG_CAL_INPUT_PARAMS start', mth_util_pkg.G_DBG_PROC_FUN_START);
67: v_err_code := '';
68:
69: If (P_NUM_YEARS < 1) THEN
70: v_err_code := fnd_message.get_string('MTH','MTH_GREG_NUM_YEARS');
71: END IF;
72:
73: SELECT Max(CAL_YEAR_NUMBER)
74: into v_latest_year
75: FROM MTH_GREGORIAN_CALENDAR
76: WHERE calendar_quarter_id IS NULL;
77:
78: IF (v_latest_year is not null and v_latest_year <> P_START_YEAR - 1) THEN
79: FND_MESSAGE.SET_NAME('MTH','MTH_GREG_START_YEAR');
80: FND_MESSAGE.SET_TOKEN('YEAR',v_latest_year+1);
81: v_err_code := v_err_code || FND_MESSAGE.GET('MTH_GREG_START_YEAR');
82: END IF;
83:
76: WHERE calendar_quarter_id IS NULL;
77:
78: IF (v_latest_year is not null and v_latest_year <> P_START_YEAR - 1) THEN
79: FND_MESSAGE.SET_NAME('MTH','MTH_GREG_START_YEAR');
80: FND_MESSAGE.SET_TOKEN('YEAR',v_latest_year+1);
81: v_err_code := v_err_code || FND_MESSAGE.GET('MTH_GREG_START_YEAR');
82: END IF;
83:
84: IF (v_latest_year is null AND P_START_YEAR < 1900) THEN
77:
78: IF (v_latest_year is not null and v_latest_year <> P_START_YEAR - 1) THEN
79: FND_MESSAGE.SET_NAME('MTH','MTH_GREG_START_YEAR');
80: FND_MESSAGE.SET_TOKEN('YEAR',v_latest_year+1);
81: v_err_code := v_err_code || FND_MESSAGE.GET('MTH_GREG_START_YEAR');
82: END IF;
83:
84: IF (v_latest_year is null AND P_START_YEAR < 1900) THEN
85: v_err_code := v_err_code || fnd_message.get_string('MTH','MTH_GREG_LATER_YEAR');
81: v_err_code := v_err_code || FND_MESSAGE.GET('MTH_GREG_START_YEAR');
82: END IF;
83:
84: IF (v_latest_year is null AND P_START_YEAR < 1900) THEN
85: v_err_code := v_err_code || fnd_message.get_string('MTH','MTH_GREG_LATER_YEAR');
86: END IF;
87:
88: RETURN v_err_code;
89: mth_util_pkg.log_msg('VALIDATE_GREG_CAL_INPUT_PARAMS end', mth_util_pkg.G_DBG_PROC_FUN_END);