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.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on HR_UTILITY

Line 91: hr_utility.trace('FF Name :'||l_ff_name);

87: ,l_ff_name
88: ,l_ftype_id
89: ,l_ftype_name;
90: CLOSE c_get_formula_info;
91: hr_utility.trace('FF Name :'||l_ff_name);
92:
93: --
94: -- Submitt the request to compile the formula
95: --

Line 101: hr_utility.trace('Request Id :'||p_request_id);

97: (p_formula_type => l_ftype_name --'Oracle Payroll' -- formula type
98: ,p_formula_name => l_ff_name); -- formula name
99:
100: p_request_id := l_request_id;
101: hr_utility.trace('Request Id :'||p_request_id);
102:
103: --hr_utility.trace('P_ABS_PRIMARY_YN :'||P_ABS_PRIMARY_YN);
104: --
105: -- Compile the additional Ben Formulas here only for the Primary Base Name

Line 103: --hr_utility.trace('P_ABS_PRIMARY_YN :'||P_ABS_PRIMARY_YN);

99:
100: p_request_id := l_request_id;
101: hr_utility.trace('Request Id :'||p_request_id);
102:
103: --hr_utility.trace('P_ABS_PRIMARY_YN :'||P_ABS_PRIMARY_YN);
104: --
105: -- Compile the additional Ben Formulas here only for the Primary Base Name
106: --
107: --IF upper(P_ABS_PRIMARY_YN) = 'Y' THEN

Line 108: --hr_utility.trace('Entered the If Stmt');

104: --
105: -- Compile the additional Ben Formulas here only for the Primary Base Name
106: --
107: --IF upper(P_ABS_PRIMARY_YN) = 'Y' THEN
108: --hr_utility.trace('Entered the If Stmt');
109: ----
110: ---- Create the BEN formulas
111: ----
112: --pqp_gb_gap_ben_formulas.create_ben_formulas

Line 122: --hr_utility.trace('BEN FF Count :'||l_ben_formulas.count);

118: --,p_error_code => l_error_code
119: --,p_error_message => l_err_msg
120: --);
121: --
122: --hr_utility.trace('BEN FF Count :'||l_ben_formulas.count);
123: ----
124: ---- Loop to compile all the BEN formulas
125: ----
126: --IF l_ben_formulas.COUNT > 0

Line 130: --hr_utility.trace('l_ben_formulas(i): '||l_ben_formulas(i));

126: --IF l_ben_formulas.COUNT > 0
127: --THEN
128: --FOR i IN l_ben_formulas.FIRST..l_ben_formulas.LAST
129: --LOOP
130: --hr_utility.trace('l_ben_formulas(i): '||l_ben_formulas(i));
131: --OPEN c_get_ben_formula_info(l_ben_formulas(i));
132: --FETCH c_get_ben_formula_info INTO l_ff_id
133: --,l_ff_name
134: --,l_ftype_id

Line 137: --hr_utility.trace('FF Name :'||l_ff_name);

133: --,l_ff_name
134: --,l_ftype_id
135: --,l_ftype_name;
136: --CLOSE c_get_ben_formula_info;
137: --hr_utility.trace('FF Name :'||l_ff_name);
138: --hr_utility.trace('FT Name :'||l_ftype_name);
139: ----
140: ---- Submitt request to compile the formula
141: ----

Line 138: --hr_utility.trace('FT Name :'||l_ftype_name);

134: --,l_ftype_id
135: --,l_ftype_name;
136: --CLOSE c_get_ben_formula_info;
137: --hr_utility.trace('FF Name :'||l_ff_name);
138: --hr_utility.trace('FT Name :'||l_ftype_name);
139: ----
140: ---- Submitt request to compile the formula
141: ----
142: --l_request_id := fnd_request.submit_request

Line 147: --hr_utility.trace('Request Id :'||l_request_id);

143: --(application => 'FF'
144: --,program => 'SINGLECOMPILE'
145: --,argument1 => l_ftype_name --'Oracle Payroll' -- formula type
146: --,argument2 => l_ff_name); -- formula name
147: --hr_utility.trace('Request Id :'||l_request_id);
148: --END LOOP;
149: --END IF;
150: --END IF;
151: -- Added by tmehra for nocopy changes Feb'03

Line 155: hr_utility.trace('Entering exception when others ');

151: -- Added by tmehra for nocopy changes Feb'03
152:
153: EXCEPTION
154: WHEN OTHERS THEN
155: hr_utility.trace('Entering exception when others ');
156: p_request_id := NULL;
157: raise;
158:
159:

Line 247: hr_utility.trace('Entering my proc........');

243:
244: -- for Multi Messages
245: hr_multi_message.enable_message_list;
246:
247: hr_utility.trace('Entering my proc........');
248: hr_utility.trace('P_ABSE_TYPE_LOOKUP_TYPE :' || P_ABSE_TYPE_LOOKUP_TYPE);
249:
250: --
251: -- If the Absence type is null

Line 248: hr_utility.trace('P_ABSE_TYPE_LOOKUP_TYPE :' || P_ABSE_TYPE_LOOKUP_TYPE);

244: -- for Multi Messages
245: hr_multi_message.enable_message_list;
246:
247: hr_utility.trace('Entering my proc........');
248: hr_utility.trace('P_ABSE_TYPE_LOOKUP_TYPE :' || P_ABSE_TYPE_LOOKUP_TYPE);
249:
250: --
251: -- If the Absence type is null
252: -- then we create a new absence scheme

Line 271: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);

267: )
268: LOOP
269: l_lookup_table(i).abs_type_id:=r_lookup.abs_type_id;
270: l_lookup_table(i).abs_type_name:=r_lookup.abs_type_name;
271: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);
272: i := i + 1;
273: END LOOP;
274: END IF;
275: l_sec_grp_id := get_security_grp_id(p_bg_id);

Line 277: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);

273: END LOOP;
274: END IF;
275: l_sec_grp_id := get_security_grp_id(p_bg_id);
276: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
277: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
278: hr_utility.trace('Calling the create_user_template from my proc...');
279:
280: l_element_type_id := pqp_gb_omp_template.create_user_template
281: (p_plan_id => P_PLAN_ID

Line 278: hr_utility.trace('Calling the create_user_template from my proc...');

274: END IF;
275: l_sec_grp_id := get_security_grp_id(p_bg_id);
276: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
277: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
278: hr_utility.trace('Calling the create_user_template from my proc...');
279:
280: l_element_type_id := pqp_gb_omp_template.create_user_template
281: (p_plan_id => P_PLAN_ID
282: ,p_plan_description => P_PLAN_DESCRIPTION

Line 320: hr_utility.trace('Ele Type Id :'||p_element_type_id);

316: ,p_bg_id => P_BG_ID
317: );
318:
319: p_element_type_id := l_element_type_id;
320: hr_utility.trace('Ele Type Id :'||p_element_type_id);
321:
322: --
323: -- Compile and create(BEN) all the Formulas
324: --

Line 339: hr_utility.trace('Entering exception when others ');

335: -- Added by tmehra for nocopy changes Feb'03
336:
337: EXCEPTION
338: /* WHEN OTHERS THEN
339: hr_utility.trace('Entering exception when others ');
340: p_element_type_id := NULL;
341: p_request_id := NULL;
342: raise;*/
343: WHEN hr_multi_message.error_message_exist

Line 352: hr_utility.set_location ( ' Leaving:'

348: -- at least one message exists in the list.
349: --
350: p_element_type_id := NULL;
351: p_request_id := NULL;
352: hr_utility.set_location ( ' Leaving:'
353: || l_proc_name, 40);
354: WHEN OTHERS
355: THEN
356: --

Line 367: hr_utility.set_location ( ' Leaving:'

363: IF hr_multi_message.unexpected_error_add (l_proc_name)
364: THEN
365: p_element_type_id := NULL;
366: p_request_id := NULL;
367: hr_utility.set_location ( ' Leaving:'
368: || l_proc_name, 50);
369: RAISE;
370: END IF;
371:

Line 457: hr_utility.trace('Entering :'||l_proc_name);

453: -- for Multi Messages
454: hr_multi_message.enable_message_list;
455:
456:
457: hr_utility.trace('Entering :'||l_proc_name);
458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);

Line 458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);

454: hr_multi_message.enable_message_list;
455:
456:
457: hr_utility.trace('Entering :'||l_proc_name);
458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);

Line 459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);

455:
456:
457: hr_utility.trace('Entering :'||l_proc_name);
458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);
463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);

Line 460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);

456:
457: hr_utility.trace('Entering :'||l_proc_name);
458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);
463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);
464:

Line 461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);

457: hr_utility.trace('Entering :'||l_proc_name);
458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);
463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);
464:
465:

Line 462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);

458: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);
463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);
464:
465:
466:

Line 463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);

459: hr_utility.trace('P_SCH_CAL_START_DATE : '||P_SCH_CAL_START_DATE);
460: hr_utility.trace('Enable Proration : '||P_ENABLE_ENT_PRORATION);
461: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
462: hr_utility.trace('P_FT_ROUND_CONFIG : '||P_FT_ROUND_CONFIG);
463: hr_utility.trace('P_PT_ROUND_CONFIG : '||P_PT_ROUND_CONFIG);
464:
465:
466:
467: --

Line 478: --hr_utility.trace(l_select);

474: l_sch_cal_end_date := p_sch_cal_end_date ;
475:
476: -- l_select := 'select '|| P_SCH_CAL_START_DATE
477: -- || ' from dual';
478: --hr_utility.trace(l_select);
479: --
480: -- Prepare the Calendar start date string
481: --
482: -- open c_cursor for l_select;

Line 486: hr_utility.trace('1_SCH_CAL_START_DATE : '||l_SCH_CAL_START_DATE);

482: -- open c_cursor for l_select;
483: -- fetch c_cursor into l_sch_cal_start_date;
484: -- close c_cursor;
485:
486: hr_utility.trace('1_SCH_CAL_START_DATE : '||l_SCH_CAL_START_DATE);
487:
488: hr_utility.trace('P_SCH_CAL_END_DATE : '||P_SCH_CAL_END_DATE);
489: -- l_select := 'select '|| P_SCH_CAL_END_DATE
490: -- || ' from dual';

Line 488: hr_utility.trace('P_SCH_CAL_END_DATE : '||P_SCH_CAL_END_DATE);

484: -- close c_cursor;
485:
486: hr_utility.trace('1_SCH_CAL_START_DATE : '||l_SCH_CAL_START_DATE);
487:
488: hr_utility.trace('P_SCH_CAL_END_DATE : '||P_SCH_CAL_END_DATE);
489: -- l_select := 'select '|| P_SCH_CAL_END_DATE
490: -- || ' from dual';
491: --hr_utility.trace(l_select);
492: --

Line 491: --hr_utility.trace(l_select);

487:
488: hr_utility.trace('P_SCH_CAL_END_DATE : '||P_SCH_CAL_END_DATE);
489: -- l_select := 'select '|| P_SCH_CAL_END_DATE
490: -- || ' from dual';
491: --hr_utility.trace(l_select);
492: --
493: -- Prepare the Calendar end date string
494: --
495: -- open c_cursor for l_select;

Line 499: hr_utility.trace('1_SCH_CAL_END_DATE : '||l_SCH_CAL_END_DATE);

495: -- open c_cursor for l_select;
496: -- fetch c_cursor into l_sch_cal_end_date;
497: -- close c_cursor;
498:
499: hr_utility.trace('1_SCH_CAL_END_DATE : '||l_SCH_CAL_END_DATE);
500: ELSE
501: l_sch_cal_start_date := NULL ;
502: l_sch_cal_end_date := NULL ;
503: END IF;

Line 527: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);

523: )
524: LOOP
525: l_lookup_table(i).abs_type_id:=r_lookup.abs_type_id;
526: l_lookup_table(i).abs_type_name:=r_lookup.abs_type_name;
527: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);
528: i := i + 1;
529: END LOOP;
530: END IF;
531: l_sec_grp_id := get_security_grp_id(p_bg_id);

Line 545: hr_utility.trace('Abs Type Name :'||l_lookup_table_plan_typ(i).name);

541: )
542: LOOP
543: l_lookup_table_plan_typ(i).plan_type_id:=r_lookup.abs_type_id;
544: l_lookup_table_plan_typ(i).name:=r_lookup.abs_type_name;
545: hr_utility.trace('Abs Type Name :'||l_lookup_table_plan_typ(i).name);
546: i := i + 1;
547: END LOOP;
548: ELSE
549: l_lookup_table_plan_typ := P_PLAN_TYPE_LOOKUP_VALUE;

Line 550: hr_utility.trace('In Else: assigning l_lookup_table_plan_typ value');

546: i := i + 1;
547: END LOOP;
548: ELSE
549: l_lookup_table_plan_typ := P_PLAN_TYPE_LOOKUP_VALUE;
550: hr_utility.trace('In Else: assigning l_lookup_table_plan_typ value');
551:
552: END IF;
553:
554: --End of Populating lookup for plan type l_lookup_table_plan_typ ---LG

Line 558: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);

554: --End of Populating lookup for plan type l_lookup_table_plan_typ ---LG
555:
556:
557: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
558: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
559: hr_utility.trace('Calling the create_user_template from my proc...');
560:
561:
562: l_element_type_id := pqp_gb_osp_template.create_user_template

Line 559: hr_utility.trace('Calling the create_user_template from my proc...');

555:
556:
557: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
558: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
559: hr_utility.trace('Calling the create_user_template from my proc...');
560:
561:
562: l_element_type_id := pqp_gb_osp_template.create_user_template
563: (p_plan_id => P_PLAN_ID

Line 611: hr_utility.trace('Ele Type Id :'||p_element_type_id);

607: ,p_pt_round_config => P_PT_ROUND_CONFIG
608: );
609:
610: p_element_type_id := l_element_type_id;
611: hr_utility.trace('Ele Type Id :'||p_element_type_id);
612:
613: --
614: -- Compile and create(BEN) all the Formulas
615: --

Line 630: hr_utility.trace('Entering exception when others ');

626: -- Added by tmehra for nocopy changes Feb'03
627:
628: EXCEPTION
629: /* WHEN OTHERS THEN
630: hr_utility.trace('Entering exception when others ');
631: p_element_type_id := NULL;
632: p_request_id := NULL;
633: raise; */
634: WHEN hr_multi_message.error_message_exist THEN

Line 642: hr_utility.set_location ( ' Leaving:'

638: -- at least one message exists in the list.
639: --
640: p_element_type_id := NULL;
641: p_request_id := NULL;
642: hr_utility.set_location ( ' Leaving:'
643: || l_proc_name, 40);
644: WHEN OTHERS THEN
645: --
646: -- When Multiple Message Detection is enabled catch

Line 656: hr_utility.set_location ( ' Leaving:'

652: IF hr_multi_message.unexpected_error_add (l_proc_name)
653: THEN
654: p_element_type_id := NULL;
655: p_request_id := NULL;
656: hr_utility.set_location ( ' Leaving:'
657: || l_proc_name, 50);
658: RAISE;
659: -- Bug 14112886
660: ELSE

Line 722: hr_utility.trace('Entering :'||l_proc_name);

718: -- for Multi Messages
719: hr_multi_message.enable_message_list;
720:
721:
722: hr_utility.trace('Entering :'||l_proc_name);
723: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
724: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
725:
726: IF P_ABS_TYPE_LOOKUP_TYPE IS NULL THEN

Line 723: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);

719: hr_multi_message.enable_message_list;
720:
721:
722: hr_utility.trace('Entering :'||l_proc_name);
723: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
724: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
725:
726: IF P_ABS_TYPE_LOOKUP_TYPE IS NULL THEN
727:

Line 724: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);

720:
721:
722: hr_utility.trace('Entering :'||l_proc_name);
723: hr_utility.trace('P_ABS_TYPE_LOOKUP_TYPE :' || P_ABS_TYPE_LOOKUP_TYPE);
724: hr_utility.trace('ABS_SHEDWP : '||P_ABS_SCHEDULE_WP);
725:
726: IF P_ABS_TYPE_LOOKUP_TYPE IS NULL THEN
727:
728: -- Fill the Absence types table.

Line 741: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);

737: )
738: LOOP
739: l_lookup_table(i).abs_type_id:=r_lookup.abs_type_id;
740: l_lookup_table(i).abs_type_name:=r_lookup.abs_type_name;
741: hr_utility.trace('Abs Type Name :'||l_lookup_table(i).abs_type_name);
742: i := i + 1;
743: END LOOP;
744: END IF;
745: l_sec_grp_id := get_security_grp_id(p_bg_id);

Line 749: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);

745: l_sec_grp_id := get_security_grp_id(p_bg_id);
746:
747:
748: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
749: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
750: hr_utility.trace('Calling the create_user_template from my proc...');
751:
752:
753: l_element_type_id := pqp_gb_unpaid_template.create_user_template

Line 750: hr_utility.trace('Calling the create_user_template from my proc...');

746:
747:
748: -- l_sec_grp_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
749: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
750: hr_utility.trace('Calling the create_user_template from my proc...');
751:
752:
753: l_element_type_id := pqp_gb_unpaid_template.create_user_template
754: (p_plan_id => P_PLAN_ID

Line 781: hr_utility.trace('Ele Type Id :'||p_element_type_id);

777: ,p_bg_id => p_bg_id
778: );
779:
780: p_element_type_id := l_element_type_id;
781: hr_utility.trace('Ele Type Id :'||p_element_type_id);
782:
783: --
784: -- Compile and create(BEN) all the Formulas
785: --

Line 807: hr_utility.set_location ( ' Leaving:'

803: -- at least one message exists in the list.
804: --
805: p_element_type_id := NULL;
806: p_request_id := NULL;
807: hr_utility.set_location ( ' Leaving:'
808: || l_proc_name, 40);
809: WHEN OTHERS THEN
810: --
811: -- When Multiple Message Detection is enabled catch

Line 821: hr_utility.set_location ( ' Leaving:'

817: IF hr_multi_message.unexpected_error_add (l_proc_name)
818: THEN
819: p_element_type_id := NULL;
820: p_request_id := NULL;
821: hr_utility.set_location ( ' Leaving:'
822: || l_proc_name, 50);
823: RAISE;
824: END IF;
825: