APPS.PER_APPLICANT_PKG dependencies on HR_UTILITY

Line 389: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 1 ) ;

385: begin
386: --
387: --Create the PERSON record
388: --
389: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 1 ) ;
390: if ( p_method_of_apl_num_gen = 'A' and p_applicant_number is null) then
391: hr_person.generate_number( p_current_employee => 'N',
392: p_current_applicant => 'Y',
393: p_current_npw => 'N',

Line 735: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 2 ) ;

731: -- **************************
732: -- Create the ADDRESS record
733: -- **************************
734: l_dummy_number := NULL ;
735: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 2 ) ;
736: per_addresses_pkg.insert_row(
737: p_row_id => l_dummy_varchar2
738: ,p_address_id => l_dummy_number
739: ,p_business_group_id => p_business_group_id

Line 815: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 3 ) ;

811: end if ;
812: --
813: l_application_id := NULL ;
814: l_dummy_varchar2 := NULL ;
815: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 3 ) ;
816: per_applications_pkg.Insert_Row(p_Rowid => l_dummy_varchar2,
817: p_Application_Id => l_application_id,
818: p_Business_Group_Id => p_business_group_id,
819: p_Person_Id => p_person_id,

Line 858: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;

854: --
855: -- Create the ASSIGNMENT record
856: --
857: --
858: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;
859: l_dummy_number := NULL ;
860: l_dummy_varchar2 := NULL ;
861: --
862: -- Set the end date of the assignment if the status is TERM_APL

Line 1006: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 5 ) ;

1002: l_assignment_id,
1003: p_effective_start_date => p_date_received,
1004: p_effective_end_date => l_asg_end_date) ;
1005: --
1006: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 5 ) ;
1007: update_group ( p_people_group_id,
1008: p_people_group_name ) ;
1009: --
1010: -- Create letter request

Line 1407: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;

1403: from per_business_groups pbg
1404: where business_group_id = p_business_group_id ;
1405: begin
1406: --
1407: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;
1408: -- Retrieve the person type for a system person type of APL
1409: open c1 ;
1410: fetch c1 into p_person_type_id,
1411: p_system_person_type ;

Line 1851: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');

1847: open c1 ;
1848: fetch c1 into l_dummy_number ;
1849: if c1%found then
1850: close c1 ;
1851: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');
1852: hr_utility.raise_error ;
1853: end if ;
1854: close c1 ;
1855: --

Line 1852: hr_utility.raise_error ;

1848: fetch c1 into l_dummy_number ;
1849: if c1%found then
1850: close c1 ;
1851: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');
1852: hr_utility.raise_error ;
1853: end if ;
1854: close c1 ;
1855: --
1856: end check_apl_num_unique ;

Line 1879: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );

1875: open c1 ;
1876: fetch c1 into l_dummy_number ;
1877: if c1%found then
1878: close c1 ;
1879: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );
1880: hr_utility.raise_error ;
1881: end if;
1882: close c1 ;
1883: --

Line 1880: hr_utility.raise_error ;

1876: fetch c1 into l_dummy_number ;
1877: if c1%found then
1878: close c1 ;
1879: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );
1880: hr_utility.raise_error ;
1881: end if;
1882: close c1 ;
1883: --
1884: open c2 ;

Line 1888: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );

1884: open c2 ;
1885: fetch c2 into l_dummy_number ;
1886: if c2%found then
1887: close c2 ;
1888: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );
1889: hr_utility.raise_error ;
1890: end if;
1891: close c2 ;
1892: --

Line 1889: hr_utility.raise_error ;

1885: fetch c2 into l_dummy_number ;
1886: if c2%found then
1887: close c2 ;
1888: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );
1889: hr_utility.raise_error ;
1890: end if;
1891: close c2 ;
1892: --
1893: -- Fix for 3908271 starts here.

Line 1989: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);

1985: -- Fix for bug 3680947 ends here.
1986: --
1987: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
1988:
1989: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
1990:
1991: insert into per_letter_requests
1992: ( letter_request_id,
1993: business_group_id,