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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_appraisal_period_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< set_plan_status >-----------------------------|

Line 28: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;

24: l_dummy boolean;
25:
26: begin
27:
28: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
29:
30: --
31: -- Only attempt to set the plan's status if the procedure has been
32: -- called correctly.

Line 40: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

36: IF per_pmp_bus.return_status_code(p_plan_id) = 'PUBLISHED' THEN
37: --
38: -- Call the plan update row-handler.
39: --
40: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
41:
42: l_ovn := per_pmp_bus.return_ovn(p_plan_id);
43: l_status_code := 'UPDATED';
44:

Line 55: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 980); END IF;

51: ,p_no_life_events_warning => l_dummy);
52: END IF;
53: END IF;
54:
55: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 980); END IF;
56:
57: end set_plan_status;
58: --
59: -- ----------------------------------------------------------------------------

Line 130: hr_utility.set_location('Entering:'|| l_proc, 10);

126: begin
127:
128: IF g_debug THEN
129:
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131:
132: hr_utility.trace(' ');
133: hr_utility.trace(' --------------------------------'||
134: '---------------------------------');

Line 132: hr_utility.trace(' ');

128: IF g_debug THEN
129:
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131:
132: hr_utility.trace(' ');
133: hr_utility.trace(' --------------------------------'||
134: '---------------------------------');
135: hr_utility.trace(' IN / IN OUT PARAMETER '||
136: ' VALUE');

Line 133: hr_utility.trace(' --------------------------------'||

129:
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131:
132: hr_utility.trace(' ');
133: hr_utility.trace(' --------------------------------'||
134: '---------------------------------');
135: hr_utility.trace(' IN / IN OUT PARAMETER '||
136: ' VALUE');
137: hr_utility.trace(' --------------------------------'||

Line 135: hr_utility.trace(' IN / IN OUT PARAMETER '||

131:
132: hr_utility.trace(' ');
133: hr_utility.trace(' --------------------------------'||
134: '---------------------------------');
135: hr_utility.trace(' IN / IN OUT PARAMETER '||
136: ' VALUE');
137: hr_utility.trace(' --------------------------------'||
138: '+--------------------------------');
139: hr_utility.trace(' p_plan_id '||

Line 137: hr_utility.trace(' --------------------------------'||

133: hr_utility.trace(' --------------------------------'||
134: '---------------------------------');
135: hr_utility.trace(' IN / IN OUT PARAMETER '||
136: ' VALUE');
137: hr_utility.trace(' --------------------------------'||
138: '+--------------------------------');
139: hr_utility.trace(' p_plan_id '||
140: to_char(p_plan_id));
141: hr_utility.trace(' p_appraisal_template_id '||

Line 139: hr_utility.trace(' p_plan_id '||

135: hr_utility.trace(' IN / IN OUT PARAMETER '||
136: ' VALUE');
137: hr_utility.trace(' --------------------------------'||
138: '+--------------------------------');
139: hr_utility.trace(' p_plan_id '||
140: to_char(p_plan_id));
141: hr_utility.trace(' p_appraisal_template_id '||
142: to_char(p_appraisal_template_id));
143: hr_utility.trace(' p_start_date '||

Line 141: hr_utility.trace(' p_appraisal_template_id '||

137: hr_utility.trace(' --------------------------------'||
138: '+--------------------------------');
139: hr_utility.trace(' p_plan_id '||
140: to_char(p_plan_id));
141: hr_utility.trace(' p_appraisal_template_id '||
142: to_char(p_appraisal_template_id));
143: hr_utility.trace(' p_start_date '||
144: to_char(p_start_date));
145: hr_utility.trace(' p_end_date '||

Line 143: hr_utility.trace(' p_start_date '||

139: hr_utility.trace(' p_plan_id '||
140: to_char(p_plan_id));
141: hr_utility.trace(' p_appraisal_template_id '||
142: to_char(p_appraisal_template_id));
143: hr_utility.trace(' p_start_date '||
144: to_char(p_start_date));
145: hr_utility.trace(' p_end_date '||
146: to_char(p_end_date));
147: hr_utility.trace(' p_task_start_date '||

Line 145: hr_utility.trace(' p_end_date '||

141: hr_utility.trace(' p_appraisal_template_id '||
142: to_char(p_appraisal_template_id));
143: hr_utility.trace(' p_start_date '||
144: to_char(p_start_date));
145: hr_utility.trace(' p_end_date '||
146: to_char(p_end_date));
147: hr_utility.trace(' p_task_start_date '||
148: to_char(p_task_start_date));
149: hr_utility.trace(' p_task_end_date '||

Line 147: hr_utility.trace(' p_task_start_date '||

143: hr_utility.trace(' p_start_date '||
144: to_char(p_start_date));
145: hr_utility.trace(' p_end_date '||
146: to_char(p_end_date));
147: hr_utility.trace(' p_task_start_date '||
148: to_char(p_task_start_date));
149: hr_utility.trace(' p_task_end_date '||
150: to_char(p_task_end_date));
151: hr_utility.trace(' p_initiator_code '||

Line 149: hr_utility.trace(' p_task_end_date '||

145: hr_utility.trace(' p_end_date '||
146: to_char(p_end_date));
147: hr_utility.trace(' p_task_start_date '||
148: to_char(p_task_start_date));
149: hr_utility.trace(' p_task_end_date '||
150: to_char(p_task_end_date));
151: hr_utility.trace(' p_initiator_code '||
152: p_initiator_code);
153: hr_utility.trace(' --------------------------------'||

Line 151: hr_utility.trace(' p_initiator_code '||

147: hr_utility.trace(' p_task_start_date '||
148: to_char(p_task_start_date));
149: hr_utility.trace(' p_task_end_date '||
150: to_char(p_task_end_date));
151: hr_utility.trace(' p_initiator_code '||
152: p_initiator_code);
153: hr_utility.trace(' --------------------------------'||
154: '+--------------------------------');
155: hr_utility.trace(' p_effective_date '||

Line 153: hr_utility.trace(' --------------------------------'||

149: hr_utility.trace(' p_task_end_date '||
150: to_char(p_task_end_date));
151: hr_utility.trace(' p_initiator_code '||
152: p_initiator_code);
153: hr_utility.trace(' --------------------------------'||
154: '+--------------------------------');
155: hr_utility.trace(' p_effective_date '||
156: to_char(p_effective_date));
157: hr_utility.trace(' --------------------------------'||

Line 155: hr_utility.trace(' p_effective_date '||

151: hr_utility.trace(' p_initiator_code '||
152: p_initiator_code);
153: hr_utility.trace(' --------------------------------'||
154: '+--------------------------------');
155: hr_utility.trace(' p_effective_date '||
156: to_char(p_effective_date));
157: hr_utility.trace(' --------------------------------'||
158: '---------------------------------');
159: hr_utility.trace(' ');

Line 157: hr_utility.trace(' --------------------------------'||

153: hr_utility.trace(' --------------------------------'||
154: '+--------------------------------');
155: hr_utility.trace(' p_effective_date '||
156: to_char(p_effective_date));
157: hr_utility.trace(' --------------------------------'||
158: '---------------------------------');
159: hr_utility.trace(' ');
160:
161: END IF;

Line 159: hr_utility.trace(' ');

155: hr_utility.trace(' p_effective_date '||
156: to_char(p_effective_date));
157: hr_utility.trace(' --------------------------------'||
158: '---------------------------------');
159: hr_utility.trace(' ');
160:
161: END IF;
162:
163: --

Line 240: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

236:
237: --
238: -- Process Logic
239: --
240: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
241:
242: per_pma_ins.ins
243: (p_effective_date => l_effective_date
244: ,p_plan_id => p_plan_id

Line 362: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

358: --
359: set_plan_status(p_plan_id,p_start_date);
360:
361:
362: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
363: --
364: -- When in validation only mode raise the Validate_Enabled exception
365: --
366: if p_validate then

Line 380: hr_utility.trace(' ');

376: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
377: --
378: IF g_debug THEN
379:
380: hr_utility.trace(' ');
381: hr_utility.trace(' --------------------------------'||
382: '---------------------------------');
383: hr_utility.trace(' IN OUT / OUT PARAMETER '||
384: ' VALUE');

Line 381: hr_utility.trace(' --------------------------------'||

377: --
378: IF g_debug THEN
379:
380: hr_utility.trace(' ');
381: hr_utility.trace(' --------------------------------'||
382: '---------------------------------');
383: hr_utility.trace(' IN OUT / OUT PARAMETER '||
384: ' VALUE');
385: hr_utility.trace(' --------------------------------'||

Line 383: hr_utility.trace(' IN OUT / OUT PARAMETER '||

379:
380: hr_utility.trace(' ');
381: hr_utility.trace(' --------------------------------'||
382: '---------------------------------');
383: hr_utility.trace(' IN OUT / OUT PARAMETER '||
384: ' VALUE');
385: hr_utility.trace(' --------------------------------'||
386: '+--------------------------------');
387: hr_utility.trace(' p_appraisal_period_id '||

Line 385: hr_utility.trace(' --------------------------------'||

381: hr_utility.trace(' --------------------------------'||
382: '---------------------------------');
383: hr_utility.trace(' IN OUT / OUT PARAMETER '||
384: ' VALUE');
385: hr_utility.trace(' --------------------------------'||
386: '+--------------------------------');
387: hr_utility.trace(' p_appraisal_period_id '||
388: to_char(p_appraisal_period_id));
389: hr_utility.trace(' p_object_version_number '||

Line 387: hr_utility.trace(' p_appraisal_period_id '||

383: hr_utility.trace(' IN OUT / OUT PARAMETER '||
384: ' VALUE');
385: hr_utility.trace(' --------------------------------'||
386: '+--------------------------------');
387: hr_utility.trace(' p_appraisal_period_id '||
388: to_char(p_appraisal_period_id));
389: hr_utility.trace(' p_object_version_number '||
390: to_char(p_object_version_number));
391: hr_utility.trace(' --------------------------------'||

Line 389: hr_utility.trace(' p_object_version_number '||

385: hr_utility.trace(' --------------------------------'||
386: '+--------------------------------');
387: hr_utility.trace(' p_appraisal_period_id '||
388: to_char(p_appraisal_period_id));
389: hr_utility.trace(' p_object_version_number '||
390: to_char(p_object_version_number));
391: hr_utility.trace(' --------------------------------'||
392: '---------------------------------');
393: hr_utility.trace(' ');

Line 391: hr_utility.trace(' --------------------------------'||

387: hr_utility.trace(' p_appraisal_period_id '||
388: to_char(p_appraisal_period_id));
389: hr_utility.trace(' p_object_version_number '||
390: to_char(p_object_version_number));
391: hr_utility.trace(' --------------------------------'||
392: '---------------------------------');
393: hr_utility.trace(' ');
394: hr_utility.set_location(' Leaving:'||l_proc, 970);
395:

Line 393: hr_utility.trace(' ');

389: hr_utility.trace(' p_object_version_number '||
390: to_char(p_object_version_number));
391: hr_utility.trace(' --------------------------------'||
392: '---------------------------------');
393: hr_utility.trace(' ');
394: hr_utility.set_location(' Leaving:'||l_proc, 970);
395:
396: END IF;
397:

Line 394: hr_utility.set_location(' Leaving:'||l_proc, 970);

390: to_char(p_object_version_number));
391: hr_utility.trace(' --------------------------------'||
392: '---------------------------------');
393: hr_utility.trace(' ');
394: hr_utility.set_location(' Leaving:'||l_proc, 970);
395:
396: END IF;
397:
398: exception

Line 412: hr_utility.set_location(' Leaving:'||l_proc, 980);

408: -- when validation only mode is being used.)
409: --
410: p_appraisal_period_id := null;
411: p_object_version_number := null;
412: hr_utility.set_location(' Leaving:'||l_proc, 980);
413: when others then
414: --
415: -- A validation or unexpected error has occured
416: --

Line 424: hr_utility.set_location(' Leaving:'||l_proc, 990);

420: -- OUT parameters, including warnings, to null
421: --
422: p_appraisal_period_id := null;
423: p_object_version_number := null;
424: hr_utility.set_location(' Leaving:'||l_proc, 990);
425: raise;
426: end create_appraisal_period;
427: --
428: -- ----------------------------------------------------------------------------

Line 496: hr_utility.set_location('Entering:'|| l_proc, 10);

492: begin
493:
494: IF g_debug THEN
495:
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497:
498: hr_utility.trace(' ');
499: hr_utility.trace(' --------------------------------'||
500: '---------------------------------');

Line 498: hr_utility.trace(' ');

494: IF g_debug THEN
495:
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497:
498: hr_utility.trace(' ');
499: hr_utility.trace(' --------------------------------'||
500: '---------------------------------');
501: hr_utility.trace(' IN / IN OUT PARAMETER '||
502: ' VALUE');

Line 499: hr_utility.trace(' --------------------------------'||

495:
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497:
498: hr_utility.trace(' ');
499: hr_utility.trace(' --------------------------------'||
500: '---------------------------------');
501: hr_utility.trace(' IN / IN OUT PARAMETER '||
502: ' VALUE');
503: hr_utility.trace(' --------------------------------'||

Line 501: hr_utility.trace(' IN / IN OUT PARAMETER '||

497:
498: hr_utility.trace(' ');
499: hr_utility.trace(' --------------------------------'||
500: '---------------------------------');
501: hr_utility.trace(' IN / IN OUT PARAMETER '||
502: ' VALUE');
503: hr_utility.trace(' --------------------------------'||
504: '+--------------------------------');
505: hr_utility.trace(' p_appraisal_period_id '||

Line 503: hr_utility.trace(' --------------------------------'||

499: hr_utility.trace(' --------------------------------'||
500: '---------------------------------');
501: hr_utility.trace(' IN / IN OUT PARAMETER '||
502: ' VALUE');
503: hr_utility.trace(' --------------------------------'||
504: '+--------------------------------');
505: hr_utility.trace(' p_appraisal_period_id '||
506: to_char(p_appraisal_period_id));
507: hr_utility.trace(' p_object_version_number '||

Line 505: hr_utility.trace(' p_appraisal_period_id '||

501: hr_utility.trace(' IN / IN OUT PARAMETER '||
502: ' VALUE');
503: hr_utility.trace(' --------------------------------'||
504: '+--------------------------------');
505: hr_utility.trace(' p_appraisal_period_id '||
506: to_char(p_appraisal_period_id));
507: hr_utility.trace(' p_object_version_number '||
508: to_char(p_object_version_number));
509: hr_utility.trace(' p_start_date '||

Line 507: hr_utility.trace(' p_object_version_number '||

503: hr_utility.trace(' --------------------------------'||
504: '+--------------------------------');
505: hr_utility.trace(' p_appraisal_period_id '||
506: to_char(p_appraisal_period_id));
507: hr_utility.trace(' p_object_version_number '||
508: to_char(p_object_version_number));
509: hr_utility.trace(' p_start_date '||
510: to_char(p_start_date));
511: hr_utility.trace(' p_end_date '||

Line 509: hr_utility.trace(' p_start_date '||

505: hr_utility.trace(' p_appraisal_period_id '||
506: to_char(p_appraisal_period_id));
507: hr_utility.trace(' p_object_version_number '||
508: to_char(p_object_version_number));
509: hr_utility.trace(' p_start_date '||
510: to_char(p_start_date));
511: hr_utility.trace(' p_end_date '||
512: to_char(p_end_date));
513: hr_utility.trace(' p_task_start_date '||

Line 511: hr_utility.trace(' p_end_date '||

507: hr_utility.trace(' p_object_version_number '||
508: to_char(p_object_version_number));
509: hr_utility.trace(' p_start_date '||
510: to_char(p_start_date));
511: hr_utility.trace(' p_end_date '||
512: to_char(p_end_date));
513: hr_utility.trace(' p_task_start_date '||
514: to_char(p_task_start_date));
515: hr_utility.trace(' p_task_end_date '||

Line 513: hr_utility.trace(' p_task_start_date '||

509: hr_utility.trace(' p_start_date '||
510: to_char(p_start_date));
511: hr_utility.trace(' p_end_date '||
512: to_char(p_end_date));
513: hr_utility.trace(' p_task_start_date '||
514: to_char(p_task_start_date));
515: hr_utility.trace(' p_task_end_date '||
516: to_char(p_task_end_date));
517: hr_utility.trace(' p_initiator_code '||

Line 515: hr_utility.trace(' p_task_end_date '||

511: hr_utility.trace(' p_end_date '||
512: to_char(p_end_date));
513: hr_utility.trace(' p_task_start_date '||
514: to_char(p_task_start_date));
515: hr_utility.trace(' p_task_end_date '||
516: to_char(p_task_end_date));
517: hr_utility.trace(' p_initiator_code '||
518: p_initiator_code);
519: hr_utility.trace(' p_effective_date '||

Line 517: hr_utility.trace(' p_initiator_code '||

513: hr_utility.trace(' p_task_start_date '||
514: to_char(p_task_start_date));
515: hr_utility.trace(' p_task_end_date '||
516: to_char(p_task_end_date));
517: hr_utility.trace(' p_initiator_code '||
518: p_initiator_code);
519: hr_utility.trace(' p_effective_date '||
520: to_char(p_effective_date));
521: hr_utility.trace(' --------------------------------'||

Line 519: hr_utility.trace(' p_effective_date '||

515: hr_utility.trace(' p_task_end_date '||
516: to_char(p_task_end_date));
517: hr_utility.trace(' p_initiator_code '||
518: p_initiator_code);
519: hr_utility.trace(' p_effective_date '||
520: to_char(p_effective_date));
521: hr_utility.trace(' --------------------------------'||
522: '---------------------------------');
523: hr_utility.trace(' ');

Line 521: hr_utility.trace(' --------------------------------'||

517: hr_utility.trace(' p_initiator_code '||
518: p_initiator_code);
519: hr_utility.trace(' p_effective_date '||
520: to_char(p_effective_date));
521: hr_utility.trace(' --------------------------------'||
522: '---------------------------------');
523: hr_utility.trace(' ');
524:
525: END IF;

Line 523: hr_utility.trace(' ');

519: hr_utility.trace(' p_effective_date '||
520: to_char(p_effective_date));
521: hr_utility.trace(' --------------------------------'||
522: '---------------------------------');
523: hr_utility.trace(' ');
524:
525: END IF;
526:
527: --

Line 604: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

600:
601: --
602: -- Process Logic
603: --
604: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
605:
606: per_pma_upd.upd
607: (p_effective_date => l_effective_date
608: ,p_appraisal_period_id => p_appraisal_period_id

Line 722: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

718: --
719: set_plan_status(per_pma_shd.g_old_rec.plan_id
720: ,per_pma_shd.g_old_rec.start_date);
721:
722: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
723: --
724: -- When in validation only mode raise the Validate_Enabled exception
725: --
726: if p_validate then

Line 739: hr_utility.trace(' ');

735: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
736: --
737: IF g_debug THEN
738:
739: hr_utility.trace(' ');
740: hr_utility.trace(' --------------------------------'||
741: '---------------------------------');
742: hr_utility.trace(' IN OUT / OUT PARAMETER '||
743: ' VALUE');

Line 740: hr_utility.trace(' --------------------------------'||

736: --
737: IF g_debug THEN
738:
739: hr_utility.trace(' ');
740: hr_utility.trace(' --------------------------------'||
741: '---------------------------------');
742: hr_utility.trace(' IN OUT / OUT PARAMETER '||
743: ' VALUE');
744: hr_utility.trace(' --------------------------------'||

Line 742: hr_utility.trace(' IN OUT / OUT PARAMETER '||

738:
739: hr_utility.trace(' ');
740: hr_utility.trace(' --------------------------------'||
741: '---------------------------------');
742: hr_utility.trace(' IN OUT / OUT PARAMETER '||
743: ' VALUE');
744: hr_utility.trace(' --------------------------------'||
745: '+--------------------------------');
746: hr_utility.trace(' p_object_version_number '||

Line 744: hr_utility.trace(' --------------------------------'||

740: hr_utility.trace(' --------------------------------'||
741: '---------------------------------');
742: hr_utility.trace(' IN OUT / OUT PARAMETER '||
743: ' VALUE');
744: hr_utility.trace(' --------------------------------'||
745: '+--------------------------------');
746: hr_utility.trace(' p_object_version_number '||
747: to_char(p_object_version_number));
748: hr_utility.trace(' --------------------------------'||

Line 746: hr_utility.trace(' p_object_version_number '||

742: hr_utility.trace(' IN OUT / OUT PARAMETER '||
743: ' VALUE');
744: hr_utility.trace(' --------------------------------'||
745: '+--------------------------------');
746: hr_utility.trace(' p_object_version_number '||
747: to_char(p_object_version_number));
748: hr_utility.trace(' --------------------------------'||
749: '---------------------------------');
750: hr_utility.trace(' ');

Line 748: hr_utility.trace(' --------------------------------'||

744: hr_utility.trace(' --------------------------------'||
745: '+--------------------------------');
746: hr_utility.trace(' p_object_version_number '||
747: to_char(p_object_version_number));
748: hr_utility.trace(' --------------------------------'||
749: '---------------------------------');
750: hr_utility.trace(' ');
751: hr_utility.set_location(' Leaving:'||l_proc, 970);
752:

Line 750: hr_utility.trace(' ');

746: hr_utility.trace(' p_object_version_number '||
747: to_char(p_object_version_number));
748: hr_utility.trace(' --------------------------------'||
749: '---------------------------------');
750: hr_utility.trace(' ');
751: hr_utility.set_location(' Leaving:'||l_proc, 970);
752:
753: END IF;
754:

Line 751: hr_utility.set_location(' Leaving:'||l_proc, 970);

747: to_char(p_object_version_number));
748: hr_utility.trace(' --------------------------------'||
749: '---------------------------------');
750: hr_utility.trace(' ');
751: hr_utility.set_location(' Leaving:'||l_proc, 970);
752:
753: END IF;
754:
755: exception

Line 768: hr_utility.set_location(' Leaving:'||l_proc, 980);

764: -- (Any key or derived arguments must be set to null
765: -- when validation only mode is being used.)
766: --
767: p_object_version_number := null;
768: hr_utility.set_location(' Leaving:'||l_proc, 980);
769: when others then
770: --
771: -- A validation or unexpected error has occured
772: --

Line 779: hr_utility.set_location(' Leaving:'||l_proc, 990);

775: -- Reset IN OUT parameters and set all
776: -- OUT parameters, including warnings, to null
777: --
778: p_object_version_number := null;
779: hr_utility.set_location(' Leaving:'||l_proc, 990);
780: raise;
781: end update_appraisal_period;
782: --
783: -- ----------------------------------------------------------------------------

Line 801: hr_utility.set_location('Entering:'|| l_proc, 10);

797: begin
798:
799: IF g_debug THEN
800:
801: hr_utility.set_location('Entering:'|| l_proc, 10);
802:
803: hr_utility.trace(' ');
804: hr_utility.trace(' --------------------------------'||
805: '---------------------------------');

Line 803: hr_utility.trace(' ');

799: IF g_debug THEN
800:
801: hr_utility.set_location('Entering:'|| l_proc, 10);
802:
803: hr_utility.trace(' ');
804: hr_utility.trace(' --------------------------------'||
805: '---------------------------------');
806: hr_utility.trace(' IN / IN OUT PARAMETER '||
807: ' VALUE');

Line 804: hr_utility.trace(' --------------------------------'||

800:
801: hr_utility.set_location('Entering:'|| l_proc, 10);
802:
803: hr_utility.trace(' ');
804: hr_utility.trace(' --------------------------------'||
805: '---------------------------------');
806: hr_utility.trace(' IN / IN OUT PARAMETER '||
807: ' VALUE');
808: hr_utility.trace(' --------------------------------'||

Line 806: hr_utility.trace(' IN / IN OUT PARAMETER '||

802:
803: hr_utility.trace(' ');
804: hr_utility.trace(' --------------------------------'||
805: '---------------------------------');
806: hr_utility.trace(' IN / IN OUT PARAMETER '||
807: ' VALUE');
808: hr_utility.trace(' --------------------------------'||
809: '+--------------------------------');
810: hr_utility.trace(' p_appraisal_period_id '||

Line 808: hr_utility.trace(' --------------------------------'||

804: hr_utility.trace(' --------------------------------'||
805: '---------------------------------');
806: hr_utility.trace(' IN / IN OUT PARAMETER '||
807: ' VALUE');
808: hr_utility.trace(' --------------------------------'||
809: '+--------------------------------');
810: hr_utility.trace(' p_appraisal_period_id '||
811: to_char(p_appraisal_period_id));
812: hr_utility.trace(' p_object_version_number '||

Line 810: hr_utility.trace(' p_appraisal_period_id '||

806: hr_utility.trace(' IN / IN OUT PARAMETER '||
807: ' VALUE');
808: hr_utility.trace(' --------------------------------'||
809: '+--------------------------------');
810: hr_utility.trace(' p_appraisal_period_id '||
811: to_char(p_appraisal_period_id));
812: hr_utility.trace(' p_object_version_number '||
813: to_char(p_object_version_number));
814: hr_utility.trace(' --------------------------------'||

Line 812: hr_utility.trace(' p_object_version_number '||

808: hr_utility.trace(' --------------------------------'||
809: '+--------------------------------');
810: hr_utility.trace(' p_appraisal_period_id '||
811: to_char(p_appraisal_period_id));
812: hr_utility.trace(' p_object_version_number '||
813: to_char(p_object_version_number));
814: hr_utility.trace(' --------------------------------'||
815: '---------------------------------');
816: hr_utility.trace(' ');

Line 814: hr_utility.trace(' --------------------------------'||

810: hr_utility.trace(' p_appraisal_period_id '||
811: to_char(p_appraisal_period_id));
812: hr_utility.trace(' p_object_version_number '||
813: to_char(p_object_version_number));
814: hr_utility.trace(' --------------------------------'||
815: '---------------------------------');
816: hr_utility.trace(' ');
817:
818: END IF;

Line 816: hr_utility.trace(' ');

812: hr_utility.trace(' p_object_version_number '||
813: to_char(p_object_version_number));
814: hr_utility.trace(' --------------------------------'||
815: '---------------------------------');
816: hr_utility.trace(' ');
817:
818: END IF;
819:
820: --

Line 844: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

840:
841: --
842: -- Process Logic
843: --
844: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
845:
846: per_pma_del.del
847: (p_appraisal_period_id => p_appraisal_period_id
848: ,p_object_version_number => p_object_version_number

Line 867: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

863: ,p_hook_type => 'AP'
864: );
865: end;
866:
867: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
868: --
869: -- When in validation only mode raise the Validate_Enabled exception
870: --
871: if p_validate then

Line 880: hr_utility.trace(' ');

876: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
877: --
878: IF g_debug THEN
879:
880: hr_utility.trace(' ');
881: hr_utility.trace(' --------------------------------'||
882: '---------------------------------');
883: hr_utility.trace(' IN OUT / OUT PARAMETER '||
884: ' VALUE');

Line 881: hr_utility.trace(' --------------------------------'||

877: --
878: IF g_debug THEN
879:
880: hr_utility.trace(' ');
881: hr_utility.trace(' --------------------------------'||
882: '---------------------------------');
883: hr_utility.trace(' IN OUT / OUT PARAMETER '||
884: ' VALUE');
885: hr_utility.trace(' --------------------------------'||

Line 883: hr_utility.trace(' IN OUT / OUT PARAMETER '||

879:
880: hr_utility.trace(' ');
881: hr_utility.trace(' --------------------------------'||
882: '---------------------------------');
883: hr_utility.trace(' IN OUT / OUT PARAMETER '||
884: ' VALUE');
885: hr_utility.trace(' --------------------------------'||
886: '+--------------------------------');
887: hr_utility.trace(' ');

Line 885: hr_utility.trace(' --------------------------------'||

881: hr_utility.trace(' --------------------------------'||
882: '---------------------------------');
883: hr_utility.trace(' IN OUT / OUT PARAMETER '||
884: ' VALUE');
885: hr_utility.trace(' --------------------------------'||
886: '+--------------------------------');
887: hr_utility.trace(' ');
888: hr_utility.set_location(' Leaving:'||l_proc, 970);
889:

Line 887: hr_utility.trace(' ');

883: hr_utility.trace(' IN OUT / OUT PARAMETER '||
884: ' VALUE');
885: hr_utility.trace(' --------------------------------'||
886: '+--------------------------------');
887: hr_utility.trace(' ');
888: hr_utility.set_location(' Leaving:'||l_proc, 970);
889:
890: END IF;
891:

Line 888: hr_utility.set_location(' Leaving:'||l_proc, 970);

884: ' VALUE');
885: hr_utility.trace(' --------------------------------'||
886: '+--------------------------------');
887: hr_utility.trace(' ');
888: hr_utility.set_location(' Leaving:'||l_proc, 970);
889:
890: END IF;
891:
892: exception

Line 899: hr_utility.set_location(' Leaving:'||l_proc, 980);

895: -- As the Validate_Enabled exception has been raised
896: -- we must rollback to the savepoint
897: --
898: rollback to delete_appraisal_period;
899: hr_utility.set_location(' Leaving:'||l_proc, 980);
900: when others then
901: --
902: -- A validation or unexpected error has occured
903: --

Line 905: hr_utility.set_location(' Leaving:'||l_proc, 990);

901: --
902: -- A validation or unexpected error has occured
903: --
904: rollback to delete_appraisal_period;
905: hr_utility.set_location(' Leaving:'||l_proc, 990);
906: raise;
907: end delete_appraisal_period;
908: --
909: end hr_appraisal_period_api;