DBA Data[Home] [Help]

APPS.HR_RU_ASG_HOOK dependencies on FND_DATE

Line 118: IF fnd_date.canonical_to_date(p_segment4) < l_min_start_date THEN

114: hr_utility.raise_error;
115: END IF;
116: END IF;
117: IF p_segment4 <> hr_api.g_varchar2 THEN
118: IF fnd_date.canonical_to_date(p_segment4) < l_min_start_date THEN
119: hr_utility.set_message(800, 'HR_RU_INVALID_ISSUE_DATE');
120: hr_utility.raise_error;
121: END IF;
122: END IF;

Line 124: IF fnd_date.canonical_to_date(p_segment5) < l_min_start_date THEN

120: hr_utility.raise_error;
121: END IF;
122: END IF;
123: IF p_segment5 <> hr_api.g_varchar2 THEN
124: IF fnd_date.canonical_to_date(p_segment5) < l_min_start_date THEN
125: hr_utility.set_message(800, 'HR_RU_INVALID_END_DATE');
126: hr_utility.raise_error;
127: END IF;
128: END IF;

Line 291: IF fnd_date.canonical_to_date(p_scl_segment4) < p_effective_date THEN

287: hr_utility.raise_error;
288: END IF;
289: END IF;
290: IF p_scl_segment4 IS NOT NULL THEN
291: IF fnd_date.canonical_to_date(p_scl_segment4) < p_effective_date THEN
292: hr_utility.set_message(800, 'HR_RU_INVALID_ISSUE_DATE');
293: hr_utility.raise_error;
294: END IF;
295: END IF;

Line 297: IF fnd_date.canonical_to_date(p_scl_segment5) < p_effective_date THEN

293: hr_utility.raise_error;
294: END IF;
295: END IF;
296: IF p_scl_segment5 IS NOT NULL THEN
297: IF fnd_date.canonical_to_date(p_scl_segment5) < p_effective_date THEN
298: hr_utility.set_message(800, 'HR_RU_INVALID_END_DATE');
299: hr_utility.raise_error;
300: END IF;
301: END IF;