323: p_expiry_information := 0;
324: RETURN;
325:
326: ELSE
327: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
328: hr_utility.raise_error;
329:
330: END IF;
331:
324: RETURN;
325:
326: ELSE
327: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
328: hr_utility.raise_error;
329:
330: END IF;
331:
332: IF p_user_effective_date >= l_expiry_date THEN
443: ELSIF p_dimension_name LIKE '%LTD' THEN
444: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
445:
446: ELSE
447: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
448: hr_utility.raise_error;
449:
450: END IF;
451:
444: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
445:
446: ELSE
447: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
448: hr_utility.raise_error;
449:
450: END IF;
451:
452: EXCEPTION