[Home] [Help]
1570: -- Check that the person referred by is in the same business group
1571: -- as the business group of the assignment.
1572: --
1573: If (p_business_group_id <> l_business_group_id AND
1574: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
1575: then
1576: --
1577: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1578: hr_multi_message.add
1588: -- Condition to check profile value also added
1589: -- If he is an employee or a contingent worker with the profile set,
1590: -- no errors shown
1591: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1592: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1593: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1594: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1595: hr_multi_message.add
1596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
2898: --
2899: -- Bug 3190625
2900: -- Condition to check profile value also added
2901: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2902: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2903: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2904: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2905: hr_multi_message.add
2906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2910: -- Check that the recruiter is in the same business group
2911: -- as the business group of the applicant assignment.
2912: --
2913: If (p_business_group_id <> l_business_group_id AND
2914: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N')
2915: then
2916: --
2917: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2918: hr_multi_message.add
4624: -- Check that the supervisor is in the same business group as the
4625: -- person of the assignment.
4626: --
4627: If (p_business_group_id <> l_business_group_id AND
4628: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
4629: then
4630: --
4631: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4632: hr_multi_message.add
4639: -- worker where the profile option permits.
4640: --
4641: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4642: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4643: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4644: Then
4645: --Bug3917021
4646: if csr_asg_typ%isopen then
4647: close csr_asg_typ;
4793: -- worker assignment.
4794: --
4795: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4796: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4797: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4798: Then
4799: --
4800: hr_utility.set_location(l_proc, 80);
4801: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');