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_UTIL_MISC_WEB dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hr_util_misc_web AS
2: /* $Header: hrutlmsw.pkb 120.1 2005/09/23 16:01:33 svittal noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package varchar2(31) := 'hr_util_misc_web.';
6: g_owa_package varchar2(2000) := hr_util_misc_web.g_owa||g_package;
7: --
8: g_image_directory varchar2(30) default null;

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

24:
25:
26: BEGIN
27: --
28: hr_utility.set_location('Entering: '|| l_proc,5);
29: open csr_group_separator;
30: fetch csr_group_separator into l_parameter;
31: close csr_group_separator;
32: hr_utility.set_location('Leaving: '|| l_proc,10);

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

28: hr_utility.set_location('Entering: '|| l_proc,5);
29: open csr_group_separator;
30: fetch csr_group_separator into l_parameter;
31: close csr_group_separator;
32: hr_utility.set_location('Leaving: '|| l_proc,10);
33: RETURN (l_parameter);
34:
35: EXCEPTION
36: WHEN OTHERS THEN

Line 37: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

33: RETURN (l_parameter);
34:
35: EXCEPTION
36: WHEN OTHERS THEN
37: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
38: RETURN null;
39:
40: END get_nls_parameter;
41:

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

45: FUNCTION get_currency_mask
46: RETURN VARCHAR2 IS
47: l_proc constant varchar2(100) := g_package || ' get_currency_mask';
48: BEGIN
49: hr_utility.set_location('Entering: '|| l_proc,5);
50: hr_utility.set_location('Leaving: '|| l_proc,10);
51: RETURN (substr(get_nls_parameter('NLS_CURRENCY'),1,1));
52:
53: END get_currency_mask;

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

46: RETURN VARCHAR2 IS
47: l_proc constant varchar2(100) := g_package || ' get_currency_mask';
48: BEGIN
49: hr_utility.set_location('Entering: '|| l_proc,5);
50: hr_utility.set_location('Leaving: '|| l_proc,10);
51: RETURN (substr(get_nls_parameter('NLS_CURRENCY'),1,1));
52:
53: END get_currency_mask;
54:

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

58: FUNCTION get_group_separator
59: RETURN VARCHAR2 IS
60: l_proc constant varchar2(100) := g_package || ' get_group_separator';
61: BEGIN
62: hr_utility.set_location('Entering: '|| l_proc,5);
63: hr_utility.set_location('Leaving: '|| l_proc,10);
64: RETURN (substr(get_nls_parameter('NLS_NUMERIC_CHARACTERS'),2,1));
65:
66: END get_group_separator;

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

59: RETURN VARCHAR2 IS
60: l_proc constant varchar2(100) := g_package || ' get_group_separator';
61: BEGIN
62: hr_utility.set_location('Entering: '|| l_proc,5);
63: hr_utility.set_location('Leaving: '|| l_proc,10);
64: RETURN (substr(get_nls_parameter('NLS_NUMERIC_CHARACTERS'),2,1));
65:
66: END get_group_separator;
67:

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

74: l_group_separator V$NLS_PARAMETERS.value%type;
75: l_number number;
76: l_proc constant varchar2(100) := g_package || ' is_valid_number';
77: BEGIN
78: hr_utility.set_location('Entering: '|| l_proc,5);
79: l_group_separator := get_group_separator;
80:
81: l_number := to_number
82: (replace(p_number,substr(l_group_separator,1,1)));

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

79: l_group_separator := get_group_separator;
80:
81: l_number := to_number
82: (replace(p_number,substr(l_group_separator,1,1)));
83: hr_utility.set_location('Leaving: '|| l_proc,10);
84: RETURN TRUE;
85:
86: EXCEPTION
87: WHEN OTHERS THEN

Line 88: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

84: RETURN TRUE;
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
89: RETURN FALSE;
90:
91: END is_valid_number;
92:

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

100: l_currency_mask V$NLS_PARAMETERS.value%type;
101: l_number number;
102: l_proc constant varchar2(100) := g_package || ' is_valid_currency';
103: BEGIN
104: hr_utility.set_location('Entering: '|| l_proc,5);
105: --
106: l_group_separator := get_group_separator;
107: l_currency_mask := get_currency_mask;
108:

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

109: l_number := to_number
110: (replace(replace(p_currency
111: ,substr(l_group_separator,1,1))
112: ,substr(l_currency_mask,1,1)));
113: hr_utility.set_location('Leaving: '|| l_proc,10);
114: RETURN TRUE;
115:
116: EXCEPTION
117: WHEN OTHERS THEN

Line 118: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

114: RETURN TRUE;
115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
119: RETURN FALSE;
120:
121: END is_valid_currency;
122:

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

128: FUNCTION get_language_code
129: RETURN varchar2 IS
130: l_proc constant varchar2(100) := g_package || ' get_language_code';
131: BEGIN
132: hr_utility.set_location('Entering: '|| l_proc,5);
133: hr_utility.set_location('Leaving: '|| l_proc,10);
134: RETURN(icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));
135:
136: END get_language_code;

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

129: RETURN varchar2 IS
130: l_proc constant varchar2(100) := g_package || ' get_language_code';
131: BEGIN
132: hr_utility.set_location('Entering: '|| l_proc,5);
133: hr_utility.set_location('Leaving: '|| l_proc,10);
134: RETURN(icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));
135:
136: END get_language_code;
137:

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

142: FUNCTION get_image_directory
143: RETURN varchar2 IS
144: l_proc constant varchar2(100) := g_package || ' get_image_directory';
145: BEGIN
146: hr_utility.set_location('Entering: '|| l_proc,5);
147: --
148: IF g_image_directory IS null THEN
149: g_image_directory := hr_util_misc_web.g_image_dir;
150: END IF;

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

148: IF g_image_directory IS null THEN
149: g_image_directory := hr_util_misc_web.g_image_dir;
150: END IF;
151: --
152: hr_utility.set_location('Leaving: '|| l_proc,10);
153: RETURN g_image_directory;
154: --
155: END get_image_directory;
156:

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

166: FUNCTION get_calendar_file
167: RETURN VARCHAR2 IS
168: l_proc constant varchar2(100) := g_package || ' get_calendar_file';
169: BEGIN
170: hr_utility.set_location('Entering: '|| l_proc,5);
171: hr_utility.set_location('Leaving: '|| l_proc,10);
172: RETURN (hr_util_misc_web.g_html_dir || 'webtools/jslib/cabo_calendar.html');
173: END get_calendar_file;
174:

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

167: RETURN VARCHAR2 IS
168: l_proc constant varchar2(100) := g_package || ' get_calendar_file';
169: BEGIN
170: hr_utility.set_location('Entering: '|| l_proc,5);
171: hr_utility.set_location('Leaving: '|| l_proc,10);
172: RETURN (hr_util_misc_web.g_html_dir || 'webtools/jslib/cabo_calendar.html');
173: END get_calendar_file;
174:
175:

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

180: FUNCTION get_html_directory
181: RETURN varchar2 IS
182: l_proc constant varchar2(100) := g_package || ' get_html_directory';
183: BEGIN
184: hr_utility.set_location('Entering: '|| l_proc,5);
185: --
186: IF g_html_directory IS null THEN
187: g_html_directory := hr_util_misc_web.g_html_dir||get_language_code||'/';
188: END IF;

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

186: IF g_html_directory IS null THEN
187: g_html_directory := hr_util_misc_web.g_html_dir||get_language_code||'/';
188: END IF;
189: --
190: hr_utility.set_location('Leaving: '|| l_proc,10);
191: RETURN g_html_directory;
192: --
193: END get_html_directory;
194:

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

254: l_legislation_code per_business_groups.legislation_code%type default null;
255: l_proc constant varchar2(100) := g_package || ' get_person_rec';
256:
257: BEGIN
258: hr_utility.set_location('Entering: '|| l_proc,5);
259: l_legislation_code := null;
260: OPEN csr_leg_code;
261: hr_utility.trace('Going into Fetch after (OPEN csr_leg_code): '|| l_proc);
262: FETCH csr_leg_code into l_legislation_code;

Line 261: hr_utility.trace('Going into Fetch after (OPEN csr_leg_code): '|| l_proc);

257: BEGIN
258: hr_utility.set_location('Entering: '|| l_proc,5);
259: l_legislation_code := null;
260: OPEN csr_leg_code;
261: hr_utility.trace('Going into Fetch after (OPEN csr_leg_code): '|| l_proc);
262: FETCH csr_leg_code into l_legislation_code;
263: IF csr_leg_code%NOTFOUND
264: THEN
265: CLOSE csr_leg_code;

Line 266: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

262: FETCH csr_leg_code into l_legislation_code;
263: IF csr_leg_code%NOTFOUND
264: THEN
265: CLOSE csr_leg_code;
266: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
267: hr_utility.trace(' Exception HR_7220_INVALID_PRIMARY_KEY ');
268: RAISE g_error_handled;
269: ELSE
270: CLOSE csr_leg_code;

Line 267: hr_utility.trace(' Exception HR_7220_INVALID_PRIMARY_KEY ');

263: IF csr_leg_code%NOTFOUND
264: THEN
265: CLOSE csr_leg_code;
266: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
267: hr_utility.trace(' Exception HR_7220_INVALID_PRIMARY_KEY ');
268: RAISE g_error_handled;
269: ELSE
270: CLOSE csr_leg_code;
271: END IF;

Line 276: hr_utility.trace('Going into Fetch after (OPEN csr_pp(p_person_id p_legislation_code )): '|| l_proc);

272:
273: -- Now get the person record using the legislation code found.
274: OPEN csr_pp(p_person_id => p_person_id
275: ,p_legislation_code => l_legislation_code);
276: hr_utility.trace('Going into Fetch after (OPEN csr_pp(p_person_id p_legislation_code )): '|| l_proc);
277: FETCH csr_pp INTO l_person_rec.business_group_id
278: ,l_person_rec.last_name
279: ,l_person_rec.first_name
280: ,l_person_rec.person_type_id

Line 288: hr_utility.trace(' Exception HR_51396_WEB_PERSON_NOT_FND ');

284:
285: IF csr_pp%NOTFOUND OR csr_pp%NOTFOUND IS null THEN
286: CLOSE csr_pp;
287: fnd_message.set_name('PER','HR_51396_WEB_PERSON_NOT_FND');
288: hr_utility.trace(' Exception HR_51396_WEB_PERSON_NOT_FND ');
289: RAISE g_error_handled;
290: END IF;
291: CLOSE csr_pp;
292: hr_utility.set_location('Leaving: '|| l_proc,20);

Line 292: hr_utility.set_location('Leaving: '|| l_proc,20);

288: hr_utility.trace(' Exception HR_51396_WEB_PERSON_NOT_FND ');
289: RAISE g_error_handled;
290: END IF;
291: CLOSE csr_pp;
292: hr_utility.set_location('Leaving: '|| l_proc,20);
293: RETURN (l_person_rec);
294: --
295: EXCEPTION
296: WHEN others THEN

Line 297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

293: RETURN (l_person_rec);
294: --
295: EXCEPTION
296: WHEN others THEN
297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
298: hr_utility.trace(' Exception ' || sqlerrm );
299: RAISE g_error_handled;
300: END get_person_rec;
301: --

Line 298: hr_utility.trace(' Exception ' || sqlerrm );

294: --
295: EXCEPTION
296: WHEN others THEN
297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
298: hr_utility.trace(' Exception ' || sqlerrm );
299: RAISE g_error_handled;
300: END get_person_rec;
301: --
302: -- ------------------------------------------------------------------------

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

310: RETURN VARCHAR2
311: IS
312: l_proc constant varchar2(100) := g_package || ' return_msg_text';
313: BEGIN
314: hr_utility.set_location('Entering: '|| l_proc,5);
315:
316:
317: fnd_message.set_name (p_application_id, p_message_name);
318: -- To fix 2095929

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

316:
317: fnd_message.set_name (p_application_id, p_message_name);
318: -- To fix 2095929
319: --RETURN fnd_message.get;
320: hr_utility.set_location('Leaving: '|| l_proc,10);
321: RETURN replace(fnd_message.get,'''','\''');
322: END return_msg_text;
323: -- ----------------------------------------------------------------------------
324: -- |--< Get_lookup_values >---------------------------------------------------|

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

335: --
336: -- l_proc VARCHAR2 (72) := g_package || ' Get_lookup_values';
337: --
338: BEGIN
339: hr_utility.set_location('Entering: '|| l_proc,5);
340: --
341: l_temp_array := HR_GENERAL_UTILITIES.Get_lookup_values
342: (p_lookup_type => p_lookup_type);
343:

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

345: l_array(i).lookup_type := l_temp_array(i).lookup_type;
346: l_array(i).lookup_code := l_temp_array(i).lookup_code;
347: l_array(i).meaning := l_temp_array(i).meaning;
348: END LOOP;
349: hr_utility.set_location('Leaving: '|| l_proc,10);
350: RETURN l_array;
351: END Get_lookup_values;
352: -- ----------------------------------------------------------------------------
353: -- ------------------------------------------------------------------------

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

367: l_person_id number;
368: l_proc constant varchar2(100) := g_package || ' get_user_date_format';
369: --
370: begin
371: hr_utility.set_location('Entering: '|| l_proc,5);
372: validate_session(p_person_id => l_person_id
373: ,p_icx_update => false);
374: l_date_fmt := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
375: --

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

372: validate_session(p_person_id => l_person_id
373: ,p_icx_update => false);
374: l_date_fmt := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
375: --
376: hr_utility.set_location('Leaving: '|| l_proc,10);
377: return l_date_fmt;
378: --
379: Exception
380: when others then

Line 381: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

377: return l_date_fmt;
378: --
379: Exception
380: when others then
381: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
382: hr_utility.trace(' Exception ' || sqlerrm );
383: raise g_date_error;
384: --
385: end get_user_date_format;

Line 382: hr_utility.trace(' Exception ' || sqlerrm );

378: --
379: Exception
380: when others then
381: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
382: hr_utility.trace(' Exception ' || sqlerrm );
383: raise g_date_error;
384: --
385: end get_user_date_format;
386: --

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

525: l_date_format varchar2(200) default null;
526: l_proc constant varchar2(100) := g_package || ' decode_date_lookup_code';
527: --
528: Begin
529: hr_utility.set_location('Entering: '|| l_proc,5);
530: --
531: IF p_date_lookup_code is null or p_date_compare_to_column is null THEN
532: goto done;
533: END IF;

Line 564: hr_utility.trace('In( IF upper(l_date_range) = WL or upper(l_date_range) = MP): '|| l_proc);

560: --
561: l_unit_of_time := substr(l_date_lookup_code, 8);
562: --
563: IF upper(l_date_range) = 'WL' or upper(l_date_range) = 'MP' THEN
564: hr_utility.trace('In( IF upper(l_date_range) = WL or upper(l_date_range) = MP): '|| l_proc);
565: -- 'WL' -> Within Last
566: -- 'MP' -> more than x(days, weeks, months, years) in the past
567: -- We need to subtract the calculated date from the p_effective_date for
568: -- either 'WL' or 'MP'

Line 613: hr_utility.trace('In else of ( IF upper(l_date_range) = WL or upper(l_date_range) = MP): '|| l_proc);

609: l_sql_expression := p_date_compare_to_column || ' < '
610: || l_calculated_date_exp;
611: END IF;
612: ELSE
613: hr_utility.trace('In else of ( IF upper(l_date_range) = WL or upper(l_date_range) = MP): '|| l_proc);
614: IF upper(l_date_range) = 'WN' or upper(l_date_range) = 'MF' THEN
615: -- 'WN' -> Within Next
616: -- 'MP' -> more than x(days, weeks, months, years) in the future
617: -- We need to add the calculated date from the p_effective_date for

Line 648: hr_utility.set_location('Leaving: '|| l_proc,15);

644: END IF;
645: END IF;
646: --
647: <>
648: hr_utility.set_location('Leaving: '|| l_proc,15);
649: return l_sql_expression;
650: --
651: End decode_date_lookup_code;
652: --

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

665: l_date2char_exp varchar2(2000) default null;
666: --
667: l_proc constant varchar2(100) := g_package || ' build_date2char_expression';
668: Begin
669: hr_utility.set_location('Entering: '|| l_proc,5);
670: --Convert the incoming date to character format first using the passed in
671: --date format.
672: l_date_char := to_char(p_date, p_date_format);
673: --

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

690: p_date_format ||
691: '''' ||
692: ')';
693: --
694: hr_utility.set_location('Leaving: '|| l_proc,10);
695: return l_date2char_exp;
696: --
697: EXCEPTION
698: When others THEN

Line 699: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

695: return l_date2char_exp;
696: --
697: EXCEPTION
698: When others THEN
699: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
700: hr_utility.trace(' Exception ' || sqlerrm );
701: raise g_date_error;
702: --
703: END build_date2char_expression;

Line 700: hr_utility.trace(' Exception ' || sqlerrm );

696: --
697: EXCEPTION
698: When others THEN
699: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
700: hr_utility.trace(' Exception ' || sqlerrm );
701: raise g_date_error;
702: --
703: END build_date2char_expression;
704: --

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

740: l_msg_text2 varchar2(2000) default null;
741: l_proc constant varchar2(100) := g_package || ' validate_date_lookup_code';
742: --
743: Begin
744: hr_utility.set_location('Entering: '|| l_proc,5);
745: --
746: IF p_lookup_type is null THEN
747: -- issue error
748: fnd_message.set_name('PER','HR_WEB_INVALID_DATE_LKUP_CODE');

Line 768: hr_utility.trace('Going into Fetch after (OPEN get_lookup_code_meaning ): '|| l_proc);

764: END IF;
765: --
766: OPEN get_lookup_code_meaning;
767: LOOP
768: hr_utility.trace('Going into Fetch after (OPEN get_lookup_code_meaning ): '|| l_proc);
769: FETCH get_lookup_code_meaning into l_lookup_code_meaning_row;
770: exit when get_lookup_code_meaning%NOTFOUND;
771: -------------------------------------------------------------------------
772: -- We want to capture all the errors for each component of the code. Hence,

Line 804: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

800: END IF;
801: --
802: EXCEPTION
803: WHEN g_invalid_time_period THEN
804: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
805: l_date_error := 'Y';
806: goto check_if_err_found;
807: --
808: WHEN others THEN

Line 809: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

805: l_date_error := 'Y';
806: goto check_if_err_found;
807: --
808: WHEN others THEN
809: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
810: l_date_error := 'Y';
811: goto check_if_err_found;
812:
813: END; -- End Time Period block

Line 823: hr_utility.set_location('EXCEPTION: '|| l_proc,565);

819: -- "ORA-06502: PL/SQL: numeric or value error".
820: --
821: Exception
822: When others THEN
823: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
824: l_date_error := 'Y';
825: goto check_if_err_found;
826:
827: END;

Line 848: hr_utility.set_location('EXCEPTION: '|| l_proc,570);

844: END IF;
845: --
846: Exception
847: WHEN g_invalid_time_unit THEN
848: hr_utility.set_location('EXCEPTION: '|| l_proc,570);
849: l_date_error := 'Y';
850: goto check_if_err_found;
851:
852: END;

Line 877: hr_utility.set_location('Leaving: '|| l_proc,15);

873:
874: END LOOP;
875: --
876: <>
877: hr_utility.set_location('Leaving: '|| l_proc,15);
878: return l_lookup_code_meaning_rec_tbl;
879: --
880: Exception
881: When others THEN

Line 882: hr_utility.set_location('EXCEPTION: '|| l_proc,575);

878: return l_lookup_code_meaning_rec_tbl;
879: --
880: Exception
881: When others THEN
882: hr_utility.set_location('EXCEPTION: '|| l_proc,575);
883: -- Add error to error table
884: fnd_message.set_name('PER','HR_WEB_INVALID_DATE_LKUP_CODE');
885: l_msg_text := fnd_message.get;
886: --

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

913: --
914: l_proc varchar2(100) := g_package || 'insert_session_row';
915: --
916: BEGIN
917: hr_utility.set_location('Entering: '|| l_proc,5);
918: --
919: /* g_debug := hr_utility.debug_enabled;
920: if g_debug then
921: l_proc := g_package || 'insert_session_row';

Line 919: /* g_debug := hr_utility.debug_enabled;

915: --
916: BEGIN
917: hr_utility.set_location('Entering: '|| l_proc,5);
918: --
919: /* g_debug := hr_utility.debug_enabled;
920: if g_debug then
921: l_proc := g_package || 'insert_session_row';
922: hr_utility.set_location('Entering : ' || l_proc, 5);
923: end if; */

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

918: --
919: /* g_debug := hr_utility.debug_enabled;
920: if g_debug then
921: l_proc := g_package || 'insert_session_row';
922: hr_utility.set_location('Entering : ' || l_proc, 5);
923: end if; */
924: --
925: dt_fndate.set_effective_date(trunc(p_effective_date));
926: --

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

924: --
925: dt_fndate.set_effective_date(trunc(p_effective_date));
926: --
927: /* if g_debug then
928: hr_utility.set_location('Leaving : ' || l_proc, 10);
929: end if; */
930: --
931: hr_utility.set_location('Leaving: '|| l_proc,10);
932: EXCEPTION

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

927: /* if g_debug then
928: hr_utility.set_location('Leaving : ' || l_proc, 10);
929: end if; */
930: --
931: hr_utility.set_location('Leaving: '|| l_proc,10);
932: EXCEPTION
933: WHEN others THEN
934: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
935: null;

Line 934: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

930: --
931: hr_utility.set_location('Leaving: '|| l_proc,10);
932: EXCEPTION
933: WHEN others THEN
934: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
935: null;
936: END insert_session_row;
937:
938: -- ------------------------------------------------------------------------

Line 972: g_debug := hr_utility.debug_enabled;

968:
969: BEGIN
970:
971: --
972: g_debug := hr_utility.debug_enabled;
973: if g_debug then
974: --l_proc := g_package || 'insert_session_row';
975: hr_utility.set_location('Entering : ' || l_proc, 5);
976: end if;

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

971: --
972: g_debug := hr_utility.debug_enabled;
973: if g_debug then
974: --l_proc := g_package || 'insert_session_row';
975: hr_utility.set_location('Entering : ' || l_proc, 5);
976: end if;
977: --
978: dt_fndate.set_effective_date(trunc(p_effective_date));
979: --

Line 985: hr_utility.trace('Going into Fetch after ( OPEN get_session_id): '|| l_proc);

981:
982: -- The following select query is to retreive the session_id just created.
983: -- This will aid debugging to the caller.
984: OPEN get_session_id;
985: hr_utility.trace('Going into Fetch after ( OPEN get_session_id): '|| l_proc);
986: FETCH get_session_id into l_session_id;
987: IF get_session_id%NOTFOUND
988: THEN
989: l_session_id := null;

Line 997: hr_utility.set_location('Leaving : ' || l_proc, 15);

993:
994: p_session_id := l_session_id;
995:
996: if g_debug then
997: hr_utility.set_location('Leaving : ' || l_proc, 15);
998: end if;
999: --
1000: EXCEPTION
1001: WHEN others THEN

Line 1002: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

998: end if;
999: --
1000: EXCEPTION
1001: WHEN others THEN
1002: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1003: rollback;
1004: raise;
1005: END autonomous_commit_fnd_sess_row;
1006:

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

1009:
1010: l_person_id per_people_f.person_id%type;
1011: l_proc constant varchar2(100) := g_package || ' remove_session_row';
1012: BEGIN
1013: hr_utility.set_location('Entering: '|| l_proc,5);
1014: delete from fnd_sessions
1015: where session_id = userenv('sessionid');
1016: hr_utility.set_location('Leaving : ' || l_proc, 10);
1017: EXCEPTION

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

1012: BEGIN
1013: hr_utility.set_location('Entering: '|| l_proc,5);
1014: delete from fnd_sessions
1015: where session_id = userenv('sessionid');
1016: hr_utility.set_location('Leaving : ' || l_proc, 10);
1017: EXCEPTION
1018: WHEN others THEN
1019: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1020: raise;

Line 1019: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1015: where session_id = userenv('sessionid');
1016: hr_utility.set_location('Leaving : ' || l_proc, 10);
1017: EXCEPTION
1018: WHEN others THEN
1019: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1020: raise;
1021: END remove_session_row;
1022:
1023: -- ------------------------------------------------------------------------

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

1040: l_person_id per_people_f.person_id%type;
1041: l_proc constant varchar2(100) := g_package || ' validate_session';
1042: --
1043: BEGIN
1044: hr_utility.set_location('Entering: '|| l_proc,5);
1045: hr_util_misc_web.validate_session
1046: (p_person_id => l_person_id
1047: ,p_web_username => l_web_username
1048: ,p_check_ota => p_check_ota

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

1050: ,p_check_pay => p_check_pay
1051: ,p_icx_update => p_icx_update
1052: ,p_icx_commit => p_icx_commit);
1053: p_person_id := l_person_id;
1054: hr_utility.set_location('Leaving : ' || l_proc, 10);
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1058: NULL;

Line 1057: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1053: p_person_id := l_person_id;
1054: hr_utility.set_location('Leaving : ' || l_proc, 10);
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1058: NULL;
1059: END validate_session;
1060:
1061: PROCEDURE validate_session(p_person_id out nocopy number

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

1079: l_hr_installation_status fnd_product_installations.status%TYPE default null;
1080: l_proc constant varchar2(100) := g_package || ' validate_session';
1081:
1082: BEGIN
1083: hr_utility.set_location('Entering: '|| l_proc,5);
1084: IF NOT(icx_sec.validateSession(c_update => p_icx_update
1085: ,c_commit => p_icx_commit)) THEN
1086: RAISE g_error_handled;
1087: ELSE

Line 1091: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id 800) ): '|| l_proc);

1087: ELSE
1088: -- ensure HR is fully installed
1089: -- If not then raise an error
1090: OPEN csr_hr_installation_status(p_application_id => 800);
1091: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id 800) ): '|| l_proc);
1092: FETCH csr_hr_installation_status into l_hr_installation_status;
1093: CLOSE csr_hr_installation_status;
1094: IF NOT l_hr_installation_status = 'I' THEN
1095: --

Line 1104: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id 810) ): '|| l_proc);

1100: IF p_check_ota = 'Y' THEN
1101: -- ensure ota is fully installed
1102: -- If not then raise an error
1103: OPEN csr_hr_installation_status(p_application_id => 810);
1104: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id 810) ): '|| l_proc);
1105: FETCH csr_hr_installation_status into l_hr_installation_status;
1106: CLOSE csr_hr_installation_status;
1107: IF NOT l_hr_installation_status = 'I' THEN
1108: --

Line 1118: hr_utility.trace('Going into Fetch after( OPEN csr_hr_installation_status(p_application_id => 1234)) ): '|| l_proc);

1114: -- ensure benefits is fully installed
1115: -- If not then raise an error
1116: -- We don't know the benefits number yet...must change that here:
1117: OPEN csr_hr_installation_status(p_application_id => 1234);
1118: hr_utility.trace('Going into Fetch after( OPEN csr_hr_installation_status(p_application_id => 1234)) ): '|| l_proc);
1119: FETCH csr_hr_installation_status into l_hr_installation_status;
1120: CLOSE csr_hr_installation_status;
1121: IF NOT l_hr_installation_status = 'I' THEN
1122: --

Line 1132: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id => 801) ): '|| l_proc);

1128: IF p_check_pay = 'Y' THEN
1129: -- ensure Payroll is fully installed
1130: -- If not then raise an error
1131: OPEN csr_hr_installation_status(p_application_id => 801);
1132: hr_utility.trace('Going into Fetch after(OPEN csr_hr_installation_status(p_application_id => 801) ): '|| l_proc);
1133: FETCH csr_hr_installation_status into l_hr_installation_status;
1134: CLOSE csr_hr_installation_status;
1135: IF NOT l_hr_installation_status = 'I' THEN
1136: --

Line 1154: hr_utility.trace('In if( IF l_web_user_id = -1 ) ): '|| l_proc);

1150: l_web_user_id := icx_sec.getID(n_param => 10);
1151: --
1152: -- determine if the web user is -1 (pseudo session)
1153: IF l_web_user_id = -1 THEN
1154: hr_utility.trace('In if( IF l_web_user_id = -1 ) ): '|| l_proc);
1155: -- as we are in a pseudo session get the cookie record
1156: -- for the cookie WF_SESSION
1157: l_cookie := owa_cookie.get('WF_SESSION');
1158: -- ensure the cookie exists

Line 1173: hr_utility.trace(' Exception HR_51393_WEB_COOKIE_ERROR ');

1169: -- the WF_SESSION cookie does not exist. a serious error
1170: -- has ocurred which must be reported
1171: --
1172: fnd_message.set_name('PER','HR_51393_WEB_COOKIE_ERROR');
1173: hr_utility.trace(' Exception HR_51393_WEB_COOKIE_ERROR ');
1174: RAISE g_error_handled;
1175: END IF;
1176: ELSE
1177: hr_utility.trace('In else of if( IF l_web_user_id = -1 ) ): '|| l_proc);

Line 1177: hr_utility.trace('In else of if( IF l_web_user_id = -1 ) ): '|| l_proc);

1173: hr_utility.trace(' Exception HR_51393_WEB_COOKIE_ERROR ');
1174: RAISE g_error_handled;
1175: END IF;
1176: ELSE
1177: hr_utility.trace('In else of if( IF l_web_user_id = -1 ) ): '|| l_proc);
1178: l_person_id := icx_sec.getID(n_param => 9);
1179: --
1180: -- getid with a parm of 99 returns the web user name.
1181: l_web_username := icx_sec.getID(n_param => 99);

Line 1187: hr_utility.set_location('Leaving: '|| l_proc,40);

1183: END IF;
1184: p_person_id := l_person_id;
1185: p_web_username := l_web_username;
1186: g_error_handled_var := FALSE;
1187: hr_utility.set_location('Leaving: '|| l_proc,40);
1188: EXCEPTION
1189: WHEN g_no_app_error THEN
1190: hr_utility.trace(' validate_session ' || SQLERRM );
1191: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 1190: hr_utility.trace(' validate_session ' || SQLERRM );

1186: g_error_handled_var := FALSE;
1187: hr_utility.set_location('Leaving: '|| l_proc,40);
1188: EXCEPTION
1189: WHEN g_no_app_error THEN
1190: hr_utility.trace(' validate_session ' || SQLERRM );
1191: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1192: raise;
1193: WHEN TOO_MANY_ROWS then
1194: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

Line 1191: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1187: hr_utility.set_location('Leaving: '|| l_proc,40);
1188: EXCEPTION
1189: WHEN g_no_app_error THEN
1190: hr_utility.trace(' validate_session ' || SQLERRM );
1191: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1192: raise;
1193: WHEN TOO_MANY_ROWS then
1194: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1195: -- too many rows will be returned if the csr_iwu returns more than

Line 1194: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

1190: hr_utility.trace(' validate_session ' || SQLERRM );
1191: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1192: raise;
1193: WHEN TOO_MANY_ROWS then
1194: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1195: -- too many rows will be returned if the csr_iwu returns more than
1196: -- one person id for the web user.
1197: fnd_message.set_name('PER','HR_51776_WEB_TOO_MANY_USERS');
1198: hr_utility.trace(' Exception HR_51776_WEB_TOO_MANY_USERS ');

Line 1198: hr_utility.trace(' Exception HR_51776_WEB_TOO_MANY_USERS ');

1194: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1195: -- too many rows will be returned if the csr_iwu returns more than
1196: -- one person id for the web user.
1197: fnd_message.set_name('PER','HR_51776_WEB_TOO_MANY_USERS');
1198: hr_utility.trace(' Exception HR_51776_WEB_TOO_MANY_USERS ');
1199: WHEN g_error_handled then
1200: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
1201: g_error_handled_var := TRUE;
1202: raise;

Line 1200: hr_utility.set_location('EXCEPTION: '|| l_proc,565);

1196: -- one person id for the web user.
1197: fnd_message.set_name('PER','HR_51776_WEB_TOO_MANY_USERS');
1198: hr_utility.trace(' Exception HR_51776_WEB_TOO_MANY_USERS ');
1199: WHEN g_error_handled then
1200: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
1201: g_error_handled_var := TRUE;
1202: raise;
1203: WHEN others then
1204: hr_utility.set_location('EXCEPTION: '|| l_proc,570);

Line 1204: hr_utility.set_location('EXCEPTION: '|| l_proc,570);

1200: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
1201: g_error_handled_var := TRUE;
1202: raise;
1203: WHEN others then
1204: hr_utility.set_location('EXCEPTION: '|| l_proc,570);
1205: hr_utility.trace(' Exception ' || sqlerrm );
1206: raise;
1207: END validate_session;
1208: -- ------------------------------------------------------------------------

Line 1205: hr_utility.trace(' Exception ' || sqlerrm );

1201: g_error_handled_var := TRUE;
1202: raise;
1203: WHEN others then
1204: hr_utility.set_location('EXCEPTION: '|| l_proc,570);
1205: hr_utility.trace(' Exception ' || sqlerrm );
1206: raise;
1207: END validate_session;
1208: -- ------------------------------------------------------------------------
1209: -- prepare_parameter

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

1222: l_prefix varchar2(1);
1223: l_proc constant varchar2(100) := g_package || ' prepare_parameter';
1224:
1225: BEGIN
1226: hr_utility.set_location('Entering: '|| l_proc,5);
1227: IF p_value IS NOT null THEN
1228: IF p_prefix THEN
1229: l_prefix := '&';
1230: END IF;

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

1227: IF p_value IS NOT null THEN
1228: IF p_prefix THEN
1229: l_prefix := '&';
1230: END IF;
1231: hr_utility.set_location('Leaving: '|| l_proc,10);
1232: RETURN(l_prefix||p_name||'='||replace(p_value, ' ', '+'));
1233: ELSE
1234: hr_utility.set_location('Leaving: '|| l_proc,20);
1235: RETURN(null);

Line 1234: hr_utility.set_location('Leaving: '|| l_proc,20);

1230: END IF;
1231: hr_utility.set_location('Leaving: '|| l_proc,10);
1232: RETURN(l_prefix||p_name||'='||replace(p_value, ' ', '+'));
1233: ELSE
1234: hr_utility.set_location('Leaving: '|| l_proc,20);
1235: RETURN(null);
1236: END IF;
1237: END prepare_parameter;
1238: -------------------------------------------------------------------------------

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

1244: FUNCTION get_complete_url(p_url IN VARCHAR2 DEFAULT NULL) RETURN LONG IS
1245: l_url LONG;
1246: l_proc constant varchar2(100) := g_package || ' get_complete_url';
1247: BEGIN
1248: hr_utility.set_location('Entering: '|| l_proc,5);
1249: IF p_url IS NOT NULL THEN
1250: l_url := hr_util_misc_web.get_owa_url || p_url;
1251: ELSE
1252: l_url := hr_util_misc_web.get_owa_url;

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

1250: l_url := hr_util_misc_web.get_owa_url || p_url;
1251: ELSE
1252: l_url := hr_util_misc_web.get_owa_url;
1253: END IF;
1254: hr_utility.set_location('Leaving: '|| l_proc,10);
1255: RETURN l_url;
1256: END get_complete_url;
1257:
1258: -- This function will return a url with following format

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

1262: FUNCTION get_owa_url RETURN VARCHAR2 IS
1263: l_owa VARCHAR2(2000);
1264: l_proc constant varchar2(100) := g_package || ' get_owa_url';
1265: BEGIN
1266: hr_utility.set_location('Entering: '|| l_proc,5);
1267: -- Fix for bug 894682
1268: l_owa := FND_WEB_CONFIG.PLSQL_AGENT;
1269: hr_utility.set_location('Leaving: '|| l_proc,10);
1270: RETURN l_owa;

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

1265: BEGIN
1266: hr_utility.set_location('Entering: '|| l_proc,5);
1267: -- Fix for bug 894682
1268: l_owa := FND_WEB_CONFIG.PLSQL_AGENT;
1269: hr_utility.set_location('Leaving: '|| l_proc,10);
1270: RETURN l_owa;
1271: END get_owa_url;
1272:
1273: -- ------------------------------------------------------------------------

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

1294: l_seq_num fnd_attached_documents.seq_num%type default 0;
1295: l_creation_date fnd_documents_tl.creation_date%TYPE default null;
1296: l_proc constant varchar2(100) := g_package || ' get_resume';
1297: begin
1298: hr_utility.set_location('Entering: '|| l_proc,5);
1299: ----------------------------------------------------------------------------
1300: -- 10/15/97
1301: -- The following validate_session is not for security check because this
1302: -- procedure is not registered in fnd_enabled_plsql table. The real reason

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

1338: p_resume := l_resume_from_database;
1339: p_rowid := l_rowid;
1340: p_creation_date := l_creation_date;
1341: --
1342: hr_utility.set_location('Leaving: '|| l_proc,10);
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1346: -- an error has occurred but because we are producing HTML

Line 1345: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1341: --
1342: hr_utility.set_location('Leaving: '|| l_proc,10);
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1346: -- an error has occurred but because we are producing HTML
1347: -- just raise the exception
1348: p_resume := null;
1349: p_rowid := null;

Line 1350: hr_utility.trace(' Exception ' || sqlerrm);

1346: -- an error has occurred but because we are producing HTML
1347: -- just raise the exception
1348: p_resume := null;
1349: p_rowid := null;
1350: hr_utility.trace(' Exception ' || sqlerrm);
1351: raise;
1352: end get_resume;
1353:
1354:

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

1364: l_document_id fnd_documents.document_id%TYPE;
1365: l_media_id fnd_documents_tl.media_id%TYPE;
1366: l_proc constant varchar2(100) := g_package || ' insert_attachment_v4';
1367: begin
1368: hr_utility.set_location('Entering: '|| l_proc,5);
1369: insert_attachment
1370: (p_attachment_text => p_attachment_text
1371: ,p_entity_name => p_entity_name
1372: ,p_pk1_value => p_pk1_value

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

1375: ,p_login_person_id => p_login_person_id
1376: ,p_attached_document_id => l_attached_document_id
1377: ,p_document_id => l_document_id
1378: ,p_media_id => l_media_id);
1379: hr_utility.set_location('Leaving: '|| l_proc,10);
1380: end insert_attachment_v4;
1381: -- ----------------------------------------------------------------------------
1382: -- |--------------------------< insert_attachment >----------------------------|
1383: -- ----------------------------------------------------------------------------

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

1431: and name = p_name;
1432: --
1433:
1434: Begin
1435: hr_utility.set_location('Entering: '|| l_proc,5);
1436: --
1437: -- Get language
1438: select userenv('LANG') into l_language from dual;
1439: --

Line 1444: hr_utility.trace('Going into Fetch after ( open csr_get_seq_num): '|| l_proc);

1440: -- Get seq num
1441: --
1442: l_seq_num := 0;
1443: open csr_get_seq_num;
1444: hr_utility.trace('Going into Fetch after ( open csr_get_seq_num): '|| l_proc);
1445: fetch csr_get_seq_num into l_seq_num;
1446: close csr_get_seq_num;
1447: --
1448: -- Get category ID

Line 1451: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language)m): '|| l_proc);

1447: --
1448: -- Get category ID
1449: --
1450: open csr_get_category_id (csr_p_lang => l_language);
1451: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language)m): '|| l_proc);
1452: fetch csr_get_category_id into l_category_id;
1453: if csr_get_category_id%notfound then
1454: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1455: hr_utility.raise_error;

Line 1454: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1450: open csr_get_category_id (csr_p_lang => l_language);
1451: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language)m): '|| l_proc);
1452: fetch csr_get_category_id into l_category_id;
1453: if csr_get_category_id%notfound then
1454: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1455: hr_utility.raise_error;
1456: end if;
1457: close csr_get_category_id;
1458: --

Line 1455: hr_utility.raise_error;

1451: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language)m): '|| l_proc);
1452: fetch csr_get_category_id into l_category_id;
1453: if csr_get_category_id%notfound then
1454: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1455: hr_utility.raise_error;
1456: end if;
1457: close csr_get_category_id;
1458: --
1459: -- get sequence id for attached_document_id

Line 1526: hr_utility.set_location('Leaving: '|| l_proc,20);

1522: p_document_id := l_document_id;
1523: p_media_id := l_media_id;
1524: p_rowid := l_rowid;
1525:
1526: hr_utility.set_location('Leaving: '|| l_proc,20);
1527: EXCEPTION
1528: When others then
1529: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1530: raise;

Line 1529: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1525:
1526: hr_utility.set_location('Leaving: '|| l_proc,20);
1527: EXCEPTION
1528: When others then
1529: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1530: raise;
1531: --
1532: end insert_attachment;
1533:

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

1580: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
1581: --
1582: --
1583: Begin
1584: hr_utility.set_location('Entering: '|| l_proc,5);
1585: --
1586: -- Get language
1587: select userenv('LANG') into l_language from dual;
1588: --

Line 1592: hr_utility.trace('Going into Fetch after ( Open csr_get_attached_doc): '|| l_proc);

1588: --
1589: -- Get the before update nullable fields which are not used by the
1590: -- Web page to ensure the values are propagated.
1591: Open csr_get_attached_doc;
1592: hr_utility.trace('Going into Fetch after ( Open csr_get_attached_doc): '|| l_proc);
1593: fetch csr_get_attached_doc into l_attached_doc_pre_upd;
1594: IF csr_get_attached_doc%NOTFOUND THEN
1595: close csr_get_attached_doc;
1596: raise data_error;

Line 1600: hr_utility.trace('Going into Fetch after ( Open csr_get_doc(l_attached_doc_pre_upd.document_id)): '|| l_proc);

1596: raise data_error;
1597: END IF;
1598:
1599: Open csr_get_doc(l_attached_doc_pre_upd.document_id);
1600: hr_utility.trace('Going into Fetch after ( Open csr_get_doc(l_attached_doc_pre_upd.document_id)): '|| l_proc);
1601: fetch csr_get_doc into l_doc_pre_upd;
1602: IF csr_get_doc%NOTFOUND then
1603: close csr_get_doc;
1604: raise data_error;

Line 1609: hr_utility.trace('Going into Fetch after (Open csr_get_doc_tl (csr_p_lang => l_language,csr_p_document_id => l_attached_doc_pre_upd.document_id)): '|| l_proc);

1605: END IF;
1606:
1607: Open csr_get_doc_tl (csr_p_lang => l_language
1608: ,csr_p_document_id => l_attached_doc_pre_upd.document_id);
1609: hr_utility.trace('Going into Fetch after (Open csr_get_doc_tl (csr_p_lang => l_language,csr_p_document_id => l_attached_doc_pre_upd.document_id)): '|| l_proc);
1610: fetch csr_get_doc_tl into l_doc_tl_pre_upd;
1611: IF csr_get_doc_tl%NOTFOUND then
1612: close csr_get_doc_tl;
1613: raise data_error;

Line 1759: hr_utility.set_location('Leaving: '|| l_proc,25);

1755: -- Now update the long text table
1756: update fnd_documents_long_text
1757: set long_text = l_attachment_text
1758: where media_id = l_doc_tl_pre_upd.media_id;
1759: hr_utility.set_location('Leaving: '|| l_proc,25);
1760: EXCEPTION
1761: when others then
1762: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1763: raise;

Line 1762: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1758: where media_id = l_doc_tl_pre_upd.media_id;
1759: hr_utility.set_location('Leaving: '|| l_proc,25);
1760: EXCEPTION
1761: when others then
1762: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1763: raise;
1764: --
1765: End update_attachment;
1766:

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

1780: l_seq_num fnd_attached_documents.seq_num%type;
1781: l_creation_date fnd_documents_tl.creation_date%type;
1782: l_proc constant varchar2(100) := g_package || ' get_attachment_v4';
1783: begin
1784: hr_utility.set_location('Entering: '|| l_proc,5);
1785: get_attachment
1786: (p_attachment_text => p_attachment_text
1787: ,p_entity_name => p_entity_name
1788: ,p_pk1_value => p_pk1_value

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

1794: ,p_category_id => l_category_id
1795: ,p_seq_num => l_seq_num
1796: ,p_creation_date => l_creation_date
1797: ,p_user_name => p_name);
1798: hr_utility.set_location('Leaving: '|| l_proc,10);
1799:
1800: exception
1801: when others then
1802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 1802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1798: hr_utility.set_location('Leaving: '|| l_proc,10);
1799:
1800: exception
1801: when others then
1802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1803: p_attachment_text := null;
1804: p_rowid := null;
1805:
1806: end get_attachment_v4;

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

1879: from fnd_documents_long_text
1880: where media_id = csr_p_media_id;
1881:
1882: Begin
1883: hr_utility.set_location('Entering: '|| l_proc,5);
1884: --
1885: -- Get language
1886: select userenv('LANG') into l_language from dual;
1887: --

Line 1908: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language) ): '|| l_proc);

1904: -- -------------------------------------------------------------------------
1905: -- 1) Get Category ID.
1906: -- -------------------------------------------------------------------------
1907: open csr_get_category_id (csr_p_lang => l_language);
1908: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language) ): '|| l_proc);
1909: fetch csr_get_category_id into l_category_id;
1910: if csr_get_category_id%notfound then
1911: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1912: hr_utility.raise_error;

Line 1911: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1907: open csr_get_category_id (csr_p_lang => l_language);
1908: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language) ): '|| l_proc);
1909: fetch csr_get_category_id into l_category_id;
1910: if csr_get_category_id%notfound then
1911: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1912: hr_utility.raise_error;
1913: end if;
1914: close csr_get_category_id;
1915: --

Line 1912: hr_utility.raise_error;

1908: hr_utility.trace('Going into Fetch after (open csr_get_category_id (csr_p_lang => l_language) ): '|| l_proc);
1909: fetch csr_get_category_id into l_category_id;
1910: if csr_get_category_id%notfound then
1911: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1912: hr_utility.raise_error;
1913: end if;
1914: close csr_get_category_id;
1915: --
1916: -- -------------------------------------------------------------------------

Line 1921: hr_utility.trace('Going into Fetch after (Open csr_attached_documents (csr_p_cat_id => l_category_id)) ): '|| l_proc);

1917: -- 2) Get attached_document_id, document_id.
1918: -- -------------------------------------------------------------------------
1919: --
1920: Open csr_attached_documents (csr_p_cat_id => l_category_id);
1921: hr_utility.trace('Going into Fetch after (Open csr_attached_documents (csr_p_cat_id => l_category_id)) ): '|| l_proc);
1922: fetch csr_attached_documents into l_rowid, l_attached_document_id,
1923: l_document_id, l_seq_num, l_update_date;
1924:
1925: IF csr_attached_documents%NOTFOUND THEN

Line 1926: hr_utility.trace('In( IF csr_attached_documents%NOTFOUND): '|| l_proc);

1922: fetch csr_attached_documents into l_rowid, l_attached_document_id,
1923: l_document_id, l_seq_num, l_update_date;
1924:
1925: IF csr_attached_documents%NOTFOUND THEN
1926: hr_utility.trace('In( IF csr_attached_documents%NOTFOUND): '|| l_proc);
1927: close csr_attached_documents;
1928: ELSE
1929: hr_utility.trace('In else of ( IF csr_attached_documents%NOTFOUND): '|| l_proc);
1930: open csr_documents_tl(csr_p_document_id => l_document_id);

Line 1929: hr_utility.trace('In else of ( IF csr_attached_documents%NOTFOUND): '|| l_proc);

1925: IF csr_attached_documents%NOTFOUND THEN
1926: hr_utility.trace('In( IF csr_attached_documents%NOTFOUND): '|| l_proc);
1927: close csr_attached_documents;
1928: ELSE
1929: hr_utility.trace('In else of ( IF csr_attached_documents%NOTFOUND): '|| l_proc);
1930: open csr_documents_tl(csr_p_document_id => l_document_id);
1931: hr_utility.trace('Going into Fetch after (open csr_documents_tl(csr_p_document_id => l_document_id)): '|| l_proc);
1932: fetch csr_documents_tl into l_media_id , l_creation_date;
1933: IF csr_documents_tl%NOTFOUND THEN

Line 1931: hr_utility.trace('Going into Fetch after (open csr_documents_tl(csr_p_document_id => l_document_id)): '|| l_proc);

1927: close csr_attached_documents;
1928: ELSE
1929: hr_utility.trace('In else of ( IF csr_attached_documents%NOTFOUND): '|| l_proc);
1930: open csr_documents_tl(csr_p_document_id => l_document_id);
1931: hr_utility.trace('Going into Fetch after (open csr_documents_tl(csr_p_document_id => l_document_id)): '|| l_proc);
1932: fetch csr_documents_tl into l_media_id , l_creation_date;
1933: IF csr_documents_tl%NOTFOUND THEN
1934:
1935: close csr_attached_documents;

Line 1937: raise hr_utility.hr_error;

1933: IF csr_documents_tl%NOTFOUND THEN
1934:
1935: close csr_attached_documents;
1936: close csr_documents_tl;
1937: raise hr_utility.hr_error;
1938: ELSE
1939: open csr_documents_long_text(csr_p_media_id => l_media_id);
1940: hr_utility.trace('Going into Fetch after (open csr_documents_long_text(csr_p_media_id => l_media_id)): '|| l_proc);
1941: fetch csr_documents_long_text into l_attachment_text;

Line 1940: hr_utility.trace('Going into Fetch after (open csr_documents_long_text(csr_p_media_id => l_media_id)): '|| l_proc);

1936: close csr_documents_tl;
1937: raise hr_utility.hr_error;
1938: ELSE
1939: open csr_documents_long_text(csr_p_media_id => l_media_id);
1940: hr_utility.trace('Going into Fetch after (open csr_documents_long_text(csr_p_media_id => l_media_id)): '|| l_proc);
1941: fetch csr_documents_long_text into l_attachment_text;
1942: IF csr_documents_long_text%NOTFOUND THEN
1943: close csr_attached_documents;
1944: close csr_documents_tl;

Line 1946: raise hr_utility.hr_error;

1942: IF csr_documents_long_text%NOTFOUND THEN
1943: close csr_attached_documents;
1944: close csr_documents_tl;
1945: close csr_documents_long_text;
1946: raise hr_utility.hr_error;
1947: ELSE
1948: close csr_attached_documents;
1949: close csr_documents_tl;
1950: close csr_documents_long_text;

Line 1963: hr_utility.set_location('Leaving: '|| l_proc,35);

1959: p_rowid := l_rowid;
1960: p_category_id := l_category_id;
1961: p_seq_num := l_seq_num;
1962: p_creation_date := l_creation_date;
1963: hr_utility.set_location('Leaving: '|| l_proc,35);
1964:
1965: exception
1966: when hr_utility.hr_error THEN
1967: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 1966: when hr_utility.hr_error THEN

1962: p_creation_date := l_creation_date;
1963: hr_utility.set_location('Leaving: '|| l_proc,35);
1964:
1965: exception
1966: when hr_utility.hr_error THEN
1967: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1968: raise;
1969:
1970: when others then

Line 1967: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1963: hr_utility.set_location('Leaving: '|| l_proc,35);
1964:
1965: exception
1966: when hr_utility.hr_error THEN
1967: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1968: raise;
1969:
1970: when others then
1971: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

Line 1971: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

1967: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1968: raise;
1969:
1970: when others then
1971: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1972: hr_utility.trace(' Exception ' || sqlerrm );
1973: raise;
1974:
1975: end get_attachment;

Line 1972: hr_utility.trace(' Exception ' || sqlerrm );

1968: raise;
1969:
1970: when others then
1971: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1972: hr_utility.trace(' Exception ' || sqlerrm );
1973: raise;
1974:
1975: end get_attachment;
1976:

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

1992: IS
1993: v_url varchar2(32000);
1994: l_proc constant varchar2(100) := g_package || ' string_to_url';
1995: BEGIN
1996: hr_utility.set_location('Entering: '|| l_proc,5);
1997: /* The order of the next three "replace" calls matters! */
1998:
1999: v_url := replace ( p_url, '%', '%25' );
2000: v_url := replace ( v_url, '+', '%2B' );

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

2004: /* but the order of the next "replace" calls doen't matter */
2005:
2006: v_url := replace ( v_url, '&', '%26' );
2007: v_url := replace ( v_url, '?', '%3F' );
2008: hr_utility.set_location('Leaving: '|| l_proc,10);
2009: return v_url;
2010: END string_to_url;
2011:
2012:

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

2034: ) RETURN BOOLEAN IS
2035: l_text_value VARCHAR2(2000);
2036: l_proc constant varchar2(100) := g_package || ' isManager';
2037: BEGIN
2038: hr_utility.set_location('Entering: '|| l_proc,5);
2039:
2040:
2041: l_text_value :=
2042: wf_engine.getItemAttrText

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

2044: ,itemkey => p_item_key
2045: ,aname => 'P_PERSON_ID');
2046:
2047: IF l_text_value IS NULL THEN
2048: hr_utility.set_location('Leaving: '|| l_proc,10);
2049: -- Since no value is set for P_PERSON_ID, it must be Employee.
2050: RETURN FALSE;
2051: ELSE
2052: -- Since P_PERSON_ID is set, it must be Manager.

Line 2053: hr_utility.set_location('Leaving: '|| l_proc,15);

2049: -- Since no value is set for P_PERSON_ID, it must be Employee.
2050: RETURN FALSE;
2051: ELSE
2052: -- Since P_PERSON_ID is set, it must be Manager.
2053: hr_utility.set_location('Leaving: '|| l_proc,15);
2054: RETURN TRUE;
2055: END IF;
2056:
2057: EXCEPTION

Line 2060: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2056:
2057: EXCEPTION
2058: WHEN OTHERS THEN
2059:
2060: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2061: RETURN FALSE;
2062: END isManager;
2063: /*------------------------------------------------------------------------------
2064: | Name : isSelfUpdating

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

2086: l_text_value VARCHAR2(2000);
2087: g_person_id per_all_people_f.person_id%TYPE;
2088: l_proc constant varchar2(100) := g_package || ' isSelfUpdating';
2089: BEGIN
2090: hr_utility.set_location('Entering: '|| l_proc,5);
2091: l_text_value :=
2092: wf_engine.getItemAttrText
2093: (itemtype => p_item_type
2094: ,itemkey => p_item_key

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

2097: -- get the g_person_id from validate session
2098: hr_util_misc_web.validate_session(p_person_id => g_person_id,p_icx_update => false);
2099:
2100: IF l_text_value IS NULL OR to_number(l_text_value) = g_person_id THEN
2101: hr_utility.set_location('Leaving: '|| l_proc,10);
2102: RETURN TRUE; -- Manager updating him/herself or EDA mode
2103: ELSE
2104: hr_utility.set_location('Leaving: '|| l_proc,15);
2105: RETURN FALSE; -- Manager updating his/her employee

Line 2104: hr_utility.set_location('Leaving: '|| l_proc,15);

2100: IF l_text_value IS NULL OR to_number(l_text_value) = g_person_id THEN
2101: hr_utility.set_location('Leaving: '|| l_proc,10);
2102: RETURN TRUE; -- Manager updating him/herself or EDA mode
2103: ELSE
2104: hr_utility.set_location('Leaving: '|| l_proc,15);
2105: RETURN FALSE; -- Manager updating his/her employee
2106: END IF;
2107:
2108: EXCEPTION

Line 2110: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2106: END IF;
2107:
2108: EXCEPTION
2109: WHEN OTHERS THEN
2110: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2111: RETURN TRUE;
2112: END isSelfUpdating;
2113: /*------------------------------------------------------------------------------
2114: | Name : get_called_from

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

2134: SELECT a.function_id
2135: FROM icx_sessions a
2136: WHERE session_id = p_session_id;
2137: BEGIN
2138: hr_utility.set_location('Entering: '|| l_proc,5);
2139: -- --------------------------------------------------------
2140: -- Get the Function ID
2141: -- --------------------------------------------------------
2142: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));

Line 2143: hr_utility.trace('Going into Fetch after (csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID)) ): '|| l_proc);

2139: -- --------------------------------------------------------
2140: -- Get the Function ID
2141: -- --------------------------------------------------------
2142: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2143: hr_utility.trace('Going into Fetch after (csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID)) ): '|| l_proc);
2144: FETCH csr_icx_session INTO l_function_id;
2145: CLOSE csr_icx_session;
2146:
2147: -- --------------------------------------------------------

Line 2153: hr_utility.set_location('Leaving: '|| l_proc,15);

2149: -- --------------------------------------------------------
2150: l_fnd_form_function := get_fnd_form_function(l_function_id);
2151: l_called_from := SUBSTR(UPPER(l_fnd_form_function.parameters)
2152: ,LENGTH('P_CALLED_FROM=') + 1);
2153: hr_utility.set_location('Leaving: '|| l_proc,15);
2154: RETURN l_called_from;
2155: EXCEPTION
2156: WHEN OTHERS THEN
2157: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2157: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2153: hr_utility.set_location('Leaving: '|| l_proc,15);
2154: RETURN l_called_from;
2155: EXCEPTION
2156: WHEN OTHERS THEN
2157: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2158: RAISE;
2159: END get_called_from;
2160:
2161: /*------------------------------------------------------------------------------

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

2174: WHERE function_id = p_function_id;
2175: l_function fnd_form_functions%ROWTYPE;
2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;

Line 2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);

2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;

Line 2183: hr_utility.set_location('Leaving: '|| l_proc,15);

2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;
2185: EXCEPTION
2186: WHEN OTHERS THEN
2187: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2187: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;
2185: EXCEPTION
2186: WHEN OTHERS THEN
2187: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2188: RAISE;
2189: END get_fnd_Form_function;
2190:
2191:

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

2212: SELECT a.function_id
2213: FROM icx_sessions a
2214: WHERE session_id = p_session_id;
2215: BEGIN
2216: hr_utility.set_location('Entering: '|| l_proc,5);
2217: -- --------------------------------------------------------
2218: -- Get the Function ID
2219: -- --------------------------------------------------------
2220: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));

Line 2221: hr_utility.trace('Going into Fetch after (OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);

2217: -- --------------------------------------------------------
2218: -- Get the Function ID
2219: -- --------------------------------------------------------
2220: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2221: hr_utility.trace('Going into Fetch after (OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2222: FETCH csr_icx_session INTO l_function_id;
2223: CLOSE csr_icx_session;
2224:
2225: -- --------------------------------------------------------

Line 2234: hr_utility.set_location('Leaving: '|| l_proc,15);

2230: ,LENGTH('P_PROCESS_NAME=') + 1);
2231: l_called_from := SUBSTR(UPPER(l_called_from)
2232: ,1
2233: ,INSTR(UPPER(l_called_from),'&P_ITEM') -1 );
2234: hr_utility.set_location('Leaving: '|| l_proc,15);
2235: RETURN l_called_from;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2238: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2234: hr_utility.set_location('Leaving: '|| l_proc,15);
2235: RETURN l_called_from;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2239: RAISE;
2240: END get_process_name;
2241:
2242: /*------------------------------------------------------------------------------

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

2260: SELECT a.function_id
2261: FROM icx_sessions a
2262: WHERE session_id = p_session_id;
2263: BEGIN
2264: hr_utility.set_location('Entering: '|| l_proc,5);
2265:
2266: -- --------------------------------------------------------
2267: -- Get the Function ID
2268: -- --------------------------------------------------------

Line 2270: hr_utility.trace('Going into Fetch after ( OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);

2266: -- --------------------------------------------------------
2267: -- Get the Function ID
2268: -- --------------------------------------------------------
2269: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2270: hr_utility.trace('Going into Fetch after ( OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2271: FETCH csr_icx_session INTO l_function_id;
2272: CLOSE csr_icx_session;
2273:
2274: -- --------------------------------------------------------

Line 2293: hr_utility.set_location('Leaving: '|| l_proc,15);

2289: ELSE
2290: l_called_from := SUBSTR(UPPER(l_called_from)
2291: ,14);
2292: END IF;
2293: hr_utility.set_location('Leaving: '|| l_proc,15);
2294: RETURN l_called_from;
2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2293: hr_utility.set_location('Leaving: '|| l_proc,15);
2294: RETURN l_called_from;
2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2298: RAISE;
2299: END get_item_type;
2300:
2301: /*

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

2341: l_person_id per_people_f.person_id%type;
2342: l_proc constant varchar2(100) := g_package || ' get_business_group_id';
2343:
2344: BEGIN
2345: hr_utility.set_location('Entering: '|| l_proc,5);
2346: IF p_person_id is null then
2347: validate_session(p_person_id => l_person_id
2348: ,p_icx_update => false);
2349: fnd_profile.get (

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

2354: ln_person_rec := get_person_rec(p_effective_date => TRUNC(SYSDATE)
2355: ,p_person_id => p_person_id);
2356: ln_business_group_id := ln_person_rec.business_group_id;
2357: END IF;
2358: hr_utility.set_location('Leaving: '|| l_proc,10);
2359:
2360: RETURN (ln_business_group_id);
2361:
2362: EXCEPTION

Line 2364: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2360: RETURN (ln_business_group_id);
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN
2364: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2365: htp.p ('Exception in hr_utl'
2366: || g_package || '.get_business_group_id - '
2367: || SQLERRM || ' ' || SQLCODE
2368: );

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

2388: l_proc constant varchar2(100) := g_package || ' check_business_group';
2389: invalid_security_permission exception;
2390: BEGIN
2391:
2392: hr_utility.set_location('Entering: '|| l_proc,5);
2393: open check_person;
2394: hr_utility.trace('Going into Fetch after (open check_person): '|| l_proc);
2395: fetch check_person into l_person_id;
2396: if check_person%notfound then

Line 2394: hr_utility.trace('Going into Fetch after (open check_person): '|| l_proc);

2390: BEGIN
2391:
2392: hr_utility.set_location('Entering: '|| l_proc,5);
2393: open check_person;
2394: hr_utility.trace('Going into Fetch after (open check_person): '|| l_proc);
2395: fetch check_person into l_person_id;
2396: if check_person%notfound then
2397: close check_person;
2398: fnd_message.set_name('PER', 'HR_INVALID_SECURITY_PERMISSION');

Line 2399: hr_utility.trace(' Exception in hr_util_misc_web.check_businss_group ' || SQLERRM );

2395: fetch check_person into l_person_id;
2396: if check_person%notfound then
2397: close check_person;
2398: fnd_message.set_name('PER', 'HR_INVALID_SECURITY_PERMISSION');
2399: hr_utility.trace(' Exception in hr_util_misc_web.check_businss_group ' || SQLERRM );
2400: raise invalid_security_permission;
2401: end if;
2402: close check_person;
2403: /*

Line 2411: hr_utility.set_location('Leaving: '|| l_proc,15);

2407: (p_message => fnd_message.get);
2408: END IF;
2409: */
2410:
2411: hr_utility.set_location('Leaving: '|| l_proc,15);
2412: EXCEPTION
2413: when invalid_security_permission then
2414: hr_utility.trace(' Exception HR_INVALID_SECURITY_PERMISSION in hr_util_misc_web.check_business_group ' || SQLERRM );
2415: hr_utility.set_location('Leaving: '|| l_proc,15);

Line 2414: hr_utility.trace(' Exception HR_INVALID_SECURITY_PERMISSION in hr_util_misc_web.check_business_group ' || SQLERRM );

2410:
2411: hr_utility.set_location('Leaving: '|| l_proc,15);
2412: EXCEPTION
2413: when invalid_security_permission then
2414: hr_utility.trace(' Exception HR_INVALID_SECURITY_PERMISSION in hr_util_misc_web.check_business_group ' || SQLERRM );
2415: hr_utility.set_location('Leaving: '|| l_proc,15);
2416: raise;
2417: when others then
2418: hr_utility.trace(' Exception in hr_util_misc_web.check_business_group ' || SQLERRM );

Line 2415: hr_utility.set_location('Leaving: '|| l_proc,15);

2411: hr_utility.set_location('Leaving: '|| l_proc,15);
2412: EXCEPTION
2413: when invalid_security_permission then
2414: hr_utility.trace(' Exception HR_INVALID_SECURITY_PERMISSION in hr_util_misc_web.check_business_group ' || SQLERRM );
2415: hr_utility.set_location('Leaving: '|| l_proc,15);
2416: raise;
2417: when others then
2418: hr_utility.trace(' Exception in hr_util_misc_web.check_business_group ' || SQLERRM );
2419: hr_utility.set_location('Leaving: '|| l_proc,15);

Line 2418: hr_utility.trace(' Exception in hr_util_misc_web.check_business_group ' || SQLERRM );

2414: hr_utility.trace(' Exception HR_INVALID_SECURITY_PERMISSION in hr_util_misc_web.check_business_group ' || SQLERRM );
2415: hr_utility.set_location('Leaving: '|| l_proc,15);
2416: raise;
2417: when others then
2418: hr_utility.trace(' Exception in hr_util_misc_web.check_business_group ' || SQLERRM );
2419: hr_utility.set_location('Leaving: '|| l_proc,15);
2420: raise;
2421: END check_business_group;
2422:

Line 2419: hr_utility.set_location('Leaving: '|| l_proc,15);

2415: hr_utility.set_location('Leaving: '|| l_proc,15);
2416: raise;
2417: when others then
2418: hr_utility.trace(' Exception in hr_util_misc_web.check_business_group ' || SQLERRM );
2419: hr_utility.set_location('Leaving: '|| l_proc,15);
2420: raise;
2421: END check_business_group;
2422:
2423: /*

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

2430: PROCEDURE initialize_hr_globals
2431: (p_reset_errors IN VARCHAR2 DEFAULT 'Y') IS
2432: l_proc constant varchar2(100) := g_package || ' initialize_hr_globals';
2433: BEGIN
2434: hr_utility.set_location('Entering: '|| l_proc,5);
2435: IF p_reset_errors = 'Y' THEN
2436: hr_errors_api.g_error := false;
2437: hr_errors_api.g_errorTable.delete;
2438: hr_errors_api.g_count := 0;

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

2436: hr_errors_api.g_error := false;
2437: hr_errors_api.g_errorTable.delete;
2438: hr_errors_api.g_count := 0;
2439: END IF;
2440: hr_utility.set_location('Leaving: '|| l_proc,10);
2441: END initialize_hr_globals;
2442:
2443: END hr_util_misc_web;