[Home] [Help]
69:
70: --
71: begin
72: --
73: hr_utility.set_location('Entering:'|| l_proc, 10);
74: --
75: -- Issue a savepoint
76: --
77: savepoint create_progression_point;
75: -- Issue a savepoint
76: --
77: savepoint create_progression_point;
78:
79: hr_utility.set_location(l_proc, 20);
80:
81: --
82: -- Truncate the time portion from all IN date parameters
83: --
139: -- End of before hook process (create_progression_point)
140: --
141: end;
142:
143: hr_utility.set_location(l_proc, 30);
144: --
145: -- Process Logic
146: --
147:
193: ,p_information29 => p_information29
194: ,p_information30 => p_information30
195: );
196:
197: hr_utility.set_location(l_proc, 40);
198:
199: --
200: --
201: -- Call After Process hook for create_progression_point
263: then
264: raise hr_api.validate_enabled;
265: end if;
266: --
267: hr_utility.set_location(l_proc, 50);
268: --
269: -- Set OUT parameters
270: --
271: p_spinal_point_id := l_spinal_point_id;
270: --
271: p_spinal_point_id := l_spinal_point_id;
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:' ||l_proc, 60);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
289: --
290: p_spinal_point_id := null;
291: p_object_version_number := null;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 70);
294: --
295: when others then
296: --
297: -- A validation or unexpected error has occurred
299: --
300: --
301: ROLLBACK TO create_progression_point;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 80);
304: --
305: raise;
306: --
307: end create_progression_point;
370:
371: --
372: begin
373: --
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: --
376: lv_object_version_number := p_object_version_number;
377:
378: --
379: -- Issue a savepoint
380: --
381: savepoint update_progression_point;
382:
383: hr_utility.set_location(l_proc, 20);
384:
385: --
386: -- Truncate the time portion from all IN date parameters
387: --
445: -- End of before hook process (update_progression_point)
446: --
447: end;
448:
449: hr_utility.set_location(l_proc, 30);
450: --
451: -- Process Logic
452: --
453:
506: -- Assign the out parameters.
507: --
508: p_object_version_number := l_object_version_number;
509:
510: hr_utility.set_location(l_proc, 40);
511:
512: --
513: --
514: -- Call After Process hook for create_grade
576: then
577: raise hr_api.validate_enabled;
578: end if;
579: --
580: hr_utility.set_location(l_proc, 50);
581: --
582: -- Set OUT parameters
583: --
584: p_object_version_number := l_object_version_number;
582: -- Set OUT parameters
583: --
584: p_object_version_number := l_object_version_number;
585: --
586: hr_utility.set_location(' Leaving:' ||l_proc, 60);
587: --
588: exception
589: --
590: when hr_api.validate_enabled then
600: -- when validation only mode is being used.)
601: --
602: p_object_version_number := p_object_version_number;
603: --
604: hr_utility.set_location(' Leaving:'||l_proc, 70);
605: --
606: when others then
607: --
608: -- A validation or unexpected error has occurred
612: rollback to update_progression_point;
613: --
614: p_object_version_number := lv_object_version_number;
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 80);
617: --
618: raise;
619: --
620: end update_progression_point;
636: --
637: l_proc varchar2(72) := g_package||'delete_progression_point';
638:
639: begin
640: hr_utility.set_location('Entering:'|| l_proc, 10);
641:
642: --
643: -- Issue a savepoint
644: --
660: ,p_hook_type => 'BP'
661: );
662: end;
663:
664: hr_utility.set_location(l_proc, 20);
665:
666: --
667: -- Process Logic
668: --
670: per_psp_del.del
671: (p_spinal_point_id => p_spinal_point_id
672: ,p_object_version_number => p_object_version_number);
673:
674: hr_utility.set_location(l_proc, 30);
675:
676: --
677: -- Call After Process User Hook
678: --
688: ,p_hook_type => 'AP'
689: );
690: end;
691:
692: hr_utility.set_location(l_proc, 40);
693:
694: --
695: -- When in validation only mode raise the Validate_Enabled exception
696: --
697: if p_validate then
698: raise hr_api.validate_enabled;
699: end if;
700:
701: hr_utility.set_location(' Leaving:'||l_proc, 100);
702: exception
703: when hr_api.validate_enabled then
704: hr_utility.set_location(' Leaving...:'||l_proc, 50);
705: --
700:
701: hr_utility.set_location(' Leaving:'||l_proc, 100);
702: exception
703: when hr_api.validate_enabled then
704: hr_utility.set_location(' Leaving...:'||l_proc, 50);
705: --
706: -- As the Validate_Enabled exception has been raised
707: -- we must rollback to the savepoint
708: --
712: -- (Any key or derived arguments must be set to null
713: -- when validation only mode is being used.)
714: --
715: when others then
716: hr_utility.set_location(' Leaving...:'||l_proc, 60);
717: --
718: -- A validation or unexpected error has occured
719: --
720: rollback to delete_progression_point;