DBA Data[Home] [Help]

APPS.BEN_ELIG_OPTD_MDCR_PRTE_API dependencies on HR_UTILITY

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

62: l_object_version_number ben_elig_optd_mdcr_prte_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_ELIG_OPTD_MDCR_PRTE;

Line 72: hr_utility.set_location(l_proc, 20);

68: -- Issue a savepoint if operating in validation only mode
69: --
70: savepoint create_ELIG_OPTD_MDCR_PRTE;
71: --
72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Process Logic
75: --
76: begin

Line 242: hr_utility.set_location(l_proc, 60);

238: p_base_table_reference_column => 'ELIG_OPTD_MDCR_FLAG',
239: p_reference_table => 'BEN_ELIG_OPTD_MDCR_PRTE_F',
240: p_reference_table_column => 'ELIGY_PRFL_ID');
241: --
242: hr_utility.set_location(l_proc, 60);
243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: if p_validate then

Line 257: hr_utility.set_location(' Leaving:'||l_proc, 70);

253: p_effective_start_date := l_effective_start_date;
254: p_effective_end_date := l_effective_end_date;
255: p_object_version_number := l_object_version_number;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: --
259: exception
260: --
261: when hr_api.validate_enabled then

Line 276: hr_utility.set_location(' Leaving:'||l_proc, 80);

272: p_elig_optd_mdcr_prte_id := null;
273: p_effective_start_date := null;
274: p_effective_end_date := null;
275: p_object_version_number := null;
276: hr_utility.set_location(' Leaving:'||l_proc, 80);
277: --
278: when others then
279: --
280: -- A validation or unexpected error has occured

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

344: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
345: --
346: begin
347: --
348: hr_utility.set_location('Entering:'|| l_proc, 10);
349: --
350: -- Issue a savepoint if operating in validation only mode
351: --
352: savepoint update_ELIG_OPTD_MDCR_PRTE;

Line 354: hr_utility.set_location(l_proc, 20);

350: -- Issue a savepoint if operating in validation only mode
351: --
352: savepoint update_ELIG_OPTD_MDCR_PRTE;
353: --
354: hr_utility.set_location(l_proc, 20);
355: --
356: -- Process Logic
357: --
358: l_object_version_number := p_object_version_number;

Line 521: hr_utility.set_location(l_proc, 60);

517: -- End of API User Hook for the after hook of update_ELIG_OPTD_MDCR_PRTE
518: --
519: end;
520: --
521: hr_utility.set_location(l_proc, 60);
522: --
523: -- When in validation only mode raise the Validate_Enabled exception
524: --
525: if p_validate then

Line 535: hr_utility.set_location(' Leaving:'||l_proc, 70);

531: p_object_version_number := l_object_version_number;
532: p_effective_start_date := l_effective_start_date;
533: p_effective_end_date := l_effective_end_date;
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 70);
536: --
537: exception
538: --
539: when hr_api.validate_enabled then

Line 552: hr_utility.set_location(' Leaving:'||l_proc, 80);

548: -- when validation only mode is being used.)
549: --
550: p_effective_start_date := null;
551: p_effective_end_date := null;
552: hr_utility.set_location(' Leaving:'||l_proc, 80);
553: --
554: when others then
555: --
556: -- A validation or unexpected error has occured

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

583: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
584: --
585: begin
586: --
587: hr_utility.set_location('Entering:'|| l_proc, 10);
588: --
589: -- Issue a savepoint if operating in validation only mode
590: --
591: savepoint delete_ELIG_OPTD_MDCR_PRTE;

Line 593: hr_utility.set_location(l_proc, 20);

589: -- Issue a savepoint if operating in validation only mode
590: --
591: savepoint delete_ELIG_OPTD_MDCR_PRTE;
592: --
593: hr_utility.set_location(l_proc, 20);
594: --
595: -- Process Logic
596: --
597: l_object_version_number := p_object_version_number;

Line 665: hr_utility.set_location(l_proc, 60);

661: p_base_table_reference_column => 'ELIG_OPTD_MDCR_FLAG',
662: p_reference_table => 'BEN_ELIG_OPTD_MDCR_PRTE_F',
663: p_reference_table_column => 'ELIGY_PRFL_ID');
664: --
665: hr_utility.set_location(l_proc, 60);
666: --
667: -- When in validation only mode raise the Validate_Enabled exception
668: --
669: if p_validate then

Line 673: hr_utility.set_location(' Leaving:'||l_proc, 70);

669: if p_validate then
670: raise hr_api.validate_enabled;
671: end if;
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 70);
674: --
675: exception
676: --
677: when hr_api.validate_enabled then

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

721: l_validation_end_date date;
722: --
723: begin
724: --
725: hr_utility.set_location('Entering:'|| l_proc, 10);
726: --
727: ben_eom_shd.lck
728: (
729: p_elig_optd_mdcr_prte_id => p_elig_optd_mdcr_prte_id

Line 737: hr_utility.set_location(' Leaving:'||l_proc, 70);

733: ,p_effective_date => p_effective_date
734: ,p_datetrack_mode => p_datetrack_mode
735: );
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 70);
738: --
739: end lck;
740: --
741: end ben_ELIG_OPTD_MDCR_PRTE_api;