APPS.PER_ES_ORG_INFO dependencies on FND_DATE

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

95: -- Validation for Natural Disater dates
96: --
97: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
98: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
99: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
100: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
101: hr_utility.raise_error;
102: END IF;
103: END IF;

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

106: -- Validation for Natural Disater dates
107: --
108: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
109: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
110: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
111: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
112: hr_utility.raise_error;
113: END IF;
114: END IF;

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

117: -- Validation for Partial Unemployment dates
118: --
119: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
120: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
121: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
122: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
123: hr_utility.raise_error;
124: END IF;
125: END IF;

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

132: -- Validation for Contribution Exempt Situation dates
133: --
134: IF p_org_info_type_code='ES_CONTRIB_EXEMPT' THEN
135: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
136: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
137: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
138: hr_utility.raise_error;
139: END IF;
140: END IF;

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

143: -- Validation for Temporary Disability Management Deduction dates
144: --
145: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
146: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
147: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
148: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
149: hr_utility.raise_error;
150: END IF;
151: END IF;

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

166: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
167: hr_utility.raise_error;
168: END IF;
169: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
170: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
171: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
172: hr_utility.raise_error;
173: END IF;
174: END IF;

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

295: -- Validation for Natural Disater dates
296: --
297: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
298: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
299: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
300: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
301: hr_utility.raise_error;
302: END IF;
303: END IF;

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

306: -- Validation for Natural Disater dates
307: --
308: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
309: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
310: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
311: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
312: hr_utility.raise_error;
313: END IF;
314: END IF;

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

317: -- Validation for Partial Unemployment dates
318: --
319: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
320: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
322: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;

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

332: -- Validation for Contribution Exempt Situation dates
333: --
334: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
335: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
336: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
337: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
338: hr_utility.raise_error;
339: END IF;
340: END IF;

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

343: -- Validation for Temporary Disability Management Deduction dates
344: --
345: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
346: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
347: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
348: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
349: hr_utility.raise_error;
350: END IF;
351: END IF;

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

366: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
367: hr_utility.raise_error;
368: END IF;
369: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
370: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
371: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
372: hr_utility.raise_error;
373: END IF;
374: END IF;