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.

[Home] [Help]

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 103: hr_utility.trace('Request Id :'||p_request_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 354: hr_utility.set_location ( ' Leaving:'

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

Line 369: hr_utility.set_location ( ' Leaving:'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 644: hr_utility.set_location ( ' Leaving:'

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

Line 658: hr_utility.set_location ( ' Leaving:'

654: IF hr_multi_message.unexpected_error_add (l_proc_name)
655: THEN
656: p_element_type_id := NULL;
657: p_request_id := NULL;
658: hr_utility.set_location ( ' Leaving:'
659: || l_proc_name, 50);
660: RAISE;
661: END IF;
662:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 805: hr_utility.set_location ( ' Leaving:'

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

Line 819: hr_utility.set_location ( ' Leaving:'

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