[Home] [Help]
1610: -- Check that the person referred by is in the same business group
1611: -- as the business group of the assignment.
1612: --
1613: If (p_business_group_id <> l_business_group_id AND
1614: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
1615: then
1616: --
1617: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1618: hr_multi_message.add
1628: -- Condition to check profile value also added
1629: -- If he is an employee or a contingent worker with the profile set,
1630: -- no errors shown
1631: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1632: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1633: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1634: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1635: hr_multi_message.add
1636: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
2938: --
2939: -- Bug 3190625
2940: -- Condition to check profile value also added
2941: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2942: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2943: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2944: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2945: hr_multi_message.add
2946: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2950: -- Check that the recruiter is in the same business group
2951: -- as the business group of the applicant assignment.
2952: --
2953: If (p_business_group_id <> l_business_group_id AND
2954: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N')
2955: then
2956: --
2957: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2958: hr_multi_message.add
4697: -- Check that the supervisor is in the same business group as the
4698: -- person of the assignment.
4699: --
4700: If (p_business_group_id <> l_business_group_id AND
4701: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
4702: then
4703: --
4704: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4705: hr_multi_message.add
4712: -- worker where the profile option permits.
4713: --
4714: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4715: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4716: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4717: Then
4718: --Bug3917021
4719: if csr_asg_typ%isopen then
4720: close csr_asg_typ;
4866: -- worker assignment.
4867: --
4868: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4869: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4870: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4871: Then
4872: --
4873: hr_utility.set_location(l_proc, 80);
4874: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');
4976: -- effective date)
4977: --
4978: -- ER FPT
4979: if hrempter.g_fpt_rev_ter = 'N'
4980: or (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N') then
4981:
4982: per_per_bus.chk_system_pers_type
4983: (p_person_id => p_person_id
4984: ,p_validation_start_date => p_validation_start_date