1: PACKAGE BODY HR_SESSION_UTILITIES AS
2: /* $Header: hrsessuw.pkb 120.1 2005/09/23 15:54:57 svittal noship $*/
3: -- ----------------------------------------------------------------------------
4: -- |--< VARIABLES >-----------------------------------------------------------|
5: -- ----------------------------------------------------------------------------
76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: hr_utility.set_message
80: ( hr_session_utilities.g_PER_application_id
81: , 'HR_6153_ALL_PROCEDURE_FAIL'
82: );
83: hr_utility.set_message_token('PROCEDURE', l_proc);
84: hr_utility.set_message_token('STEP', sqlerrm);
81: , 'HR_6153_ALL_PROCEDURE_FAIL'
82: );
83: hr_utility.set_message_token('PROCEDURE', l_proc);
84: hr_utility.set_message_token('STEP', sqlerrm);
85: RAISE hr_session_utilities.g_fatal_error;
86: END insert_session_row;
87: -- ----------------------------------------------------------------------------
88: -- |--< insert_session_row >--------------------------------------------------|
89: -- ----------------------------------------------------------------------------
120: --
121: EXCEPTION
122: WHEN OTHERS THEN
123: hr_utility.set_message
124: ( hr_session_utilities.g_PER_application_id
125: , 'HR_6153_ALL_PROCEDURE_FAIL'
126: );
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP', sqlerrm);
125: , 'HR_6153_ALL_PROCEDURE_FAIL'
126: );
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP', sqlerrm);
129: RAISE hr_session_utilities.g_fatal_error;
130: END insert_session_row;
131: -- ----------------------------------------------------------------------------
132: -- |--< remove_session_row >--------------------------------------------------|
133: -- ----------------------------------------------------------------------------
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: hr_utility.set_message
161: ( hr_session_utilities.g_PER_application_id
162: , 'HR_6153_ALL_PROCEDURE_FAIL'
163: );
164: hr_utility.set_message_token('PROCEDURE', l_proc);
165: hr_utility.set_message_token('STEP', sqlerrm);
162: , 'HR_6153_ALL_PROCEDURE_FAIL'
163: );
164: hr_utility.set_message_token('PROCEDURE', l_proc);
165: hr_utility.set_message_token('STEP', sqlerrm);
166: RAISE hr_session_utilities.g_fatal_error;
167: END remove_session_row;
168: -- ----------------------------------------------------------------------------
169: -- |--< Get_Installation_Status >---------------------------------------------|
170: -- ----------------------------------------------------------------------------
193: RETURN l_hr_installation_status;
194: EXCEPTION
195: WHEN OTHERS THEN
196: hr_utility.set_message
197: ( hr_session_utilities.g_PER_application_id
198: , 'HR_6153_ALL_PROCEDURE_FAIL'
199: );
200: hr_utility.set_message_token('PROCEDURE', l_proc);
201: hr_utility.set_message_token('STEP', sqlerrm);
198: , 'HR_6153_ALL_PROCEDURE_FAIL'
199: );
200: hr_utility.set_message_token('PROCEDURE', l_proc);
201: hr_utility.set_message_token('STEP', sqlerrm);
202: RAISE hr_session_utilities.g_fatal_error;
203: END Get_Installation_Status;
204: -- ----------------------------------------------------------------------------
205: -- |--< validate_session >----------------------------------------------------|
206: -- ----------------------------------------------------------------------------
453: RETURN icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
454: EXCEPTION
455: WHEN OTHERS THEN
456: hr_utility.set_message
457: ( hr_session_utilities.g_PER_application_id
458: , 'HR_6153_ALL_PROCEDURE_FAIL'
459: );
460: hr_utility.set_message_token('PROCEDURE', l_proc);
461: hr_utility.set_message_token('STEP', sqlerrm);
458: , 'HR_6153_ALL_PROCEDURE_FAIL'
459: );
460: hr_utility.set_message_token('PROCEDURE', l_proc);
461: hr_utility.set_message_token('STEP', sqlerrm);
462: RAISE hr_session_utilities.g_fatal_error;
463: END get_language_code;
464: -- ----------------------------------------------------------------------------
465: -- |--< get_image_directory >-------------------------------------------------|
466: -- ----------------------------------------------------------------------------
480: IF g_debug THEN
481: hr_utility.set_location('Entering : ' || l_proc, 5);
482: END IF;
483:
484: RETURN '/' || hr_session_utilities.g_image_dir || '/'
485: || get_language_code||'/';
486: EXCEPTION
487: WHEN OTHERS THEN
488: hr_utility.set_message
485: || get_language_code||'/';
486: EXCEPTION
487: WHEN OTHERS THEN
488: hr_utility.set_message
489: ( hr_session_utilities.g_PER_application_id
490: , 'HR_6153_ALL_PROCEDURE_FAIL'
491: );
492: hr_utility.set_message_token('PROCEDURE', l_proc);
493: hr_utility.set_message_token('STEP', sqlerrm);
490: , 'HR_6153_ALL_PROCEDURE_FAIL'
491: );
492: hr_utility.set_message_token('PROCEDURE', l_proc);
493: hr_utility.set_message_token('STEP', sqlerrm);
494: RAISE hr_session_utilities.g_fatal_error;
495: END get_image_directory;
496: -- ----------------------------------------------------------------------------
497: -- |--< get_html_directory >--------------------------------------------------|
498: -- ----------------------------------------------------------------------------
515: END IF;
516:
517:
518: RETURN
519: '/' || hr_session_utilities.g_html_dir || '/' || get_language_code||'/';
520: EXCEPTION
521: WHEN OTHERS THEN
522: hr_utility.set_message
523: ( hr_session_utilities.g_PER_application_id
519: '/' || hr_session_utilities.g_html_dir || '/' || get_language_code||'/';
520: EXCEPTION
521: WHEN OTHERS THEN
522: hr_utility.set_message
523: ( hr_session_utilities.g_PER_application_id
524: , 'HR_6153_ALL_PROCEDURE_FAIL'
525: );
526: hr_utility.set_message_token('PROCEDURE', l_proc);
527: hr_utility.set_message_token('STEP', sqlerrm);
524: , 'HR_6153_ALL_PROCEDURE_FAIL'
525: );
526: hr_utility.set_message_token('PROCEDURE', l_proc);
527: hr_utility.set_message_token('STEP', sqlerrm);
528: RAISE hr_session_utilities.g_fatal_error;
529: END get_html_directory;
530: -- ----------------------------------------------------------------------------
531: -- |--< get_static_html_directory >-------------------------------------------|
532: -- ----------------------------------------------------------------------------
549: END IF;
550:
551: RETURN
552: '/' ||
553: hr_session_utilities.g_static_html_dir ||'/';
554: EXCEPTION
555: WHEN OTHERS THEN
556: hr_utility.set_message
557: ( hr_session_utilities.g_PER_application_id
553: hr_session_utilities.g_static_html_dir ||'/';
554: EXCEPTION
555: WHEN OTHERS THEN
556: hr_utility.set_message
557: ( hr_session_utilities.g_PER_application_id
558: , 'HR_6153_ALL_PROCEDURE_FAIL'
559: );
560: hr_utility.set_message_token('PROCEDURE', l_proc);
561: hr_utility.set_message_token('STEP', sqlerrm);
558: , 'HR_6153_ALL_PROCEDURE_FAIL'
559: );
560: hr_utility.set_message_token('PROCEDURE', l_proc);
561: hr_utility.set_message_token('STEP', sqlerrm);
562: RAISE hr_session_utilities.g_fatal_error;
563: END get_static_html_directory;
564: -- ----------------------------------------------------------------------------
565: -- |--< get_java_directory >--------------------------------------------------|
566: -- ----------------------------------------------------------------------------
582: hr_utility.set_location('Entering : ' || l_proc, 5);
583: END IF;
584:
585: --
586: RETURN hr_session_utilities.g_java_dir || get_language_code||'/';
587: EXCEPTION
588: WHEN OTHERS THEN
589: hr_utility.set_message
590: ( hr_session_utilities.g_PER_application_id
586: RETURN hr_session_utilities.g_java_dir || get_language_code||'/';
587: EXCEPTION
588: WHEN OTHERS THEN
589: hr_utility.set_message
590: ( hr_session_utilities.g_PER_application_id
591: , 'HR_6153_ALL_PROCEDURE_FAIL'
592: );
593: hr_utility.set_message_token('PROCEDURE', l_proc);
594: hr_utility.set_message_token('STEP', sqlerrm);
591: , 'HR_6153_ALL_PROCEDURE_FAIL'
592: );
593: hr_utility.set_message_token('PROCEDURE', l_proc);
594: hr_utility.set_message_token('STEP', sqlerrm);
595: RAISE hr_session_utilities.g_fatal_error;
596: END get_java_directory;
597: -- ----------------------------------------------------------------------------
598: -- |--< get_user_date_format >------------------------------------------------|
599: -- ----------------------------------------------------------------------------
637: RETURN l_owa;
638: EXCEPTION
639: WHEN OTHERS THEN
640: hr_utility.set_message
641: ( hr_session_utilities.g_PER_application_id
642: , 'HR_6153_ALL_PROCEDURE_FAIL'
643: );
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP', sqlerrm);
642: , 'HR_6153_ALL_PROCEDURE_FAIL'
643: );
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP', sqlerrm);
646: RAISE hr_session_utilities.g_fatal_error;
647: END Get_Base_HREF;
648: -- ----------------------------------------------------------------------------
649: -- |--< Get_Today >-----------------------------------------------------------|
650: -- ----------------------------------------------------------------------------
767: --
768: -- bug 748569 fix: validate_session package initialization code eliminated
769: -- handled by frame drawing procedures only
770: --
771: g_loggedin_user := hr_session_utilities.get_LoggedIn_User;
772: */
773:
774: END HR_SESSION_UTILITIES;
770: --
771: g_loggedin_user := hr_session_utilities.get_LoggedIn_User;
772: */
773:
774: END HR_SESSION_UTILITIES;