APPS.PER_MX_VALIDATIONS dependencies on FND_PROFILE

Line 38: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN

34: l_chk_unique := TRUE;
35: l_valid := p_rfc_id;
36: l_warning := 'N';
37:
38: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN
39:
40: IF p_rfc_id IS NOT NULL THEN
41:
42: -- Call the core package to perform the format check on the RFC ID

Line 50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN

46: l_valid := hr_ni_chk_pkg.chk_nat_id_format( p_rfc_id, 'AAAA-DDDDDD-XXX');
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;

Line 88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN

84: OR p_person_id <> pp.person_id)
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

Line 150: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' THEN

146: l_valid := p_ss_id;
147: l_warning := 'N';
148:
149:
150: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' THEN
151:
152: IF p_ss_id IS NOT NULL THEN
153:
154: -- Call the core package to perform the format check on the SS ID

Line 160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN

156: l_valid := hr_ni_chk_pkg.chk_nat_id_format( p_ss_id, 'DD-DD-DD-DDDD-D');
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

Line 198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN

194: OR p_person_id <> pp.person_id)
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

Line 256: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN

252: --
253: l_valid := '1';
254: l_warning := 'N';
255:
256: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN
257:
258: IF p_ms_id IS NOT NULL THEN
259:
260: --

Line 265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN

261: -- Check if Military Service ID is 13 characters long
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

Line 300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN

296: OR p_person_id <> pp.person_id)
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

Line 350: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN

346: --
347: l_valid := '1';
348: l_warning := 'N';
349:
350: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' THEN
351:
352: IF p_fga_id IS NOT NULL THEN
353:
354: --

Line 359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN

355: -- Check if Federal Government Affiliation ID is 13 characters long
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

Line 393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN

389: OR p_person_id <> pp.person_id)
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