[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;
475:
476: --
477: begin
478: --
479: hr_utility.set_location('Entering:'|| l_proc, 10);
480: --
481: lv_object_version_number := p_object_version_number;
482:
483: --
484: -- Issue a savepoint
485: --
486: savepoint update_progression_point;
487:
488: hr_utility.set_location(l_proc, 20);
489:
490: --
491: -- Truncate the time portion from all IN date parameters
492: --
550: -- End of before hook process (update_progression_point)
551: --
552: end;
553:
554: hr_utility.set_location(l_proc, 30);
555: --
556: -- Process Logic
557: --
558:
620: -- Assign the out parameters.
621: --
622: p_object_version_number := l_object_version_number;
623:
624: hr_utility.set_location(l_proc, 40);
625:
626: --
627: --
628: -- Call After Process hook for create_grade
690: then
691: raise hr_api.validate_enabled;
692: end if;
693: --
694: hr_utility.set_location(l_proc, 50);
695: --
696: -- Set OUT parameters
697: --
698: p_object_version_number := l_object_version_number;
696: -- Set OUT parameters
697: --
698: p_object_version_number := l_object_version_number;
699: --
700: hr_utility.set_location(' Leaving:' ||l_proc, 60);
701: --
702: exception
703: --
704: when hr_api.validate_enabled then
714: -- when validation only mode is being used.)
715: --
716: p_object_version_number := p_object_version_number;
717: --
718: hr_utility.set_location(' Leaving:'||l_proc, 70);
719: --
720: when others then
721: --
722: -- A validation or unexpected error has occurred
726: rollback to update_progression_point;
727: --
728: p_object_version_number := lv_object_version_number;
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 80);
731: --
732: raise;
733: --
734: end update_progression_point;
785:
786: -- End changes for bug 9328526
787:
788: begin
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790:
791: --
792: -- Issue a savepoint
793: --
809: ,p_hook_type => 'BP'
810: );
811: end;
812:
813: hr_utility.set_location(l_proc, 20);
814:
815: --
816: -- Process Logic
817: --
825: else
826: close c_get_ps_id;
827: end if;
828:
829: hr_utility.set_location(l_proc, 25);
830:
831: if nvl(p_called_from,'API') <> 'GSPW' then
832: pqh_gsp_utility.chk_ps_for_upd_del
833: (p_parent_spine_id => l_parent_spine_id
834: ,p_entity => 'PROGRESSION_POINT'
835: );
836: end if;
837:
838: hr_utility.set_location(l_proc, 26);
839:
840: -- End changes for bug 9328526
841:
842: per_psp_del.del
842: per_psp_del.del
843: (p_spinal_point_id => p_spinal_point_id
844: ,p_object_version_number => p_object_version_number);
845:
846: hr_utility.set_location(l_proc, 30);
847:
848: --
849: -- Call After Process User Hook
850: --
860: ,p_hook_type => 'AP'
861: );
862: end;
863:
864: hr_utility.set_location(l_proc, 40);
865:
866: --
867: -- When in validation only mode raise the Validate_Enabled exception
868: --
869: if p_validate then
870: raise hr_api.validate_enabled;
871: end if;
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception
875: when hr_api.validate_enabled then
876: hr_utility.set_location(' Leaving...:'||l_proc, 50);
877: --
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception
875: when hr_api.validate_enabled then
876: hr_utility.set_location(' Leaving...:'||l_proc, 50);
877: --
878: -- As the Validate_Enabled exception has been raised
879: -- we must rollback to the savepoint
880: --
884: -- (Any key or derived arguments must be set to null
885: -- when validation only mode is being used.)
886: --
887: when others then
888: hr_utility.set_location(' Leaving...:'||l_proc, 60);
889: --
890: -- A validation or unexpected error has occured
891: --
892: rollback to delete_progression_point;