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: SELECT 'Y'
551: INTO l_status

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

566: l_nat_lbl := rtrim(l_nat_lbl);
567: end if;
568:
569: if p_raise_error_or_warning = 'ERROR' then
570: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
571: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
572: hr_utility.raise_error;
573: else
574: /* psingla -- To execute null statement if the Legislation is Polish and the profile

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

567: end if;
568:
569: if p_raise_error_or_warning = 'ERROR' then
570: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
571: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
572: hr_utility.raise_error;
573: else
574: /* psingla -- To execute null statement if the Legislation is Polish and the profile
575: PER_NI_UNIQUE_ERROR_WARNING is set to null

Line 572: hr_utility.raise_error;

568:
569: if p_raise_error_or_warning = 'ERROR' then
570: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
571: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
572: hr_utility.raise_error;
573: else
574: /* psingla -- To execute null statement if the Legislation is Polish and the profile
575: PER_NI_UNIQUE_ERROR_WARNING is set to null
576: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

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

572: hr_utility.raise_error;
573: else
574: /* psingla -- To execute null statement if the Legislation is Polish and the profile
575: PER_NI_UNIQUE_ERROR_WARNING is set to null
576: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
577: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
578: raise local_warning; */
579: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
580: null;

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

573: else
574: /* psingla -- To execute null statement if the Legislation is Polish and the profile
575: PER_NI_UNIQUE_ERROR_WARNING is set to null
576: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
577: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
578: raise local_warning; */
579: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
580: null;
581: else

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

578: raise local_warning; */
579: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
580: null;
581: else
582: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
583: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
584: raise local_warning;
585: end if;
586: end if;

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

579: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
580: null;
581: else
582: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
583: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
584: raise local_warning;
585: end if;
586: end if;
587: --

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

585: end if;
586: end if;
587: --
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 15);
590: --
591: exception
592: when no_data_found then null;
593: when local_warning then

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

594: raise;
595: end;
596: exception
597: when NO_DATA_FOUND then
598: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
600: hr_utility.set_message_token('STEP','1');
601: hr_utility.raise_error;
602: when local_warning then

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

595: end;
596: exception
597: when NO_DATA_FOUND then
598: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
600: hr_utility.set_message_token('STEP','1');
601: hr_utility.raise_error;
602: when local_warning then
603: hr_utility.set_warning;

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

596: exception
597: when NO_DATA_FOUND then
598: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
600: hr_utility.set_message_token('STEP','1');
601: hr_utility.raise_error;
602: when local_warning then
603: hr_utility.set_warning;
604: end check_ni_unique;

Line 601: hr_utility.raise_error;

597: when NO_DATA_FOUND then
598: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
599: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
600: hr_utility.set_message_token('STEP','1');
601: hr_utility.raise_error;
602: when local_warning then
603: hr_utility.set_warning;
604: end check_ni_unique;
605: end hr_ni_chk_pkg;

Line 603: hr_utility.set_warning;

599: hr_utility.set_message_token('PROCEDURE','CHECK_NI_UNIQUE');
600: hr_utility.set_message_token('STEP','1');
601: hr_utility.raise_error;
602: when local_warning then
603: hr_utility.set_warning;
604: end check_ni_unique;
605: end hr_ni_chk_pkg;
606: