APPS.PER_ES_ORG_INFO dependencies on FND_DATE

Line 91: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

87: -- Validation for Natural Disater dates
88: --
89: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
90: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
91: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
92: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
93: hr_utility.raise_error;
94: END IF;
95: END IF;

Line 102: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

98: -- Validation for Natural Disater dates
99: --
100: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
101: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
102: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
103: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
104: hr_utility.raise_error;
105: END IF;
106: END IF;

Line 113: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

109: -- Validation for Partial Unemployment dates
110: --
111: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
112: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
113: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
114: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
115: hr_utility.raise_error;
116: END IF;
117: END IF;

Line 128: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN

124: -- Validation for Contribution Exempt Situation dates
125: --
126: IF p_org_info_type_code='ES_CONTRIB_EXEMPT' THEN
127: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
128: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
129: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
130: hr_utility.raise_error;
131: END IF;
132: END IF;

Line 139: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN

135: -- Validation for Temporary Disability Management Deduction dates
136: --
137: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
138: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
139: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
140: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
141: hr_utility.raise_error;
142: END IF;
143: END IF;

Line 162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

158: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
159: hr_utility.raise_error;
160: END IF;
161: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
163: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
164: hr_utility.raise_error;
165: END IF;
166: END IF;

Line 284: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

280: -- Validation for Natural Disater dates
281: --
282: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
283: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
284: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
285: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
286: hr_utility.raise_error;
287: END IF;
288: END IF;

Line 295: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

291: -- Validation for Natural Disater dates
292: --
293: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
294: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
295: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
296: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
297: hr_utility.raise_error;
298: END IF;
299: END IF;

Line 306: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN

302: -- Validation for Partial Unemployment dates
303: --
304: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
305: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
306: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
307: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
308: hr_utility.raise_error;
309: END IF;
310: END IF;

Line 321: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN

317: -- Validation for Contribution Exempt Situation dates
318: --
319: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
320: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
322: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;

Line 332: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN

328: -- Validation for Temporary Disability Management Deduction dates
329: --
330: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
331: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
332: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
333: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
334: hr_utility.raise_error;
335: END IF;
336: END IF;

Line 355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

351: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
352: hr_utility.raise_error;
353: END IF;
354: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
356: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
357: hr_utility.raise_error;
358: END IF;
359: END IF;