eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SESSION_UTILITIES dependencies on HR_UTILITY

Line 13: g_debug boolean := hr_utility.debug_enabled;

9: g_loggedin_user per_people_f%ROWTYPE;
10: l_val_person_id per_people_f.person_id%TYPE;
11: g_do_process BOOLEAN;
12: --2721758
13: g_debug boolean := hr_utility.debug_enabled;
14: -- ----------------------------------------------------------------------------
15: -- |--< Get_LoggedIn_User >---------------------------------------------------|
16: -- ----------------------------------------------------------------------------
17: FUNCTION Get_LoggedIn_User

Line 24: g_debug := hr_utility.debug_enabled;

20: l_person_id per_people_f.person_id%TYPE;
21: --
22: l_proc VARCHAR2 (72) ;
23: BEGIN
24: g_debug := hr_utility.debug_enabled;
25:
26: IF g_debug THEN
27: l_proc := g_package || ' Get_LoggedIn_User';
28: hr_utility.set_location('Entering : ' || l_proc, 5);

Line 28: hr_utility.set_location('Entering : ' || l_proc, 5);

24: g_debug := hr_utility.debug_enabled;
25:
26: IF g_debug THEN
27: l_proc := g_package || ' Get_LoggedIn_User';
28: hr_utility.set_location('Entering : ' || l_proc, 5);
29: END IF;
30:
31: -- note validate session is only used to retrieve data here
32: -- not actually used to validate the session (done outside of the function)

Line 63: g_debug := hr_utility.debug_enabled;

59: IS
60: --
61: l_proc VARCHAR2 (72) := g_package || 'insert_session_row';
62: BEGIN
63: g_debug := hr_utility.debug_enabled;
64:
65: IF g_debug THEN
66: hr_utility.set_location('Entering : ' || l_proc, 5);
67: END IF;

Line 66: hr_utility.set_location('Entering : ' || l_proc, 5);

62: BEGIN
63: g_debug := hr_utility.debug_enabled;
64:
65: IF g_debug THEN
66: hr_utility.set_location('Entering : ' || l_proc, 5);
67: END IF;
68:
69: --
70: dt_fndate.set_effective_date(trunc(p_effective_date));

Line 74: hr_utility.set_location('Leaving : ' || l_proc, 10);

70: dt_fndate.set_effective_date(trunc(p_effective_date));
71: --
72:
73: IF g_debug THEN
74: hr_utility.set_location('Leaving : ' || l_proc, 10);
75: END IF;
76:
77: EXCEPTION
78: WHEN OTHERS THEN

Line 79: hr_utility.set_message

75: END IF;
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);

Line 83: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
85: RAISE hr_session_utilities.g_fatal_error;
86: END insert_session_row;
87: -- ----------------------------------------------------------------------------

Line 84: hr_utility.set_message_token('STEP', sqlerrm);

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);
85: RAISE hr_session_utilities.g_fatal_error;
86: END insert_session_row;
87: -- ----------------------------------------------------------------------------
88: -- |--< insert_session_row >--------------------------------------------------|

Line 104: g_debug := hr_utility.debug_enabled;

100: l_date date;
101: --
102: l_proc VARCHAR2 (72) := g_package || 'insert_session_row';
103: BEGIN
104: g_debug := hr_utility.debug_enabled;
105:
106: IF g_debug THEN
107: hr_utility.set_location('Entering : ' || l_proc, 5);
108: END IF;

Line 107: hr_utility.set_location('Entering : ' || l_proc, 5);

103: BEGIN
104: g_debug := hr_utility.debug_enabled;
105:
106: IF g_debug THEN
107: hr_utility.set_location('Entering : ' || l_proc, 5);
108: END IF;
109:
110: --
111: l_date := trunc(SYSDATE);

Line 117: hr_utility.set_location('Leaving : ' || l_proc, 10);

113: dt_fndate.set_effective_date(l_date);
114: --
115:
116: IF g_debug THEN
117: hr_utility.set_location('Leaving : ' || l_proc, 10);
118: END IF;
119:
120: --
121: EXCEPTION

Line 123: hr_utility.set_message

119:
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);

Line 127: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
129: RAISE hr_session_utilities.g_fatal_error;
130: END insert_session_row;
131: -- ----------------------------------------------------------------------------

Line 128: hr_utility.set_message_token('STEP', sqlerrm);

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);
129: RAISE hr_session_utilities.g_fatal_error;
130: END insert_session_row;
131: -- ----------------------------------------------------------------------------
132: -- |--< remove_session_row >--------------------------------------------------|

Line 145: g_debug := hr_utility.debug_enabled;

141: l_person_id per_people_f.person_id%type;
142: --
143: l_proc VARCHAR2 (72) := g_package || ' remove_session_row';
144: BEGIN
145: g_debug := hr_utility.debug_enabled;
146:
147: IF g_debug THEN
148: hr_utility.set_location('Entering : ' || l_proc, 5);
149: END IF;

Line 148: hr_utility.set_location('Entering : ' || l_proc, 5);

144: BEGIN
145: g_debug := hr_utility.debug_enabled;
146:
147: IF g_debug THEN
148: hr_utility.set_location('Entering : ' || l_proc, 5);
149: END IF;
150:
151: delete from fnd_sessions
152: where session_id = userenv('sessionid');

Line 155: hr_utility.set_location('Leaving : ' || l_proc, 10);

151: delete from fnd_sessions
152: where session_id = userenv('sessionid');
153:
154: IF g_debug THEN
155: hr_utility.set_location('Leaving : ' || l_proc, 10);
156: END IF;
157:
158: EXCEPTION
159: WHEN OTHERS THEN

Line 160: hr_utility.set_message

156: END IF;
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);

Line 164: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
166: RAISE hr_session_utilities.g_fatal_error;
167: END remove_session_row;
168: -- ----------------------------------------------------------------------------

Line 165: hr_utility.set_message_token('STEP', sqlerrm);

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);
166: RAISE hr_session_utilities.g_fatal_error;
167: END remove_session_row;
168: -- ----------------------------------------------------------------------------
169: -- |--< Get_Installation_Status >---------------------------------------------|

Line 186: hr_utility.set_location('Entering : ' || l_proc, 5);

182: l_proc VARCHAR2 (72) := g_package || ' Get_Installation_Status';
183: BEGIN
184:
185: IF g_debug THEN
186: hr_utility.set_location('Entering : ' || l_proc, 5);
187: END IF;
188:
189: OPEN csr_hr_installation_status(p_application_id => p_application_id);
190: FETCH csr_hr_installation_status into l_hr_installation_status;

Line 196: hr_utility.set_message

192: --
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);

Line 200: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
202: RAISE hr_session_utilities.g_fatal_error;
203: END Get_Installation_Status;
204: -- ----------------------------------------------------------------------------

Line 201: hr_utility.set_message_token('STEP', sqlerrm);

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);
202: RAISE hr_session_utilities.g_fatal_error;
203: END Get_Installation_Status;
204: -- ----------------------------------------------------------------------------
205: -- |--< validate_session >----------------------------------------------------|

Line 237: hr_utility.set_location('Entering : ' || l_proc, 5);

233: BEGIN
234:
235: IF g_debug THEN
236: l_proc := g_package || ' validate_session';
237: hr_utility.set_location('Entering : ' || l_proc, 5);
238: END IF;
239:
240: hr_util_misc_web.validate_session
241: (p_person_id => l_person_id

Line 250: hr_utility.set_location('Leaving : ' || l_proc, 5);

246: ,p_icx_commit => p_icx_commit); -- 10/15/97 Changed
247: p_person_id := l_person_id;
248:
249: IF g_debug THEN
250: hr_utility.set_location('Leaving : ' || l_proc, 5);
251: END IF;
252:
253: EXCEPTION
254: WHEN OTHERS THEN

Line 291: hr_utility.set_location('Entering : ' || l_proc, 5);

287: BEGIN
288:
289: IF g_debug THEN
290: l_proc := g_package || ' validate_session';
291: hr_utility.set_location('Entering : ' || l_proc, 5);
292: END IF;
293:
294: -- validate the session
295: -- ----------------------------------------------------------------------------

Line 308: hr_utility.set_location(l_proc, 10);

304: RAISE g_fatal_error;
305: ELSE
306:
307: IF g_debug THEN
308: hr_utility.set_location(l_proc, 10);
309: END IF;
310:
311: --
312: -- ensure HR is fully installed, else raise error

Line 348: hr_utility.set_location(l_proc, 10);

344: END IF;
345: -- ----------------------------------------------------------------------------
346:
347: IF g_debug THEN
348: hr_utility.set_location(l_proc, 10);
349: END IF;
350:
351: --
352: -- getid with a parm of 10 returns the web user id.

Line 364: hr_utility.set_location(l_proc, 20);

360: -- determine if the web user is -1 (pseudo session)
361: IF l_web_user_id = -1 then
362:
363: IF g_debug THEN
364: hr_utility.set_location(l_proc, 20);
365: END IF;
366:
367: -- as we are in a pseudo session get the cookie record
368: -- for the cookie WF_SESSION

Line 383: hr_utility.set_location(l_proc, 30);

379: --
380: ELSE
381:
382: IF g_debug THEN
383: hr_utility.set_location(l_proc, 30);
384: END IF;
385:
386: -- the WF_SESSION cookie does not exist. a serious error
387: -- has ocurred which must be reported

Line 395: hr_utility.set_location(l_proc, 40);

391: END IF;
392: ELSE
393:
394: IF g_debug THEN
395: hr_utility.set_location(l_proc, 40);
396: END IF;
397:
398: -- 11/14/96 the person_id is stored in security attribute values
399: -- associated with a web user.

Line 415: hr_utility.set_location('Leaving : ' || l_proc, 10);

411: p_web_username := l_web_username;
412: --
413:
414: IF g_debug THEN
415: hr_utility.set_location('Leaving : ' || l_proc, 10);
416: END IF;
417:
418: EXCEPTION
419: -- too many rows will be returned if the csr_iwu returns more than

Line 447: g_debug := hr_utility.debug_enabled;

443: --
444: --
445: l_proc VARCHAR2 (72) := g_package || ' get_language_code';
446: BEGIN
447: g_debug := hr_utility.debug_enabled;
448:
449: IF g_debug THEN
450: hr_utility.set_location('Entering : ' || l_proc, 5);
451: END IF;

Line 450: hr_utility.set_location('Entering : ' || l_proc, 5);

446: BEGIN
447: g_debug := hr_utility.debug_enabled;
448:
449: IF g_debug THEN
450: hr_utility.set_location('Entering : ' || l_proc, 5);
451: END IF;
452:
453: RETURN icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
454: EXCEPTION

Line 456: hr_utility.set_message

452:
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);

Line 460: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
462: RAISE hr_session_utilities.g_fatal_error;
463: END get_language_code;
464: -- ----------------------------------------------------------------------------

Line 461: hr_utility.set_message_token('STEP', sqlerrm);

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);
462: RAISE hr_session_utilities.g_fatal_error;
463: END get_language_code;
464: -- ----------------------------------------------------------------------------
465: -- |--< get_image_directory >-------------------------------------------------|

Line 478: g_debug := hr_utility.debug_enabled;

474: RETURN VARCHAR2
475: IS
476: l_proc VARCHAR2 (72) := g_package || ' get_image_directory';
477: BEGIN
478: g_debug := hr_utility.debug_enabled;
479:
480: IF g_debug THEN
481: hr_utility.set_location('Entering : ' || l_proc, 5);
482: END IF;

Line 481: hr_utility.set_location('Entering : ' || l_proc, 5);

477: BEGIN
478: g_debug := hr_utility.debug_enabled;
479:
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||'/';

Line 488: hr_utility.set_message

484: RETURN '/' || hr_session_utilities.g_image_dir || '/'
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);

Line 492: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
494: RAISE hr_session_utilities.g_fatal_error;
495: END get_image_directory;
496: -- ----------------------------------------------------------------------------

Line 493: hr_utility.set_message_token('STEP', sqlerrm);

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);
494: RAISE hr_session_utilities.g_fatal_error;
495: END get_image_directory;
496: -- ----------------------------------------------------------------------------
497: -- |--< get_html_directory >--------------------------------------------------|

Line 511: g_debug := hr_utility.debug_enabled;

507: --
508: --
509: l_proc VARCHAR2 (72) := g_package || ' get_html_directory';
510: BEGIN
511: g_debug := hr_utility.debug_enabled;
512:
513: IF g_debug THEN
514: hr_utility.set_location('Entering : ' || l_proc, 5);
515: END IF;

Line 514: hr_utility.set_location('Entering : ' || l_proc, 5);

510: BEGIN
511: g_debug := hr_utility.debug_enabled;
512:
513: IF g_debug THEN
514: hr_utility.set_location('Entering : ' || l_proc, 5);
515: END IF;
516:
517:
518: RETURN

Line 522: hr_utility.set_message

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
524: , 'HR_6153_ALL_PROCEDURE_FAIL'
525: );
526: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 526: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
528: RAISE hr_session_utilities.g_fatal_error;
529: END get_html_directory;
530: -- ----------------------------------------------------------------------------

Line 527: hr_utility.set_message_token('STEP', sqlerrm);

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);
528: RAISE hr_session_utilities.g_fatal_error;
529: END get_html_directory;
530: -- ----------------------------------------------------------------------------
531: -- |--< get_static_html_directory >-------------------------------------------|

Line 545: g_debug := hr_utility.debug_enabled;

541: --
542: --
543: l_proc VARCHAR2 (72) := g_package || ' get_static_html_directory';
544: BEGIN
545: g_debug := hr_utility.debug_enabled;
546:
547: IF g_debug THEN
548: hr_utility.set_location('Entering : ' || l_proc, 5);
549: END IF;

Line 548: hr_utility.set_location('Entering : ' || l_proc, 5);

544: BEGIN
545: g_debug := hr_utility.debug_enabled;
546:
547: IF g_debug THEN
548: hr_utility.set_location('Entering : ' || l_proc, 5);
549: END IF;
550:
551: RETURN
552: '/' ||

Line 556: hr_utility.set_message

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
558: , 'HR_6153_ALL_PROCEDURE_FAIL'
559: );
560: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 560: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
562: RAISE hr_session_utilities.g_fatal_error;
563: END get_static_html_directory;
564: -- ----------------------------------------------------------------------------

Line 561: hr_utility.set_message_token('STEP', sqlerrm);

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);
562: RAISE hr_session_utilities.g_fatal_error;
563: END get_static_html_directory;
564: -- ----------------------------------------------------------------------------
565: -- |--< get_java_directory >--------------------------------------------------|

Line 579: g_debug := hr_utility.debug_enabled;

575: --
576: --
577: l_proc VARCHAR2 (72) := g_package || ' get_java_directory';
578: BEGIN
579: g_debug := hr_utility.debug_enabled;
580:
581: IF g_debug THEN
582: hr_utility.set_location('Entering : ' || l_proc, 5);
583: END IF;

Line 582: hr_utility.set_location('Entering : ' || l_proc, 5);

578: BEGIN
579: g_debug := hr_utility.debug_enabled;
580:
581: IF g_debug THEN
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||'/';

Line 589: hr_utility.set_message

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
591: , 'HR_6153_ALL_PROCEDURE_FAIL'
592: );
593: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 593: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
595: RAISE hr_session_utilities.g_fatal_error;
596: END get_java_directory;
597: -- ----------------------------------------------------------------------------

Line 594: hr_utility.set_message_token('STEP', sqlerrm);

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);
595: RAISE hr_session_utilities.g_fatal_error;
596: END get_java_directory;
597: -- ----------------------------------------------------------------------------
598: -- |--< get_user_date_format >------------------------------------------------|

Line 624: g_debug := hr_utility.debug_enabled;

620: IS
621: l_owa VARCHAR2 (1000);
622: l_proc VARCHAR2 (72) := g_package || ' Get_Base_HREF';
623: BEGIN
624: g_debug := hr_utility.debug_enabled;
625:
626: IF g_debug THEN
627: hr_utility.set_location('Entering : ' || l_proc, 5);
628: END IF;

Line 627: hr_utility.set_location('Entering : ' || l_proc, 5);

623: BEGIN
624: g_debug := hr_utility.debug_enabled;
625:
626: IF g_debug THEN
627: hr_utility.set_location('Entering : ' || l_proc, 5);
628: END IF;
629:
630: -- Fix for bug 894682
631: l_owa := FND_WEB_CONFIG.PLSQL_AGENT;

Line 634: hr_utility.set_location('Leaving : ' || l_proc, 10);

630: -- Fix for bug 894682
631: l_owa := FND_WEB_CONFIG.PLSQL_AGENT;
632:
633: IF g_debug THEN
634: hr_utility.set_location('Leaving : ' || l_proc, 10);
635: END IF;
636:
637: RETURN l_owa;
638: EXCEPTION

Line 640: hr_utility.set_message

636:
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);

Line 644: hr_utility.set_message_token('PROCEDURE', l_proc);

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);
646: RAISE hr_session_utilities.g_fatal_error;
647: END Get_Base_HREF;
648: -- ----------------------------------------------------------------------------

Line 645: hr_utility.set_message_token('STEP', sqlerrm);

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);
646: RAISE hr_session_utilities.g_fatal_error;
647: END Get_Base_HREF;
648: -- ----------------------------------------------------------------------------
649: -- |--< Get_Today >-----------------------------------------------------------|

Line 681: g_debug := hr_utility.debug_enabled;

677: l_return_val VARCHAR2 (2000);
678: l_user_agent VARCHAR2 (2000) := owa_util.get_cgi_env ('HTTP_USER_AGENT');
679: l_proc VARCHAR2 (72) ;
680: BEGIN
681: g_debug := hr_utility.debug_enabled;
682:
683: IF g_debug THEN
684: l_proc := g_package || ' Get_Print_Action';
685: hr_utility.set_location('Entering : ' || l_proc, 5);

Line 685: hr_utility.set_location('Entering : ' || l_proc, 5);

681: g_debug := hr_utility.debug_enabled;
682:
683: IF g_debug THEN
684: l_proc := g_package || ' Get_Print_Action';
685: hr_utility.set_location('Entering : ' || l_proc, 5);
686: END IF;
687:
688: IF INSTR
689: ( UPPER

Line 753: hr_utility.set_location('Leaving : ' || l_proc, 10);

749: );
750: */
751:
752: IF g_debug THEN
753: hr_utility.set_location('Leaving : ' || l_proc, 10);
754: END IF;
755:
756: --
757: RETURN l_return_val;