DBA Data[Home] [Help]

APPS.PER_PEOPLE11_PKG dependencies on HR_UTILITY

Line 183: hr_utility.set_location('per_people11_pkg.insert_row1',10);

179: --
180: -- Test current numbers are not used by
181: -- the system already.
182: --
183: hr_utility.set_location('per_people11_pkg.insert_row1',10);
184: hr_person.validate_unique_number(p_person_id =>p_person_id
185: , p_business_group_id => p_business_group_id
186: , p_employee_number => p_employee_number
187: , p_applicant_number => p_applicant_number

Line 194: hr_utility.set_location('Employee Number = '||p_employee_number,20);

190: , p_current_applicant => p_current_applicant_flag
191: , p_current_npw => null --p_current_npw_flag
192: );
193:
194: hr_utility.set_location('Employee Number = '||p_employee_number,20);
195: hr_utility.set_location('Applicant Number = '||p_applicant_number,30);
196:
197: -- bug no 9248094 starts here
198:

Line 195: hr_utility.set_location('Applicant Number = '||p_applicant_number,30);

191: , p_current_npw => null --p_current_npw_flag
192: );
193:
194: hr_utility.set_location('Employee Number = '||p_employee_number,20);
195: hr_utility.set_location('Applicant Number = '||p_applicant_number,30);
196:
197: -- bug no 9248094 starts here
198:
199: if p_date_of_death is not null and trunc(p_date_of_death) > trunc(sysdate) then

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

210:
211: --Start of fix for Bug 2167668
212:
213: IF p_start_date > p_hold_applicant_date_until THEN
214: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
215: hr_utility.set_message_token('HOLD_DATE', p_start_date );
216: hr_utility.raise_error;
217: END IF;
218: -- End of fix for Bug 2167668

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

211: --Start of fix for Bug 2167668
212:
213: IF p_start_date > p_hold_applicant_date_until THEN
214: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
215: hr_utility.set_message_token('HOLD_DATE', p_start_date );
216: hr_utility.raise_error;
217: END IF;
218: -- End of fix for Bug 2167668
219:

Line 216: hr_utility.raise_error;

212:
213: IF p_start_date > p_hold_applicant_date_until THEN
214: hr_utility.set_message('800', 'PER_289796_HOLD_UNTIL_DATE');
215: hr_utility.set_message_token('HOLD_DATE', p_start_date );
216: hr_utility.raise_error;
217: END IF;
218: -- End of fix for Bug 2167668
219:
220: -- #345205

Line 227: hr_utility.set_location('Applicant Number = '||p_applicant_number,35);

223: -- applicant with an initial status of TERM_APL - this requires two person
224: -- rows on successive days.
225: -- DK 27-FEB-96
226: if ( p_person_id is null ) then
227: hr_utility.set_location('Applicant Number = '||p_applicant_number,35);
228: open c1;
229: fetch c1 into p_person_id;
230: close c1;
231: hr_utility.set_location('per_people11_pkg.insert_row1',40);

Line 231: hr_utility.set_location('per_people11_pkg.insert_row1',40);

227: hr_utility.set_location('Applicant Number = '||p_applicant_number,35);
228: open c1;
229: fetch c1 into p_person_id;
230: close c1;
231: hr_utility.set_location('per_people11_pkg.insert_row1',40);
232: end if;
233: --
234: /* BEGIN OF WWBUG 1975359 */
235: if p_party_id is not null then

Line 544: hr_utility.set_location('per_people11_pkg.insert_row1',45);

540: --
541: -- Earlier version comments were moved from this place to
542: -- after the command close c_person.
543: --
544: hr_utility.set_location('per_people11_pkg.insert_row1',45);
545: open c_person;
546: --
547: fetch c_person into l_person;
548: --

Line 557: hr_utility.set_location('Updating party id',10);

553: -- BEGIN TCA_UNMERGE CHANGES
554: --
555: per_hrtca_merge.create_tca_person(p_rec => l_person);
556: --
557: hr_utility.set_location('Updating party id',10);
558: --
559: -- Now assign the resulting party id back to the record.
560: --
561: update per_all_people_f

Line 577: hr_utility.set_location('per_people11_pkg.insert_row1',50);

573: p_action => 'INSERT');
574: */
575: --
576: --
577: hr_utility.set_location('per_people11_pkg.insert_row1',50);
578: --
579: open c2;
580: --
581: fetch c2 into p_rowid;

Line 583: hr_utility.set_location('per_people11_pkg.insert_row1',60);

579: open c2;
580: --
581: fetch c2 into p_rowid;
582: --
583: hr_utility.set_location('per_people11_pkg.insert_row1',60);
584: close c2;
585: --
586: ben_dt_trgr_handle.person(p_rowid => null
587: ,p_business_group_id => p_business_group_id

Line 643: hr_utility.set_location('per_people11_pkg.insert_row1',70);

639: --inserts (note CWK are done in their own API anyway, not here)
640: --2462779: Modification to avoce ref'd fix. Call populate_new_person for
641: -- EMPs and APLs but call populate_new_contact for new OTHERs.
642: --
643: hr_utility.set_location('per_people11_pkg.insert_row1',70);
644: --
645: if p_create_defaults_for in ('EMP','APL') then
646: hr_security_internal.populate_new_person
647: (p_business_group_id=>p_business_group_id

Line 655: hr_utility.set_location('per_people11_pkg.insert_row1',75);

651: (p_business_group_id=>p_business_group_id
652: ,p_person_id =>p_person_id);
653: end if;
654: --
655: hr_utility.set_location('per_people11_pkg.insert_row1',75);
656: --
657: if p_create_defaults_for in ('EMP','APL') then
658: --
659: -- #317298 We must insert a row into per_person_list for the new EMP

Line 678: hr_utility.set_location('per_people11_pkg.insert_row1',80);

674: --,p_person_id =>p_person_id);
675: --
676: if p_create_defaults_for = 'EMP' then
677: --
678: hr_utility.set_location('per_people11_pkg.insert_row1',80);
679: -- insert employee rows.
680: --
681: -- VT 08/13/96
682: per_people9_pkg.insert_employee_rows(p_person_id => p_person_id

Line 701: hr_utility.set_location('per_people11_pkg.insert_row1',90);

697: ,p_adjusted_svc_date =>p_adjusted_svc_date);
698:
699: else
700: --
701: hr_utility.set_location('per_people11_pkg.insert_row1',90);
702: -- do insert applicant rows.
703: --
704: -- VT 08/13/96
705: per_people9_pkg.insert_applicant_rows(p_person_id => p_person_id

Line 721: hr_utility.set_location('per_people11_pkg.insert_row1',100);

717: ,p_created_by => p_created_by
718: ,p_creation_date => p_creation_date
719: );
720: end if;
721: hr_utility.set_location('per_people11_pkg.insert_row1',100);
722: end if;
723: --
724: -- PTU : Start of Changes
725: --

Line 726: hr_utility.set_location('per_people11_pkg.insert_row1',110);

722: end if;
723: --
724: -- PTU : Start of Changes
725: --
726: hr_utility.set_location('per_people11_pkg.insert_row1',110);
727: hr_per_type_usage_internal.maintain_person_type_usage
728: (p_effective_date => p_effective_start_date
729: ,p_person_id => p_person_id
730: ,p_person_type_id => p_person_type_id

Line 739: hr_utility.set_location('Leaving: per_people11_pkg.insert_row1',120);

735: --
736: per_hrwf_synch.per_per_wf(p_rec => l_person,
737: p_action => 'INSERT');
738: --
739: hr_utility.set_location('Leaving: per_people11_pkg.insert_row1',120);
740: end insert_row1;
741: --
742: procedure delete_row1(p_rowid VARCHAR2) is
743:

Line 785: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',10);

781:
782: --Bug 10171874 ends
783:
784: begin
785: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',10);
786:
787: --
788: -- bug 4635241 starts here
789: --

Line 796: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',20);

792: close c_person;
793:
794: -- bug 4635241 end here
795: --
796: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',20);
797:
798: delete from per_all_people_f
799: where rowid=chartorowid(p_rowid);
800: --

Line 805: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',20);

801: -- bug 4635241 starts here
802: --
803: if ( l_person_rec.effective_start_date <= sysdate ) then
804:
805: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',20);
806:
807: open c_person1(l_person_rec.effective_start_date,
808: l_person_rec.person_id);
809: fetch c_person1 into l_person_rec1;

Line 813: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',30);

809: fetch c_person1 into l_person_rec1;
810: if c_person1 % notfound then
811: -- close c_person1; --commented for 9735750
812:
813: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',30);
814:
815: open c_person2(l_person_rec.effective_start_date,
816: l_person_rec.person_id);
817: fetch c_person2 into l_person_rec1;

Line 824: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',40);

820: close c_person1;
821: --
822: if (l_person_rec1.person_id is not null) then
823:
824: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',40);
825:
826: per_hrwf_synch.per_per_wf(l_person_rec1,'INSERT');
827: end if;
828: --

Line 833: hr_utility.set_location('TCA Call per_people11_pkg.delete_row1',40);

829: end if;
830: -- bug 4635241 ends here
831:
832: -- 10171874
833: hr_utility.set_location('TCA Call per_people11_pkg.delete_row1',40);
834:
835: open csr_tca_person(l_person_rec.effective_start_date,l_person_rec.person_id);
836: fetch csr_tca_person into l_tca_person_rec;
837:

Line 839: hr_utility.set_location('TCA Call per_people11_pkg.delete_row1',45);

835: open csr_tca_person(l_person_rec.effective_start_date,l_person_rec.person_id);
836: fetch csr_tca_person into l_tca_person_rec;
837:
838: if csr_tca_person%found then
839: hr_utility.set_location('TCA Call per_people11_pkg.delete_row1',45);
840:
841: per_hrtca_merge.update_tca_person(p_Rec => l_tca_person_rec);
842:
843: hr_utility.set_location('After TCA Call per_people11_pkg.delete_row1',50);

Line 843: hr_utility.set_location('After TCA Call per_people11_pkg.delete_row1',50);

839: hr_utility.set_location('TCA Call per_people11_pkg.delete_row1',45);
840:
841: per_hrtca_merge.update_tca_person(p_Rec => l_tca_person_rec);
842:
843: hr_utility.set_location('After TCA Call per_people11_pkg.delete_row1',50);
844: end if;
845: close csr_tca_person;
846:
847: -- 10171874

Line 849: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',50);

845: close csr_tca_person;
846:
847: -- 10171874
848:
849: hr_utility.set_location('Leaving: per_people11_pkg.delete_row1',50);
850:
851: end delete_row1;
852: --
853: --