DBA Data[Home] [Help]

APPS.BEN_ELIG_SP_CLNG_PRG_PRTE_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

296: p_elig_sp_clng_prg_prte_id := null;
297: p_effective_start_date := null;
298: p_effective_end_date := null;
299: p_object_version_number := null;
300: hr_utility.set_location(' Leaving:'||l_proc, 80);
301: --
302: raise;
303: --
304: end create_elig_sp_clng_prg_prte;

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

362: l_effective_end_date ben_elig_sp_clng_prg_prte_f.effective_end_date%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);
367: --
368: -- Issue a savepoint if operating in validation only mode
369: --
370: savepoint update_elig_sp_clng_prg_prte;

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

368: -- Issue a savepoint if operating in validation only mode
369: --
370: savepoint update_elig_sp_clng_prg_prte;
371: --
372: hr_utility.set_location(l_proc, 20);
373: --
374: -- Process Logic
375: --
376: l_object_version_number := p_object_version_number;

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

544: -- End of API User Hook for the after hook of update_elig_sp_clng_prg_prte
545: --
546: end;
547: --
548: hr_utility.set_location(l_proc, 60);
549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then

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

558: p_object_version_number := l_object_version_number;
559: p_effective_start_date := l_effective_start_date;
560: p_effective_end_date := l_effective_end_date;
561: --
562: hr_utility.set_location(' Leaving:'||l_proc, 70);
563: --
564: exception
565: --
566: when hr_api.validate_enabled then

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

573: -- Only set output warning arguments
574: -- (Any key or derived arguments must be set to null
575: -- when validation only mode is being used.)
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 80);
578: --
579: when others then
580: --
581: -- A validation or unexpected error has occured

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

584: --
585: p_effective_start_date := null;
586: p_effective_end_date := null;
587: p_object_version_number := l_object_version_number;
588: hr_utility.set_location(' Leaving:'||l_proc, 80);
589: --
590: raise;
591: --
592: end update_elig_sp_clng_prg_prte;

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

612: l_effective_end_date ben_elig_sp_clng_prg_prte_f.effective_end_date%TYPE;
613: --
614: begin
615: --
616: hr_utility.set_location('Entering:'|| l_proc, 10);
617: --
618: -- Issue a savepoint if operating in validation only mode
619: --
620: savepoint delete_elig_sp_clng_prg_prte;

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

618: -- Issue a savepoint if operating in validation only mode
619: --
620: savepoint delete_elig_sp_clng_prg_prte;
621: --
622: hr_utility.set_location(l_proc, 20);
623: --
624: -- Process Logic
625: --
626: l_object_version_number := p_object_version_number;

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

690: p_base_table_reference_column => 'ELIG_SP_CLNG_PRG_PT_FLAG',
691: p_reference_table => 'BEN_ELIG_SP_CLNG_PRG_PRTE_F',
692: p_reference_table_column => 'ELIGY_PRFL_ID');
693: --
694: hr_utility.set_location(l_proc, 60);
695: --
696: -- When in validation only mode raise the Validate_Enabled exception
697: --
698: if p_validate then

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

698: if p_validate then
699: raise hr_api.validate_enabled;
700: end if;
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 70);
703: --
704: exception
705: --
706: when hr_api.validate_enabled then

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

725: --
726: p_effective_start_date := null;
727: p_effective_end_date := null;
728: p_object_version_number := l_object_version_number;
729: hr_utility.set_location(' Leaving:'||l_proc, 80);
730: --
731: raise;
732: --
733: end delete_elig_sp_clng_prg_prte;

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

754: l_validation_end_date date;
755: --
756: begin
757: --
758: hr_utility.set_location('Entering:'|| l_proc, 10);
759: --
760: ben_esp_shd.lck
761: (
762: p_elig_sp_clng_prg_prte_id => p_elig_sp_clng_prg_prte_id

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

766: ,p_effective_date => p_effective_date
767: ,p_datetrack_mode => p_datetrack_mode
768: );
769: --
770: hr_utility.set_location(' Leaving:'||l_proc, 70);
771: --
772: end lck;
773: --
774: end ben_elig_sp_clng_prg_prte_api;