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_PEOPLE4_PKG dependencies on HR_UTILITY

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

196: -- If no data found and a previous hire date existed
197: -- then raise an error;
198: --
199: if p_s_hire_date is not null then
200: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Update_row');
202: hr_utility.raise_error;
203: end if;
204: end;

Line 201: hr_utility.set_message_token('PROCEDURE','Update_row');

197: -- then raise an error;
198: --
199: if p_s_hire_date is not null then
200: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Update_row');
202: hr_utility.raise_error;
203: end if;
204: end;
205: --

Line 202: hr_utility.raise_error;

198: --
199: if p_s_hire_date is not null then
200: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Update_row');
202: hr_utility.raise_error;
203: end if;
204: end;
205: --
206: -- check the integrity of the date change.

Line 387: hr_utility.raise_error;

383: ,p_person_id
384: ,p_business_group_id
385: ,p_effective_start_date) then
386: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
387: hr_utility.raise_error;
388: end if;
389: --
390: -- Ensure there are no future applicant assignments
391: --

Line 464: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');

460: -- then there is an error. Otherwise go around end_accepted
461: -- to multiple contracts.
462: --
463: if l_num_accepted_appls = l_num_appls then
464: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
465: hr_utility.raise_error;
466: else
467: p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
468: end if;

Line 465: hr_utility.raise_error;

461: -- to multiple contracts.
462: --
463: if l_num_accepted_appls = l_num_appls then
464: hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
465: hr_utility.raise_error;
466: else
467: p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
468: end if;
469: --

Line 474: hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');

470: -- Number of accepted does not equal number of current then
471: -- end_accepted.
472: --
473: elsif l_num_accepted_appls <> l_num_appls then
474: hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');
475: p_status := 'END_UNACCEPTED'; -- next code re-entry,
476: return;
477: --
478: -- Otherwise ignore end_accepted.

Line 498: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);

494: end if; -- End of END_UNACCEPTED
495: --
496: -- Test to see if multiple contracts are a possibility.
497: --
498: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
499: if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
500: if l_num_accepted_appls >1 then
501: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
502: return;

Line 501: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');

497: --
498: hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
499: if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
500: if l_num_accepted_appls >1 then
501: hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
502: return;
503: else
504: p_status := 'CHOOSE_VAC'; -- next code re-entry.
505: end if;

Line 511: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);

507: --
508: -- Choose whether to change the Primary assignment
509: -- and which vacancy is to be the primary if so.
510: --
511: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);
512: if p_status = 'CHOOSE_VAC' then
513: return;
514: end if; --End of CHOOSE_VAC
515: --

Line 520: hr_utility.set_location('update_row - b4 HIRE',1);

516: -- Can now hire the Person
517: -- Note HIRE status can only be set from client form
518: -- as interaction is generally required.
519: --
520: hr_utility.set_location('update_row - b4 HIRE',1);
521: if p_status = 'HIRE' then
522: --
523: -- If new is Emp and old was Emp_apl
524: -- then l_emp_emp_apl is set to Y

Line 535: hr_utility.set_location('update_row - b4 hrhirapl',1);

531: end if;
532: --
533: -- Run the employ_applicant stored procedure
534: --
535: hr_utility.set_location('update_row - b4 hrhirapl',1);
536: hrhirapl.employ_applicant(p_person_id
537: ,p_business_group_id
538: ,p_legislation_code
539: ,p_new_primary_id

Line 552: hr_utility.set_location('update_row - after hrhirapl',2);

548: ,l_set_of_books_id
549: ,l_employ_emp_apl
550: ,NULL
551: ,p_session_date); -- Bug 3564129
552: hr_utility.set_location('update_row - after hrhirapl',2);
553: end if; -- End of HIRE.
554: end if; -- Of Person type change checks.
555: --
556: hr_utility.set_location('update_row - b4 update',1);

Line 556: hr_utility.set_location('update_row - b4 update',1);

552: hr_utility.set_location('update_row - after hrhirapl',2);
553: end if; -- End of HIRE.
554: end if; -- Of Person type change checks.
555: --
556: hr_utility.set_location('update_row - b4 update',1);
557: update per_people_f ppf
558: set ppf.person_id = p_person_id
559: ,ppf.effective_start_date = p_effective_start_date
560: ,ppf.effective_end_date = p_effective_end_date

Line 663: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');

659: ,ppf.per_information30 = p_i30
660: where ppf.rowid = p_rowid;
661: --
662: if sql%rowcount <1 then
663: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
664: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
665: hr_utility.raise_error;
666: end if;
667: --

Line 664: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);

660: where ppf.rowid = p_rowid;
661: --
662: if sql%rowcount <1 then
663: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
664: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
665: hr_utility.raise_error;
666: end if;
667: --
668: -- Tests required post-update

Line 665: hr_utility.raise_error;

661: --
662: if sql%rowcount <1 then
663: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
664: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
665: hr_utility.raise_error;
666: end if;
667: --
668: -- Tests required post-update
669: --

Line 670: hr_utility.set_location('update_row - after update',1);

666: end if;
667: --
668: -- Tests required post-update
669: --
670: hr_utility.set_location('update_row - after update',1);
671: --
672: -- Has the Date of Birth changed?
673: --
674: if p_date_of_birth is null and

Line 692: hr_utility.set_location('update_row - after update',2);

688: ,p_start_date => p_last_update_date
689: );
690: end if;
691: --
692: hr_utility.set_location('update_row - after update',2);
693: --
694: -- test if hire_date has changed. and system person type has not.
695: --
696: if ((p_current_employee_flag = 'Y')

Line 707: hr_utility.set_location('update_row - after update',3);

703: per_people3_pkg.update_period(p_person_id =>p_person_id
704: ,p_hire_date => p_s_hire_date
705: ,p_new_hire_date =>p_hire_date);
706: --
707: hr_utility.set_location('update_row - after update',3);
708: --
709: -- Update the hire records i.e
710: -- assignment etc.
711: --

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

739: raise NO_DATA_FOUND;
740: end if;
741: exception
742: when NO_DATA_FOUND then
743: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE','Update_row');
745: hr_utility.set_message_token('STEP','4');
746: hr_utility.raise_error;
747: end;

Line 744: hr_utility.set_message_token('PROCEDURE','Update_row');

740: end if;
741: exception
742: when NO_DATA_FOUND then
743: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE','Update_row');
745: hr_utility.set_message_token('STEP','4');
746: hr_utility.raise_error;
747: end;
748: else

Line 745: hr_utility.set_message_token('STEP','4');

741: exception
742: when NO_DATA_FOUND then
743: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE','Update_row');
745: hr_utility.set_message_token('STEP','4');
746: hr_utility.raise_error;
747: end;
748: else
749: close get_pay_proposal;

Line 746: hr_utility.raise_error;

742: when NO_DATA_FOUND then
743: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
744: hr_utility.set_message_token('PROCEDURE','Update_row');
745: hr_utility.set_message_token('STEP','4');
746: hr_utility.raise_error;
747: end;
748: else
749: close get_pay_proposal;
750: end if;

Line 751: hr_utility.set_location('update_row - after update',5);

747: end;
748: else
749: close get_pay_proposal;
750: end if;
751: hr_utility.set_location('update_row - after update',5);
752: --
753: -- Run the assignment_link_usages and Element_entry
754: -- code for Assignment Criteria.
755: --

Line 848: hr_utility.set_location('hr_person.check_rehire',1);

844: v_dummy INTEGER;
845: v_dummy_fpd date;
846: --
847: begin
848: hr_utility.set_location('hr_person.check_rehire',1);
849: --
850: -- Check if old PPS row exists
851: --
852: open old_pps_exists;

Line 868: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');

864: fetch pps_not_ended into v_dummy_fpd;
865: if pps_not_ended%FOUND then
866: close pps_not_ended;
867: if v_dummy_fpd is null then
868: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
869: else
870: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
871: end if;
872: hr_utility.raise_error;

Line 870: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');

866: close pps_not_ended;
867: if v_dummy_fpd is null then
868: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
869: else
870: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
871: end if;
872: hr_utility.raise_error;
873: end if;
874: close pps_not_ended;

Line 872: hr_utility.raise_error;

868: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
869: else
870: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
871: end if;
872: hr_utility.raise_error;
873: end if;
874: close pps_not_ended;
875: else
876: close old_pps_exists;

Line 903: hr_utility.set_message('801','HR_7950_PPM_NULL_DOB');

899: --
900: if get_payroll%FOUND
901: then
902: close get_payroll;
903: hr_utility.set_message('801','HR_7950_PPM_NULL_DOB');
904: hr_utility.raise_error;
905: else
906: close get_payroll;
907: end if;

Line 904: hr_utility.raise_error;

900: if get_payroll%FOUND
901: then
902: close get_payroll;
903: hr_utility.set_message('801','HR_7950_PPM_NULL_DOB');
904: hr_utility.raise_error;
905: else
906: close get_payroll;
907: end if;
908: end;

Line 943: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');

939: --
940: if p_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
941: --
942: if p_original_date_of_hire > p_hire_date then
943: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
944: hr_utility.raise_error;
945: --
946: elsif p_person_id is not null then
947: -- commented out the following code for bug 4672540 as l_session_date is no longer needed.

Line 944: hr_utility.raise_error;

940: if p_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
941: --
942: if p_original_date_of_hire > p_hire_date then
943: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
944: hr_utility.raise_error;
945: --
946: elsif p_person_id is not null then
947: -- commented out the following code for bug 4672540 as l_session_date is no longer needed.
948: -- start of fix #3632547

Line 974: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');

970: ) then
971: l_earliest_date := p_hire_date;
972: end if;
973: if p_original_date_of_hire > l_earliest_date then
974: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
975: hr_utility.raise_error;
976: end if;
977: close csr_earliest_date;
978: end if;

Line 975: hr_utility.raise_error;

971: l_earliest_date := p_hire_date;
972: end if;
973: if p_original_date_of_hire > l_earliest_date then
974: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
975: hr_utility.raise_error;
976: end if;
977: close csr_earliest_date;
978: end if;
979: --