DBA Data[Home] [Help]

APPS.BEN_ELIG_HLTH_CVG_PRTE_API dependencies on HR_UTILITY

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

64: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Issue a savepoint if operating in validation only mode
71: --
72: savepoint create_ELIG_HLTH_CVG_PRTE;

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

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

Line 135: hr_utility.set_location(l_proc, 30);

131: -- End of API User Hook for the before hook of create_ELIG_HLTH_CVG_PRTE
132: --
133: end;
134: --
135: hr_utility.set_location(l_proc, 30);
136: ben_ehc_ins.ins
137: (
138: p_ELIG_HLTH_CVG_PRTE_id => l_ELIG_HLTH_CVG_PRTE_id
139: ,p_effective_start_date => l_effective_start_date

Line 182: hr_utility.set_location(l_proc, 40);

178: ,p_object_version_number => l_object_version_number
179: ,p_effective_date => trunc(p_effective_date)
180: );
181: --
182: hr_utility.set_location(l_proc, 40);
183: begin
184: --
185: -- Start of API User Hook for the after hook of create_ELIG_HLTH_CVG_PRTE
186: --

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

238: --
239: -- End of API User Hook for the after hook of create_ELIG_HLTH_CVG_PRTE
240: --
241: end;
242: hr_utility.set_location(l_proc, 50);
243: --
244: ben_profile_handler.event_handler
245: (p_event => 'CREATE',
246: p_base_table => 'BEN_ELIGY_PRFL_F',

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

249: p_base_table_reference_column => 'ELIG_HLTH_CVG_FLAG',
250: p_reference_table => 'BEN_ELIG_HLTH_CVG_PRTE_F',
251: p_reference_table_column => 'ELIGY_PRFL_ID');
252: --
253: hr_utility.set_location(l_proc, 60);
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
257: if p_validate then

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

264: p_effective_start_date := l_effective_start_date;
265: p_effective_end_date := l_effective_end_date;
266: p_object_version_number := l_object_version_number;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 70);
269: --
270: exception
271: --
272: when hr_api.validate_enabled then

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

283: p_ELIG_HLTH_CVG_PRTE_id := null;
284: p_effective_start_date := null;
285: p_effective_end_date := null;
286: p_object_version_number := null;
287: hr_utility.set_location(' Leaving:'||l_proc, 80);
288: --
289: when others then
290: --
291: -- A validation or unexpected error has occured

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

358: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);
363: --
364: -- Issue a savepoint if operating in validation only mode
365: --
366: savepoint update_ELIG_HLTH_CVG_PRTE;

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

364: -- Issue a savepoint if operating in validation only mode
365: --
366: savepoint update_ELIG_HLTH_CVG_PRTE;
367: --
368: hr_utility.set_location(l_proc, 20);
369: --
370: -- Process Logic
371: --
372: l_object_version_number := p_object_version_number;

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

537: -- End of API User Hook for the after hook of update_ELIG_HLTH_CVG_PRTE
538: --
539: end;
540: --
541: hr_utility.set_location(l_proc, 60);
542: --
543: -- When in validation only mode raise the Validate_Enabled exception
544: --
545: if p_validate then

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

551: p_object_version_number := l_object_version_number;
552: p_effective_start_date := l_effective_start_date;
553: p_effective_end_date := l_effective_end_date;
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 70);
556: --
557: exception
558: --
559: when hr_api.validate_enabled then

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

566: -- Only set output warning arguments
567: -- (Any key or derived arguments must be set to null
568: -- when validation only mode is being used.)
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 80);
571: --
572: when others then
573: --
574: -- A validation or unexpected error has occured

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

603: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'|| l_proc, 10);
608: --
609: -- Issue a savepoint if operating in validation only mode
610: --
611: savepoint delete_ELIG_HLTH_CVG_PRTE;

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

609: -- Issue a savepoint if operating in validation only mode
610: --
611: savepoint delete_ELIG_HLTH_CVG_PRTE;
612: --
613: hr_utility.set_location(l_proc, 20);
614: --
615: -- Process Logic
616: --
617: l_object_version_number := p_object_version_number;

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

681: p_base_table_reference_column => 'ELIG_HLTH_CVG_FLAG',
682: p_reference_table => 'BEN_ELIG_HLTH_CVG_PRTE_F',
683: p_reference_table_column => 'ELIGY_PRFL_ID');
684: --
685: hr_utility.set_location(l_proc, 60);
686: --
687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: if p_validate then

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

689: if p_validate then
690: raise hr_api.validate_enabled;
691: end if;
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 70);
694: --
695: exception
696: --
697: when hr_api.validate_enabled then

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

743: l_validation_end_date date;
744: --
745: begin
746: --
747: hr_utility.set_location('Entering:'|| l_proc, 10);
748: --
749: ben_ehc_shd.lck
750: (
751: p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_PRTE_id

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

755: ,p_effective_date => p_effective_date
756: ,p_datetrack_mode => p_datetrack_mode
757: );
758: --
759: hr_utility.set_location(' Leaving:'||l_proc, 70);
760: --
761: end lck;
762: --
763: end ben_ELIG_HLTH_CVG_PRTE_api;