APPS.PER_GENERIC_REPORT_PKG dependencies on HR_UTILITY

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

115: (line_type,line_number,line_content)
116: values ('B',l_recs_inserted,l_full_name||
117: lpad(l_sex,50-length(l_full_name),' '));
118: l_recs_inserted := l_recs_inserted + 1;
119: hr_utility.set_location(l_proc,20);
120: end loop;
121: close c1;
122: end example1;
123: -- *************************************************************************

Line 197: hr_utility.set_location(l_proc,25);

193: insert into per_generic_report_output
194: (line_type,line_number,line_content)
195: values ('B',l_recs_inserted,' '||upper(l_full_name));
196: l_recs_inserted := l_recs_inserted + 1;
197: hr_utility.set_location(l_proc,25);
198: end loop;
199: close c2;
200: end example2;
201: -- *************************************************************************

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

281: insert into per_generic_report_output
282: (line_type,line_number,line_content)
283: values ('B',l_recs_inserted,l_sex||' '||initcap(l_full_name));
284: l_recs_inserted := l_recs_inserted + 1;
285: hr_utility.set_location(l_proc,30);
286: end loop;
287: close c3;
288: end example3;
289: -- *************************************************************************

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

352: -- program execution.
353: --
354: l_proc varchar(72) := g_package || 'generate_report';
355: begin
356: hr_utility.set_location('Entering: ' ||l_proc,5);
357: --
358: -- Delete existing data from per_generic_report_output
359: --
360: delete from per_generic_report_output;

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

484: select name
485: from per_vacancies
486: where name = p_param_1;
487: begin
488: hr_utility.set_location('Entering:' || l_proc,5);
489: --
490: -- This cursor checks whether a fetch was successful, in other words
491: -- does a vacancy exist. If not then a variable is set and an
492: -- appropriate error message will be displayed.

Line 513: hr_utility.set_location(l_proc,15);

509: end if;
510: --
511: -- Close cursor c1
512: --
513: hr_utility.set_location(l_proc,15);
514: close c1;
515: --
516: -- Return control back to the form if vacancy has not been found.
517: -- Display error message if vacancy not found.

Line 521: hr_utility.set_message(801,'HR_51001_THE_VAC_NOT_FOUND');

517: -- Display error message if vacancy not found.
518: --
519: if not l_success then
520: --
521: hr_utility.set_message(801,'HR_51001_THE_VAC_NOT_FOUND');
522: hr_utility.raise_error;
523: end if;
524: --
525: -- ***********************************************************************

Line 522: hr_utility.raise_error;

518: --
519: if not l_success then
520: --
521: hr_utility.set_message(801,'HR_51001_THE_VAC_NOT_FOUND');
522: hr_utility.raise_error;
523: end if;
524: --
525: -- ***********************************************************************
526: -- DO NOT REMOVE THE NEXT LINE : l_report_number := ........

Line 560: hr_utility.set_location(l_proc,35);

556: -- Check to see if the request was successful otherwise display an error
557: -- message.
558: --
559: if l_report_number = 0 then
560: hr_utility.set_location(l_proc,35);
561: hr_utility.set_message(801,'HR_51002_REPORT_CANT_SUBMITTED');
562: hr_utility.raise_error;
563: end if;
564: --

Line 561: hr_utility.set_message(801,'HR_51002_REPORT_CANT_SUBMITTED');

557: -- message.
558: --
559: if l_report_number = 0 then
560: hr_utility.set_location(l_proc,35);
561: hr_utility.set_message(801,'HR_51002_REPORT_CANT_SUBMITTED');
562: hr_utility.raise_error;
563: end if;
564: --
565: -- return true if all checks have been successful

Line 562: hr_utility.raise_error;

558: --
559: if l_report_number = 0 then
560: hr_utility.set_location(l_proc,35);
561: hr_utility.set_message(801,'HR_51002_REPORT_CANT_SUBMITTED');
562: hr_utility.raise_error;
563: end if;
564: --
565: -- return true if all checks have been successful
566: --