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_PEOPLE12_PKG dependencies on PER_PEOPLE12_PKG

Line 1: PACKAGE BODY PER_PEOPLE12_PKG AS

1: PACKAGE BODY PER_PEOPLE12_PKG AS
2: /* $Header: peper12t.pkb 120.11.12010000.2 2008/08/06 09:23:46 ubhat ship $ */
3: --
4: --
5: -- Bug fix 2824664

Line 625: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',5);

621: -- on startup = 'BEGIN'( First time called from form)
622: -- other values depend on what meesages have been returned to the client
623: -- and the re-entry point on return from the client.
624: --
625: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',5);
626: --
627: /* BEGIN OF WWBUG 1975359 */
628: open c1;
629: --

Line 646: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',10);

642: /* BEGIN OF WWBUG 1975359 */
643: --
644: if p_status = 'BEGIN' then
645: --
646: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',10);
647: -- Test to see if the hire_date_has changed
648: -- Providing Person type has not and it is emp.
649: -- Or that it has changed to EMP
650: --

Line 665: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',15);

661: -- get the period_of_service_id
662: -- 303729 if person is a supervisor
663: -- test whether change to hire_date would invalidate this action
664: --
665: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',15);
666: --
667: if ((p_hire_date <> p_s_hire_date)
668: and (p_system_person_type = p_s_system_person_type))
669: then

Line 670: per_people12_pkg.check_not_supervisor(p_person_id

666: --
667: if ((p_hire_date <> p_s_hire_date)
668: and (p_system_person_type = p_s_system_person_type))
669: then
670: per_people12_pkg.check_not_supervisor(p_person_id
671: ,p_hire_date
672: ,p_s_hire_date);
673: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',20);
674: end if;

Line 673: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',20);

669: then
670: per_people12_pkg.check_not_supervisor(p_person_id
671: ,p_hire_date
672: ,p_s_hire_date);
673: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',20);
674: end if;
675: begin
676: select pps.period_of_service_id
677: into l_period_of_service_id

Line 682: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',25);

678: from per_periods_of_service pps
679: where pps.person_id = p_person_id
680: and pps.date_start = p_s_hire_date;
681: --
682: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',25);
683: exception
684: when no_data_found then
685: --
686: -- If no data found and a previous hire date existed

Line 699: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',30);

695: --
696: -- check the integrity of the date change.
697: -- Date may come in between a person type change.
698: --
699: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',30);
700: hr_date_chk.check_hire_ref_int(p_person_id
701: ,p_business_group_id
702: ,l_period_of_service_id
703: ,p_s_hire_date

Line 709: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',35);

705: ,p_hire_date);
706: -- VT 12/05/96 bug #418637
707: -- check the existence of the recurring element entries
708: --
709: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',35);
710: per_people12_pkg.check_recur_ent(p_person_id,p_hire_date,
711: p_s_hire_date,l_warn_ee);
712: end if;
713: --

Line 710: per_people12_pkg.check_recur_ent(p_person_id,p_hire_date,

706: -- VT 12/05/96 bug #418637
707: -- check the existence of the recurring element entries
708: --
709: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',35);
710: per_people12_pkg.check_recur_ent(p_person_id,p_hire_date,
711: p_s_hire_date,l_warn_ee);
712: end if;
713: --
714: -- check session date and effective_start_date for differences

Line 721: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',40);

717: -- a global version of session date to update the rows (not good)
718: --
719: -- VT 08/13/96
720: if p_session_date <> p_effective_start_date then
721: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',40);
722: per_people9_pkg.update_old_person_row(p_person_id =>p_person_id
723: ,p_session_date => p_session_date
724: ,p_effective_start_date=>p_effective_start_date);
725: end if;

Line 740: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',45);

736: -- if p_current_employee_flag = 'Y' and
737: -- p_current_applicant_flag is null and
738: -- p_employee_number is not null then
739: -- null;
740: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',45);
741: -- else
742: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',50);
743: -- hr_person.generate_number(p_current_employee_flag
744: -- ,p_current_applicant_flag

Line 742: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',50);

738: -- p_employee_number is not null then
739: -- null;
740: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',45);
741: -- else
742: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',50);
743: -- hr_person.generate_number(p_current_employee_flag
744: -- ,p_current_applicant_flag
745: -- ,null --p_current_npw_flag
746: -- ,p_national_identifier

Line 766: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',55);

762: , p_current_employee => p_current_employee_flag
763: , p_current_applicant => p_current_applicant_flag
764: , p_current_npw => null --p_current_npw_flag
765: );
766: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',55);
767: -- VT 12/05/96 bug #418637
768: if l_warn_ee = 'Y' then
769: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
770: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.

Line 769: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);

765: );
766: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',55);
767: -- VT 12/05/96 bug #418637
768: if l_warn_ee = 'Y' then
769: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
770: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
771: else
772: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
773: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.

Line 772: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);

768: if l_warn_ee = 'Y' then
769: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
770: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
771: else
772: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
773: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
774: end if;
775: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',70);
776:

Line 775: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',70);

771: else
772: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
773: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
774: end if;
775: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',70);
776:
777: --Start of fix for Bug 2167668
778:
779: IF p_start_date > p_hold_applicant_date_until THEN

Line 790: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',75);

786: end if; -- End the First in section
787: --
788: -- VT 12/05/96 bug #418637
789: if p_status = 'RECUR_ENT_CHK' then
790: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',75);
791: return;
792: end if; -- End of RECUR_ENT_CHK
793: --
794: --

Line 808: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',80);

804: and p_s_system_person_type = 'EMP')
805: or (p_system_person_type = 'EX_EMP_APL'
806: and p_s_system_person_type = 'EX_EMP') then
807: --
808: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',80);
809: NULL;
810: -- 3652025 >> this process is replaced by call to
811: -- hr_applicant_internal.create_applicant_anytime() procedure.
812: -- called directly from PERWSEPI.pld

Line 829: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',85);

825: --
826: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
827: -- ,p_hire_date => greatest(p_hire_date
828: --,p_effective_start_date));
829: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',85);
830: --
831: -- Insert the default applicant row and applicant
832: -- assignment.
833: --

Line 850: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',90);

846: -- ,p_last_update_login => p_last_update_login
847: -- ,p_created_by => p_created_by
848: -- ,p_creation_date => p_creation_date);
849: --
850: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',90);
851: --
852: -- PTU Changes
853:
854: --hr_per_type_usage_internal.maintain_person_type_usage

Line 860: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',92);

856: -- ,p_person_id => p_person_id
857: -- ,p_person_type_id => p_person_type_id
858: -- );
859: --
860: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',92);
861: -- PTU Changes
862: -- <<
863: -- Has the Person type changed to become that of an employee
864: -- when the previous type is not a current applicant?

Line 871: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',95);

867: and ( p_s_system_person_type = 'OTHER'
868: or p_s_system_person_type = 'EX_EMP'
869: or p_s_system_person_type = 'EX_APL')) then /* Bug 523924 */
870: -- or p_s_system_person_type = 'EX_EMP')) then
871: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',95);
872: --
873: -- Ensure no future person_type_changes.
874: --
875: if hr_person.chk_future_person_type(p_s_system_person_type

Line 888: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',100);

884: end if;
885: --
886: if p_s_system_person_type = 'EX_EMP'
887: then
888: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',100);
889: --
890: -- Bug 3154253 stars here.
891: -- Passed earlier of p_ession_date and p_hire_date
892: -- (p_effective_start_date) to the check_hire procedure.

Line 895: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);

891: -- Passed earlier of p_ession_date and p_hire_date
892: -- (p_effective_start_date) to the check_hire procedure.
893: --
894: if p_session_date < p_effective_start_date then
895: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
896: per_people12_pkg.check_rehire(p_person_id, p_session_date);
897: else
898: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
899: per_people12_pkg.check_rehire(p_person_id, p_hire_date);

Line 896: per_people12_pkg.check_rehire(p_person_id, p_session_date);

892: -- (p_effective_start_date) to the check_hire procedure.
893: --
894: if p_session_date < p_effective_start_date then
895: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
896: per_people12_pkg.check_rehire(p_person_id, p_session_date);
897: else
898: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
899: per_people12_pkg.check_rehire(p_person_id, p_hire_date);
900: end if;

Line 898: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);

894: if p_session_date < p_effective_start_date then
895: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
896: per_people12_pkg.check_rehire(p_person_id, p_session_date);
897: else
898: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
899: per_people12_pkg.check_rehire(p_person_id, p_hire_date);
900: end if;
901: --
902: -- bug 3154253 ends here.

Line 899: per_people12_pkg.check_rehire(p_person_id, p_hire_date);

895: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
896: per_people12_pkg.check_rehire(p_person_id, p_session_date);
897: else
898: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
899: per_people12_pkg.check_rehire(p_person_id, p_hire_date);
900: end if;
901: --
902: -- bug 3154253 ends here.
903: --

Line 904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);

900: end if;
901: --
902: -- bug 3154253 ends here.
903: --
904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);
905: end if;
906: per_people12_pkg.check_future_changes(p_person_id
907: ,p_effective_start_date);
908: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);

Line 906: per_people12_pkg.check_future_changes(p_person_id

902: -- bug 3154253 ends here.
903: --
904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);
905: end if;
906: per_people12_pkg.check_future_changes(p_person_id
907: ,p_effective_start_date);
908: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);
909: --
910: -- Ensure there are no future applicant assignments

Line 908: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);

904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);
905: end if;
906: per_people12_pkg.check_future_changes(p_person_id
907: ,p_effective_start_date);
908: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);
909: --
910: -- Ensure there are no future applicant assignments
911: --
912: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',115);

923: per_people3_pkg.check_future_apl(p_person_id => p_person_id
924: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
925: end if;
926:
927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',115);
928: --
929: -- Insert the default period_of service and assignment
930: -- rows.
931: --

Line 950: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',120);

946: ,p_created_by => p_created_by
947: ,p_creation_date => p_creation_date
948: ,p_adjusted_svc_date => p_adjusted_svc_date);
949: --
950: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',120);
951:
952: -- PTU Changes
953:
954: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

Line 960: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1201);

956: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
957: and p_system_person_type = 'EMP'
958: -- and p_session_date = p_effective_start_date then
959: and l_back2back then
960: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1201);
961: hr_per_type_usage_internal.maintain_person_type_usage
962: (p_effective_date => p_effective_start_date
963: ,p_person_id => p_person_id
964: ,p_person_type_id => p_person_type_id

Line 973: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1202);

969: (p_effective_date => p_effective_start_date
970: ,p_person_id => p_person_id
971: ,p_person_type_id => p_person_type_id
972: );
973: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1202);
974: end if;
975:
976: -- PTU Changes
977:

Line 978: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',121);

974: end if;
975:
976: -- PTU Changes
977:
978: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',121);
979:
980: -- Has the Person become an Employee or Employee applicant from being an
981: -- applicant or employee applicant?
982: --

Line 989: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',125);

985: or (p_system_person_type = 'EMP_APL'
986: and p_s_system_person_type in ('APL','EX_EMP_APL')) /* Bug 732598 */
987: or (p_system_person_type = 'EMP'
988: and p_s_system_person_type = 'EMP_APL')) then
989: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',125);
990: --
991: -- Ensure no future person_type_changes.
992: --
993: if hr_person.chk_future_person_type(p_s_system_person_type

Line 1018: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',130);

1014: per_people3_pkg.check_future_apl(p_person_id => p_person_id
1015: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
1016: end if;
1017:
1018: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',130);
1019: --
1020: -- Check if the person have open term_assignment records. These can be
1021: -- found by checking if the person have a periods_of_service with
1022: -- no FPD and a value for ATD. Bug 2881076

Line 1023: per_people12_pkg.check_rehire(p_person_id

1019: --
1020: -- Check if the person have open term_assignment records. These can be
1021: -- found by checking if the person have a periods_of_service with
1022: -- no FPD and a value for ATD. Bug 2881076
1023: per_people12_pkg.check_rehire(p_person_id
1024: ,p_hire_date);
1025: --
1026: -- Check that the change is valid.
1027: --

Line 1030: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',135);

1026: -- Check that the change is valid.
1027: --
1028: if p_status = 'VACANCY_CHECK' then
1029: loop
1030: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',135);
1031: exit when p_status = 'BOOKINGS_EXIST';
1032: --
1033: -- Check each vacancy,if it is oversubscribed
1034: -- l_fire_warning = 'Y', return to client

Line 1039: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',140);

1035: -- displaying relevant message.
1036: -- on return l_vacancy_id starts the cursor at the
1037: -- relevant point.
1038: --
1039: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',140);
1040: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
1041: ,p_fire_warning => l_fire_warning
1042: ,p_vacancy_id => p_vacancy_id
1043: -- **** Start new code for bug 2264569 ****************

Line 1048: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',145);

1044: ,p_table => p_tab -- #2381925
1045: -- **** End new code for bug 2264569 *****************
1046: );
1047: if l_fire_warning = 'Y' then
1048: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',145);
1049: return;
1050: elsif l_fire_warning = 'N' then
1051: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
1052: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.

Line 1051: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);

1047: if l_fire_warning = 'Y' then
1048: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',145);
1049: return;
1050: elsif l_fire_warning = 'N' then
1051: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
1052: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
1053: end if;
1054: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
1055: end loop;

Line 1054: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);

1050: elsif l_fire_warning = 'N' then
1051: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
1052: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
1053: end if;
1054: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
1055: end loop;
1056: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',160);
1057: end if; -- End of VACANCY_CHECK
1058: --

Line 1056: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',160);

1052: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
1053: end if;
1054: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
1055: end loop;
1056: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',160);
1057: end if; -- End of VACANCY_CHECK
1058: --
1059: if p_status = 'BOOKINGS_EXIST' then
1060: -- VT 09/18/96 #288087, #380280 , #2172590

Line 1064: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);

1060: -- VT 09/18/96 #288087, #380280 , #2172590
1061: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
1062: ,p_business_group_id =>p_business_group_id
1063: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
1064: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
1065: return;
1066: else
1067: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',170);
1068: -- **** Start commented code for bug 2264569 *************************

Line 1067: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',170);

1063: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
1064: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
1065: return;
1066: else
1067: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',170);
1068: -- **** Start commented code for bug 2264569 *************************
1069: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
1070: -- **** End commented code for bug 2264569 ***************************
1071: -- **** Start new code for bug 2264569 ***************************

Line 1075: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',175);

1071: -- **** Start new code for bug 2264569 ***************************
1072: p_status := 'CHOOSE_VAC'; -- Set next possible re-entry point.
1073: -- **** End new code for bug 2264569 *********************************
1074: end if;
1075: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',175);
1076: end if;
1077: if p_status = 'END_BOOKINGS' then
1078: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
1079: hrhirapl.end_bookings(p_person_id

Line 1078: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);

1074: end if;
1075: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',175);
1076: end if;
1077: if p_status = 'END_BOOKINGS' then
1078: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
1079: hrhirapl.end_bookings(p_person_id
1080: , p_business_group_id
1081: , p_hire_date);
1082: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',185);

Line 1082: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',185);

1078: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
1079: hrhirapl.end_bookings(p_person_id
1080: , p_business_group_id
1081: , p_hire_date);
1082: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',185);
1083: --
1084: -- **** START commented code for bug 2264569 *************************** --
1085: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
1086: -- **** End commented code for bug 2264569 ************************

Line 1102: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',190);

1098: -- if p_status='GET_APPLS' then
1099: --
1100: -- Get all the accepted applicants
1101: --
1102: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',190);
1103: -- per_people3_pkg.get_accepted_appls(p_person_id => p_person_id
1104: -- ,p_num_accepted_appls => l_num_accepted_appls
1105: -- ,p_new_primary_id =>p_new_primary_id);
1106: --

Line 1109: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',195);

1105: -- ,p_new_primary_id =>p_new_primary_id);
1106: --
1107: -- Get all current applicant assignments.
1108: --
1109: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',195);
1110: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
1111: -- ,p_num_appls => l_num_appls);
1112: --
1113: -- if p_system_person_type = 'EMP_APL' then

Line 1114: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',200);

1110: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
1111: -- ,p_num_appls => l_num_appls);
1112: --
1113: -- if p_system_person_type = 'EMP_APL' then
1114: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',200);
1115: --
1116: -- If we have got this far then there must be > 0 Accepted
1117: -- applications,therefore check p_system_person_type if EMP_APL
1118: -- and number of accepted is equal to number of current assignments

Line 1126: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',205);

1122: -- if l_num_accepted_appls = l_num_appls then
1123: -- hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
1124: -- hr_utility.raise_error;
1125: -- else
1126: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',205);
1127: -- p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
1128: -- end if;
1129: -- --
1130: -- Number of accepted does not equal number of current then

Line 1132: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',210);

1128: -- end if;
1129: -- --
1130: -- Number of accepted does not equal number of current then
1131: -- end_accepted.
1132: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',210);
1133: --
1134: -- elsif l_num_accepted_appls <> l_num_appls then
1135: -- hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');
1136: -- p_status := 'END_UNACCEPTED'; -- next code re-entry,

Line 1142: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',215);

1138: -- --
1139: -- Otherwise ignore end_accepted.
1140: --
1141: -- else
1142: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',215);
1143: -- p_status := 'MULTIPLE_CONTRACTS'; -- next code re-entry.
1144: -- end if;
1145: -- end if; -- End of GET_APPLS
1146: --

Line 1151: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',220);

1147: -- if p_status = 'END_UNACCEPTED' then
1148: --
1149: -- End the unaccepted assignments.
1150: --
1151: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',220);
1152: -- hrhirapl.end_unaccepted_app_assign(p_person_id
1153: -- ,p_business_group_id
1154: -- ,p_legislation_code
1155: -- ,p_session_date);

Line 1156: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',225);

1152: -- hrhirapl.end_unaccepted_app_assign(p_person_id
1153: -- ,p_business_group_id
1154: -- ,p_legislation_code
1155: -- ,p_session_date);
1156: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',225);
1157: -- p_status := 'MULTIPLE_CONTRACTS';
1158: -- end if; -- End of END_UNACCEPTED
1159: -- --
1160: -- -- Test to see if multiple contracts are a possibility.

Line 1169: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);

1165: -- hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
1166: -- return;
1167: -- else
1168: -- p_status := 'CHOOSE_VAC'; -- next code re-entry.
1169: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);
1170: -- end if;
1171: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',235);
1172: -- end if; -- End of MULTIPLE_CONTRACTS
1173: --

Line 1171: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',235);

1167: -- else
1168: -- p_status := 'CHOOSE_VAC'; -- next code re-entry.
1169: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);
1170: -- end if;
1171: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',235);
1172: -- end if; -- End of MULTIPLE_CONTRACTS
1173: --
1174: -- **** END commented code for bug 2264569 ****************************
1175: --

Line 1181: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',240);

1177: -- and which vacancy is to be the primary if so.
1178: --
1179: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);
1180: if p_status = 'CHOOSE_VAC' then
1181: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',240);
1182: return;
1183: end if; --End of CHOOSE_VAC
1184: --
1185: -- Can now hire the Person

Line 1194: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',245);

1190: -- +-------------------------------------------------------------------+
1191: -- +--------- BEGIN: Hire process -------------------------------------+
1192: -- +-------------------------------------------------------------------+
1193: if p_status = 'HIRE' then
1194: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',245);
1195:
1196: -- bug fix 2824664:
1197: if p_update_primary = 'Y'
1198: and future_pactid_exists(p_person_id, p_effective_start_date)

Line 1200: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',246);

1196: -- bug fix 2824664:
1197: if p_update_primary = 'Y'
1198: and future_pactid_exists(p_person_id, p_effective_start_date)
1199: then
1200: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',246);
1201: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
1202: hr_utility.raise_error;
1203: end if;
1204: -- end bug fix 2824664

Line 1211: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',250);

1207: -- then l_emp_emp_apl is set to Y
1208: --
1209: if p_system_person_type = 'EMP'
1210: and p_s_system_person_type = 'EMP_APL' then
1211: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',250);
1212: l_employ_emp_apl := 'Y';
1213: else
1214: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',255);
1215: l_employ_emp_apl := 'N';

Line 1214: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',255);

1210: and p_s_system_person_type = 'EMP_APL' then
1211: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',250);
1212: l_employ_emp_apl := 'Y';
1213: else
1214: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',255);
1215: l_employ_emp_apl := 'N';
1216: end if;
1217: --
1218: -- Run the employ_applicant stored procedure

Line 1223: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',257);

1219: --
1220: hr_utility.set_location('update_row - b4 hrhirapl',1);
1221: -- **** Start new code for bug 2264569 *****************************
1222: -- End date chosen unaccepted applicant assignments
1223: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',257);
1224: hrhirapl.end_unaccepted_app_assign(p_person_id
1225: ,p_business_group_id
1226: ,p_legislation_code
1227: ,p_session_date

Line 1233: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',259);

1229: hr_utility.set_location('update_row - b4 hrhirapl',2);
1230:
1231: -- **** End new code for bug 2264569 *****************************
1232:
1233: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',259);
1234: hrhirapl.employ_applicant(p_person_id
1235: ,p_business_group_id
1236: ,p_legislation_code
1237: ,p_new_primary_id

Line 1267: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);

1263: --
1264: -- **** START new code for bug 2264569 ******************************************
1265: -- Update the system person type to EMP_APL if user is keeping active APPLS.
1266: if hr_employee_applicant_api.retain_exists(p_tab) then
1267: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
1268: p_system_person_type := 'EMP_APL';
1269: open c_apl_flag(p_system_person_type);
1270: fetch c_apl_flag into p_current_applicant_flag;
1271: close c_apl_flag;

Line 1289: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1211);

1285: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL')
1286: and p_system_person_type = 'EMP'
1287: -- and p_session_date = p_effective_start_date then
1288: and l_back2back then
1289: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1211);
1290: hr_per_type_usage_internal.maintain_person_type_usage
1291: (p_effective_date => p_effective_start_date
1292: ,p_person_id => p_person_id
1293: ,p_person_type_id => p_person_type_id

Line 1302: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1212);

1298: (p_effective_date => p_effective_start_date
1299: ,p_person_id => p_person_id
1300: ,p_person_type_id => p_person_type_id
1301: );
1302: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1212);
1303: end if;
1304: -- Bug 3637893 Ends
1305: --
1306: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);

Line 1306: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);

1302: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1212);
1303: end if;
1304: -- Bug 3637893 Ends
1305: --
1306: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
1307: -- **** Start new code for bug 2264569 **********************************
1308: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
1309: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);
1310: -- **** End new code for bug 2264569 **********************************

Line 1309: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);

1305: --
1306: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
1307: -- **** Start new code for bug 2264569 **********************************
1308: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
1309: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);
1310: -- **** End new code for bug 2264569 **********************************
1311: hr_per_type_usage_internal.maintain_person_type_usage
1312: (p_effective_date => p_effective_start_date
1313: ,p_person_id => p_person_id

Line 1328: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',265);

1324: end if; -- End of hire
1325: -- +-------------------------------------------------------------------+
1326: -- +----------- END: Hire process -------------------------------------+
1327: -- +-------------------------------------------------------------------+
1328: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',265);
1329: end if; -- End of HIRE.
1330: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',270);
1331: end if; -- Of Person type change checks.
1332: --

Line 1330: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',270);

1326: -- +----------- END: Hire process -------------------------------------+
1327: -- +-------------------------------------------------------------------+
1328: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',265);
1329: end if; -- End of HIRE.
1330: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',270);
1331: end if; -- Of Person type change checks.
1332: --
1333: -- changed p_rowid => null to p_rowid => p_rowid
1334: --

Line 1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);

1405:
1406: end if;
1407:
1408: hr_utility.set_location('update_row - b4 update',1);
1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(

Line 1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);

1406: end if;
1407:
1408: hr_utility.set_location('update_row - b4 update',1);
1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
1414: p_business_group_id,p_system_person_type),272);

Line 1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);

1407:
1408: hr_utility.set_location('update_row - b4 update',1);
1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
1414: p_business_group_id,p_system_person_type),272);
1415:

Line 1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);

1408: hr_utility.set_location('update_row - b4 update',1);
1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
1414: p_business_group_id,p_system_person_type),272);
1415:
1416: -- Bug 6196362 Starts.

Line 1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(

1409: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
1410: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
1411: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
1412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
1414: p_business_group_id,p_system_person_type),272);
1415:
1416: -- Bug 6196362 Starts.
1417: -- update per_people_f ppf

Line 1578: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',275);

1574: end if;
1575: --
1576:
1577: -- Start of Fix #2447513
1578: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',275);
1579: --End of Fix
1580:
1581: -- Tests required post-update
1582: --

Line 1608: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',280);

1604: -- Has the Date of Birth changed?
1605: --
1606: if p_date_of_birth is null and
1607: p_s_date_of_birth is not null then
1608: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',280);
1609: per_people12_pkg.check_birth_date(p_person_id);
1610: end if;
1611: if p_date_of_birth <> p_s_date_of_birth then
1612: --

Line 1609: per_people12_pkg.check_birth_date(p_person_id);

1605: --
1606: if p_date_of_birth is null and
1607: p_s_date_of_birth is not null then
1608: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',280);
1609: per_people12_pkg.check_birth_date(p_person_id);
1610: end if;
1611: if p_date_of_birth <> p_s_date_of_birth then
1612: --
1613: -- Run the assignment_link_usages and Element_entry

Line 1617: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',282);

1613: -- Run the assignment_link_usages and Element_entry
1614: -- code for Change of Personal qualifying conditions.
1615: --
1616: --
1617: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',282);
1618: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
1619: ,p_business_group_id=>p_business_group_id
1620: ,p_person_id =>p_person_id
1621: ,p_old_start =>p_s_hire_date

Line 1624: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',285);

1620: ,p_person_id =>p_person_id
1621: ,p_old_start =>p_s_hire_date
1622: ,p_start_date => p_last_update_date
1623: );
1624: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',285);
1625: end if;
1626: --
1627: hr_utility.set_location('update_row - after update',2);
1628: --

Line 1645: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);

1641: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
1642: ) then
1643: --
1644: -- Update the period of service for the employee
1645: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);
1646: --
1647: per_people3_pkg.update_period(p_person_id =>p_person_id
1648: ,p_hire_date => p_s_hire_date
1649: ,p_new_hire_date =>p_hire_date

Line 1672: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',295);

1668: ,p_last_updated_by
1669: ,p_last_update_login);
1670: End if;
1671: --
1672: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',295);
1673: -- Commented, as this action is being done in
1674: -- hr_change_start_date_api.update_pay_proposal (pehirapi.pkb)
1675: -- open get_pay_proposal;
1676: -- fetch get_pay_proposal into v_dummy;

Line 1704: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);

1700: -- hr_utility.set_message_token('STEP','4');
1701: -- hr_utility.raise_error;
1702: -- end;
1703: -- else
1704: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);
1705: -- close get_pay_proposal;
1706: -- end if;
1707: hr_utility.set_location('update_row - after update',5);
1708: --

Line 1725: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',305);

1721: ,p_old_date_start => p_s_hire_date
1722: ,p_person_id => p_person_id
1723: ,p_system_person_type => 'EMP'
1724: );
1725: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',305);
1726: --
1727: -- PTU : end of changes
1728: --
1729: --

Line 1739: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',310);

1735: ,p_person_id =>p_person_id
1736: ,p_old_start =>p_s_hire_date
1737: ,p_start_date => p_hire_date);
1738: --
1739: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',310);
1740: --
1741: end if;
1742: --
1743: -- 1766066, contact start date enh. start

Line 1767: hr_utility.set_location('Leaving PER_PEOPLE12_PKG.update_row1',315);

1763: p_action => 'UPDATE');
1764: --*/
1765: --
1766: p_status := 'END'; -- Status required to end update loop on server
1767: hr_utility.set_location('Leaving PER_PEOPLE12_PKG.update_row1',315);
1768: --
1769: end update_row1;
1770: --
1771: procedure check_future_changes(p_person_id NUMBER

Line 1882: l_proc := 'per_people12_pkg.check_rehire';

1878: --
1879: -- 115.67 (END)
1880: --
1881: begin
1882: l_proc := 'per_people12_pkg.check_rehire';
1883: hr_utility.set_location('Entering '||l_proc,5);
1884: --
1885: -- 115.67 (START)
1886: --

Line 2100: l_proc varchar2(100) := 'per_people12_pkg.ins_or_upd_precursor_row';

2096: and ppt.default_flag = 'Y'
2097: and ppt.active_flag = 'Y'
2098: and ppt.system_person_type = 'OTHER';
2099: --
2100: l_proc varchar2(100) := 'per_people12_pkg.ins_or_upd_precursor_row';
2101: l_per_rec per_all_people_f%rowtype;
2102: l_system_person_type varchar2(60);
2103: l_dummy varchar2(10);
2104: l_cov_date_start date;

Line 2408: l_proc varchar2(100) := 'per_people12_pkg.maintain_coverage';

2404: select max(date_start)
2405: from per_periods_of_service
2406: where person_id = c_person_id;
2407: --
2408: l_proc varchar2(100) := 'per_people12_pkg.maintain_coverage';
2409: l_cov_date_start date;
2410: l_person_id number;
2411: l_contact_person_id number;
2412: l_ctr_date_start date;

Line 2455: END PER_PEOPLE12_PKG;

2451: hr_utility.set_location('Leaving '||l_proc,40);
2452: end maintain_coverage;
2453: --
2454: --
2455: END PER_PEOPLE12_PKG;