DBA Data[Home] [Help]

APPS.GHR_MASS_ACTIONS_PKG dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering ' || l_proc,5);

29: and nvl(noa.date_to,nvl(p_effective_date,trunc(sysdate))) ;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering ' || l_proc,5);
34: p_noa_id := Null;
35: p_noa_desc := Null;
36:
37: for noa_id_desc in c_noa loop

Line 38: hr_utility.set_location( l_proc,10);

34: p_noa_id := Null;
35: p_noa_desc := Null;
36:
37: for noa_id_desc in c_noa loop
38: hr_utility.set_location( l_proc,10);
39: p_noa_id := noa_id_desc.nature_of_action_id;
40: p_noa_desc := noa_id_desc.description;
41: end loop;
42: hr_utility.set_location('Leaving ' || l_proc,15);

Line 42: hr_utility.set_location('Leaving ' || l_proc,15);

38: hr_utility.set_location( l_proc,10);
39: p_noa_id := noa_id_desc.nature_of_action_id;
40: p_noa_desc := noa_id_desc.description;
41: end loop;
42: hr_utility.set_location('Leaving ' || l_proc,15);
43: -- Nocopy Changes
44: Exception
45: When others then
46: p_noa_id := null;

Line 77: hr_utility.set_location('Entering ' || l_proc,5);

73: between rem.date_from and nvl(rem.date_to,nvl(p_effective_date, trunc(sysdate)));
74:
75: begin
76: --
77: hr_utility.set_location('Entering ' || l_proc,5);
78: p_remark_id := Null;
79: p_remark_desc := Null;
80:
81: for rem_id_desc in c_rem_desc loop

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

78: p_remark_id := Null;
79: p_remark_desc := Null;
80:
81: for rem_id_desc in c_rem_desc loop
82: hr_utility.set_location( l_proc,10);
83: p_remark_id := rem_id_desc.remark_id;
84: p_remark_desc := rem_id_desc.description;
85: end loop;
86: hr_utility.set_location('Leaving ' || l_proc,15);

Line 86: hr_utility.set_location('Leaving ' || l_proc,15);

82: hr_utility.set_location( l_proc,10);
83: p_remark_id := rem_id_desc.remark_id;
84: p_remark_desc := rem_id_desc.description;
85: end loop;
86: hr_utility.set_location('Leaving ' || l_proc,15);
87: -- Nocopy Changes
88: Exception
89: When others then
90: p_remark_id := Null;

Line 116: hr_utility.set_location('Leaving ' || l_proc,10);

112: p_sf52_rec.employee_national_identifier := p_emp_rec.national_identifier;
113: p_Sf52_rec.employee_date_of_birth := p_emp_rec.date_of_birth;
114: p_sf52_rec.employee_assignment_id := p_emp_rec.assignment_id;
115:
116: hr_utility.set_location('Leaving ' || l_proc,10);
117: -- Nocopy Changes
118: Exception
119: When others then
120: p_sf52_rec := l_sf52_rec;

Line 137: hr_utility.set_location('Entering ' || l_proc,5);

133: begin
134: -- Nocopy Changes
135: l_sf52_rec := p_sf52_rec;
136: --
137: hr_utility.set_location('Entering ' || l_proc,5);
138:
139: p_sf52_rec.tenure := p_asg_sf52_rec.tenure;
140: p_sf52_rec.to_step_or_rate := p_asg_sf52_rec.step_or_rate;
141: p_sf52_rec.annuitant_indicator := p_asg_sf52_rec.annuitant_indicator;

Line 148: hr_utility.set_location('Leaving ' || l_proc,10);

144: p_sf52_rec.part_time_hours := p_asg_sf52_rec.part_time_hours;
145:
146:
147:
148: hr_utility.set_location('Leaving ' || l_proc,10);
149: -- Nocopy Changes
150: Exception
151: When others then
152: p_sf52_rec := l_sf52_rec;

Line 170: hr_utility.set_location('Entering ' || l_proc,5);

166: begin
167: -- Nocopy Changes
168: l_sf52_rec := p_sf52_rec;
169: --
170: hr_utility.set_location('Entering ' || l_proc,5);
171:
172: p_sf52_rec.flsa_category := p_pos_grp1_rec.flsa_category;
173: p_sf52_rec.bargaining_unit_status := p_pos_grp1_rec.bargaining_unit_status;
174: p_sf52_rec.functional_class := p_pos_grp1_rec.functional_class;

Line 177: hr_utility.set_location('Leaving ' || l_proc,10);

173: p_sf52_rec.bargaining_unit_status := p_pos_grp1_rec.bargaining_unit_status;
174: p_sf52_rec.functional_class := p_pos_grp1_rec.functional_class;
175: p_sf52_rec.supervisory_status := p_pos_grp1_rec.supervisory_status;
176:
177: hr_utility.set_location('Leaving ' || l_proc,10);
178: -- Nocopy Changes
179: Exception
180: When others then
181: p_sf52_rec := l_sf52_rec;

Line 198: hr_utility.set_location('Entering ' || l_proc,5);

194: begin
195: -- Nocopy Changes
196: l_sf52_rec := p_sf52_rec;
197: --
198: hr_utility.set_location('Entering ' || l_proc,5);
199: p_sf52_rec.to_basic_pay := p_pay_calc_rec.basic_pay;
200: p_sf52_rec.to_locality_adj := p_pay_calc_rec.locality_adj;
201: p_sf52_rec.to_adj_basic_pay := p_pay_calc_rec.adj_basic_pay;
202: p_sf52_rec.to_total_salary := p_pay_calc_rec.total_salary;

Line 216: hr_utility.set_location('Leaving ' || l_proc,10);

212:
213: -- If open_pay_fields then custom_pay_calc_flag should be set to 'Y' . Should we also consider the assignment of the
214: -- above pay elements based on the the boolean out parameter. ????
215:
216: hr_utility.set_location('Leaving ' || l_proc,10);
217:
218: -- Nocopy Changes
219: Exception
220: When others then

Line 241: hr_utility.set_location('Leaving ' || l_proc,10);

237: p_sf52_rec.duty_station_id := p_duty_station_rec.duty_station_id;
238: p_sf52_rec.duty_station_code := p_duty_station_rec.duty_station_code;
239: p_sf52_rec.duty_station_desc := p_duty_station_rec.duty_station_desc;
240:
241: hr_utility.set_location('Leaving ' || l_proc,10);
242: -- Nocopy Changes
243: Exception
244: When others then
245: p_sf52_rec := l_sf52_rec;

Line 353: hr_utility.set_location('Entering ' || l_proc,5);

349:
350:
351: begin
352: savepoint get_personnel_off_groupbox;
353: hr_utility.set_location('Entering ' || l_proc,5);
354:
355: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow
356:
357:

Line 380: hr_utility.set_message(8301,'GHR_38479_INV_GBOX_FOR_PER_OFF');

376: -- fetch groupbox_id as well as other routing group details
377:
378: if l_groupbox_id is null then
379: -- Remember to create a new message and update the message number
380: hr_utility.set_message(8301,'GHR_38479_INV_GBOX_FOR_PER_OFF');
381: hr_utility.raise_error;
382: else
383: p_groupbox_id := l_groupbox_id;
384: p_routing_group_id := l_routing_group_id;

Line 381: hr_utility.raise_error;

377:
378: if l_groupbox_id is null then
379: -- Remember to create a new message and update the message number
380: hr_utility.set_message(8301,'GHR_38479_INV_GBOX_FOR_PER_OFF');
381: hr_utility.raise_error;
382: else
383: p_groupbox_id := l_groupbox_id;
384: p_routing_group_id := l_routing_group_id;
385: -- Make sure that this is a valid groupbox with atleast a single user

Line 392: hr_utility.set_message(8301,'GHR_38480_NO_GBOX_USERS');

388: l_count := gbusers.cnt;
389: end loop;
390: If nvl(l_count,0) = 0 then
391: -- Remember to create a new message and update the message number
392: hr_utility.set_message(8301,'GHR_38480_NO_GBOX_USERS');
393: hr_utility.raise_error;
394: End if;
395: end if;
396: -- NOCOPY CHANGES

Line 393: hr_utility.raise_error;

389: end loop;
390: If nvl(l_count,0) = 0 then
391: -- Remember to create a new message and update the message number
392: hr_utility.set_message(8301,'GHR_38480_NO_GBOX_USERS');
393: hr_utility.raise_error;
394: End if;
395: end if;
396: -- NOCOPY CHANGES
397: EXCEPTION