DBA Data[Home] [Help]

APPS.BEN_ELIG_SCHEDD_HRS_PRTE_API dependencies on HR_UTILITY

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

72: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_ELIG_SCHEDD_HRS_PRTE;

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

78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_ELIG_SCHEDD_HRS_PRTE;
81: --
82: hr_utility.set_location(l_proc, 20);
83: --
84: -- Process Logic
85: --
86: begin

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

278: p_base_table_reference_column => 'ELIG_SCHEDD_HRS_FLAG',
279: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
280: p_reference_table_column => 'ELIGY_PRFL_ID');
281: --
282: hr_utility.set_location(l_proc, 60);
283: --
284: -- When in validation only mode raise the Validate_Enabled exception
285: --
286: if p_validate then

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

293: p_effective_start_date := l_effective_start_date;
294: p_effective_end_date := l_effective_end_date;
295: p_object_version_number := l_object_version_number;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 70);
298: --
299: exception
300: --
301: when hr_api.validate_enabled then

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

312: p_elig_schedd_hrs_prte_id := null;
313: p_effective_start_date := null;
314: p_effective_end_date := null;
315: p_object_version_number := null;
316: hr_utility.set_location(' Leaving:'||l_proc, 80);
317: --
318: when others then
319: --
320: -- A validation or unexpected error has occured

Line 327: hr_utility.set_location(' Leaving:'||l_proc, 90);

323: p_elig_schedd_hrs_prte_id := null;
324: p_effective_start_date := null;
325: p_effective_end_date := null;
326: p_object_version_number := null;
327: hr_utility.set_location(' Leaving:'||l_proc, 90);
328: raise;
329: --
330: end create_ELIG_SCHEDD_HRS_PRTE;
331: -- ----------------------------------------------------------------------------

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

395: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
396: --
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);
400: --
401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint update_ELIG_SCHEDD_HRS_PRTE;

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

401: -- Issue a savepoint if operating in validation only mode
402: --
403: savepoint update_ELIG_SCHEDD_HRS_PRTE;
404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: -- Process Logic
408: --
409: l_object_version_number := p_object_version_number;

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

598: -- End of API User Hook for the after hook of update_ELIG_SCHEDD_HRS_PRTE
599: --
600: end;
601: --
602: hr_utility.set_location(l_proc, 60);
603: --
604: -- When in validation only mode raise the Validate_Enabled exception
605: --
606: if p_validate then

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

612: p_object_version_number := l_object_version_number;
613: p_effective_start_date := l_effective_start_date;
614: p_effective_end_date := l_effective_end_date;
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: --
618: exception
619: --
620: when hr_api.validate_enabled then

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

627: -- Only set output warning arguments
628: -- (Any key or derived arguments must be set to null
629: -- when validation only mode is being used.)
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 80);
632: --
633: when others then
634: --
635: -- A validation or unexpected error has occured

Line 640: hr_utility.set_location(' Leaving:'||l_proc, 90);

636: --
637: ROLLBACK TO update_ELIG_SCHEDD_HRS_PRTE;
638: p_effective_start_date := null;
639: p_effective_end_date := null;
640: hr_utility.set_location(' Leaving:'||l_proc, 90);
641: raise;
642: --
643: end update_ELIG_SCHEDD_HRS_PRTE;
644: -- ----------------------------------------------------------------------------

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

663: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Issue a savepoint if operating in validation only mode
670: --
671: savepoint delete_ELIG_SCHEDD_HRS_PRTE;

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

669: -- Issue a savepoint if operating in validation only mode
670: --
671: savepoint delete_ELIG_SCHEDD_HRS_PRTE;
672: --
673: hr_utility.set_location(l_proc, 20);
674: --
675: -- Process Logic
676: --
677: l_object_version_number := p_object_version_number;

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

741: p_base_table_reference_column => 'ELIG_SCHEDD_HRS_FLAG',
742: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
743: p_reference_table_column => 'ELIGY_PRFL_ID');
744: --
745: hr_utility.set_location(l_proc, 60);
746: --
747: -- When in validation only mode raise the Validate_Enabled exception
748: --
749: if p_validate then

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

749: if p_validate then
750: raise hr_api.validate_enabled;
751: end if;
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 70);
754: --
755: exception
756: --
757: when hr_api.validate_enabled then

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

801: l_validation_end_date date;
802: --
803: begin
804: --
805: hr_utility.set_location('Entering:'|| l_proc, 10);
806: --
807: ben_esh_shd.lck
808: (
809: p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id

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

813: ,p_effective_date => p_effective_date
814: ,p_datetrack_mode => p_datetrack_mode
815: );
816: --
817: hr_utility.set_location(' Leaving:'||l_proc, 70);
818: --
819: end lck;
820: --
821: end ben_ELIG_SCHEDD_HRS_PRTE_api;