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 128: hr_utility.set_location('Entering:'|| l_proc, 10);

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

Line 130: hr_utility.trace(' ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 157: hr_utility.trace(' ');

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

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

232:
233: --
234: -- Process Logic
235: --
236: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
237:
238: per_pma_ins.ins
239: (p_effective_date => l_effective_date
240: ,p_plan_id => p_plan_id

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

350: --
351: set_plan_status(p_plan_id,p_start_date);
352:
353:
354: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
355: --
356: -- When in validation only mode raise the Validate_Enabled exception
357: --
358: if p_validate then

Line 372: hr_utility.trace(' ');

368: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
369: --
370: IF g_debug THEN
371:
372: hr_utility.trace(' ');
373: hr_utility.trace(' --------------------------------'||
374: '---------------------------------');
375: hr_utility.trace(' IN OUT / OUT PARAMETER '||
376: ' VALUE');

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

369: --
370: IF g_debug THEN
371:
372: hr_utility.trace(' ');
373: hr_utility.trace(' --------------------------------'||
374: '---------------------------------');
375: hr_utility.trace(' IN OUT / OUT PARAMETER '||
376: ' VALUE');
377: hr_utility.trace(' --------------------------------'||

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

371:
372: hr_utility.trace(' ');
373: hr_utility.trace(' --------------------------------'||
374: '---------------------------------');
375: hr_utility.trace(' IN OUT / OUT PARAMETER '||
376: ' VALUE');
377: hr_utility.trace(' --------------------------------'||
378: '+--------------------------------');
379: hr_utility.trace(' p_appraisal_period_id '||

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

373: hr_utility.trace(' --------------------------------'||
374: '---------------------------------');
375: hr_utility.trace(' IN OUT / OUT PARAMETER '||
376: ' VALUE');
377: hr_utility.trace(' --------------------------------'||
378: '+--------------------------------');
379: hr_utility.trace(' p_appraisal_period_id '||
380: to_char(p_appraisal_period_id));
381: hr_utility.trace(' p_object_version_number '||

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

375: hr_utility.trace(' IN OUT / OUT PARAMETER '||
376: ' VALUE');
377: hr_utility.trace(' --------------------------------'||
378: '+--------------------------------');
379: hr_utility.trace(' p_appraisal_period_id '||
380: to_char(p_appraisal_period_id));
381: hr_utility.trace(' p_object_version_number '||
382: to_char(p_object_version_number));
383: hr_utility.trace(' --------------------------------'||

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

377: hr_utility.trace(' --------------------------------'||
378: '+--------------------------------');
379: hr_utility.trace(' p_appraisal_period_id '||
380: to_char(p_appraisal_period_id));
381: hr_utility.trace(' p_object_version_number '||
382: to_char(p_object_version_number));
383: hr_utility.trace(' --------------------------------'||
384: '---------------------------------');
385: hr_utility.trace(' ');

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

379: hr_utility.trace(' p_appraisal_period_id '||
380: to_char(p_appraisal_period_id));
381: hr_utility.trace(' p_object_version_number '||
382: to_char(p_object_version_number));
383: hr_utility.trace(' --------------------------------'||
384: '---------------------------------');
385: hr_utility.trace(' ');
386: hr_utility.set_location(' Leaving:'||l_proc, 970);
387:

Line 385: hr_utility.trace(' ');

381: hr_utility.trace(' p_object_version_number '||
382: to_char(p_object_version_number));
383: hr_utility.trace(' --------------------------------'||
384: '---------------------------------');
385: hr_utility.trace(' ');
386: hr_utility.set_location(' Leaving:'||l_proc, 970);
387:
388: END IF;
389:

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

382: to_char(p_object_version_number));
383: hr_utility.trace(' --------------------------------'||
384: '---------------------------------');
385: hr_utility.trace(' ');
386: hr_utility.set_location(' Leaving:'||l_proc, 970);
387:
388: END IF;
389:
390: exception

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

400: -- when validation only mode is being used.)
401: --
402: p_appraisal_period_id := null;
403: p_object_version_number := null;
404: hr_utility.set_location(' Leaving:'||l_proc, 980);
405: when others then
406: --
407: -- A validation or unexpected error has occured
408: --

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

412: -- OUT parameters, including warnings, to null
413: --
414: p_appraisal_period_id := null;
415: p_object_version_number := null;
416: hr_utility.set_location(' Leaving:'||l_proc, 990);
417: raise;
418: end create_appraisal_period;
419: --
420: -- ----------------------------------------------------------------------------

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

482: begin
483:
484: IF g_debug THEN
485:
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487:
488: hr_utility.trace(' ');
489: hr_utility.trace(' --------------------------------'||
490: '---------------------------------');

Line 488: hr_utility.trace(' ');

484: IF g_debug THEN
485:
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487:
488: hr_utility.trace(' ');
489: hr_utility.trace(' --------------------------------'||
490: '---------------------------------');
491: hr_utility.trace(' IN / IN OUT PARAMETER '||
492: ' VALUE');

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

485:
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487:
488: hr_utility.trace(' ');
489: hr_utility.trace(' --------------------------------'||
490: '---------------------------------');
491: hr_utility.trace(' IN / IN OUT PARAMETER '||
492: ' VALUE');
493: hr_utility.trace(' --------------------------------'||

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

487:
488: hr_utility.trace(' ');
489: hr_utility.trace(' --------------------------------'||
490: '---------------------------------');
491: hr_utility.trace(' IN / IN OUT PARAMETER '||
492: ' VALUE');
493: hr_utility.trace(' --------------------------------'||
494: '+--------------------------------');
495: hr_utility.trace(' p_appraisal_period_id '||

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

489: hr_utility.trace(' --------------------------------'||
490: '---------------------------------');
491: hr_utility.trace(' IN / IN OUT PARAMETER '||
492: ' VALUE');
493: hr_utility.trace(' --------------------------------'||
494: '+--------------------------------');
495: hr_utility.trace(' p_appraisal_period_id '||
496: to_char(p_appraisal_period_id));
497: hr_utility.trace(' p_object_version_number '||

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

491: hr_utility.trace(' IN / IN OUT PARAMETER '||
492: ' VALUE');
493: hr_utility.trace(' --------------------------------'||
494: '+--------------------------------');
495: hr_utility.trace(' p_appraisal_period_id '||
496: to_char(p_appraisal_period_id));
497: hr_utility.trace(' p_object_version_number '||
498: to_char(p_object_version_number));
499: hr_utility.trace(' p_start_date '||

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

493: hr_utility.trace(' --------------------------------'||
494: '+--------------------------------');
495: hr_utility.trace(' p_appraisal_period_id '||
496: to_char(p_appraisal_period_id));
497: hr_utility.trace(' p_object_version_number '||
498: to_char(p_object_version_number));
499: hr_utility.trace(' p_start_date '||
500: to_char(p_start_date));
501: hr_utility.trace(' p_end_date '||

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

495: hr_utility.trace(' p_appraisal_period_id '||
496: to_char(p_appraisal_period_id));
497: hr_utility.trace(' p_object_version_number '||
498: to_char(p_object_version_number));
499: hr_utility.trace(' p_start_date '||
500: to_char(p_start_date));
501: hr_utility.trace(' p_end_date '||
502: to_char(p_end_date));
503: hr_utility.trace(' p_task_start_date '||

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

497: hr_utility.trace(' p_object_version_number '||
498: to_char(p_object_version_number));
499: hr_utility.trace(' p_start_date '||
500: to_char(p_start_date));
501: hr_utility.trace(' p_end_date '||
502: to_char(p_end_date));
503: hr_utility.trace(' p_task_start_date '||
504: to_char(p_task_start_date));
505: hr_utility.trace(' p_task_end_date '||

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

499: hr_utility.trace(' p_start_date '||
500: to_char(p_start_date));
501: hr_utility.trace(' p_end_date '||
502: to_char(p_end_date));
503: hr_utility.trace(' p_task_start_date '||
504: to_char(p_task_start_date));
505: hr_utility.trace(' p_task_end_date '||
506: to_char(p_task_end_date));
507: hr_utility.trace(' p_initiator_code '||

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

501: hr_utility.trace(' p_end_date '||
502: to_char(p_end_date));
503: hr_utility.trace(' p_task_start_date '||
504: to_char(p_task_start_date));
505: hr_utility.trace(' p_task_end_date '||
506: to_char(p_task_end_date));
507: hr_utility.trace(' p_initiator_code '||
508: p_initiator_code);
509: hr_utility.trace(' p_effective_date '||

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

503: hr_utility.trace(' p_task_start_date '||
504: to_char(p_task_start_date));
505: hr_utility.trace(' p_task_end_date '||
506: to_char(p_task_end_date));
507: hr_utility.trace(' p_initiator_code '||
508: p_initiator_code);
509: hr_utility.trace(' p_effective_date '||
510: to_char(p_effective_date));
511: hr_utility.trace(' --------------------------------'||

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

505: hr_utility.trace(' p_task_end_date '||
506: to_char(p_task_end_date));
507: hr_utility.trace(' p_initiator_code '||
508: p_initiator_code);
509: hr_utility.trace(' p_effective_date '||
510: to_char(p_effective_date));
511: hr_utility.trace(' --------------------------------'||
512: '---------------------------------');
513: hr_utility.trace(' ');

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

507: hr_utility.trace(' p_initiator_code '||
508: p_initiator_code);
509: hr_utility.trace(' p_effective_date '||
510: to_char(p_effective_date));
511: hr_utility.trace(' --------------------------------'||
512: '---------------------------------');
513: hr_utility.trace(' ');
514:
515: END IF;

Line 513: hr_utility.trace(' ');

509: hr_utility.trace(' p_effective_date '||
510: to_char(p_effective_date));
511: hr_utility.trace(' --------------------------------'||
512: '---------------------------------');
513: hr_utility.trace(' ');
514:
515: END IF;
516:
517: --

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

588:
589: --
590: -- Process Logic
591: --
592: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
593:
594: per_pma_upd.upd
595: (p_effective_date => l_effective_date
596: ,p_appraisal_period_id => p_appraisal_period_id

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

702: --
703: set_plan_status(per_pma_shd.g_old_rec.plan_id
704: ,per_pma_shd.g_old_rec.start_date);
705:
706: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
707: --
708: -- When in validation only mode raise the Validate_Enabled exception
709: --
710: if p_validate then

Line 723: hr_utility.trace(' ');

719: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
720: --
721: IF g_debug THEN
722:
723: hr_utility.trace(' ');
724: hr_utility.trace(' --------------------------------'||
725: '---------------------------------');
726: hr_utility.trace(' IN OUT / OUT PARAMETER '||
727: ' VALUE');

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

720: --
721: IF g_debug THEN
722:
723: hr_utility.trace(' ');
724: hr_utility.trace(' --------------------------------'||
725: '---------------------------------');
726: hr_utility.trace(' IN OUT / OUT PARAMETER '||
727: ' VALUE');
728: hr_utility.trace(' --------------------------------'||

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

722:
723: hr_utility.trace(' ');
724: hr_utility.trace(' --------------------------------'||
725: '---------------------------------');
726: hr_utility.trace(' IN OUT / OUT PARAMETER '||
727: ' VALUE');
728: hr_utility.trace(' --------------------------------'||
729: '+--------------------------------');
730: hr_utility.trace(' p_object_version_number '||

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

724: hr_utility.trace(' --------------------------------'||
725: '---------------------------------');
726: hr_utility.trace(' IN OUT / OUT PARAMETER '||
727: ' VALUE');
728: hr_utility.trace(' --------------------------------'||
729: '+--------------------------------');
730: hr_utility.trace(' p_object_version_number '||
731: to_char(p_object_version_number));
732: hr_utility.trace(' --------------------------------'||

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

726: hr_utility.trace(' IN OUT / OUT PARAMETER '||
727: ' VALUE');
728: hr_utility.trace(' --------------------------------'||
729: '+--------------------------------');
730: hr_utility.trace(' p_object_version_number '||
731: to_char(p_object_version_number));
732: hr_utility.trace(' --------------------------------'||
733: '---------------------------------');
734: hr_utility.trace(' ');

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

728: hr_utility.trace(' --------------------------------'||
729: '+--------------------------------');
730: hr_utility.trace(' p_object_version_number '||
731: to_char(p_object_version_number));
732: hr_utility.trace(' --------------------------------'||
733: '---------------------------------');
734: hr_utility.trace(' ');
735: hr_utility.set_location(' Leaving:'||l_proc, 970);
736:

Line 734: hr_utility.trace(' ');

730: hr_utility.trace(' p_object_version_number '||
731: to_char(p_object_version_number));
732: hr_utility.trace(' --------------------------------'||
733: '---------------------------------');
734: hr_utility.trace(' ');
735: hr_utility.set_location(' Leaving:'||l_proc, 970);
736:
737: END IF;
738:

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

731: to_char(p_object_version_number));
732: hr_utility.trace(' --------------------------------'||
733: '---------------------------------');
734: hr_utility.trace(' ');
735: hr_utility.set_location(' Leaving:'||l_proc, 970);
736:
737: END IF;
738:
739: exception

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

748: -- (Any key or derived arguments must be set to null
749: -- when validation only mode is being used.)
750: --
751: p_object_version_number := null;
752: hr_utility.set_location(' Leaving:'||l_proc, 980);
753: when others then
754: --
755: -- A validation or unexpected error has occured
756: --

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

759: -- Reset IN OUT parameters and set all
760: -- OUT parameters, including warnings, to null
761: --
762: p_object_version_number := null;
763: hr_utility.set_location(' Leaving:'||l_proc, 990);
764: raise;
765: end update_appraisal_period;
766: --
767: -- ----------------------------------------------------------------------------

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

781: begin
782:
783: IF g_debug THEN
784:
785: hr_utility.set_location('Entering:'|| l_proc, 10);
786:
787: hr_utility.trace(' ');
788: hr_utility.trace(' --------------------------------'||
789: '---------------------------------');

Line 787: hr_utility.trace(' ');

783: IF g_debug THEN
784:
785: hr_utility.set_location('Entering:'|| l_proc, 10);
786:
787: hr_utility.trace(' ');
788: hr_utility.trace(' --------------------------------'||
789: '---------------------------------');
790: hr_utility.trace(' IN / IN OUT PARAMETER '||
791: ' VALUE');

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

784:
785: hr_utility.set_location('Entering:'|| l_proc, 10);
786:
787: hr_utility.trace(' ');
788: hr_utility.trace(' --------------------------------'||
789: '---------------------------------');
790: hr_utility.trace(' IN / IN OUT PARAMETER '||
791: ' VALUE');
792: hr_utility.trace(' --------------------------------'||

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

786:
787: hr_utility.trace(' ');
788: hr_utility.trace(' --------------------------------'||
789: '---------------------------------');
790: hr_utility.trace(' IN / IN OUT PARAMETER '||
791: ' VALUE');
792: hr_utility.trace(' --------------------------------'||
793: '+--------------------------------');
794: hr_utility.trace(' p_appraisal_period_id '||

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

788: hr_utility.trace(' --------------------------------'||
789: '---------------------------------');
790: hr_utility.trace(' IN / IN OUT PARAMETER '||
791: ' VALUE');
792: hr_utility.trace(' --------------------------------'||
793: '+--------------------------------');
794: hr_utility.trace(' p_appraisal_period_id '||
795: to_char(p_appraisal_period_id));
796: hr_utility.trace(' p_object_version_number '||

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

790: hr_utility.trace(' IN / IN OUT PARAMETER '||
791: ' VALUE');
792: hr_utility.trace(' --------------------------------'||
793: '+--------------------------------');
794: hr_utility.trace(' p_appraisal_period_id '||
795: to_char(p_appraisal_period_id));
796: hr_utility.trace(' p_object_version_number '||
797: to_char(p_object_version_number));
798: hr_utility.trace(' --------------------------------'||

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

792: hr_utility.trace(' --------------------------------'||
793: '+--------------------------------');
794: hr_utility.trace(' p_appraisal_period_id '||
795: to_char(p_appraisal_period_id));
796: hr_utility.trace(' p_object_version_number '||
797: to_char(p_object_version_number));
798: hr_utility.trace(' --------------------------------'||
799: '---------------------------------');
800: hr_utility.trace(' ');

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

794: hr_utility.trace(' p_appraisal_period_id '||
795: to_char(p_appraisal_period_id));
796: hr_utility.trace(' p_object_version_number '||
797: to_char(p_object_version_number));
798: hr_utility.trace(' --------------------------------'||
799: '---------------------------------');
800: hr_utility.trace(' ');
801:
802: END IF;

Line 800: hr_utility.trace(' ');

796: hr_utility.trace(' p_object_version_number '||
797: to_char(p_object_version_number));
798: hr_utility.trace(' --------------------------------'||
799: '---------------------------------');
800: hr_utility.trace(' ');
801:
802: END IF;
803:
804: --

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

824:
825: --
826: -- Process Logic
827: --
828: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
829:
830: per_pma_del.del
831: (p_appraisal_period_id => p_appraisal_period_id
832: ,p_object_version_number => p_object_version_number

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

847: ,p_hook_type => 'AP'
848: );
849: end;
850:
851: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
852: --
853: -- When in validation only mode raise the Validate_Enabled exception
854: --
855: if p_validate then

Line 864: hr_utility.trace(' ');

860: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
861: --
862: IF g_debug THEN
863:
864: hr_utility.trace(' ');
865: hr_utility.trace(' --------------------------------'||
866: '---------------------------------');
867: hr_utility.trace(' IN OUT / OUT PARAMETER '||
868: ' VALUE');

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

861: --
862: IF g_debug THEN
863:
864: hr_utility.trace(' ');
865: hr_utility.trace(' --------------------------------'||
866: '---------------------------------');
867: hr_utility.trace(' IN OUT / OUT PARAMETER '||
868: ' VALUE');
869: hr_utility.trace(' --------------------------------'||

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

863:
864: hr_utility.trace(' ');
865: hr_utility.trace(' --------------------------------'||
866: '---------------------------------');
867: hr_utility.trace(' IN OUT / OUT PARAMETER '||
868: ' VALUE');
869: hr_utility.trace(' --------------------------------'||
870: '+--------------------------------');
871: hr_utility.trace(' ');

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

865: hr_utility.trace(' --------------------------------'||
866: '---------------------------------');
867: hr_utility.trace(' IN OUT / OUT PARAMETER '||
868: ' VALUE');
869: hr_utility.trace(' --------------------------------'||
870: '+--------------------------------');
871: hr_utility.trace(' ');
872: hr_utility.set_location(' Leaving:'||l_proc, 970);
873:

Line 871: hr_utility.trace(' ');

867: hr_utility.trace(' IN OUT / OUT PARAMETER '||
868: ' VALUE');
869: hr_utility.trace(' --------------------------------'||
870: '+--------------------------------');
871: hr_utility.trace(' ');
872: hr_utility.set_location(' Leaving:'||l_proc, 970);
873:
874: END IF;
875:

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

868: ' VALUE');
869: hr_utility.trace(' --------------------------------'||
870: '+--------------------------------');
871: hr_utility.trace(' ');
872: hr_utility.set_location(' Leaving:'||l_proc, 970);
873:
874: END IF;
875:
876: exception

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

879: -- As the Validate_Enabled exception has been raised
880: -- we must rollback to the savepoint
881: --
882: rollback to delete_appraisal_period;
883: hr_utility.set_location(' Leaving:'||l_proc, 980);
884: when others then
885: --
886: -- A validation or unexpected error has occured
887: --

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

885: --
886: -- A validation or unexpected error has occured
887: --
888: rollback to delete_appraisal_period;
889: hr_utility.set_location(' Leaving:'||l_proc, 990);
890: raise;
891: end delete_appraisal_period;
892: --
893: end hr_appraisal_period_api;