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.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 352: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');

348: if p_assignment_id is not null then
349: open fut_upd_asg;
350: fetch fut_upd_asg into l_dummy;
351: if fut_upd_asg%FOUND then
352: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
353: app_exception.raise_exception;
354: end if;
355: close fut_upd_asg;
356: end if;

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

357:
358: open other_asg;
359: fetch other_asg into l_dummy;
360: if other_asg%FOUND then
361: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
362: app_exception.raise_exception;
363: end if;
364: close other_asg;
365:

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

398:
399: if l_max_ele > 0 then
400: l_index := 1;
401: loop
402: hr_utility.trace('p_table(l_index).process_flag >> '||p_table(l_index).process_flag);
403: hr_utility.trace('p_table(l_index).id >> '||p_table(l_index).id);
404: if nvl(p_table(l_index).process_flag,'E') <> 'R' then
405:
406: open min_eff_date(p_table(l_index).id);

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

399: if l_max_ele > 0 then
400: l_index := 1;
401: loop
402: hr_utility.trace('p_table(l_index).process_flag >> '||p_table(l_index).process_flag);
403: hr_utility.trace('p_table(l_index).id >> '||p_table(l_index).id);
404: if nvl(p_table(l_index).process_flag,'E') <> 'R' then
405:
406: open min_eff_date(p_table(l_index).id);
407: fetch min_eff_date into l_start_date;

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

410: open fut_apl(p_table(l_index).id);
411: fetch fut_apl into l_dummy;
412: if fut_apl%FOUND then
413: close fut_apl;
414: hr_utility.trace('12345');
415: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
416: app_exception.raise_exception;
417: end if;
418: hr_utility.trace('123458');

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

411: fetch fut_apl into l_dummy;
412: if fut_apl%FOUND then
413: close fut_apl;
414: hr_utility.trace('12345');
415: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
416: app_exception.raise_exception;
417: end if;
418: hr_utility.trace('123458');
419: close fut_apl;

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

414: hr_utility.trace('12345');
415: hr_utility.set_message('801','HR_7975_ASG_INV_FUTURE_ASA');
416: app_exception.raise_exception;
417: end if;
418: hr_utility.trace('123458');
419: close fut_apl;
420: end if;
421: end if;
422: l_index := l_index + 1;

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

456: fetch pps into pps_rec;
457: end loop pps_loop;
458: --
459: if pps%rowcount <>1 then
460: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
461: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
462: hr_utility.raise_error;
463: end if;
464: --

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

457: end loop pps_loop;
458: --
459: if pps%rowcount <>1 then
460: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
461: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
462: hr_utility.raise_error;
463: end if;
464: --
465: close pps;

Line 462: hr_utility.raise_error;

458: --
459: if pps%rowcount <>1 then
460: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
461: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
462: hr_utility.raise_error;
463: end if;
464: --
465: close pps;
466: --

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

764: end if;
765: --
766: exception
767: when no_accepted_assign then
768: hr_utility.set_message('801','HR_6428_EMP_NO_ACCEPT_ASS');
769: hr_utility.raise_error;
770: when others then
771: raise;
772: end;

Line 769: hr_utility.raise_error;

765: --
766: exception
767: when no_accepted_assign then
768: hr_utility.set_message('801','HR_6428_EMP_NO_ACCEPT_ASS');
769: hr_utility.raise_error;
770: when others then
771: raise;
772: end;
773: --

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

800: begin
801: open get_dates;
802: fetch get_dates into p_min_start, p_max_end;
803: if get_dates%NOTFOUND then
804: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
805: hr_utility.set_message_token('PROCEDURE','get_date_range');
806: hr_utility.set_message_token('STEP','1');
807: hr_utility.raise_error;
808: end if;

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

801: open get_dates;
802: fetch get_dates into p_min_start, p_max_end;
803: if get_dates%NOTFOUND then
804: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
805: hr_utility.set_message_token('PROCEDURE','get_date_range');
806: hr_utility.set_message_token('STEP','1');
807: hr_utility.raise_error;
808: end if;
809: close get_dates;

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

802: fetch get_dates into p_min_start, p_max_end;
803: if get_dates%NOTFOUND then
804: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
805: hr_utility.set_message_token('PROCEDURE','get_date_range');
806: hr_utility.set_message_token('STEP','1');
807: hr_utility.raise_error;
808: end if;
809: close get_dates;
810: end;

Line 807: hr_utility.raise_error;

803: if get_dates%NOTFOUND then
804: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
805: hr_utility.set_message_token('PROCEDURE','get_date_range');
806: hr_utility.set_message_token('STEP','1');
807: hr_utility.raise_error;
808: end if;
809: close get_dates;
810: end;
811: --

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

823: begin
824: open get_dates;
825: fetch get_dates into p_min_start, p_max_end;
826: if get_dates%NOTFOUND then
827: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
829: hr_utility.set_message_token('STEP','1');
830: hr_utility.raise_error;
831: end if;

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

824: open get_dates;
825: fetch get_dates into p_min_start, p_max_end;
826: if get_dates%NOTFOUND then
827: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
829: hr_utility.set_message_token('STEP','1');
830: hr_utility.raise_error;
831: end if;
832: close get_dates;

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

825: fetch get_dates into p_min_start, p_max_end;
826: if get_dates%NOTFOUND then
827: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
829: hr_utility.set_message_token('STEP','1');
830: hr_utility.raise_error;
831: end if;
832: close get_dates;
833: end;

Line 830: hr_utility.raise_error;

826: if get_dates%NOTFOUND then
827: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE','get_asg_date_range');
829: hr_utility.set_message_token('STEP','1');
830: hr_utility.raise_error;
831: end if;
832: close get_dates;
833: end;
834: --