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_OPT_PLTYP_IN_PGM_API dependencies on HR_UTILITY

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

87: l_future_optip_id ben_optip_f.optip_id%TYPE;
88: --
89: begin
90: --
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: --
93: -- Issue a savepoint if operating in validation only mode
94: --
95: savepoint create_opt_pltyp_in_pgm;

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

93: -- Issue a savepoint if operating in validation only mode
94: --
95: savepoint create_opt_pltyp_in_pgm;
96: --
97: hr_utility.set_location(l_proc, 20);
98: --
99: -- Process Logic
100: --
101: --

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

104: fetch c_uniq_optip into l_dummy;
105: --
106: if c_uniq_optip%found then
107: --
108: hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;
109: hr_utility.set_location('exiting from '||l_proc,25);
110: close c_uniq_optip ;
111: return ;
112: --

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

105: --
106: if c_uniq_optip%found then
107: --
108: hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;
109: hr_utility.set_location('exiting from '||l_proc,25);
110: close c_uniq_optip ;
111: return ;
112: --
113: end if;

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

117: fetch c_future_optip into l_future_optip_id ;
118: --
119: if c_future_optip%found then
120: --
121: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
122: update ben_optip_f
123: set effective_start_date = p_effective_date
124: where optip_id = l_future_optip_id ;
125: hr_utility.set_location('exiting from '||l_proc,25);

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

121: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
122: update ben_optip_f
123: set effective_start_date = p_effective_date
124: where optip_id = l_future_optip_id ;
125: hr_utility.set_location('exiting from '||l_proc,25);
126: close c_future_optip ;
127: return ;
128: --
129: end if;

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

296: -- End of API User Hook for the after hook of create_opt_pltyp_in_pgm
297: --
298: end;
299: --
300: hr_utility.set_location(l_proc, 60);
301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --
304: if p_validate then

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

311: p_effective_start_date := l_effective_start_date;
312: p_effective_end_date := l_effective_end_date;
313: p_object_version_number := l_object_version_number;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: --
317: exception
318: --
319: when hr_api.validate_enabled then

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

330: p_optip_id := null;
331: p_effective_start_date := null;
332: p_effective_end_date := null;
333: p_object_version_number := null;
334: hr_utility.set_location(' Leaving:'||l_proc, 80);
335: --
336: when others then
337: --
338: -- A validation or unexpected error has occured

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

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

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

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

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

594: -- End of API User Hook for the after hook of update_opt_pltyp_in_pgm
595: --
596: end;
597: --
598: hr_utility.set_location(l_proc, 60);
599: --
600: -- When in validation only mode raise the Validate_Enabled exception
601: --
602: if p_validate then

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

608: p_object_version_number := l_object_version_number;
609: p_effective_start_date := l_effective_start_date;
610: p_effective_end_date := l_effective_end_date;
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 70);
613: --
614: exception
615: --
616: when hr_api.validate_enabled then

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

626: --
627: p_effective_start_date := null;
628: p_effective_end_date := null;
629:
630: hr_utility.set_location(' Leaving:'||l_proc, 80);
631: --
632: when others then
633: --
634: -- A validation or unexpected error has occured

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

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

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

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

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

733: -- End of API User Hook for the after hook of delete_opt_pltyp_in_pgm
734: --
735: end;
736: --
737: hr_utility.set_location(l_proc, 60);
738: --
739: -- When in validation only mode raise the Validate_Enabled exception
740: --
741: if p_validate then

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

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

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

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

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

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