DBA Data[Home] [Help]

APPS.BEN_PDW_MASS_UPD_RATES dependencies on HR_UTILITY

Line 15: hr_utility.set_location('Intering get_dt_modes p_dt_mode '||l_datetrack_mode,10);

11: l_update boolean := true ;
12: l_datetrack_mode varchar2(80) := p_datetrack_mode ;
13: begin
14: --
15: hr_utility.set_location('Intering get_dt_modes p_dt_mode '||l_datetrack_mode,10);
16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --

Line 16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);

12: l_datetrack_mode varchar2(80) := p_datetrack_mode ;
13: begin
14: --
15: hr_utility.set_location('Intering get_dt_modes p_dt_mode '||l_datetrack_mode,10);
16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --
20: if p_effective_end_date <> hr_api.g_eot then

Line 17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);

13: begin
14: --
15: hr_utility.set_location('Intering get_dt_modes p_dt_mode '||l_datetrack_mode,10);
16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --
20: if p_effective_end_date <> hr_api.g_eot then
21: --

Line 18: hr_utility.set_location('p_effective_date '||p_effective_date,10);

14: --
15: hr_utility.set_location('Intering get_dt_modes p_dt_mode '||l_datetrack_mode,10);
16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --
20: if p_effective_end_date <> hr_api.g_eot then
21: --
22: if p_dml_operation = 'INSERT' then

Line 112: hr_utility.set_location('Leaving get_dt_modes p_dt_mode '||p_datetrack_mode,10);

108: --
109: p_datetrack_mode := l_datetrack_mode ;
110: -- p_update := l_update ;
111: --
112: hr_utility.set_location('Leaving get_dt_modes p_dt_mode '||p_datetrack_mode,10);
113: --
114: end get_dt_modes ;
115:
116: procedure UPLOAD_RATE(

Line 156: hr_utility.set_location('UPLOAD_RATE: Entering',10);

152: l_input_value_id number;
153: l_datetrack_mode pqh_copy_entity_txns.datetrack_mode%TYPE;
154: BEGIN
155: l_object_version_number := p_object_version_number;
156: hr_utility.set_location('UPLOAD_RATE: Entering',10);
157: -- As of now, user can choose UPDATE or CORRECTION as the date track selection.
158: -- We are not allowing future data date track selections
159: IF (P_RATE_TYPE = hr_general.decode_lookup('BEN_MRT_RT_TYPE','STD_RT') or 'ABR' = P_RATE_TYPE) then
160: hr_utility.set_location('UPloading Standard Rate',15);

Line 160: hr_utility.set_location('UPloading Standard Rate',15);

156: hr_utility.set_location('UPLOAD_RATE: Entering',10);
157: -- As of now, user can choose UPDATE or CORRECTION as the date track selection.
158: -- We are not allowing future data date track selections
159: IF (P_RATE_TYPE = hr_general.decode_lookup('BEN_MRT_RT_TYPE','STD_RT') or 'ABR' = P_RATE_TYPE) then
160: hr_utility.set_location('UPloading Standard Rate',15);
161: begin
162: select 'Y' into l_future_data_exists
163: from
164: BEN_ACTY_BASE_RT_F a

Line 238: hr_utility.set_location('Finished uploadeing Standard Rate',18);

234: ,p_datetrack_mode => l_datetrack_mode
235: ,p_effective_start_date => l_effective_start_date
236: ,p_effective_end_date => l_effective_end_date
237: );
238: hr_utility.set_location('Finished uploadeing Standard Rate',18);
239: elsif (P_RATE_TYPE = hr_general.decode_lookup('BEN_MRT_RT_TYPE','VRBL_RT') or 'VPF' = P_RATE_TYPE) then
240: hr_utility.set_location('Uploading Variable Rate',15);
241: begin
242: select 'Y' into l_future_data_exists

Line 240: hr_utility.set_location('Uploading Variable Rate',15);

236: ,p_effective_end_date => l_effective_end_date
237: );
238: hr_utility.set_location('Finished uploadeing Standard Rate',18);
239: elsif (P_RATE_TYPE = hr_general.decode_lookup('BEN_MRT_RT_TYPE','VRBL_RT') or 'VPF' = P_RATE_TYPE) then
240: hr_utility.set_location('Uploading Variable Rate',15);
241: begin
242: select 'Y' into l_future_data_exists
243: from
244: BEN_VRBL_RT_PRFL_F a

Line 290: hr_utility.set_location('Finished uploading Variable Rate',18);

286: ,p_datetrack_mode => l_datetrack_mode
287: ,p_effective_start_date => l_effective_start_date
288: ,p_effective_end_date => l_effective_end_date
289: );
290: hr_utility.set_location('Finished uploading Variable Rate',18);
291: end if;
292: hr_utility.set_location('UPLOAD_RATE: Leaving',20);
293: /* */
294: end UPLOAD_RATE;

Line 292: hr_utility.set_location('UPLOAD_RATE: Leaving',20);

288: ,p_effective_end_date => l_effective_end_date
289: );
290: hr_utility.set_location('Finished uploading Variable Rate',18);
291: end if;
292: hr_utility.set_location('UPLOAD_RATE: Leaving',20);
293: /* */
294: end UPLOAD_RATE;
295:
296: