eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NI_CHK_PKG dependencies on HR_UTILITY

Line 39: hr_utility.set_location('Entering:'|| l_proc, 3);

35: where pbg.business_group_id = p_business_group_id;
36: --
37: Begin
38: --
39: hr_utility.set_location('Entering:'|| l_proc, 3);
40: --
41: -- validate arguments prior to calling validate_national_identifier
42: --
43: -- check national identifier is not null

Line 46: hr_utility.set_message(801,'HR_51242_PER_NAT_ID_NULL');

42: --
43: -- check national identifier is not null
44: --
45: if p_national_identifier is null then
46: hr_utility.set_message(801,'HR_51242_PER_NAT_ID_NULL');
47: hr_utility.raise_error;
48: end if;
49: l_return_value := p_national_identifier;
50: --

Line 47: hr_utility.raise_error;

43: -- check national identifier is not null
44: --
45: if p_national_identifier is null then
46: hr_utility.set_message(801,'HR_51242_PER_NAT_ID_NULL');
47: hr_utility.raise_error;
48: end if;
49: l_return_value := p_national_identifier;
50: --
51: -- check birth date is not null

Line 54: hr_utility.set_message(800,'HR_52767_PER_DOB_NULL');

50: --
51: -- check birth date is not null
52: --
53: if p_birth_date is null then
54: hr_utility.set_message(800,'HR_52767_PER_DOB_NULL');
55: hr_utility.raise_error;
56: end if;
57: --
58: -- check gender is not null

Line 55: hr_utility.raise_error;

51: -- check birth date is not null
52: --
53: if p_birth_date is null then
54: hr_utility.set_message(800,'HR_52767_PER_DOB_NULL');
55: hr_utility.raise_error;
56: end if;
57: --
58: -- check gender is not null
59: --

Line 61: hr_utility.set_message(800,'HR_52766_PER_GENDER_NULL');

57: --
58: -- check gender is not null
59: --
60: if p_gender is null then
61: hr_utility.set_message(800,'HR_52766_PER_GENDER_NULL');
62: hr_utility.raise_error;
63: end if;
64: --
65: -- check session date is not null

Line 62: hr_utility.raise_error;

58: -- check gender is not null
59: --
60: if p_gender is null then
61: hr_utility.set_message(800,'HR_52766_PER_GENDER_NULL');
62: hr_utility.raise_error;
63: end if;
64: --
65: -- check session date is not null
66: --

Line 68: hr_utility.set_message(800,'HR_52768_PER_SESSION_DATE_NULL');

64: --
65: -- check session date is not null
66: --
67: if p_session_date is null then
68: hr_utility.set_message(800,'HR_52768_PER_SESSION_DATE_NULL');
69: hr_utility.raise_error;
70: end if;
71: --
72: -- validate p_business_group and derrive legislation code

Line 69: hr_utility.raise_error;

65: -- check session date is not null
66: --
67: if p_session_date is null then
68: hr_utility.set_message(800,'HR_52768_PER_SESSION_DATE_NULL');
69: hr_utility.raise_error;
70: end if;
71: --
72: -- validate p_business_group and derrive legislation code
73: --

Line 75: hr_utility.set_message(800,'HR_52769_PER_BUS_GRP_NULL');

71: --
72: -- validate p_business_group and derrive legislation code
73: --
74: if p_business_group_id is null then
75: hr_utility.set_message(800,'HR_52769_PER_BUS_GRP_NULL');
76: hr_utility.raise_error;
77: else
78: open csr_bg;
79: fetch csr_bg into l_legislation_code;

Line 76: hr_utility.raise_error;

72: -- validate p_business_group and derrive legislation code
73: --
74: if p_business_group_id is null then
75: hr_utility.set_message(800,'HR_52769_PER_BUS_GRP_NULL');
76: hr_utility.raise_error;
77: else
78: open csr_bg;
79: fetch csr_bg into l_legislation_code;
80: if csr_bg%notfound then

Line 81: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

77: else
78: open csr_bg;
79: fetch csr_bg into l_legislation_code;
80: if csr_bg%notfound then
81: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
82: hr_utility.raise_error;
83: end if;
84: close csr_bg;
85: end if;

Line 82: hr_utility.raise_error;

78: open csr_bg;
79: fetch csr_bg into l_legislation_code;
80: if csr_bg%notfound then
81: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
82: hr_utility.raise_error;
83: end if;
84: close csr_bg;
85: end if;
86: --

Line 88: hr_utility.set_location(l_proc, 6);

84: close csr_bg;
85: end if;
86: --
87: --
88: hr_utility.set_location(l_proc, 6);
89: --
90: --
91: -- Now call NI validation routine...
92: l_return_value := hr_ni_chk_pkg.validate_national_identifier(

Line 106: hr_utility.set_location('Leaving:'|| l_proc, 8);

102: p_region_of_birth => l_region_of_birth,
103: p_country_of_birth => l_country_of_birth);
104: --
105: --
106: hr_utility.set_location('Leaving:'|| l_proc, 8);
107: --
108: return l_return_value;
109: --
110: end validate_national_identifier;

Line 193: hr_utility.set_location('Entering:'|| l_proc, 5);

189: and p_session_date between effective_start_date and effective_end_date;
190:
191: begin
192: --
193: hr_utility.set_location('Entering:'|| l_proc, 5);
194: --
195: --
196: l_return_value := p_national_identifier;
197: --

Line 223: hr_utility.set_location(l_proc, 10);

219: --
220: --
221:
222: --
223: hr_utility.set_location(l_proc, 10);
224: --
225: -- Addition for 1891893
226: --
227: open csr_compiled_formula;

Line 265: hr_utility.set_location(l_proc, 15);

261: l_inputs(l_in_cnt).value := p_nationality;
262: end if;
263: end loop;
264: --
265: hr_utility.set_location(l_proc, 15);
266: --
267: --
268: ff_exec.run_formula(l_inputs,l_outputs);
269: --

Line 284: hr_utility.set_message(801,l_invalid_mesg);

280: --
281: if l_return_value = 'INVALID_ID' then
282: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' then
283: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' then
284: hr_utility.set_message(801,l_invalid_mesg);
285: hr_utility.raise_error;
286: else
287: l_warning :='Y';
288: end if;

Line 285: hr_utility.raise_error;

281: if l_return_value = 'INVALID_ID' then
282: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' then
283: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' then
284: hr_utility.set_message(801,l_invalid_mesg);
285: hr_utility.raise_error;
286: else
287: l_warning :='Y';
288: end if;
289: end if;

Line 297: hr_utility.raise_error;

293: -- If the formula is invalid then error 1891893
294: -- ********************************************
295: elsif fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'NONE' then
296: fnd_message.set_name('PER','HR_289303_NI_FORMULA_ERROR');
297: hr_utility.raise_error;
298: end if;
299: close csr_compiled_formula;
300: --
301: -- End of fix for 1891893

Line 303: hr_utility.set_location('Leaving:'|| l_proc, 20);

299: close csr_compiled_formula;
300: --
301: -- End of fix for 1891893
302: --
303: hr_utility.set_location('Leaving:'|| l_proc, 20);
304: --
305: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') ='NONE' or fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') ='WARN' then
306: l_return_value := p_national_identifier;
307: end if;

Line 314: hr_utility.set_location('Leaving:'|| l_proc, 22);

310: return l_return_value;
311: exception
312: when NO_DATA_FOUND then
313: --
314: hr_utility.set_location('Leaving:'|| l_proc, 22);
315: --
316: return l_return_value;
317: --
318:

Line 360: hr_utility.set_location('Entering:'|| l_proc, 5);

356: l_proc varchar2(72) := g_package||'chk_nat_id_format';
357: --
358: begin
359: --
360: hr_utility.set_location('Entering:'|| l_proc, 5);
361: --
362:
363: l_nat_id := '0';
364: l_valid := 1;

Line 512: hr_utility.set_location('Leaving:'|| l_proc, 10);

508:
509: /* End format string check */
510: end if;
511: --
512: hr_utility.set_location('Leaving:'|| l_proc, 10);
513: --
514:
515: return l_nat_id;
516:

Line 537: hr_utility.set_location('Entering:'|| l_proc, 5);

533: l_proc varchar2(72) := g_package||'check_ni_unique';
534: --
535: begin
536: --
537: hr_utility.set_location('Entering:'|| l_proc, 5);
538: --
539: SELECT org_information9
540: INTO l_legislation_code
541: FROM hr_organization_information

Line 547: hr_utility.set_location(l_proc, 10);

543: AND organization_id = p_business_group_id;
544: --
545: --
546: --
547: hr_utility.set_location(l_proc, 10);
548: --
549: begin
550: /* Bug 12594992, introduced the below if else structure to cater to specific requirements of UK.
551: For UK, the first 8 digits of national identifier should only be checked for uniqueness.

Line 585: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');

581: l_nat_lbl := rtrim(l_nat_lbl);
582: end if;
583:
584: if p_raise_error_or_warning = 'ERROR' then
585: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
586: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
587: hr_utility.raise_error;
588: else
589: /* psingla -- To execute null statement if the Legislation is Polish and the profile

Line 586: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

582: end if;
583:
584: if p_raise_error_or_warning = 'ERROR' then
585: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
586: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
587: hr_utility.raise_error;
588: else
589: /* psingla -- To execute null statement if the Legislation is Polish and the profile
590: PER_NI_UNIQUE_ERROR_WARNING is set to null

Line 587: hr_utility.raise_error;

583:
584: if p_raise_error_or_warning = 'ERROR' then
585: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
586: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
587: hr_utility.raise_error;
588: else
589: /* psingla -- To execute null statement if the Legislation is Polish and the profile
590: PER_NI_UNIQUE_ERROR_WARNING is set to null
591: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

Line 591: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

587: hr_utility.raise_error;
588: else
589: /* psingla -- To execute null statement if the Legislation is Polish and the profile
590: PER_NI_UNIQUE_ERROR_WARNING is set to null
591: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
592: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
593: raise local_warning; */
594: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
595: null;

Line 592: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

588: else
589: /* psingla -- To execute null statement if the Legislation is Polish and the profile
590: PER_NI_UNIQUE_ERROR_WARNING is set to null
591: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
592: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
593: raise local_warning; */
594: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
595: null;
596: else

Line 597: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

593: raise local_warning; */
594: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
595: null;
596: else
597: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
598: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
599: raise local_warning;
600: end if;
601: end if;

Line 598: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

594: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
595: null;
596: else
597: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
598: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
599: raise local_warning;
600: end if;
601: end if;
602: --

Line 604: hr_utility.set_location(' Leaving:'||l_proc, 15);

600: end if;
601: end if;
602: --
603: --
604: hr_utility.set_location(' Leaving:'||l_proc, 15);
605: --
606: exception
607: when no_data_found then null;
608: when local_warning then

Line 613: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

609: raise;
610: end;
611: exception
612: when NO_DATA_FOUND then
613: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
615: hr_utility.set_message_token('STEP','1');
616: hr_utility.raise_error;
617: when local_warning then

Line 614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');

610: end;
611: exception
612: when NO_DATA_FOUND then
613: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
615: hr_utility.set_message_token('STEP','1');
616: hr_utility.raise_error;
617: when local_warning then
618: hr_utility.set_warning;

Line 615: hr_utility.set_message_token('STEP','1');

611: exception
612: when NO_DATA_FOUND then
613: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
615: hr_utility.set_message_token('STEP','1');
616: hr_utility.raise_error;
617: when local_warning then
618: hr_utility.set_warning;
619: end check_ni_unique;

Line 616: hr_utility.raise_error;

612: when NO_DATA_FOUND then
613: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
615: hr_utility.set_message_token('STEP','1');
616: hr_utility.raise_error;
617: when local_warning then
618: hr_utility.set_warning;
619: end check_ni_unique;
620: end hr_ni_chk_pkg;

Line 618: hr_utility.set_warning;

614: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
615: hr_utility.set_message_token('STEP','1');
616: hr_utility.raise_error;
617: when local_warning then
618: hr_utility.set_warning;
619: end check_ni_unique;
620: end hr_ni_chk_pkg;
621: