eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VRBL_RT_ELIG_PRFL_API dependencies on HR_UTILITY

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

84: l_future_record_end_date date;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- Issue a savepoint if operating in validation only mode
91: --
92: savepoint create_vrbl_rt_elig_prfl;

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

90: -- Issue a savepoint if operating in validation only mode
91: --
92: savepoint create_vrbl_rt_elig_prfl;
93: --
94: hr_utility.set_location(l_proc, 20);
95: --
96: -- Process Logic
97: --
98: --

Line 106: hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;

102: --
103: if c_uniq_vrbl_rt_elig_prfl%found then
104: --
105: close c_uniq_vrbl_rt_elig_prfl ;
106: hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;
107: hr_utility.set_location('exiting from '||l_proc,25);
108: -- Bug : 3621420
109: -- Raise an error as the ELPRO being inserted is already associated with the VAPRO
110: fnd_message.set_name('BEN','BEN_93966_ELPRO_FOR_VAPRO_EXST');

Line 107: hr_utility.set_location('exiting from '||l_proc,25);

103: if c_uniq_vrbl_rt_elig_prfl%found then
104: --
105: close c_uniq_vrbl_rt_elig_prfl ;
106: hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;
107: hr_utility.set_location('exiting from '||l_proc,25);
108: -- Bug : 3621420
109: -- Raise an error as the ELPRO being inserted is already associated with the VAPRO
110: fnd_message.set_name('BEN','BEN_93966_ELPRO_FOR_VAPRO_EXST');
111: fnd_message.raise_error;

Line 123: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;

119: fetch c_future_vrbl_rt_elig_prfl into l_future_vrbl_rt_elig_prfl_id, l_future_record_end_date ;
120: --
121: if c_future_vrbl_rt_elig_prfl%found then
122: --
123: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
124: update ben_vrbl_rt_elig_prfl_f
125: set effective_start_date = p_effective_date
126: where vrbl_rt_elig_prfl_id = l_future_vrbl_rt_elig_prfl_id ;
127: hr_utility.set_location('exiting from '||l_proc,25);

Line 127: hr_utility.set_location('exiting from '||l_proc,25);

123: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
124: update ben_vrbl_rt_elig_prfl_f
125: set effective_start_date = p_effective_date
126: where vrbl_rt_elig_prfl_id = l_future_vrbl_rt_elig_prfl_id ;
127: hr_utility.set_location('exiting from '||l_proc,25);
128: close c_future_vrbl_rt_elig_prfl ;
129: -- Bug : 3621420
130: -- Set the new effective start and end date for the record
131: p_effective_start_date := p_effective_date;

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

291: -- End of API User Hook for the after hook of create_vrbl_rt_elig_prfl
292: --
293: end;
294: --
295: hr_utility.set_location(l_proc, 60);
296: --
297: hr_utility.set_location(l_proc, 60);
298: ben_profile_handler.event_handler
299: (p_event => 'CREATE',

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

293: end;
294: --
295: hr_utility.set_location(l_proc, 60);
296: --
297: hr_utility.set_location(l_proc, 60);
298: ben_profile_handler.event_handler
299: (p_event => 'CREATE',
300: p_base_table => 'BEN_VRBL_RT_PRFL_F',
301: p_base_table_column => 'VRBL_RT_PRFL_ID',

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

316: p_effective_start_date := l_effective_start_date;
317: p_effective_end_date := l_effective_end_date;
318: p_object_version_number := l_object_version_number;
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 70);
321: --
322: exception
323: --
324: when hr_api.validate_enabled then

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

335: p_vrbl_rt_elig_prfl_id := null;
336: p_effective_start_date := null;
337: p_effective_end_date := null;
338: p_object_version_number := null;
339: hr_utility.set_location(' Leaving:'||l_proc, 80);
340: --
341: when others then
342: --
343: -- A validation or unexpected error has occured

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

410: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
411: --
412: begin
413: --
414: hr_utility.set_location('Entering:'|| l_proc, 10);
415: --
416: -- Issue a savepoint if operating in validation only mode
417: --
418: savepoint update_vrbl_rt_elig_prfl;

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

416: -- Issue a savepoint if operating in validation only mode
417: --
418: savepoint update_vrbl_rt_elig_prfl;
419: --
420: hr_utility.set_location(l_proc, 20);
421: --
422: -- Process Logic
423: --
424: l_object_version_number := p_object_version_number;

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

583: -- End of API User Hook for the after hook of update_vrbl_rt_elig_prfl
584: --
585: end;
586: --
587: hr_utility.set_location(l_proc, 60);
588: --
589: -- When in validation only mode raise the Validate_Enabled exception
590: --
591: if p_validate then

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

597: p_object_version_number := l_object_version_number;
598: p_effective_start_date := l_effective_start_date;
599: p_effective_end_date := l_effective_end_date;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 70);
602: --
603: exception
604: --
605: when hr_api.validate_enabled then

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

615: --
616: p_effective_start_date := null;
617: p_effective_end_date := null;
618:
619: hr_utility.set_location(' Leaving:'||l_proc, 80);
620: --
621: when others then
622: --
623: -- A validation or unexpected error has occured

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

654: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
655: --
656: begin
657: --
658: hr_utility.set_location('Entering:'|| l_proc, 10);
659: --
660: -- Issue a savepoint if operating in validation only mode
661: --
662: savepoint delete_vrbl_rt_elig_prfl;

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

660: -- Issue a savepoint if operating in validation only mode
661: --
662: savepoint delete_vrbl_rt_elig_prfl;
663: --
664: hr_utility.set_location(l_proc, 20);
665: --
666: -- Process Logic
667: --
668: l_object_version_number := p_object_version_number;

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

723: -- End of API User Hook for the after hook of delete_vrbl_rt_elig_prfl
724: --
725: end;
726: --
727: hr_utility.set_location(l_proc, 60);
728: --
729: ben_profile_handler.event_handler
730: (p_event => 'DELETE',
731: p_base_table => 'BEN_VRBL_RT_PRFL_F',

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

740: if p_validate then
741: raise hr_api.validate_enabled;
742: end if;
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 70);
745: --
746: exception
747: --
748: when hr_api.validate_enabled then

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

795: l_validation_end_date date;
796: --
797: begin
798: --
799: hr_utility.set_location('Entering:'|| l_proc, 10);
800: --
801: ben_vep_shd.lck
802: (
803: p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id

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

807: ,p_effective_date => p_effective_date
808: ,p_datetrack_mode => p_datetrack_mode
809: );
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 70);
812: --
813: end lck;
814: --
815: end ben_vrbl_rt_elig_prfl_api;