47:
48: IF l_valid = '0' THEN
49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
48: IF l_valid = '0' THEN
49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
58: l_warning := 'Y';
59:
60: END IF;
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
58: l_warning := 'Y';
59:
60: END IF;
61:
85: AND translate(l_valid, '1-', '1') = translate(pp.per_information2, '1-', '1')
86: AND pp.business_group_id +0 = p_business_group_id);
87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
86: AND pp.business_group_id +0 = p_business_group_id);
87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';
96: END IF;
97: p_warning := l_warning;
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';
96: END IF;
97: p_warning := l_warning;
98:
104: END IF;
105:
106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;
105:
106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;
113:
106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;
113:
114: --------------------------------------------------------------------------
157:
158: IF l_valid = '0' THEN
159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
158: IF l_valid = '0' THEN
159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';
168:
169: END IF;
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';
168:
169: END IF;
170:
195: AND translate(l_valid, '1-', '1') = translate(pp.per_information3, '1-', '1')
196: AND pp.business_group_id +0 = p_business_group_id);
197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
196: AND pp.business_group_id +0 = p_business_group_id);
197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';
206: END IF;
207: p_warning := l_warning;
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';
206: END IF;
207: p_warning := l_warning;
208:
215: END IF;
216:
217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --
216:
217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --
224: END check_SS;
217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --
224: END check_SS;
225:
262: --
263: IF length(p_ms_id) <> 13 THEN
264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
263: IF length(p_ms_id) <> 13 THEN
264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:
273: l_warning := 'Y';
274:
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:
273: l_warning := 'Y';
274:
275: END IF;
297: AND p_ms_id = pp.per_information6
298: AND pp.business_group_id = p_business_group_id);
299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
298: AND pp.business_group_id = p_business_group_id);
299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';
308: END IF;
309: p_warning := l_warning;
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';
308: END IF;
309: p_warning := l_warning;
310:
356: --
357: IF length(p_fga_id) <> 13 THEN
358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
357: IF length(p_fga_id) <> 13 THEN
358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';
367:
368: END IF;
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';
367:
368: END IF;
369:
390: AND p_fga_id = pp.per_information5
391: AND pp.business_group_id = p_business_group_id);
392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
391: AND pp.business_group_id = p_business_group_id);
392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';
401: END IF;
402: p_warning := l_warning;
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';
401: END IF;
402: p_warning := l_warning;
403:
433: -- Check if IMSS Medical Center is upto 3 digits long
434: --
435: IF to_number(p_imc_id) > 999 OR to_number(p_imc_id) < 0 THEN
436:
437: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
438: hr_utility.raise_error;
439:
440: END IF;
441: END IF;
434: --
435: IF to_number(p_imc_id) > 999 OR to_number(p_imc_id) < 0 THEN
436:
437: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
438: hr_utility.raise_error;
439:
440: END IF;
441: END IF;
442:
445: WHEN VALUE_ERROR THEN
446: --
447: -- Raise error when non-numeric characters are present in the IMSS Medical Center
448: --
449: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
450: hr_utility.raise_error;
451:
452: END;
453:
446: --
447: -- Raise error when non-numeric characters are present in the IMSS Medical Center
448: --
449: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
450: hr_utility.raise_error;
451:
452: END;
453:
454: --
483: l_valid := hr_ni_chk_pkg.chk_nat_id_format( p_regstrn_id, 'AADDDDDD');
484:
485: IF l_valid = '0' THEN
486:
487: hr_utility.set_message(800,'HR_MX_INVALID_DISAB_ID');
488: hr_utility.raise_error;
489:
490: END IF;
491:
484:
485: IF l_valid = '0' THEN
486:
487: hr_utility.set_message(800,'HR_MX_INVALID_DISAB_ID');
488: hr_utility.raise_error;
489:
490: END IF;
491:
492: -- Check for uniqueness of Registration ID.
501: OR p_disab_id <> pdf.disability_id)
502: AND l_valid = pdf.registration_id
503: );
504:
505: hr_utility.set_message(800,'HR_MX_DISAB_ID_UNIQUE_ERROR');
506: hr_utility.raise_error;
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
502: AND l_valid = pdf.registration_id
503: );
504:
505: hr_utility.set_message(800,'HR_MX_DISAB_ID_UNIQUE_ERROR');
506: hr_utility.raise_error;
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: null;
538: -- Check if the lookup_code for leaving reason exists in the lookup
539: --
540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
539: --
540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;
540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;
548: END IF;
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;
548: END IF;
549: --