306:
307: -- Cursor to fetch the user name of the profile
308: CURSOR c_user_profile_name IS
309: SELECT user_profile_option_name
310: FROM fnd_profile_options_vl
311: WHERE profile_option_name = p_profile_name;
312:
313: l_user_profile_name VARCHAR2(1000);
314:
347: p_user_profile_name := get_user_profile_name(l_profile.object_name);
348: g_object_name := l_profile.object_name ;
349:
350: -- Get the profile option value
351: l_value_code := fnd_profile.value(l_profile.object_name);
352:
353: -- If the profile value is the exception value stored in the set up table,
354: -- store the impact message for this
355: IF (l_value_code = l_profile.exception_value) THEN
901: IF hri_bpl_system.is_full_hr_installed = 'Y' THEN
902:
903: -- If the global start date, job family or job function profile is not set correctly
904: -- then store an impact message and return
905: IF (fnd_profile.value('HR_BIS_JOB_FAMILY') IS NULL AND
906: fnd_profile.value('HR_BIS_JOB_FUNCTION') IS NULL) THEN
907:
908: -- Set the message up
909: fnd_message.set_name
902:
903: -- If the global start date, job family or job function profile is not set correctly
904: -- then store an impact message and return
905: IF (fnd_profile.value('HR_BIS_JOB_FAMILY') IS NULL AND
906: fnd_profile.value('HR_BIS_JOB_FUNCTION') IS NULL) THEN
907:
908: -- Set the message up
909: fnd_message.set_name
910: ('HRI','HRI_407183_UNSET_JOB_PRF_IMPCT');
923:
924: ELSE
925:
926: -- Find the profile value for Job Family and Job Function
927: l_family_vl := fnd_profile.value('HR_BIS_JOB_FAMILY');
928: l_function_vl := fnd_profile.value('HR_BIS_JOB_FUNCTION');
929:
930: -- Get the setup information for job family
931: check_job_group(p_value_set_id => l_family_vl,
924: ELSE
925:
926: -- Find the profile value for Job Family and Job Function
927: l_family_vl := fnd_profile.value('HR_BIS_JOB_FAMILY');
928: l_function_vl := fnd_profile.value('HR_BIS_JOB_FUNCTION');
929:
930: -- Get the setup information for job family
931: check_job_group(p_value_set_id => l_family_vl,
932: p_job_type => 'JOB_FAMILY',