[Home] [Help]
62: l_object_version_number ben_regn_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint if operating in validation only mode
69: --
70: savepoint create_Regulations;
68: -- Issue a savepoint if operating in validation only mode
69: --
70: savepoint create_Regulations;
71: --
72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Process Logic
75: --
76: begin
229: -- End of API User Hook for the after hook of create_Regulations
230: --
231: end;
232: --
233: hr_utility.set_location(l_proc, 60);
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
244: p_effective_start_date := l_effective_start_date;
245: p_effective_end_date := l_effective_end_date;
246: p_object_version_number := l_object_version_number;
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 70);
249: --
250: exception
251: --
252: when hr_api.validate_enabled then
263: p_regn_id := null;
264: p_effective_start_date := null;
265: p_effective_end_date := null;
266: p_object_version_number := null;
267: hr_utility.set_location(' Leaving:'||l_proc, 80);
268: --
269: when others then
270: --
271: -- A validation or unexpected error has occured
335: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
336: --
337: begin
338: --
339: hr_utility.set_location('Entering:'|| l_proc, 10);
340: --
341: -- Issue a savepoint if operating in validation only mode
342: --
343: savepoint update_Regulations;
341: -- Issue a savepoint if operating in validation only mode
342: --
343: savepoint update_Regulations;
344: --
345: hr_utility.set_location(l_proc, 20);
346: --
347: -- Process Logic
348: --
349: l_object_version_number := p_object_version_number;
508: -- End of API User Hook for the after hook of update_Regulations
509: --
510: end;
511: --
512: hr_utility.set_location(l_proc, 60);
513: --
514: -- When in validation only mode raise the Validate_Enabled exception
515: --
516: if p_validate then
522: p_object_version_number := l_object_version_number;
523: p_effective_start_date := l_effective_start_date;
524: p_effective_end_date := l_effective_end_date;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 70);
527: --
528: exception
529: --
530: when hr_api.validate_enabled then
539: -- when validation only mode is being used.)
540: --
541: p_effective_start_date := null;
542: p_effective_end_date := null;
543: hr_utility.set_location(' Leaving:'||l_proc, 80);
544: --
545: when others then
546: --
547: -- A validation or unexpected error has occured
574: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
575: --
576: begin
577: --
578: hr_utility.set_location('Entering:'|| l_proc, 10);
579: --
580: -- Issue a savepoint if operating in validation only mode
581: --
582: savepoint delete_Regulations;
580: -- Issue a savepoint if operating in validation only mode
581: --
582: savepoint delete_Regulations;
583: --
584: hr_utility.set_location(l_proc, 20);
585: --
586: -- Process Logic
587: --
588: l_object_version_number := p_object_version_number;
643: -- End of API User Hook for the after hook of delete_Regulations
644: --
645: end;
646: --
647: hr_utility.set_location(l_proc, 60);
648: --
649: -- When in validation only mode raise the Validate_Enabled exception
650: --
651: if p_validate then
651: if p_validate then
652: raise hr_api.validate_enabled;
653: end if;
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 70);
656: --
657: exception
658: --
659: when hr_api.validate_enabled then
703: l_validation_end_date date;
704: --
705: begin
706: --
707: hr_utility.set_location('Entering:'|| l_proc, 10);
708: --
709: ben_reg_shd.lck
710: (
711: p_regn_id => p_regn_id
715: ,p_effective_date => p_effective_date
716: ,p_datetrack_mode => p_datetrack_mode
717: );
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 70);
720: --
721: end lck;
722: --
723: end ben_Regulations_api;