124: RETURN (icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: hr_utility.trace(' Exception in hr_misc_web.get_language_code ' || SQLERRM);
129: END get_language_code;
130:
131:
132: /*
152: RETURN hr_util_misc_web.get_image_directory;
153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: hr_utility.trace(' Exception in hr_misc_web.get_image_directory ' || SQLERRM);
157: END get_image_directory;
158:
159:
160: /*
248: WHEN OTHERS THEN
249: IF get_org_column_name%isopen then
250: close get_org_column_name;
251: end if;
252: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM);
253: END get_sshr_segment_value;
254:
255:
256: /*
345:
346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM );
350: raise;
351: END get_user_defined_job_segments;
352:
353:
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: CLOSE lc_person_details;
473: hr_utility.trace(' hr_misc_web.get_person_details ' || SQLERRM );
474:
475: END get_person_details;
476:
477:
669: CLOSE lc_assignment_details;
670: CLOSE lc_supervisor_details;
671: CLOSE lc_job_details;
672: CLOSE lc_organization_details;
673: hr_utility.trace( ' hr_misc_web.get_assignment_details ' || SQLERRM );
674:
675: END get_assignment_details;
676:
677:
733:
734: EXCEPTION
735: WHEN OTHERS THEN
736: CLOSE lc_get_assignment;
737: hr_utility.trace(' hr_misc_web.get_assignment_id ' || SQLERRM );
738:
739: END get_assignment_id;
740:
741:
975: RETURN (l_person_rec.business_group_id);
976:
977: EXCEPTION
978: WHEN OTHERS THEN
979: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );
980:
981: END get_business_group_id;
982:
983:
998: RETURN (ln_business_group_id);
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );
1003:
1004: END get_business_group_id;
1005:
1006: /*
1121: RETURN l_legislation_code;
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: hr_utility.trace(' Exception in hr_misc_web.get_legislation_code ' || SQLERRM );
1126:
1127: END get_legislation_code;
1128:
1129: