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.

[Home] [Help]

APPS.PER_PEOPLE3_PKG dependencies on HR_UTILITY

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

25: where pbg.business_group_id = p_business_group_id;
26: --
27: exception
28: when no_data_found then
29: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE'
31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then

Line 30: hr_utility.set_message_token('PROCEDURE'

26: --
27: exception
28: when no_data_found then
29: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE'
31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

Line 32: hr_utility.set_message_token('STEP','2');

28: when no_data_found then
29: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE'
31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'
36: ,'per_people3_pkg.get_number_generation_property');

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

30: hr_utility.set_message_token('PROCEDURE'
31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'
36: ,'per_people3_pkg.get_number_generation_property');
37: hr_utility.set_message_token('STEP','2');
38: end get_number_generation_property;

Line 35: hr_utility.set_message_token('PROCEDURE'

31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'
36: ,'per_people3_pkg.get_number_generation_property');
37: hr_utility.set_message_token('STEP','2');
38: end get_number_generation_property;
39: --

Line 37: hr_utility.set_message_token('STEP','2');

33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'
36: ,'per_people3_pkg.get_number_generation_property');
37: hr_utility.set_message_token('STEP','2');
38: end get_number_generation_property;
39: --
40: procedure get_legislative_ages(p_business_group_id NUMBER
41: ,p_minimum_age IN OUT NOCOPY NUMBER

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

50: and hoi1.org_information_context = 'Business Group Information';
51: --
52: exception
53: when no_data_found then
54: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
55: hr_utility.set_message_token('PROCEDURE'
56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then

Line 55: hr_utility.set_message_token('PROCEDURE'

51: --
52: exception
53: when no_data_found then
54: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
55: hr_utility.set_message_token('PROCEDURE'
56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

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

53: when no_data_found then
54: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
55: hr_utility.set_message_token('PROCEDURE'
56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'
61: ,'per_people3_pkg.get_legislative_ages');

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

55: hr_utility.set_message_token('PROCEDURE'
56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'
61: ,'per_people3_pkg.get_legislative_ages');
62: hr_utility.set_message_token('STEP','2');
63: end get_legislative_ages;

Line 60: hr_utility.set_message_token('PROCEDURE'

56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'
61: ,'per_people3_pkg.get_legislative_ages');
62: hr_utility.set_message_token('STEP','2');
63: end get_legislative_ages;
64: --

Line 62: hr_utility.set_message_token('STEP','2');

58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'
61: ,'per_people3_pkg.get_legislative_ages');
62: hr_utility.set_message_token('STEP','2');
63: end get_legislative_ages;
64: --
65:
66: procedure get_default_person_type(p_required_type VARCHAR2

Line 90: hr_utility.set_message('800','HR_289296_SEC_PROF_SETUP_ERR');

86: open per_type;
87: fetch per_type into p_person_type;
88: --
89: if per_type%ROWCOUNT <>1 then
90: hr_utility.set_message('800','HR_289296_SEC_PROF_SETUP_ERR');
91: hr_utility.raise_error;
92: end if;
93: --
94: close per_type;

Line 91: hr_utility.raise_error;

87: fetch per_type into p_person_type;
88: --
89: if per_type%ROWCOUNT <>1 then
90: hr_utility.set_message('800','HR_289296_SEC_PROF_SETUP_ERR');
91: hr_utility.raise_error;
92: end if;
93: --
94: close per_type;
95: end get_default_person_type;

Line 272: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');

268: begin
269: open fut_apl;
270: fetch fut_apl into l_dummy;
271: if fut_apl%FOUND then
272: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
273: app_exception.raise_exception;
274: end if;
275: close fut_apl;
276: end;

Line 306: hr_utility.trace('p_table(l_index).process_flag >> '||p_table(l_index).process_flag);

302:
303: if l_max_ele > 0 then
304: l_index := 1;
305: loop
306: hr_utility.trace('p_table(l_index).process_flag >> '||p_table(l_index).process_flag);
307: hr_utility.trace('p_table(l_index).id >> '||p_table(l_index).id);
308: if nvl(p_table(l_index).process_flag,'E') <> 'R' then
309: open fut_apl(p_table(l_index).id);
310: fetch fut_apl into l_dummy;

Line 307: hr_utility.trace('p_table(l_index).id >> '||p_table(l_index).id);

303: if l_max_ele > 0 then
304: l_index := 1;
305: loop
306: hr_utility.trace('p_table(l_index).process_flag >> '||p_table(l_index).process_flag);
307: hr_utility.trace('p_table(l_index).id >> '||p_table(l_index).id);
308: if nvl(p_table(l_index).process_flag,'E') <> 'R' then
309: open fut_apl(p_table(l_index).id);
310: fetch fut_apl into l_dummy;
311: if fut_apl%FOUND then

Line 313: hr_utility.trace('12345');

309: open fut_apl(p_table(l_index).id);
310: fetch fut_apl into l_dummy;
311: if fut_apl%FOUND then
312: close fut_apl;
313: hr_utility.trace('12345');
314: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
315: app_exception.raise_exception;
316: end if;
317: hr_utility.trace('123458');

Line 314: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');

310: fetch fut_apl into l_dummy;
311: if fut_apl%FOUND then
312: close fut_apl;
313: hr_utility.trace('12345');
314: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
315: app_exception.raise_exception;
316: end if;
317: hr_utility.trace('123458');
318: close fut_apl;

Line 317: hr_utility.trace('123458');

313: hr_utility.trace('12345');
314: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
315: app_exception.raise_exception;
316: end if;
317: hr_utility.trace('123458');
318: close fut_apl;
319: end if;
320: l_index := l_index + 1;
321: EXIT when l_index > l_max_ele ;

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

352: fetch pps into pps_rec;
353: end loop pps_loop;
354: --
355: if pps%rowcount <>1 then
356: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
357: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
358: hr_utility.raise_error;
359: end if;
360: --

Line 357: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');

353: end loop pps_loop;
354: --
355: if pps%rowcount <>1 then
356: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
357: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
358: hr_utility.raise_error;
359: end if;
360: --
361: close pps;

Line 358: hr_utility.raise_error;

354: --
355: if pps%rowcount <>1 then
356: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
357: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
358: hr_utility.raise_error;
359: end if;
360: --
361: close pps;
362: --

Line 664: hr_utility.set_message('801','HR_6428_EMP_NO_ACCEPT_ASS');

660: end if;
661: --
662: exception
663: when no_accepted_assign then
664: hr_utility.set_message('801','HR_6428_EMP_NO_ACCEPT_ASS');
665: hr_utility.raise_error;
666: when others then
667: raise;
668: end;

Line 665: hr_utility.raise_error;

661: --
662: exception
663: when no_accepted_assign then
664: hr_utility.set_message('801','HR_6428_EMP_NO_ACCEPT_ASS');
665: hr_utility.raise_error;
666: when others then
667: raise;
668: end;
669: --

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

696: begin
697: open get_dates;
698: fetch get_dates into p_min_start, p_max_end;
699: if get_dates%NOTFOUND then
700: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
701: hr_utility.set_message_token('PROCEDURE','get_date_range');
702: hr_utility.set_message_token('STEP','1');
703: hr_utility.raise_error;
704: end if;

Line 701: hr_utility.set_message_token('PROCEDURE','get_date_range');

697: open get_dates;
698: fetch get_dates into p_min_start, p_max_end;
699: if get_dates%NOTFOUND then
700: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
701: hr_utility.set_message_token('PROCEDURE','get_date_range');
702: hr_utility.set_message_token('STEP','1');
703: hr_utility.raise_error;
704: end if;
705: close get_dates;

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

698: fetch get_dates into p_min_start, p_max_end;
699: if get_dates%NOTFOUND then
700: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
701: hr_utility.set_message_token('PROCEDURE','get_date_range');
702: hr_utility.set_message_token('STEP','1');
703: hr_utility.raise_error;
704: end if;
705: close get_dates;
706: end;

Line 703: hr_utility.raise_error;

699: if get_dates%NOTFOUND then
700: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
701: hr_utility.set_message_token('PROCEDURE','get_date_range');
702: hr_utility.set_message_token('STEP','1');
703: hr_utility.raise_error;
704: end if;
705: close get_dates;
706: end;
707: --

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

719: begin
720: open get_dates;
721: fetch get_dates into p_min_start, p_max_end;
722: if get_dates%NOTFOUND then
723: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
724: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
725: hr_utility.set_message_token('STEP','1');
726: hr_utility.raise_error;
727: end if;

Line 724: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');

720: open get_dates;
721: fetch get_dates into p_min_start, p_max_end;
722: if get_dates%NOTFOUND then
723: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
724: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
725: hr_utility.set_message_token('STEP','1');
726: hr_utility.raise_error;
727: end if;
728: close get_dates;

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

721: fetch get_dates into p_min_start, p_max_end;
722: if get_dates%NOTFOUND then
723: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
724: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
725: hr_utility.set_message_token('STEP','1');
726: hr_utility.raise_error;
727: end if;
728: close get_dates;
729: end;

Line 726: hr_utility.raise_error;

722: if get_dates%NOTFOUND then
723: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
724: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
725: hr_utility.set_message_token('STEP','1');
726: hr_utility.raise_error;
727: end if;
728: close get_dates;
729: end;
730: --