APPS.PER_PEOPLE12_PKG dependencies on HR_UTILITY

Line 412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',5);

408: -- on startup = 'BEGIN'( First time called from form)
409: -- other values depend on what meesages have been returned to the client
410: -- and the re-entry point on return from the client.
411: --
412: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',5);
413: --
414: /* BEGIN OF WWBUG 1975359 */
415: open c1;
416: --

Line 433: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',10);

429: /* BEGIN OF WWBUG 1975359 */
430: --
431: if p_status = 'BEGIN' then
432: --
433: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',10);
434: -- Test to see if the hire_date_has changed
435: -- Providing Person type has not and it is emp.
436: -- Or that it has changed to EMP
437: --

Line 452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',15);

448: -- get the period_of_service_id
449: -- 303729 if person is a supervisor
450: -- test whether change to hire_date would invalidate this action
451: --
452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',15);
453: --
454: if ((p_hire_date <> p_s_hire_date)
455: and (p_system_person_type = p_s_system_person_type))
456: then

Line 460: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',20);

456: then
457: per_people12_pkg.check_not_supervisor(p_person_id
458: ,p_hire_date
459: ,p_s_hire_date);
460: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',20);
461: end if;
462: begin
463: select pps.period_of_service_id
464: into l_period_of_service_id

Line 469: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',25);

465: from per_periods_of_service pps
466: where pps.person_id = p_person_id
467: and pps.date_start = p_s_hire_date;
468: --
469: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',25);
470: exception
471: when no_data_found then
472: --
473: -- If no data found and a previous hire date existed

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

473: -- If no data found and a previous hire date existed
474: -- then raise an error;
475: --
476: if p_s_hire_date is not null then
477: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
478: hr_utility.set_message_token('PROCEDURE','update_row2');
479: hr_utility.raise_error;
480: end if;
481: end;

Line 478: hr_utility.set_message_token('PROCEDURE','update_row2');

474: -- then raise an error;
475: --
476: if p_s_hire_date is not null then
477: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
478: hr_utility.set_message_token('PROCEDURE','update_row2');
479: hr_utility.raise_error;
480: end if;
481: end;
482: --

Line 479: hr_utility.raise_error;

475: --
476: if p_s_hire_date is not null then
477: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
478: hr_utility.set_message_token('PROCEDURE','update_row2');
479: hr_utility.raise_error;
480: end if;
481: end;
482: --
483: -- check the integrity of the date change.

Line 486: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',30);

482: --
483: -- check the integrity of the date change.
484: -- Date may come in between a person type change.
485: --
486: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',30);
487: hr_date_chk.check_hire_ref_int(p_person_id
488: ,p_business_group_id
489: ,l_period_of_service_id
490: ,p_s_hire_date

Line 496: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',35);

492: ,p_hire_date);
493: -- VT 12/05/96 bug #418637
494: -- check the existence of the recurring element entries
495: --
496: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',35);
497: per_people12_pkg.check_recur_ent(p_person_id,p_hire_date,
498: p_s_hire_date,l_warn_ee);
499: end if;
500: --

Line 508: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',40);

504: -- a global version of session date to update the rows (not good)
505: --
506: -- VT 08/13/96
507: if p_session_date <> p_effective_start_date then
508: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',40);
509: per_people9_pkg.update_old_person_row(p_person_id =>p_person_id
510: ,p_session_date => p_session_date
511: ,p_effective_start_date=>p_effective_start_date);
512: end if;

Line 527: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',45);

523: -- if p_current_employee_flag = 'Y' and
524: -- p_current_applicant_flag is null and
525: -- p_employee_number is not null then
526: -- null;
527: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',45);
528: -- else
529: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',50);
530: -- hr_person.generate_number(p_current_employee_flag
531: -- ,p_current_applicant_flag

Line 529: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',50);

525: -- p_employee_number is not null then
526: -- null;
527: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',45);
528: -- else
529: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',50);
530: -- hr_person.generate_number(p_current_employee_flag
531: -- ,p_current_applicant_flag
532: -- ,null --p_current_npw_flag
533: -- ,p_national_identifier

Line 553: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',55);

549: , p_current_employee => p_current_employee_flag
550: , p_current_applicant => p_current_applicant_flag
551: , p_current_npw => null --p_current_npw_flag
552: );
553: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',55);
554: -- VT 12/05/96 bug #418637
555: if l_warn_ee = 'Y' then
556: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',60);
557: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.

Line 556: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',60);

552: );
553: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',55);
554: -- VT 12/05/96 bug #418637
555: if l_warn_ee = 'Y' then
556: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',60);
557: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
558: else
559: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',65);
560: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.

Line 559: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',65);

555: if l_warn_ee = 'Y' then
556: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',60);
557: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
558: else
559: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',65);
560: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
561: end if;
562: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',70);
563:

Line 562: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',70);

558: else
559: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',65);
560: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
561: end if;
562: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',70);
563:
564: --Start of fix for Bug 2167668
565:
566: IF p_start_date > p_hold_applicant_date_until THEN

Line 567: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');

563:
564: --Start of fix for Bug 2167668
565:
566: IF p_start_date > p_hold_applicant_date_until THEN
567: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
568: hr_utility.set_message_token('HOLD_DATE', p_start_date );
569: hr_utility.raise_error;
570: END IF;
571:

Line 568: hr_utility.set_message_token('HOLD_DATE', p_start_date );

564: --Start of fix for Bug 2167668
565:
566: IF p_start_date > p_hold_applicant_date_until THEN
567: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
568: hr_utility.set_message_token('HOLD_DATE', p_start_date );
569: hr_utility.raise_error;
570: END IF;
571:
572: -- End of fix for Bug 2167668

Line 569: hr_utility.raise_error;

565:
566: IF p_start_date > p_hold_applicant_date_until THEN
567: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
568: hr_utility.set_message_token('HOLD_DATE', p_start_date );
569: hr_utility.raise_error;
570: END IF;
571:
572: -- End of fix for Bug 2167668
573: end if; -- End the First in section

Line 577: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',75);

573: end if; -- End the First in section
574: --
575: -- VT 12/05/96 bug #418637
576: if p_status = 'RECUR_ENT_CHK' then
577: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',75);
578: return;
579: end if; -- End of RECUR_ENT_CHK
580: --
581: --

Line 595: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',80);

591: and p_s_system_person_type = 'EMP')
592: or (p_system_person_type = 'EX_EMP_APL'
593: and p_s_system_person_type = 'EX_EMP') then
594: --
595: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',80);
596: l_create_apl := 'Y';
597: -- 3652025 >> this process is replaced by call to
598: -- hr_applicant_internal.create_applicant_anytime() procedure.
599: -- called directly from PERWSEPI.pld

Line 616: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',85);

612: --
613: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
614: -- ,p_hire_date => greatest(p_hire_date
615: --,p_effective_start_date));
616: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',85);
617: --
618: -- Insert the default applicant row and applicant
619: -- assignment.
620: --

Line 637: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',90);

633: -- ,p_last_update_login => p_last_update_login
634: -- ,p_created_by => p_created_by
635: -- ,p_creation_date => p_creation_date);
636: --
637: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',90);
638: --
639: -- PTU Changes
640:
641: --hr_per_type_usage_internal.maintain_person_type_usage

Line 647: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',92);

643: -- ,p_person_id => p_person_id
644: -- ,p_person_type_id => p_person_type_id
645: -- );
646: --
647: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',92);
648: -- PTU Changes
649: -- <<
650: -- Has the Person type changed to become that of an employee
651: -- when the previous type is not a current applicant?

Line 658: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',95);

654: and ( p_s_system_person_type = 'OTHER'
655: or p_s_system_person_type = 'EX_EMP'
656: or p_s_system_person_type = 'EX_APL')) then /* Bug 523924 */
657: -- or p_s_system_person_type = 'EX_EMP')) then
658: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',95);
659: --
660: -- Ensure no future person_type_changes.
661: --
662: if hr_person.fpt_check_ft_person_type(p_s_system_person_type

Line 674: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',100);

670: end if;
671: --
672: if p_s_system_person_type = 'EX_EMP'
673: then
674: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',100);
675: --
676: -- Bug 3154253 stars here.
677: -- Passed earlier of p_ession_date and p_hire_date
678: -- (p_effective_start_date) to the check_hire procedure.

Line 681: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',101);

677: -- Passed earlier of p_ession_date and p_hire_date
678: -- (p_effective_start_date) to the check_hire procedure.
679: --
680: if p_session_date < p_effective_start_date then
681: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',101);
682: per_people12_pkg.check_rehire(p_person_id, p_session_date);
683: else
684: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',102);
685: per_people12_pkg.check_rehire(p_person_id, p_hire_date);

Line 684: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',102);

680: if p_session_date < p_effective_start_date then
681: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',101);
682: per_people12_pkg.check_rehire(p_person_id, p_session_date);
683: else
684: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',102);
685: per_people12_pkg.check_rehire(p_person_id, p_hire_date);
686: end if;
687: --
688: -- bug 3154253 ends here.

Line 690: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',105);

686: end if;
687: --
688: -- bug 3154253 ends here.
689: --
690: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',105);
691: end if;
692: per_people12_pkg.check_future_changes(p_person_id
693: ,p_effective_start_date);
694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',110);

Line 694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',110);

690: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',105);
691: end if;
692: per_people12_pkg.check_future_changes(p_person_id
693: ,p_effective_start_date);
694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',110);
695: --
696: -- Ensure there are no future applicant assignments
697: --
698: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 713: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',115);

709: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
710: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
711: end if;
712:
713: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',115);
714: --
715: -- Insert the default period_of service and assignment
716: -- rows.
717: --

Line 736: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',120);

732: ,p_created_by => p_created_by
733: ,p_creation_date => p_creation_date
734: ,p_adjusted_svc_date => p_adjusted_svc_date);
735: --
736: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',120);
737:
738: -- PTU Changes
739:
740: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

Line 746: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1201);

742: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
743: and p_system_person_type = 'EMP'
744: -- and p_session_date = p_effective_start_date then
745: and l_back2back then
746: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1201);
747: hr_per_type_usage_internal.maintain_person_type_usage
748: (p_effective_date => p_effective_start_date
749: ,p_person_id => p_person_id
750: ,p_person_type_id => p_person_type_id

Line 759: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1202);

755: (p_effective_date => p_effective_start_date
756: ,p_person_id => p_person_id
757: ,p_person_type_id => p_person_type_id
758: );
759: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1202);
760: end if;
761:
762: -- PTU Changes
763:

Line 764: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',121);

760: end if;
761:
762: -- PTU Changes
763:
764: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',121);
765:
766: -- Has the Person become an Employee or Employee applicant from being an
767: -- applicant or employee applicant?
768: --

Line 775: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',125);

771: or (p_system_person_type = 'EMP_APL'
772: and p_s_system_person_type in ('APL','EX_EMP_APL')) /* Bug 732598 */
773: or (p_system_person_type = 'EMP'
774: and p_s_system_person_type = 'EMP_APL')) then
775: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',125);
776: --
777: -- Ensure no future person_type_changes.
778: --
779: -- ER FPT

Line 787: hr_utility.raise_error;

783: ,p_business_group_id
784: ,'Y'
785: ,p_effective_start_date) then
786: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
787: hr_utility.raise_error;
788: end if;
789:
790: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',126);
791:

Line 790: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',126);

786: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
787: hr_utility.raise_error;
788: end if;
789:
790: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',126);
791:
792: l_max_ele := p_tab.COUNT;
793: if l_max_ele > 0 then
794: -- there should not be any future 'E' asgs

Line 796: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',127);

792: l_max_ele := p_tab.COUNT;
793: if l_max_ele > 0 then
794: -- there should not be any future 'E' asgs
795: -- there should not be any updates to the asgt on which it's hired >= hire date
796: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',127);
797: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
798: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
799: ,p_table=>p_tab);
800:

Line 804: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',128);

800:
801: else
802: -- there should not be any future 'E' (employee) asgs
803: -- there should not be any updates to the asgt on which it's hired or the appln chosen to End >= hire date
804: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',128);
805: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
806: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
807: ,p_assignment_id => p_new_primary_id);
808: end if;

Line 810: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',130);

806: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
807: ,p_assignment_id => p_new_primary_id);
808: end if;
809:
810: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',130);
811: --
812: -- Check if the person have open term_assignment records. These can be
813: -- found by checking if the person have a periods_of_service with
814: -- no FPD and a value for ATD. Bug 2881076

Line 822: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',135);

818: -- Check that the change is valid.
819: --
820: if p_status = 'VACANCY_CHECK' then
821: loop
822: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',135);
823: exit when p_status = 'BOOKINGS_EXIST';
824: --
825: -- Check each vacancy,if it is oversubscribed
826: -- l_fire_warning = 'Y', return to client

Line 831: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',140);

827: -- displaying relevant message.
828: -- on return l_vacancy_id starts the cursor at the
829: -- relevant point.
830: --
831: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',140);
832: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
833: ,p_fire_warning => l_fire_warning
834: ,p_vacancy_id => p_vacancy_id
835: -- **** Start new code for bug 2264569 ****************

Line 840: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',145);

836: ,p_table => p_tab -- #2381925
837: -- **** End new code for bug 2264569 *****************
838: );
839: if l_fire_warning = 'Y' then
840: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',145);
841: return;
842: elsif l_fire_warning = 'N' then
843: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',150);
844: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.

Line 843: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',150);

839: if l_fire_warning = 'Y' then
840: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',145);
841: return;
842: elsif l_fire_warning = 'N' then
843: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',150);
844: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
845: end if;
846: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',155);
847: end loop;

Line 846: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',155);

842: elsif l_fire_warning = 'N' then
843: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',150);
844: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
845: end if;
846: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',155);
847: end loop;
848: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',160);
849: end if; -- End of VACANCY_CHECK
850: --

Line 848: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',160);

844: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
845: end if;
846: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',155);
847: end loop;
848: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',160);
849: end if; -- End of VACANCY_CHECK
850: --
851: if p_status = 'BOOKINGS_EXIST' then
852: -- VT 09/18/96 #288087, #380280 , #2172590

Line 856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',165);

852: -- VT 09/18/96 #288087, #380280 , #2172590
853: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
854: ,p_business_group_id =>p_business_group_id
855: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',165);
857: return;
858: else
859: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',170);
860: -- **** Start commented code for bug 2264569 *************************

Line 859: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',170);

855: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',165);
857: return;
858: else
859: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',170);
860: -- **** Start commented code for bug 2264569 *************************
861: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
862: -- **** End commented code for bug 2264569 ***************************
863: -- **** Start new code for bug 2264569 ***************************

Line 867: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',175);

863: -- **** Start new code for bug 2264569 ***************************
864: p_status := 'CHOOSE_VAC'; -- Set next possible re-entry point.
865: -- **** End new code for bug 2264569 *********************************
866: end if;
867: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',175);
868: end if;
869: if p_status = 'END_BOOKINGS' then
870: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',180);
871: hrhirapl.end_bookings(p_person_id

Line 870: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',180);

866: end if;
867: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',175);
868: end if;
869: if p_status = 'END_BOOKINGS' then
870: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',180);
871: hrhirapl.end_bookings(p_person_id
872: , p_business_group_id
873: , p_hire_date);
874: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',185);

Line 874: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',185);

870: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',180);
871: hrhirapl.end_bookings(p_person_id
872: , p_business_group_id
873: , p_hire_date);
874: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',185);
875: --
876: -- **** START commented code for bug 2264569 *************************** --
877: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
878: -- **** End commented code for bug 2264569 ************************

Line 889: hr_utility.set_location('update_row2 - b4 CHOOSE_VAC',1);

885: --
886: -- Choose whether to change the Primary assignment
887: -- and which vacancy is to be the primary if so.
888: --
889: hr_utility.set_location('update_row2 - b4 CHOOSE_VAC',1);
890: if p_status = 'CHOOSE_VAC' then
891: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',240);
892: return;
893: end if; --End of CHOOSE_VAC

Line 891: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',240);

887: -- and which vacancy is to be the primary if so.
888: --
889: hr_utility.set_location('update_row2 - b4 CHOOSE_VAC',1);
890: if p_status = 'CHOOSE_VAC' then
891: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',240);
892: return;
893: end if; --End of CHOOSE_VAC
894: --
895: -- Can now hire the Person

Line 899: hr_utility.set_location('update_row2 - b4 HIRE',1);

895: -- Can now hire the Person
896: -- Note HIRE status can only be set from client form
897: -- as interaction is generally required.
898: --
899: hr_utility.set_location('update_row2 - b4 HIRE',1);
900: -- +-------------------------------------------------------------------+
901: -- +--------- BEGIN: Hire process -------------------------------------+
902: -- +-------------------------------------------------------------------+
903: if p_status = 'HIRE' then

Line 904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',245);

900: -- +-------------------------------------------------------------------+
901: -- +--------- BEGIN: Hire process -------------------------------------+
902: -- +-------------------------------------------------------------------+
903: if p_status = 'HIRE' then
904: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',245);
905:
906: -- bug fix 2824664:
907: if p_update_primary = 'Y'
908: and future_pactid_exists(p_person_id, p_effective_start_date)

Line 910: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',246);

906: -- bug fix 2824664:
907: if p_update_primary = 'Y'
908: and future_pactid_exists(p_person_id, p_effective_start_date)
909: then
910: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',246);
911: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
912: hr_utility.raise_error;
913: end if;
914: -- end bug fix 2824664

Line 912: hr_utility.raise_error;

908: and future_pactid_exists(p_person_id, p_effective_start_date)
909: then
910: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',246);
911: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
912: hr_utility.raise_error;
913: end if;
914: -- end bug fix 2824664
915: --
916: -- If new is Emp and old was Emp_apl

Line 921: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',250);

917: -- then l_emp_emp_apl is set to Y
918: --
919: if p_system_person_type = 'EMP'
920: and p_s_system_person_type = 'EMP_APL' then
921: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',250);
922: l_employ_emp_apl := 'Y';
923: else
924: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',255);
925: l_employ_emp_apl := 'N';

Line 924: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',255);

920: and p_s_system_person_type = 'EMP_APL' then
921: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',250);
922: l_employ_emp_apl := 'Y';
923: else
924: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',255);
925: l_employ_emp_apl := 'N';
926: end if;
927: --
928: -- Run the employ_applicant stored procedure

Line 930: hr_utility.set_location('update_row2 - b4 hrhirapl',1);

926: end if;
927: --
928: -- Run the employ_applicant stored procedure
929: --
930: hr_utility.set_location('update_row2 - b4 hrhirapl',1);
931: -- **** Start new code for bug 2264569 *****************************
932: -- End date chosen unaccepted applicant assignments
933: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',257);
934: hrhirapl.end_unaccepted_app_assign(p_person_id

Line 933: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',257);

929: --
930: hr_utility.set_location('update_row2 - b4 hrhirapl',1);
931: -- **** Start new code for bug 2264569 *****************************
932: -- End date chosen unaccepted applicant assignments
933: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',257);
934: hrhirapl.end_unaccepted_app_assign(p_person_id
935: ,p_business_group_id
936: ,p_legislation_code
937: ,p_session_date

Line 939: hr_utility.set_location('update_row2 - b4 hrhirapl',2);

935: ,p_business_group_id
936: ,p_legislation_code
937: ,p_session_date
938: ,p_tab);
939: hr_utility.set_location('update_row2 - b4 hrhirapl',2);
940:
941: -- **** End new code for bug 2264569 *****************************
942:
943: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',259);

Line 943: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',259);

939: hr_utility.set_location('update_row2 - b4 hrhirapl',2);
940:
941: -- **** End new code for bug 2264569 *****************************
942:
943: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',259);
944: hrhirapl.employ_applicant(p_person_id
945: ,p_business_group_id
946: ,p_legislation_code
947: ,p_new_primary_id

Line 1037: hr_utility.set_location('update_row2 - after hrhirapl',2);

1033: end loop;
1034: end if;
1035: close get_apln_id;
1036: --ER FPT
1037: hr_utility.set_location('update_row2 - after hrhirapl',2);
1038: hr_utility.set_location('manage PTU records',3);
1039: if p_system_person_type = 'EMP' then
1040: --
1041: -- PTU : Following Code has been added

Line 1038: hr_utility.set_location('manage PTU records',3);

1034: end if;
1035: close get_apln_id;
1036: --ER FPT
1037: hr_utility.set_location('update_row2 - after hrhirapl',2);
1038: hr_utility.set_location('manage PTU records',3);
1039: if p_system_person_type = 'EMP' then
1040: --
1041: -- PTU : Following Code has been added
1042: -- hr_per_type_usage_internal.maintain_ptu(

Line 1050: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);

1046: --
1047: -- **** START new code for bug 2264569 ******************************************
1048: -- Update the system person type to EMP_APL if user is keeping active APPLS.
1049: if hr_employee_applicant_api.retain_exists(p_tab) then
1050: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);
1051: p_system_person_type := 'EMP_APL';
1052: open c_apl_flag(p_system_person_type);
1053: fetch c_apl_flag into p_current_applicant_flag;
1054: close c_apl_flag;

Line 1055: hr_utility.trace(' current applicant_flag : '||p_current_applicant_flag);

1051: p_system_person_type := 'EMP_APL';
1052: open c_apl_flag(p_system_person_type);
1053: fetch c_apl_flag into p_current_applicant_flag;
1054: close c_apl_flag;
1055: hr_utility.trace(' current applicant_flag : '||p_current_applicant_flag);
1056: end if;
1057: -- **** END new code for bug 2264569 *******************************************
1058:
1059: -- Bug 3637893 Starts

Line 1072: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1211);

1068: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL')
1069: and p_system_person_type = 'EMP'
1070: -- and p_session_date = p_effective_start_date then
1071: and l_back2back then
1072: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1211);
1073: hr_per_type_usage_internal.maintain_person_type_usage
1074: (p_effective_date => p_effective_start_date
1075: ,p_person_id => p_person_id
1076: ,p_person_type_id => p_person_type_id

Line 1085: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1212);

1081: (p_effective_date => p_effective_start_date
1082: ,p_person_id => p_person_id
1083: ,p_person_type_id => p_person_type_id
1084: );
1085: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1212);
1086: end if;
1087: -- Bug 3637893 Ends
1088: --
1089: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);

Line 1089: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);

1085: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',1212);
1086: end if;
1087: -- Bug 3637893 Ends
1088: --
1089: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);
1090: -- **** Start new code for bug 2264569 **********************************
1091: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
1092: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',262);
1093: -- **** End new code for bug 2264569 **********************************

Line 1092: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',262);

1088: --
1089: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);
1090: -- **** Start new code for bug 2264569 **********************************
1091: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
1092: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',262);
1093: -- **** End new code for bug 2264569 **********************************
1094:
1095: -- ER FPT
1096: -- date track mode is set to UPDATE_CHANGE_INSERT when future EX_APL records exist

Line 1124: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);

1120: open c_person_enthn;
1121: fetch c_person_enthn into l_bgid,l_per_info1;
1122: close c_person_enthn;
1123:
1124: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
1125: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
1126: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
1127:
1128: if hr_api.return_legislation_code (l_bgid) ='US' and

Line 1125: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);

1121: fetch c_person_enthn into l_bgid,l_per_info1;
1122: close c_person_enthn;
1123:
1124: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
1125: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
1126: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
1127:
1128: if hr_api.return_legislation_code (l_bgid) ='US' and
1129: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then

Line 1126: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);

1122: close c_person_enthn;
1123:
1124: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
1125: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
1126: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
1127:
1128: if hr_api.return_legislation_code (l_bgid) ='US' and
1129: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
1130:

Line 1131: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 call enthn pkg',262);

1127:
1128: if hr_api.return_legislation_code (l_bgid) ='US' and
1129: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
1130:
1131: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 call enthn pkg',262);
1132:
1133: per_us_eth_orig_mig_pkg.irc_upgrade_ethnic_origin(p_person_id,'Y');
1134: end if;
1135:

Line 1143: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',265);

1139: end if; -- End of hire
1140: -- +-------------------------------------------------------------------+
1141: -- +----------- END: Hire process -------------------------------------+
1142: -- +-------------------------------------------------------------------+
1143: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',265);
1144: end if; -- End of HIRE.
1145: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',270);
1146: end if; -- Of Person type change checks.
1147: --

Line 1145: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',270);

1141: -- +----------- END: Hire process -------------------------------------+
1142: -- +-------------------------------------------------------------------+
1143: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',265);
1144: end if; -- End of HIRE.
1145: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',270);
1146: end if; -- Of Person type change checks.
1147: --
1148: -- changed p_rowid => null to p_rowid => p_rowid
1149: --

Line 1223: hr_utility.set_location('update_row2 - b4 update',1);

1219: close c1;
1220:
1221: end if;
1222:
1223: hr_utility.set_location('update_row2 - b4 update',1);
1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);

Line 1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);

1220:
1221: end if;
1222:
1223: hr_utility.set_location('update_row2 - b4 update',1);
1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(

Line 1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);

1221: end if;
1222:
1223: hr_utility.set_location('update_row2 - b4 update',1);
1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);

Line 1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);

1222:
1223: hr_utility.set_location('update_row2 - b4 update',1);
1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);
1230:

Line 1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);

1223: hr_utility.set_location('update_row2 - b4 update',1);
1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);
1230:
1231: -- Bug 6196362 Starts.

Line 1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(

1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);
1230:
1231: -- Bug 6196362 Starts.
1232: -- update per_people_f ppf

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

1382: ,ppf.local_name = p_local_name
1383: where ppf.rowid = p_rowid;
1384: --
1385: if sql%rowcount <1 then
1386: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1387: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1388: hr_utility.raise_error;
1389: end if;
1390: --

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

1383: where ppf.rowid = p_rowid;
1384: --
1385: if sql%rowcount <1 then
1386: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1387: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1388: hr_utility.raise_error;
1389: end if;
1390: --
1391:

Line 1388: hr_utility.raise_error;

1384: --
1385: if sql%rowcount <1 then
1386: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
1387: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
1388: hr_utility.raise_error;
1389: end if;
1390: --
1391:
1392: -- Start of Fix #2447513

Line 1393: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',275);

1389: end if;
1390: --
1391:
1392: -- Start of Fix #2447513
1393: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',275);
1394:
1395: --End of Fix
1396: -- ER FPT
1397: -- correct per table data

Line 1452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',276);

1448: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP'));
1449:
1450: END IF;
1451:
1452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',276);
1453:
1454: if nvl(l_fpt_hire_flag,'N') = 'Y' then
1455:
1456: if l_first_apl_date <> hr_api.g_eot then

Line 1466: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',277);

1462: and effective_start_date between p_effective_end_date and l_first_apl_date;
1463:
1464: end if;
1465:
1466: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',277);
1467:
1468: -- loop through the future applications > hire date
1469: for apl in csr_get_apln_details(greatest(p_hire_date,p_session_date))
1470: loop

Line 1856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',278);

1852: ,current_applicant_flag = NULL
1853: WHERE person_id = p_person_id
1854: AND effective_start_date > p_effective_end_date;
1855: end if;
1856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',278);
1857: -- ER FPT
1858: -- Tests required post-update
1859: --
1860: /* BEGIN OF WWBUG 1975359 */

Line 1870: hr_utility.set_location('update_row2 - after update',1);

1866: close c_person;
1867: --
1868: per_hrtca_merge.update_tca_person(p_Rec => l_person);
1869: --
1870: hr_utility.set_location('update_row2 - after update',1);
1871: --
1872: /* END OF WWBUG 1975359 */
1873: --
1874: -- HR/WF Synchronization call

Line 1885: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',280);

1881: -- Has the Date of Birth changed?
1882: --
1883: if p_date_of_birth is null and
1884: p_s_date_of_birth is not null then
1885: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',280);
1886: per_people12_pkg.check_birth_date(p_person_id);
1887: end if;
1888: if p_date_of_birth <> p_s_date_of_birth then
1889: --

Line 1894: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',282);

1890: -- Run the assignment_link_usages and Element_entry
1891: -- code for Change of Personal qualifying conditions.
1892: --
1893: --
1894: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',282);
1895: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
1896: ,p_business_group_id=>p_business_group_id
1897: ,p_person_id =>p_person_id
1898: ,p_old_start =>p_s_hire_date

Line 1901: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',285);

1897: ,p_person_id =>p_person_id
1898: ,p_old_start =>p_s_hire_date
1899: ,p_start_date => p_last_update_date
1900: );
1901: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',285);
1902: end if;
1903: --
1904: hr_utility.set_location('update_row2 - after update',2);
1905: --

Line 1904: hr_utility.set_location('update_row2 - after update',2);

1900: );
1901: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',285);
1902: end if;
1903: --
1904: hr_utility.set_location('update_row2 - after update',2);
1905: --
1906: -- test if hire_date has changed. and system person type has not.
1907: --
1908: if (((p_current_employee_flag = 'Y')

Line 1922: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',290);

1918: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
1919: ) then
1920: --
1921: -- Update the period of service for the employee
1922: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',290);
1923: --
1924: per_people3_pkg.update_period(p_person_id =>p_person_id
1925: ,p_hire_date => p_s_hire_date
1926: ,p_new_hire_date =>p_hire_date

Line 1929: hr_utility.set_location('update_row2 - after update',3);

1925: ,p_hire_date => p_s_hire_date
1926: ,p_new_hire_date =>p_hire_date
1927: ,p_adjusted_svc_date => p_adjusted_svc_date);
1928: --
1929: hr_utility.set_location('update_row2 - after update',3);
1930: --
1931: -- Update the hire records i.e
1932: -- assignment etc.
1933: --

Line 1940: hr_utility.set_location('update_row2 - after update',4);

1936: if (((p_current_employee_flag = 'Y')
1937: and (p_hire_date <> p_s_hire_date)
1938: and (p_system_person_type = p_s_system_person_type))) then
1939: /*--- End changes for the bug 5907880 */
1940: hr_utility.set_location('update_row2 - after update',4);
1941: hr_date_chk.update_hire_records(p_person_id
1942: ,p_applicant_number
1943: ,p_hire_date
1944: ,p_s_hire_date

Line 1949: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',295);

1945: ,p_last_updated_by
1946: ,p_last_update_login);
1947: End if;
1948: --
1949: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',295);
1950: -- Commented, as this action is being done in
1951: -- hr_change_start_date_api.update_pay_proposal (pehirapi.pkb)
1952: -- open get_pay_proposal;
1953: -- fetch get_pay_proposal into v_dummy;

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

1971: -- raise NO_DATA_FOUND;
1972: -- end if;
1973: -- exception
1974: -- when NO_DATA_FOUND then
1975: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1976: -- hr_utility.set_message_token('PROCEDURE','Update_row');
1977: -- hr_utility.set_message_token('STEP','4');
1978: -- hr_utility.raise_error;
1979: -- end;

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

1972: -- end if;
1973: -- exception
1974: -- when NO_DATA_FOUND then
1975: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1976: -- hr_utility.set_message_token('PROCEDURE','Update_row');
1977: -- hr_utility.set_message_token('STEP','4');
1978: -- hr_utility.raise_error;
1979: -- end;
1980: -- else

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

1973: -- exception
1974: -- when NO_DATA_FOUND then
1975: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1976: -- hr_utility.set_message_token('PROCEDURE','Update_row');
1977: -- hr_utility.set_message_token('STEP','4');
1978: -- hr_utility.raise_error;
1979: -- end;
1980: -- else
1981: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',300);

Line 1978: -- hr_utility.raise_error;

1974: -- when NO_DATA_FOUND then
1975: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1976: -- hr_utility.set_message_token('PROCEDURE','Update_row');
1977: -- hr_utility.set_message_token('STEP','4');
1978: -- hr_utility.raise_error;
1979: -- end;
1980: -- else
1981: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',300);
1982: -- close get_pay_proposal;

Line 1981: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',300);

1977: -- hr_utility.set_message_token('STEP','4');
1978: -- hr_utility.raise_error;
1979: -- end;
1980: -- else
1981: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',300);
1982: -- close get_pay_proposal;
1983: -- end if;
1984: hr_utility.set_location('update_row2 - after update',5);
1985: --

Line 1984: hr_utility.set_location('update_row2 - after update',5);

1980: -- else
1981: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',300);
1982: -- close get_pay_proposal;
1983: -- end if;
1984: hr_utility.set_location('update_row2 - after update',5);
1985: --
1986: -- Update PTU records to reflect hire date change.
1987: --
1988: -- PTU changes: following has been added

Line 2002: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',305);

1998: ,p_old_date_start => p_s_hire_date
1999: ,p_person_id => p_person_id
2000: ,p_system_person_type => 'EMP'
2001: );
2002: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',305);
2003: --
2004: -- PTU : end of changes
2005: --
2006: --

Line 2016: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',310);

2012: ,p_person_id =>p_person_id
2013: ,p_old_start =>p_s_hire_date
2014: ,p_start_date => p_hire_date);
2015: --
2016: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',310);
2017: --
2018: end if;
2019: --
2020: -- 1766066, contact start date enh. start

Line 2044: hr_utility.set_location('Leaving PER_PEOPLE12_PKG.update_row2',315);

2040: p_action => 'UPDATE');
2041: --*/
2042: --
2043: p_status := 'END'; -- Status required to end update loop on server
2044: hr_utility.set_location('Leaving PER_PEOPLE12_PKG.update_row2',315);
2045: --
2046: end update_row2;
2047: -- ER FPT
2048:

Line 2688: hr_utility.set_location('Future Person Type or Future asg changes exists',10);

2684:
2685: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y')
2686: and ((l_chk_future_pt = 'Y' ) or (l_chk_future_asg = 'Y')) then
2687:
2688: hr_utility.set_location('Future Person Type or Future asg changes exists',10);
2689: update_row2(p_rowid
2690: ,p_person_id
2691: ,p_effective_start_date
2692: ,p_effective_end_date

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

2882: -- on startup = 'BEGIN'( First time called from form)
2883: -- other values depend on what meesages have been returned to the client
2884: -- and the re-entry point on return from the client.
2885: --
2886: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',5);
2887: --
2888: /* BEGIN OF WWBUG 1975359 */
2889: open c1;
2890: --

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

2903: /* BEGIN OF WWBUG 1975359 */
2904: --
2905: if p_status = 'BEGIN' then
2906: --
2907: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',10);
2908: -- Test to see if the hire_date_has changed
2909: -- Providing Person type has not and it is emp.
2910: -- Or that it has changed to EMP
2911: --

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

2922: -- get the period_of_service_id
2923: -- 303729 if person is a supervisor
2924: -- test whether change to hire_date would invalidate this action
2925: --
2926: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',15);
2927: --
2928: if ((p_hire_date <> p_s_hire_date)
2929: and (p_system_person_type = p_s_system_person_type))
2930: then

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

2930: then
2931: per_people12_pkg.check_not_supervisor(p_person_id
2932: ,p_hire_date
2933: ,p_s_hire_date);
2934: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',20);
2935: end if;
2936: begin
2937: select pps.period_of_service_id
2938: into l_period_of_service_id

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

2939: from per_periods_of_service pps
2940: where pps.person_id = p_person_id
2941: and pps.date_start = p_s_hire_date;
2942: --
2943: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',25);
2944: exception
2945: when no_data_found then
2946: --
2947: -- If no data found and a previous hire date existed

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

2947: -- If no data found and a previous hire date existed
2948: -- then raise an error;
2949: --
2950: if p_s_hire_date is not null then
2951: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2952: hr_utility.set_message_token('PROCEDURE','Update_row');
2953: hr_utility.raise_error;
2954: end if;
2955: end;

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

2948: -- then raise an error;
2949: --
2950: if p_s_hire_date is not null then
2951: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2952: hr_utility.set_message_token('PROCEDURE','Update_row');
2953: hr_utility.raise_error;
2954: end if;
2955: end;
2956: --

Line 2953: hr_utility.raise_error;

2949: --
2950: if p_s_hire_date is not null then
2951: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2952: hr_utility.set_message_token('PROCEDURE','Update_row');
2953: hr_utility.raise_error;
2954: end if;
2955: end;
2956: --
2957: -- check the integrity of the date change.

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

2956: --
2957: -- check the integrity of the date change.
2958: -- Date may come in between a person type change.
2959: --
2960: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',30);
2961: hr_date_chk.check_hire_ref_int(p_person_id
2962: ,p_business_group_id
2963: ,l_period_of_service_id
2964: ,p_s_hire_date

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

2966: ,p_hire_date);
2967: -- VT 12/05/96 bug #418637
2968: -- check the existence of the recurring element entries
2969: --
2970: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',35);
2971: per_people12_pkg.check_recur_ent(p_person_id,p_hire_date,
2972: p_s_hire_date,l_warn_ee);
2973: end if;
2974: --

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

2978: -- a global version of session date to update the rows (not good)
2979: --
2980: -- VT 08/13/96
2981: if p_session_date <> p_effective_start_date then
2982: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',40);
2983: per_people9_pkg.update_old_person_row(p_person_id =>p_person_id
2984: ,p_session_date => p_session_date
2985: ,p_effective_start_date=>p_effective_start_date);
2986: end if;

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

2997: -- if p_current_employee_flag = 'Y' and
2998: -- p_current_applicant_flag is null and
2999: -- p_employee_number is not null then
3000: -- null;
3001: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',45);
3002: -- else
3003: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',50);
3004: -- hr_person.generate_number(p_current_employee_flag
3005: -- ,p_current_applicant_flag

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

2999: -- p_employee_number is not null then
3000: -- null;
3001: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',45);
3002: -- else
3003: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',50);
3004: -- hr_person.generate_number(p_current_employee_flag
3005: -- ,p_current_applicant_flag
3006: -- ,null --p_current_npw_flag
3007: -- ,p_national_identifier

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

3023: , p_current_employee => p_current_employee_flag
3024: , p_current_applicant => p_current_applicant_flag
3025: , p_current_npw => null --p_current_npw_flag
3026: );
3027: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',55);
3028: -- VT 12/05/96 bug #418637
3029: if l_warn_ee = 'Y' then
3030: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
3031: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.

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

3026: );
3027: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',55);
3028: -- VT 12/05/96 bug #418637
3029: if l_warn_ee = 'Y' then
3030: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
3031: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
3032: else
3033: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
3034: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.

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

3029: if l_warn_ee = 'Y' then
3030: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',60);
3031: p_status := 'RECUR_ENT_CHK'; -- Set status to next reentry point.
3032: else
3033: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
3034: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
3035: end if;
3036: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',70);
3037:

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

3032: else
3033: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',65);
3034: p_status := 'VACANCY_CHECK'; -- Set status to next possible reentry point.
3035: end if;
3036: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',70);
3037:
3038: --Start of fix for Bug 2167668
3039:
3040: IF p_start_date > p_hold_applicant_date_until THEN

Line 3041: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');

3037:
3038: --Start of fix for Bug 2167668
3039:
3040: IF p_start_date > p_hold_applicant_date_until THEN
3041: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
3042: hr_utility.set_message_token('HOLD_DATE', p_start_date );
3043: hr_utility.raise_error;
3044: END IF;
3045:

Line 3042: hr_utility.set_message_token('HOLD_DATE', p_start_date );

3038: --Start of fix for Bug 2167668
3039:
3040: IF p_start_date > p_hold_applicant_date_until THEN
3041: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
3042: hr_utility.set_message_token('HOLD_DATE', p_start_date );
3043: hr_utility.raise_error;
3044: END IF;
3045:
3046: -- End of fix for Bug 2167668

Line 3043: hr_utility.raise_error;

3039:
3040: IF p_start_date > p_hold_applicant_date_until THEN
3041: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
3042: hr_utility.set_message_token('HOLD_DATE', p_start_date );
3043: hr_utility.raise_error;
3044: END IF;
3045:
3046: -- End of fix for Bug 2167668
3047: end if; -- End the First in section

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

3047: end if; -- End the First in section
3048: --
3049: -- VT 12/05/96 bug #418637
3050: if p_status = 'RECUR_ENT_CHK' then
3051: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',75);
3052: return;
3053: end if; -- End of RECUR_ENT_CHK
3054: --
3055: --

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

3065: and p_s_system_person_type = 'EMP')
3066: or (p_system_person_type = 'EX_EMP_APL'
3067: and p_s_system_person_type = 'EX_EMP') then
3068: --
3069: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',80);
3070: NULL;
3071: -- 3652025 >> this process is replaced by call to
3072: -- hr_applicant_internal.create_applicant_anytime() procedure.
3073: -- called directly from PERWSEPI.pld

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

3086: --
3087: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
3088: -- ,p_hire_date => greatest(p_hire_date
3089: --,p_effective_start_date));
3090: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',85);
3091: --
3092: -- Insert the default applicant row and applicant
3093: -- assignment.
3094: --

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

3107: -- ,p_last_update_login => p_last_update_login
3108: -- ,p_created_by => p_created_by
3109: -- ,p_creation_date => p_creation_date);
3110: --
3111: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',90);
3112: --
3113: -- PTU Changes
3114:
3115: --hr_per_type_usage_internal.maintain_person_type_usage

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

3117: -- ,p_person_id => p_person_id
3118: -- ,p_person_type_id => p_person_type_id
3119: -- );
3120: --
3121: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',92);
3122: -- PTU Changes
3123: -- <<
3124: -- Has the Person type changed to become that of an employee
3125: -- when the previous type is not a current applicant?

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

3128: and ( p_s_system_person_type = 'OTHER'
3129: or p_s_system_person_type = 'EX_EMP'
3130: or p_s_system_person_type = 'EX_APL')) then /* Bug 523924 */
3131: -- or p_s_system_person_type = 'EX_EMP')) then
3132: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',95);
3133: --
3134: -- Ensure no future person_type_changes.
3135: --
3136: if hr_person.chk_future_person_type(p_s_system_person_type

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

3145: end if;
3146: --
3147: if p_s_system_person_type = 'EX_EMP'
3148: then
3149: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',100);
3150: --
3151: -- Bug 3154253 stars here.
3152: -- Passed earlier of p_ession_date and p_hire_date
3153: -- (p_effective_start_date) to the check_hire procedure.

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

3152: -- Passed earlier of p_ession_date and p_hire_date
3153: -- (p_effective_start_date) to the check_hire procedure.
3154: --
3155: if p_session_date < p_effective_start_date then
3156: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
3157: per_people12_pkg.check_rehire(p_person_id, p_session_date);
3158: else
3159: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
3160: per_people12_pkg.check_rehire(p_person_id, p_hire_date);

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

3155: if p_session_date < p_effective_start_date then
3156: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',101);
3157: per_people12_pkg.check_rehire(p_person_id, p_session_date);
3158: else
3159: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',102);
3160: per_people12_pkg.check_rehire(p_person_id, p_hire_date);
3161: end if;
3162: --
3163: -- bug 3154253 ends here.

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

3161: end if;
3162: --
3163: -- bug 3154253 ends here.
3164: --
3165: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);
3166: end if;
3167: per_people12_pkg.check_future_changes(p_person_id
3168: ,p_effective_start_date);
3169: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);

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

3165: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',105);
3166: end if;
3167: per_people12_pkg.check_future_changes(p_person_id
3168: ,p_effective_start_date);
3169: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);
3170: --
3171: -- Ensure there are no future applicant assignments
3172: --
3173: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id

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

3184: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3185: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
3186: end if;
3187:
3188: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',115);
3189: --
3190: -- Insert the default period_of service and assignment
3191: -- rows.
3192: --

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

3207: ,p_created_by => p_created_by
3208: ,p_creation_date => p_creation_date
3209: ,p_adjusted_svc_date => p_adjusted_svc_date);
3210: --
3211: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',120);
3212:
3213: -- PTU Changes
3214:
3215: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

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

3217: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
3218: and p_system_person_type = 'EMP'
3219: -- and p_session_date = p_effective_start_date then
3220: and l_back2back then
3221: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1201);
3222: hr_per_type_usage_internal.maintain_person_type_usage
3223: (p_effective_date => p_effective_start_date
3224: ,p_person_id => p_person_id
3225: ,p_person_type_id => p_person_type_id

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

3230: (p_effective_date => p_effective_start_date
3231: ,p_person_id => p_person_id
3232: ,p_person_type_id => p_person_type_id
3233: );
3234: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1202);
3235: end if;
3236:
3237: -- PTU Changes
3238:

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

3235: end if;
3236:
3237: -- PTU Changes
3238:
3239: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',121);
3240:
3241: -- Has the Person become an Employee or Employee applicant from being an
3242: -- applicant or employee applicant?
3243: --

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

3246: or (p_system_person_type = 'EMP_APL'
3247: and p_s_system_person_type in ('APL','EX_EMP_APL')) /* Bug 732598 */
3248: or (p_system_person_type = 'EMP'
3249: and p_s_system_person_type = 'EMP_APL')) then
3250: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',125);
3251: --
3252: -- Ensure no future person_type_changes.
3253: --
3254: if hr_person.chk_future_person_type(p_s_system_person_type

Line 3259: hr_utility.raise_error;

3255: ,p_person_id
3256: ,p_business_group_id
3257: ,p_effective_start_date) then
3258: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
3259: hr_utility.raise_error;
3260: end if;
3261: --
3262: -- Ensure there are no future applicant assignments
3263: --

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

3275: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3276: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
3277: end if;
3278:
3279: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',130);
3280: --
3281: -- Check if the person have open term_assignment records. These can be
3282: -- found by checking if the person have a periods_of_service with
3283: -- no FPD and a value for ATD. Bug 2881076

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

3287: -- Check that the change is valid.
3288: --
3289: if p_status = 'VACANCY_CHECK' then
3290: loop
3291: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',135);
3292: exit when p_status = 'BOOKINGS_EXIST';
3293: --
3294: -- Check each vacancy,if it is oversubscribed
3295: -- l_fire_warning = 'Y', return to client

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

3296: -- displaying relevant message.
3297: -- on return l_vacancy_id starts the cursor at the
3298: -- relevant point.
3299: --
3300: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',140);
3301: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
3302: ,p_fire_warning => l_fire_warning
3303: ,p_vacancy_id => p_vacancy_id
3304: -- **** Start new code for bug 2264569 ****************

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

3305: ,p_table => p_tab -- #2381925
3306: -- **** End new code for bug 2264569 *****************
3307: );
3308: if l_fire_warning = 'Y' then
3309: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',145);
3310: return;
3311: elsif l_fire_warning = 'N' then
3312: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
3313: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.

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

3308: if l_fire_warning = 'Y' then
3309: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',145);
3310: return;
3311: elsif l_fire_warning = 'N' then
3312: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
3313: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
3314: end if;
3315: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
3316: end loop;

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

3311: elsif l_fire_warning = 'N' then
3312: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',150);
3313: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
3314: end if;
3315: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
3316: end loop;
3317: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',160);
3318: end if; -- End of VACANCY_CHECK
3319: --

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

3313: p_status := 'BOOKINGS_EXIST'; -- Set next possible re-entry point.
3314: end if;
3315: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',155);
3316: end loop;
3317: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',160);
3318: end if; -- End of VACANCY_CHECK
3319: --
3320: if p_status = 'BOOKINGS_EXIST' then
3321: -- VT 09/18/96 #288087, #380280 , #2172590

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

3321: -- VT 09/18/96 #288087, #380280 , #2172590
3322: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
3323: ,p_business_group_id =>p_business_group_id
3324: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
3325: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
3326: return;
3327: else
3328: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',170);
3329: -- **** Start commented code for bug 2264569 *************************

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

3324: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
3325: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
3326: return;
3327: else
3328: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',170);
3329: -- **** Start commented code for bug 2264569 *************************
3330: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
3331: -- **** End commented code for bug 2264569 ***************************
3332: -- **** Start new code for bug 2264569 ***************************

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

3332: -- **** Start new code for bug 2264569 ***************************
3333: p_status := 'CHOOSE_VAC'; -- Set next possible re-entry point.
3334: -- **** End new code for bug 2264569 *********************************
3335: end if;
3336: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',175);
3337: end if;
3338: if p_status = 'END_BOOKINGS' then
3339: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
3340: hrhirapl.end_bookings(p_person_id

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

3335: end if;
3336: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',175);
3337: end if;
3338: if p_status = 'END_BOOKINGS' then
3339: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
3340: hrhirapl.end_bookings(p_person_id
3341: , p_business_group_id
3342: , p_hire_date);
3343: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',185);

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

3339: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',180);
3340: hrhirapl.end_bookings(p_person_id
3341: , p_business_group_id
3342: , p_hire_date);
3343: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',185);
3344: --
3345: -- **** START commented code for bug 2264569 *************************** --
3346: --p_status := 'GET_APPLS'; -- Set next possible re-entry point.
3347: -- **** End commented code for bug 2264569 ************************

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

3359: -- if p_status='GET_APPLS' then
3360: --
3361: -- Get all the accepted applicants
3362: --
3363: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',190);
3364: -- per_people3_pkg.get_accepted_appls(p_person_id => p_person_id
3365: -- ,p_num_accepted_appls => l_num_accepted_appls
3366: -- ,p_new_primary_id =>p_new_primary_id);
3367: --

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

3366: -- ,p_new_primary_id =>p_new_primary_id);
3367: --
3368: -- Get all current applicant assignments.
3369: --
3370: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',195);
3371: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
3372: -- ,p_num_appls => l_num_appls);
3373: --
3374: -- if p_system_person_type = 'EMP_APL' then

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

3371: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
3372: -- ,p_num_appls => l_num_appls);
3373: --
3374: -- if p_system_person_type = 'EMP_APL' then
3375: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',200);
3376: --
3377: -- If we have got this far then there must be > 0 Accepted
3378: -- applications,therefore check p_system_person_type if EMP_APL
3379: -- and number of accepted is equal to number of current assignments

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

3380: -- then there is an error. Otherwise go around end_accepted
3381: -- to multiple contracts.
3382: --
3383: -- if l_num_accepted_appls = l_num_appls then
3384: -- hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
3385: -- hr_utility.raise_error;
3386: -- else
3387: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',205);
3388: -- p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.

Line 3385: -- hr_utility.raise_error;

3381: -- to multiple contracts.
3382: --
3383: -- if l_num_accepted_appls = l_num_appls then
3384: -- hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
3385: -- hr_utility.raise_error;
3386: -- else
3387: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',205);
3388: -- p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
3389: -- end if;

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

3383: -- if l_num_accepted_appls = l_num_appls then
3384: -- hr_utility.set_message('801','HR_6791_EMP_APL_NO_ASG');
3385: -- hr_utility.raise_error;
3386: -- else
3387: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',205);
3388: -- p_status := 'MULTIPLE_CONTRACTS';-- Set next re-entry point.
3389: -- end if;
3390: -- --
3391: -- Number of accepted does not equal number of current then

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

3389: -- end if;
3390: -- --
3391: -- Number of accepted does not equal number of current then
3392: -- end_accepted.
3393: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',210);
3394: --
3395: -- elsif l_num_accepted_appls <> l_num_appls then
3396: -- hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');
3397: -- p_status := 'END_UNACCEPTED'; -- next code re-entry,

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

3392: -- end_accepted.
3393: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',210);
3394: --
3395: -- elsif l_num_accepted_appls <> l_num_appls then
3396: -- hr_utility.set_message('801','HR_EMP_UNACCEPTED_APPL');
3397: -- p_status := 'END_UNACCEPTED'; -- next code re-entry,
3398: -- return;
3399: -- --
3400: -- Otherwise ignore end_accepted.

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

3399: -- --
3400: -- Otherwise ignore end_accepted.
3401: --
3402: -- else
3403: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',215);
3404: -- p_status := 'MULTIPLE_CONTRACTS'; -- next code re-entry.
3405: -- end if;
3406: -- end if; -- End of GET_APPLS
3407: --

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

3408: -- if p_status = 'END_UNACCEPTED' then
3409: --
3410: -- End the unaccepted assignments.
3411: --
3412: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',220);
3413: -- hrhirapl.end_unaccepted_app_assign(p_person_id
3414: -- ,p_business_group_id
3415: -- ,p_legislation_code
3416: -- ,p_session_date);

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

3413: -- hrhirapl.end_unaccepted_app_assign(p_person_id
3414: -- ,p_business_group_id
3415: -- ,p_legislation_code
3416: -- ,p_session_date);
3417: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',225);
3418: -- p_status := 'MULTIPLE_CONTRACTS';
3419: -- end if; -- End of END_UNACCEPTED
3420: -- --
3421: -- -- Test to see if multiple contracts are a possibility.

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

3419: -- end if; -- End of END_UNACCEPTED
3420: -- --
3421: -- -- Test to see if multiple contracts are a possibility.
3422: -- --
3423: --hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
3424: -- if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
3425: -- if l_num_accepted_appls >1 then
3426: -- hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
3427: -- return;

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

3422: -- --
3423: --hr_utility.set_location('update_row - b4 MULTIPLE_CONTRACTS',1);
3424: -- if p_status = 'MULTIPLE_CONTRACTS' then -- MULTIPLE_CONTRACTS
3425: -- if l_num_accepted_appls >1 then
3426: -- hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
3427: -- return;
3428: -- else
3429: -- p_status := 'CHOOSE_VAC'; -- next code re-entry.
3430: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);

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

3426: -- hr_utility.set_message('801','HR_EMP_MULTIPLE_CONTRACTS');
3427: -- return;
3428: -- else
3429: -- p_status := 'CHOOSE_VAC'; -- next code re-entry.
3430: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);
3431: -- end if;
3432: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',235);
3433: -- end if; -- End of MULTIPLE_CONTRACTS
3434: --

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

3428: -- else
3429: -- p_status := 'CHOOSE_VAC'; -- next code re-entry.
3430: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',230);
3431: -- end if;
3432: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',235);
3433: -- end if; -- End of MULTIPLE_CONTRACTS
3434: --
3435: -- **** END commented code for bug 2264569 ****************************
3436: --

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

3436: --
3437: -- Choose whether to change the Primary assignment
3438: -- and which vacancy is to be the primary if so.
3439: --
3440: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);
3441: if p_status = 'CHOOSE_VAC' then
3442: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',240);
3443: return;
3444: end if; --End of CHOOSE_VAC

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

3438: -- and which vacancy is to be the primary if so.
3439: --
3440: hr_utility.set_location('update_row - b4 CHOOSE_VAC',1);
3441: if p_status = 'CHOOSE_VAC' then
3442: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',240);
3443: return;
3444: end if; --End of CHOOSE_VAC
3445: --
3446: -- Can now hire the Person

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

3446: -- Can now hire the Person
3447: -- Note HIRE status can only be set from client form
3448: -- as interaction is generally required.
3449: --
3450: hr_utility.set_location('update_row - b4 HIRE',1);
3451: -- +-------------------------------------------------------------------+
3452: -- +--------- BEGIN: Hire process -------------------------------------+
3453: -- +-------------------------------------------------------------------+
3454: if p_status = 'HIRE' then

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

3451: -- +-------------------------------------------------------------------+
3452: -- +--------- BEGIN: Hire process -------------------------------------+
3453: -- +-------------------------------------------------------------------+
3454: if p_status = 'HIRE' then
3455: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',245);
3456:
3457: -- bug fix 2824664:
3458: if p_update_primary = 'Y'
3459: and future_pactid_exists(p_person_id, p_effective_start_date)

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

3457: -- bug fix 2824664:
3458: if p_update_primary = 'Y'
3459: and future_pactid_exists(p_person_id, p_effective_start_date)
3460: then
3461: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',246);
3462: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
3463: hr_utility.raise_error;
3464: end if;
3465: -- end bug fix 2824664

Line 3463: hr_utility.raise_error;

3459: and future_pactid_exists(p_person_id, p_effective_start_date)
3460: then
3461: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',246);
3462: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
3463: hr_utility.raise_error;
3464: end if;
3465: -- end bug fix 2824664
3466: --
3467: -- If new is Emp and old was Emp_apl

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

3468: -- then l_emp_emp_apl is set to Y
3469: --
3470: if p_system_person_type = 'EMP'
3471: and p_s_system_person_type = 'EMP_APL' then
3472: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',250);
3473: l_employ_emp_apl := 'Y';
3474: else
3475: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',255);
3476: l_employ_emp_apl := 'N';

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

3471: and p_s_system_person_type = 'EMP_APL' then
3472: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',250);
3473: l_employ_emp_apl := 'Y';
3474: else
3475: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',255);
3476: l_employ_emp_apl := 'N';
3477: end if;
3478: --
3479: -- Run the employ_applicant stored procedure

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

3477: end if;
3478: --
3479: -- Run the employ_applicant stored procedure
3480: --
3481: hr_utility.set_location('update_row - b4 hrhirapl',1);
3482: -- **** Start new code for bug 2264569 *****************************
3483: -- End date chosen unaccepted applicant assignments
3484: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',257);
3485: hrhirapl.end_unaccepted_app_assign(p_person_id

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

3480: --
3481: hr_utility.set_location('update_row - b4 hrhirapl',1);
3482: -- **** Start new code for bug 2264569 *****************************
3483: -- End date chosen unaccepted applicant assignments
3484: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',257);
3485: hrhirapl.end_unaccepted_app_assign(p_person_id
3486: ,p_business_group_id
3487: ,p_legislation_code
3488: ,p_session_date

Line 3490: hr_utility.set_location('update_row - b4 hrhirapl',2);

3486: ,p_business_group_id
3487: ,p_legislation_code
3488: ,p_session_date
3489: ,p_tab);
3490: hr_utility.set_location('update_row - b4 hrhirapl',2);
3491:
3492: -- **** End new code for bug 2264569 *****************************
3493:
3494: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',259);

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

3490: hr_utility.set_location('update_row - b4 hrhirapl',2);
3491:
3492: -- **** End new code for bug 2264569 *****************************
3493:
3494: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',259);
3495: hrhirapl.employ_applicant(p_person_id
3496: ,p_business_group_id
3497: ,p_legislation_code
3498: ,p_new_primary_id

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

3511: -- **** Start new code for bug 2264569 ******
3512: ,p_tab
3513: -- **** End new code for bug 2264569 *******
3514: );
3515: hr_utility.set_location('update_row - after hrhirapl',2);
3516: hr_utility.set_location('manage PTU records',3);
3517: if p_system_person_type = 'EMP' then
3518: --
3519: -- PTU : Following Code has been added

Line 3516: hr_utility.set_location('manage PTU records',3);

3512: ,p_tab
3513: -- **** End new code for bug 2264569 *******
3514: );
3515: hr_utility.set_location('update_row - after hrhirapl',2);
3516: hr_utility.set_location('manage PTU records',3);
3517: if p_system_person_type = 'EMP' then
3518: --
3519: -- PTU : Following Code has been added
3520: -- hr_per_type_usage_internal.maintain_ptu(

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

3524: --
3525: -- **** START new code for bug 2264569 ******************************************
3526: -- Update the system person type to EMP_APL if user is keeping active APPLS.
3527: if hr_employee_applicant_api.retain_exists(p_tab) then
3528: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
3529: p_system_person_type := 'EMP_APL';
3530: open c_apl_flag(p_system_person_type);
3531: fetch c_apl_flag into p_current_applicant_flag;
3532: close c_apl_flag;

Line 3533: hr_utility.trace(' current applicant_flag : '||p_current_applicant_flag);

3529: p_system_person_type := 'EMP_APL';
3530: open c_apl_flag(p_system_person_type);
3531: fetch c_apl_flag into p_current_applicant_flag;
3532: close c_apl_flag;
3533: hr_utility.trace(' current applicant_flag : '||p_current_applicant_flag);
3534: end if;
3535: -- **** END new code for bug 2264569 *******************************************
3536:
3537: -- Bug 3637893 Starts

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

3547: --and p_system_person_type = 'EMP' --Commented for Bug#15848881
3548: and p_system_person_type in ('EMP','EMP_APL') --Added for Bug#15848881
3549: -- and p_session_date = p_effective_start_date then
3550: and l_back2back then
3551: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1211);
3552: hr_per_type_usage_internal.maintain_person_type_usage
3553: (p_effective_date => p_effective_start_date
3554: ,p_person_id => p_person_id
3555: ,p_person_type_id => p_person_type_id

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

3560: (p_effective_date => p_effective_start_date
3561: ,p_person_id => p_person_id
3562: ,p_person_type_id => p_person_type_id
3563: );
3564: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1212);
3565: end if;
3566: -- Bug 3637893 Ends
3567: --
3568: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);

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

3564: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',1212);
3565: end if;
3566: -- Bug 3637893 Ends
3567: --
3568: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
3569: -- **** Start new code for bug 2264569 **********************************
3570: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
3571: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);
3572: -- **** End new code for bug 2264569 **********************************

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

3567: --
3568: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
3569: -- **** Start new code for bug 2264569 **********************************
3570: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
3571: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);
3572: -- **** End new code for bug 2264569 **********************************
3573: hr_per_type_usage_internal.maintain_person_type_usage
3574: (p_effective_date => p_effective_start_date
3575: ,p_person_id => p_person_id

Line 3591: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);

3587: open c_person_enthn;
3588: fetch c_person_enthn into l_bgid,l_per_info1;
3589: close c_person_enthn;
3590:
3591: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
3592: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
3593: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
3594:
3595: if hr_api.return_legislation_code (l_bgid) ='US' and

Line 3592: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);

3588: fetch c_person_enthn into l_bgid,l_per_info1;
3589: close c_person_enthn;
3590:
3591: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
3592: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
3593: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
3594:
3595: if hr_api.return_legislation_code (l_bgid) ='US' and
3596: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then

Line 3593: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);

3589: close c_person_enthn;
3590:
3591: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
3592: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
3593: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
3594:
3595: if hr_api.return_legislation_code (l_bgid) ='US' and
3596: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
3597:

Line 3598: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 call enthn pkg',262);

3594:
3595: if hr_api.return_legislation_code (l_bgid) ='US' and
3596: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
3597:
3598: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 call enthn pkg',262);
3599:
3600: per_us_eth_orig_mig_pkg.irc_upgrade_ethnic_origin(p_person_id,'Y');
3601: end if;
3602:

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

3606: end if; -- End of hire
3607: -- +-------------------------------------------------------------------+
3608: -- +----------- END: Hire process -------------------------------------+
3609: -- +-------------------------------------------------------------------+
3610: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',265);
3611: end if; -- End of HIRE.
3612: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',270);
3613: end if; -- Of Person type change checks.
3614: --

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

3608: -- +----------- END: Hire process -------------------------------------+
3609: -- +-------------------------------------------------------------------+
3610: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',265);
3611: end if; -- End of HIRE.
3612: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',270);
3613: end if; -- Of Person type change checks.
3614: --
3615: -- changed p_rowid => null to p_rowid => p_rowid
3616: --

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

3686: close c1;
3687:
3688: end if;
3689:
3690: hr_utility.set_location('update_row - b4 update',1);
3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);

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

3687:
3688: end if;
3689:
3690: hr_utility.set_location('update_row - b4 update',1);
3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(

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

3688: end if;
3689:
3690: hr_utility.set_location('update_row - b4 update',1);
3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);

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

3689:
3690: hr_utility.set_location('update_row - b4 update',1);
3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);
3697:

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

3690: hr_utility.set_location('update_row - b4 update',1);
3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);
3697:
3698: -- Bug 6196362 Starts.

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

3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);
3697:
3698: -- Bug 6196362 Starts.
3699: -- update per_people_f ppf

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

3849: ,ppf.local_name = p_local_name
3850: where ppf.rowid = p_rowid;
3851: --
3852: if sql%rowcount <1 then
3853: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
3854: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
3855: hr_utility.raise_error;
3856: end if;
3857: --

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

3850: where ppf.rowid = p_rowid;
3851: --
3852: if sql%rowcount <1 then
3853: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
3854: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
3855: hr_utility.raise_error;
3856: end if;
3857: --
3858:

Line 3855: hr_utility.raise_error;

3851: --
3852: if sql%rowcount <1 then
3853: hr_utility.set_message(801,'HR_6001_ALL_MANDATORY_FIELD');
3854: hr_utility.set_message_token('MISSING_FIELD','rowid is'||p_rowid);
3855: hr_utility.raise_error;
3856: end if;
3857: --
3858:
3859: -- Start of Fix #2447513

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

3856: end if;
3857: --
3858:
3859: -- Start of Fix #2447513
3860: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',275);
3861: --End of Fix
3862:
3863: -- Tests required post-update
3864: --

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

3871: close c_person;
3872: --
3873: per_hrtca_merge.update_tca_person(p_Rec => l_person);
3874: --
3875: hr_utility.set_location('update_row - after update',1);
3876: --
3877: /* END OF WWBUG 1975359 */
3878: --
3879: -- HR/WF Synchronization call

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

3886: -- Has the Date of Birth changed?
3887: --
3888: if p_date_of_birth is null and
3889: p_s_date_of_birth is not null then
3890: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',280);
3891: per_people12_pkg.check_birth_date(p_person_id);
3892: end if;
3893: if p_date_of_birth <> p_s_date_of_birth then
3894: --

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

3895: -- Run the assignment_link_usages and Element_entry
3896: -- code for Change of Personal qualifying conditions.
3897: --
3898: --
3899: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',282);
3900: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
3901: ,p_business_group_id=>p_business_group_id
3902: ,p_person_id =>p_person_id
3903: ,p_old_start =>p_s_hire_date

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

3902: ,p_person_id =>p_person_id
3903: ,p_old_start =>p_s_hire_date
3904: ,p_start_date => p_last_update_date
3905: );
3906: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',285);
3907: end if;
3908: --
3909: hr_utility.set_location('update_row - after update',2);
3910: --

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

3905: );
3906: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',285);
3907: end if;
3908: --
3909: hr_utility.set_location('update_row - after update',2);
3910: --
3911: -- test if hire_date has changed. and system person type has not.
3912: --
3913: if (((p_current_employee_flag = 'Y')

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

3923: and Hr_General2.is_person_type(p_person_id, 'EMP',p_s_hire_date) --#2472146
3924: ) then
3925: --
3926: -- Update the period of service for the employee
3927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);
3928: --
3929: per_people3_pkg.update_period(p_person_id =>p_person_id
3930: ,p_hire_date => p_s_hire_date
3931: ,p_new_hire_date =>p_hire_date

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

3930: ,p_hire_date => p_s_hire_date
3931: ,p_new_hire_date =>p_hire_date
3932: ,p_adjusted_svc_date => p_adjusted_svc_date);
3933: --
3934: hr_utility.set_location('update_row - after update',3);
3935: --
3936: -- Update the hire records i.e
3937: -- assignment etc.
3938: --

Line 3945: hr_utility.set_location('update_row - after update',4);

3941: if (((p_current_employee_flag = 'Y')
3942: and (p_hire_date <> p_s_hire_date)
3943: and (p_system_person_type = p_s_system_person_type))) then
3944: /*--- End changes for the bug 5907880 */
3945: hr_utility.set_location('update_row - after update',4);
3946: hr_date_chk.update_hire_records(p_person_id
3947: ,p_applicant_number
3948: ,p_hire_date
3949: ,p_s_hire_date

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

3950: ,p_last_updated_by
3951: ,p_last_update_login);
3952: End if;
3953: --
3954: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',295);
3955: -- Commented, as this action is being done in
3956: -- hr_change_start_date_api.update_pay_proposal (pehirapi.pkb)
3957: -- open get_pay_proposal;
3958: -- fetch get_pay_proposal into v_dummy;

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

3976: -- raise NO_DATA_FOUND;
3977: -- end if;
3978: -- exception
3979: -- when NO_DATA_FOUND then
3980: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
3981: -- hr_utility.set_message_token('PROCEDURE','Update_row');
3982: -- hr_utility.set_message_token('STEP','4');
3983: -- hr_utility.raise_error;
3984: -- end;

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

3977: -- end if;
3978: -- exception
3979: -- when NO_DATA_FOUND then
3980: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
3981: -- hr_utility.set_message_token('PROCEDURE','Update_row');
3982: -- hr_utility.set_message_token('STEP','4');
3983: -- hr_utility.raise_error;
3984: -- end;
3985: -- else

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

3978: -- exception
3979: -- when NO_DATA_FOUND then
3980: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
3981: -- hr_utility.set_message_token('PROCEDURE','Update_row');
3982: -- hr_utility.set_message_token('STEP','4');
3983: -- hr_utility.raise_error;
3984: -- end;
3985: -- else
3986: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);

Line 3983: -- hr_utility.raise_error;

3979: -- when NO_DATA_FOUND then
3980: -- hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
3981: -- hr_utility.set_message_token('PROCEDURE','Update_row');
3982: -- hr_utility.set_message_token('STEP','4');
3983: -- hr_utility.raise_error;
3984: -- end;
3985: -- else
3986: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);
3987: -- close get_pay_proposal;

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

3982: -- hr_utility.set_message_token('STEP','4');
3983: -- hr_utility.raise_error;
3984: -- end;
3985: -- else
3986: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);
3987: -- close get_pay_proposal;
3988: -- end if;
3989: hr_utility.set_location('update_row - after update',5);
3990: --

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

3985: -- else
3986: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',300);
3987: -- close get_pay_proposal;
3988: -- end if;
3989: hr_utility.set_location('update_row - after update',5);
3990: --
3991: -- Update PTU records to reflect hire date change.
3992: --
3993: -- PTU changes: following has been added

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

4003: ,p_old_date_start => p_s_hire_date
4004: ,p_person_id => p_person_id
4005: ,p_system_person_type => 'EMP'
4006: );
4007: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',305);
4008: --
4009: -- PTU : end of changes
4010: --
4011: --

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

4017: ,p_person_id =>p_person_id
4018: ,p_old_start =>p_s_hire_date
4019: ,p_start_date => p_hire_date);
4020: --
4021: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',310);
4022: --
4023: end if;
4024: --
4025: -- 1766066, contact start date enh. start

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

4065: end if;
4066: -- End changes for bug 9879782
4067:
4068: p_status := 'END'; -- Status required to end update loop on server
4069: hr_utility.set_location('Leaving PER_PEOPLE12_PKG.update_row1',315);
4070: --
4071: end update_row1;
4072: --
4073: procedure check_future_changes(p_person_id NUMBER

Line 4206: hr_utility.set_location('Entering '||l_proc,5);

4202: -- 115.67 (END)
4203: --
4204: begin
4205: l_proc := 'per_people12_pkg.check_rehire';
4206: hr_utility.set_location('Entering '||l_proc,5);
4207: --
4208: -- 115.67 (START)
4209: --
4210: --

Line 4223: hr_utility.set_location(l_proc,10);

4219: ,l_rule_value
4220: ,l_rule_found
4221: );
4222: --
4223: hr_utility.set_location(l_proc,10);
4224: --
4225: -- 115.67 (END)
4226: --
4227: --

Line 4236: hr_utility.set_location(l_proc,15);

4232: if old_pps_exists%FOUND
4233: then
4234: close old_pps_exists;
4235: --
4236: hr_utility.set_location(l_proc,15);
4237: --
4238: -- if yes then check last PPS
4239: -- has had it's FPD closed down and that the FPD + 1
4240: -- is less than current hire date

Line 4257: hr_utility.set_location(l_proc,20);

4253: --
4254: -- 115.67 (START)
4255: --
4256: --
4257: hr_utility.set_location(l_proc,20);
4258: --
4259: if (not(l_rule_found)
4260: OR
4261: (l_rule_found AND nvl(l_rule_value,'N') = 'N'))

Line 4266: hr_utility.set_location(l_proc,25);

4262: then
4263: --
4264: -- old behaviour as rehire before fpd is not enabled
4265: --
4266: hr_utility.set_location(l_proc,25);
4267: --
4268: -- 115.67 (END)
4269: --
4270: close pps_not_ended;

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

4268: -- 115.67 (END)
4269: --
4270: close pps_not_ended;
4271: if v_dummy_fpd is null then
4272: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
4273: else
4274: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
4275: end if;
4276: hr_utility.raise_error;

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

4270: close pps_not_ended;
4271: if v_dummy_fpd is null then
4272: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
4273: else
4274: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
4275: end if;
4276: hr_utility.raise_error;
4277: --
4278: -- 115.67 (START)

Line 4276: hr_utility.raise_error;

4272: hr_utility.set_message('800','HR_51032_EMP_PREV_FPD_OPEN');
4273: else
4274: hr_utility.set_message('800','PER_289308_FUTURE_ENDED_FPD');
4275: end if;
4276: hr_utility.raise_error;
4277: --
4278: -- 115.67 (START)
4279: --
4280: else

Line 4282: hr_utility.set_location(l_proc,30);

4278: -- 115.67 (START)
4279: --
4280: else
4281: --
4282: hr_utility.set_location(l_proc,30);
4283: --
4284: -- Rehire before FPD allowed
4285: --
4286: if v_dummy_fpd is null then

Line 4288: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');

4284: -- Rehire before FPD allowed
4285: --
4286: if v_dummy_fpd is null then
4287: close pps_not_ended;
4288: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');
4289: hr_utility.raise_error;
4290: end if;
4291: if v_dummy_lspd >= p_start_date then
4292: close pps_not_ended;

Line 4289: hr_utility.raise_error;

4285: --
4286: if v_dummy_fpd is null then
4287: close pps_not_ended;
4288: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');
4289: hr_utility.raise_error;
4290: end if;
4291: if v_dummy_lspd >= p_start_date then
4292: close pps_not_ended;
4293: hr_utility.set_message('800','HR_449759_REHIRE_AFTER_LSPD');

Line 4293: hr_utility.set_message('800','HR_449759_REHIRE_AFTER_LSPD');

4289: hr_utility.raise_error;
4290: end if;
4291: if v_dummy_lspd >= p_start_date then
4292: close pps_not_ended;
4293: hr_utility.set_message('800','HR_449759_REHIRE_AFTER_LSPD');
4294: hr_utility.raise_error;
4295: end if;
4296: end if;
4297: --

Line 4294: hr_utility.raise_error;

4290: end if;
4291: if v_dummy_lspd >= p_start_date then
4292: close pps_not_ended;
4293: hr_utility.set_message('800','HR_449759_REHIRE_AFTER_LSPD');
4294: hr_utility.raise_error;
4295: end if;
4296: end if;
4297: --
4298: -- 115.67 (END)

Line 4305: hr_utility.set_location('Leaving '||l_proc,50);

4301: close pps_not_ended;
4302: else
4303: close old_pps_exists;
4304: end if;
4305: hr_utility.set_location('Leaving '||l_proc,50);
4306: end;
4307: --
4308: procedure check_birth_date(p_person_id NUMBER)
4309: is

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

4327: --
4328: if get_payroll%FOUND
4329: then
4330: close get_payroll;
4331: hr_utility.set_message('801','HR_7950_PPM_NULL_DOB');
4332: hr_utility.raise_error;
4333: else
4334: close get_payroll;
4335: end if;

Line 4332: hr_utility.raise_error;

4328: if get_payroll%FOUND
4329: then
4330: close get_payroll;
4331: hr_utility.set_message('801','HR_7950_PPM_NULL_DOB');
4332: hr_utility.raise_error;
4333: else
4334: close get_payroll;
4335: end if;
4336: end;

Line 4432: hr_utility.set_location('Entering '||l_proc,1);

4428: l_ptu_nextval number;
4429: l_object_version_number number;
4430: --
4431: begin
4432: hr_utility.set_location('Entering '||l_proc,1);
4433: hr_utility.set_location('person_id: '||p_person_id,2);
4434: open csr_per_exists(p_person_id, p_cov_date_start);
4435: fetch csr_per_exists into l_dummy;
4436: if csr_per_exists%found then

Line 4433: hr_utility.set_location('person_id: '||p_person_id,2);

4429: l_object_version_number number;
4430: --
4431: begin
4432: hr_utility.set_location('Entering '||l_proc,1);
4433: hr_utility.set_location('person_id: '||p_person_id,2);
4434: open csr_per_exists(p_person_id, p_cov_date_start);
4435: fetch csr_per_exists into l_dummy;
4436: if csr_per_exists%found then
4437: hr_utility.set_location(l_proc,5);

Line 4437: hr_utility.set_location(l_proc,5);

4433: hr_utility.set_location('person_id: '||p_person_id,2);
4434: open csr_per_exists(p_person_id, p_cov_date_start);
4435: fetch csr_per_exists into l_dummy;
4436: if csr_per_exists%found then
4437: hr_utility.set_location(l_proc,5);
4438: close csr_per_exists; --no need to create precursor row since person exists as of cov.s.d.
4439: else
4440: hr_utility.set_location(l_proc,10);
4441: close csr_per_exists;

Line 4440: hr_utility.set_location(l_proc,10);

4436: if csr_per_exists%found then
4437: hr_utility.set_location(l_proc,5);
4438: close csr_per_exists; --no need to create precursor row since person exists as of cov.s.d.
4439: else
4440: hr_utility.set_location(l_proc,10);
4441: close csr_per_exists;
4442: --
4443: open csr_per_details(p_person_id);
4444: fetch csr_per_details into l_per_rec; -- fetch once to get earliest record only

Line 4460: hr_utility.set_location(l_proc,15);

4456: where address_id = l_address_id.address_id;
4457: end loop;
4458: --
4459: if l_system_person_type = 'OTHER' then --first DT record is "OTHER" so simply extend back
4460: hr_utility.set_location(l_proc,15);
4461: update per_all_people_f
4462: set effective_start_date = p_cov_date_start,
4463: start_date = p_cov_date_start
4464: where person_id = p_person_id

Line 4482: hr_utility.set_location(l_proc,20);

4478: and ptu.person_type_id in (select ppt.person_type_id
4479: from per_person_types ppt
4480: where ppt.system_person_type = 'OTHER');
4481: else
4482: hr_utility.set_location(l_proc,20);
4483: -- now change some of the fields before inserting precursor row
4484: l_per_rec.applicant_number := null;
4485: l_per_rec.employee_number := null;
4486: l_per_rec.current_employee_flag := null;

Line 4701: hr_utility.set_location('Leaving '||l_proc,25);

4697: );
4698: --
4699: end if;
4700: end if;
4701: hr_utility.set_location('Leaving '||l_proc,25);
4702: end ins_or_upd_precursor_row;
4703: --
4704: --
4705: PROCEDURE maintain_coverage

Line 4740: hr_utility.set_location(l_proc,5);

4736: l_pds_date_start date;
4737: --
4738: begin
4739: if p_type = 'EMP' then
4740: hr_utility.set_location(l_proc,5);
4741: open csr_last_hire_date(p_person_id);
4742: fetch csr_last_hire_date into l_pds_date_start;
4743: close csr_last_hire_date;
4744: --

Line 4753: hr_utility.set_location(l_proc,15);

4749: l_cov_date_start := l_cov_rec.date_start;
4750: else
4751: l_cov_date_start := l_pds_date_start;
4752: end if;
4753: hr_utility.set_location(l_proc,15);
4754: ins_or_upd_precursor_row(l_cov_rec.contact_person_id, l_cov_date_start);
4755: end loop;
4756: elsif p_type = 'CONT' then
4757: hr_utility.set_location(l_proc,20);

Line 4757: hr_utility.set_location(l_proc,20);

4753: hr_utility.set_location(l_proc,15);
4754: ins_or_upd_precursor_row(l_cov_rec.contact_person_id, l_cov_date_start);
4755: end loop;
4756: elsif p_type = 'CONT' then
4757: hr_utility.set_location(l_proc,20);
4758: for l_cov_rec1 --person_id, date_start
4759: in csr_get_person(p_person_id)
4760: loop
4761: open csr_last_hire_date(l_cov_rec1.person_id);

Line 4770: hr_utility.set_location(l_proc,30);

4766: l_cov_date_start := l_cov_rec1.date_start;
4767: else
4768: l_cov_date_start := l_pds_date_start;
4769: end if;
4770: hr_utility.set_location(l_proc,30);
4771: ins_or_upd_precursor_row(p_person_id, l_cov_date_start);
4772: end loop;
4773: end if;
4774: hr_utility.set_location('Leaving '||l_proc,40);

Line 4774: hr_utility.set_location('Leaving '||l_proc,40);

4770: hr_utility.set_location(l_proc,30);
4771: ins_or_upd_precursor_row(p_person_id, l_cov_date_start);
4772: end loop;
4773: end if;
4774: hr_utility.set_location('Leaving '||l_proc,40);
4775: end maintain_coverage;
4776: --
4777: --
4778: END PER_PEOPLE12_PKG;