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.GHR_MASS_AWARDS_PKG dependencies on HR_UTILITY

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

33: and nvl(noa.date_to,nvl(p_effective_date,trunc(sysdate))) ;
34: --
35: BEGIN
36: --
37: hr_utility.set_location('Entering ' || l_proc,5);
38: p_noa_code := Null;
39: p_noa_desc := Null;
40:
41: for noa_code_desc in c_noa loop

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

38: p_noa_code := Null;
39: p_noa_desc := Null;
40:
41: for noa_code_desc in c_noa loop
42: hr_utility.set_location( l_proc,10);
43: p_noa_code := noa_code_desc.code;
44: p_noa_desc := noa_code_desc.description;
45: end loop;
46: hr_utility.set_location('Leaving ' || l_proc,15);

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

42: hr_utility.set_location( l_proc,10);
43: p_noa_code := noa_code_desc.code;
44: p_noa_desc := noa_code_desc.description;
45: end loop;
46: hr_utility.set_location('Leaving ' || l_proc,15);
47:
48: EXCEPTION
49: WHEN others THEN
50: -- Reset IN OUT parameters and set OUT parameters

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

138: AND person_id = p_person_id;
139:
140: BEGIN
141:
142: hr_utility.set_location('Entering ' || l_proc,5);
143: p_pa_request_id := Null;
144: p_object_version_number := Null;
145: p_pa_notification_id := Null;
146: p_rpa_type := Null;

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

147: p_mass_action_sel_flag := Null;
148: p_mass_action_comments := Null;
149:
150: for cur_rpa_rec in cur_rpa loop
151: hr_utility.set_location( l_proc,10);
152: p_pa_request_id := cur_rpa_rec.pa_request_id;
153: p_object_version_number := cur_rpa_rec.object_version_number;
154: p_pa_notification_id := cur_rpa_rec.pa_notification_id;
155: p_rpa_type := cur_rpa_rec.rpa_type;

Line 160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);

156: p_mass_action_sel_flag := cur_rpa_rec.mass_action_select_flag;
157: --Bug#3804067 Added code for comments.
158: p_mass_action_comments := cur_rpa_rec.mass_action_comments;
159: end loop;
160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);

Line 161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);

157: --Bug#3804067 Added code for comments.
158: p_mass_action_comments := cur_rpa_rec.mass_action_comments;
159: end loop;
160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);
165: hr_utility.set_location('Leaving ' || l_proc,15);

Line 162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);

158: p_mass_action_comments := cur_rpa_rec.mass_action_comments;
159: end loop;
160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);
165: hr_utility.set_location('Leaving ' || l_proc,15);
166:

Line 163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);

159: end loop;
160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);
165: hr_utility.set_location('Leaving ' || l_proc,15);
166:
167: EXCEPTION

Line 164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);

160: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);
165: hr_utility.set_location('Leaving ' || l_proc,15);
166:
167: EXCEPTION
168: WHEN others THEN

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

161: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
162: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
163: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
164: hr_utility.set_location('select flag value ' || p_mass_action_sel_flag,15);
165: hr_utility.set_location('Leaving ' || l_proc,15);
166:
167: EXCEPTION
168: WHEN others THEN
169: -- Reset IN OUT parameters and set OUT parameters

Line 178: hr_utility.set_location('Leaving ' || l_proc,20);

174: p_mass_action_sel_flag :=NULL;
175: --Bug#3804067 Added mass_action_comments
176: p_mass_action_comments :=NULL;
177: p_object_version_number :=NULL;
178: hr_utility.set_location('Leaving ' || l_proc,20);
179: RAISE;
180:
181: END get_pa_request_id_ovn;
182:

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

238: AND information_type = l_information_type;
239:
240: BEGIN
241:
242: hr_utility.set_location('Entering ' || l_proc,5);
243: p_award_amount := Null;
244: p_award_uom := Null;
245: p_award_percentage := Null;
246: p_award_agency := Null;

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

251: p_appropriation_code := Null;
252:
253: IF p_rpa_type = 'TA' then
254: for cur_rpa_tmp_rec in cur_rpa_tmp loop
255: hr_utility.set_location( l_proc,10);
256: l_pa_request_id := cur_rpa_tmp_rec.pa_request_id;
257: p_award_amount := cur_rpa_tmp_rec.award_amount;
258: p_award_uom := cur_rpa_tmp_rec.award_uom;
259: p_award_percentage := cur_rpa_tmp_rec.award_percentage;

Line 260: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);

256: l_pa_request_id := cur_rpa_tmp_rec.pa_request_id;
257: p_award_amount := cur_rpa_tmp_rec.award_amount;
258: p_award_uom := cur_rpa_tmp_rec.award_uom;
259: p_award_percentage := cur_rpa_tmp_rec.award_percentage;
260: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
261: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
262: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
264: end loop;

Line 261: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);

257: p_award_amount := cur_rpa_tmp_rec.award_amount;
258: p_award_uom := cur_rpa_tmp_rec.award_uom;
259: p_award_percentage := cur_rpa_tmp_rec.award_percentage;
260: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
261: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
262: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
264: end loop;
265: else

Line 262: hr_utility.set_location(' award uom = ' || p_award_uom ,15);

258: p_award_uom := cur_rpa_tmp_rec.award_uom;
259: p_award_percentage := cur_rpa_tmp_rec.award_percentage;
260: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
261: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
262: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
264: end loop;
265: else
266: for cur_rpa_per_rec in cur_rpa_per loop

Line 263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);

259: p_award_percentage := cur_rpa_tmp_rec.award_percentage;
260: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
261: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
262: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
264: end loop;
265: else
266: for cur_rpa_per_rec in cur_rpa_per loop
267: hr_utility.set_location( l_proc,10);

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

263: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
264: end loop;
265: else
266: for cur_rpa_per_rec in cur_rpa_per loop
267: hr_utility.set_location( l_proc,10);
268: l_pa_request_id := cur_rpa_per_rec.pa_request_id;
269: p_award_amount := cur_rpa_per_rec.award_amount;
270: p_award_uom := cur_rpa_per_rec.award_uom;
271: p_award_percentage := cur_rpa_per_rec.award_percentage;

Line 272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);

268: l_pa_request_id := cur_rpa_per_rec.pa_request_id;
269: p_award_amount := cur_rpa_per_rec.award_amount;
270: p_award_uom := cur_rpa_per_rec.award_uom;
271: p_award_percentage := cur_rpa_per_rec.award_percentage;
272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);
274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);

Line 273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);

269: p_award_amount := cur_rpa_per_rec.award_amount;
270: p_award_uom := cur_rpa_per_rec.award_uom;
271: p_award_percentage := cur_rpa_per_rec.award_percentage;
272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);
274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
277: end loop;

Line 274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);

270: p_award_uom := cur_rpa_per_rec.award_uom;
271: p_award_percentage := cur_rpa_per_rec.award_percentage;
272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);
274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
277: end loop;
278: END IF;

Line 275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);

271: p_award_percentage := cur_rpa_per_rec.award_percentage;
272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);
274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
277: end loop;
278: END IF;
279:

Line 276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);

272: hr_utility.set_location(' Rpa type = ' || p_rpa_type ,15);
273: hr_utility.set_location(' Person_id = ' || to_char(p_person_id) ,15);
274: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,15);
275: hr_utility.set_location(' award uom = ' || p_award_uom ,15);
276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
277: end loop;
278: END IF;
279:
280: hr_utility.set_location(' Rpa ID = ' ||l_pa_request_id ,15);

Line 280: hr_utility.set_location(' Rpa ID = ' ||l_pa_request_id ,15);

276: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,15);
277: end loop;
278: END IF;
279:
280: hr_utility.set_location(' Rpa ID = ' ||l_pa_request_id ,15);
281:
282: for cur_award_ei_rec in cur_award_ei(l_pa_request_id) loop
283: hr_utility.set_location( l_proc,20);
284: p_award_agency := cur_award_ei_rec.award_agency;

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

279:
280: hr_utility.set_location(' Rpa ID = ' ||l_pa_request_id ,15);
281:
282: for cur_award_ei_rec in cur_award_ei(l_pa_request_id) loop
283: hr_utility.set_location( l_proc,20);
284: p_award_agency := cur_award_ei_rec.award_agency;
285: p_award_type := cur_award_ei_rec.award_type;
286: p_group_award := cur_award_ei_rec.group_award;
287: p_tangible_benefit_dollars := cur_award_ei_rec.tangible_benefit_dollars;

Line 290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);

286: p_group_award := cur_award_ei_rec.group_award;
287: p_tangible_benefit_dollars := cur_award_ei_rec.tangible_benefit_dollars;
288: p_date_award_earned := cur_award_ei_rec.date_award_earned;
289: p_appropriation_code := cur_award_ei_rec.appropriation_code;
290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);
291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);

Line 291: hr_utility.set_location(' award type = ' || p_award_type ,15);

287: p_tangible_benefit_dollars := cur_award_ei_rec.tangible_benefit_dollars;
288: p_date_award_earned := cur_award_ei_rec.date_award_earned;
289: p_appropriation_code := cur_award_ei_rec.appropriation_code;
290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);
291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);

Line 292: hr_utility.set_location(' group award = ' || p_group_award ,15);

288: p_date_award_earned := cur_award_ei_rec.date_award_earned;
289: p_appropriation_code := cur_award_ei_rec.appropriation_code;
290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);
291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);
296: end loop;

Line 293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);

289: p_appropriation_code := cur_award_ei_rec.appropriation_code;
290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);
291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);
296: end loop;
297:

Line 294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);

290: hr_utility.set_location(' award agency = ' || p_award_agency ,15);
291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);
296: end loop;
297:
298: hr_utility.set_location('Leaving ' || l_proc,35);

Line 295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);

291: hr_utility.set_location(' award type = ' || p_award_type ,15);
292: hr_utility.set_location(' group award = ' || p_group_award ,15);
293: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,15);
294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);
296: end loop;
297:
298: hr_utility.set_location('Leaving ' || l_proc,35);
299:

Line 298: hr_utility.set_location('Leaving ' || l_proc,35);

294: hr_utility.set_location(' date award = ' || p_date_award_earned ,15);
295: hr_utility.set_location(' appr Code = ' || p_appropriation_code ,15);
296: end loop;
297:
298: hr_utility.set_location('Leaving ' || l_proc,35);
299:
300: EXCEPTION
301: WHEN others THEN
302: -- Reset IN OUT parameters and set OUT parameters

Line 314: hr_utility.set_location('Leaving ' || l_proc,40);

310: p_tangible_benefit_dollars := Null;
311: p_date_award_earned := Null;
312: p_appropriation_code := Null;
313:
314: hr_utility.set_location('Leaving ' || l_proc,40);
315: RAISE;
316:
317: END get_award_details;
318:

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

356: AND person_id is null;
357:
358: BEGIN
359:
360: hr_utility.set_location('Entering ' || l_proc,5);
361: p_first_lac1_record := Null;
362: p_first_lac2_record := Null;
363:
364: for cur_rpa_lac_rec in cur_rpa_lac loop

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

361: p_first_lac1_record := Null;
362: p_first_lac2_record := Null;
363:
364: for cur_rpa_lac_rec in cur_rpa_lac loop
365: hr_utility.set_location( l_proc,10);
366: p_first_lac1_record.first_action_la_code1 := cur_rpa_lac_rec.first_action_la_code1;
367: p_first_lac1_record.first_action_la_desc1 := cur_rpa_lac_rec.first_action_la_desc1;
368: p_first_lac1_record.first_lac1_information1 := cur_rpa_lac_rec.first_lac1_information1;
369: p_first_lac1_record.first_lac1_information2 := cur_rpa_lac_rec.first_lac1_information2;

Line 383: hr_utility.set_location('Leaving ' || l_proc,20);

379: p_first_lac2_record.first_lac2_information4 := cur_rpa_lac_rec.first_lac2_information4;
380: p_first_lac2_record.first_lac2_information5 := cur_rpa_lac_rec.first_lac2_information5;
381: end loop;
382:
383: hr_utility.set_location('Leaving ' || l_proc,20);
384:
385: EXCEPTION
386: WHEN others THEN
387: -- Reset IN OUT parameters and set OUT parameters

Line 392: hr_utility.set_location('Leaving ' || l_proc,25);

388:
389: p_first_lac1_record := Null;
390: p_first_lac2_record := Null;
391:
392: hr_utility.set_location('Leaving ' || l_proc,25);
393: RAISE;
394:
395: END get_award_lac;
396:

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

437: AND information_type = l_information_type;
438:
439: BEGIN
440:
441: hr_utility.set_location('Entering ' || l_proc,5);
442: p_award_amount := Null;
443: p_award_uom := Null;
444: p_award_percentage := Null;
445: p_award_agency := Null;

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

449: p_date_award_earned := Null;
450: p_appropriation_code := Null;
451:
452: for cur_rpa_shadow_rec in cur_rpa_shadow loop
453: hr_utility.set_location( l_proc,10);
454: p_award_amount := cur_rpa_shadow_rec.award_amount;
455: p_award_uom := cur_rpa_shadow_rec.award_uom;
456: p_award_percentage := cur_rpa_shadow_rec.award_percentage;
457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);

Line 457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);

453: hr_utility.set_location( l_proc,10);
454: p_award_amount := cur_rpa_shadow_rec.award_amount;
455: p_award_uom := cur_rpa_shadow_rec.award_uom;
456: p_award_percentage := cur_rpa_shadow_rec.award_percentage;
457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);
458: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,10);
459: hr_utility.set_location(' award uom = ' || p_award_uom ,10);
460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);
461: end loop;

Line 458: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,10);

454: p_award_amount := cur_rpa_shadow_rec.award_amount;
455: p_award_uom := cur_rpa_shadow_rec.award_uom;
456: p_award_percentage := cur_rpa_shadow_rec.award_percentage;
457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);
458: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,10);
459: hr_utility.set_location(' award uom = ' || p_award_uom ,10);
460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);
461: end loop;
462:

Line 459: hr_utility.set_location(' award uom = ' || p_award_uom ,10);

455: p_award_uom := cur_rpa_shadow_rec.award_uom;
456: p_award_percentage := cur_rpa_shadow_rec.award_percentage;
457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);
458: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,10);
459: hr_utility.set_location(' award uom = ' || p_award_uom ,10);
460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);
461: end loop;
462:
463: for cur_award_ei_shadow_rec in cur_award_ei_shadow loop

Line 460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);

456: p_award_percentage := cur_rpa_shadow_rec.award_percentage;
457: hr_utility.set_location(' pa req id = ' || to_char(p_pa_request_id) ,10);
458: hr_utility.set_location(' award amt = ' || to_char(p_award_amount) ,10);
459: hr_utility.set_location(' award uom = ' || p_award_uom ,10);
460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);
461: end loop;
462:
463: for cur_award_ei_shadow_rec in cur_award_ei_shadow loop
464: hr_utility.set_location( l_proc,20);

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

460: hr_utility.set_location(' award per = ' || to_char(p_award_percentage) ,10);
461: end loop;
462:
463: for cur_award_ei_shadow_rec in cur_award_ei_shadow loop
464: hr_utility.set_location( l_proc,20);
465: p_award_agency := cur_award_ei_shadow_rec.award_agency;
466: p_award_type := cur_award_ei_shadow_rec.award_type;
467: p_group_award := cur_award_ei_shadow_rec.group_award;
468: p_tangible_benefit_dollars := cur_award_ei_shadow_rec.tangible_benefit_dollars;

Line 471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);

467: p_group_award := cur_award_ei_shadow_rec.group_award;
468: p_tangible_benefit_dollars := cur_award_ei_shadow_rec.tangible_benefit_dollars;
469: p_date_award_earned := cur_award_ei_shadow_rec.date_award_earned;
470: p_appropriation_code := cur_award_ei_shadow_rec.appropriation_code;
471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);
472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);

Line 472: hr_utility.set_location(' award type = ' || p_award_type ,20);

468: p_tangible_benefit_dollars := cur_award_ei_shadow_rec.tangible_benefit_dollars;
469: p_date_award_earned := cur_award_ei_shadow_rec.date_award_earned;
470: p_appropriation_code := cur_award_ei_shadow_rec.appropriation_code;
471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);
472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);

Line 473: hr_utility.set_location(' group award = ' || p_group_award ,20);

469: p_date_award_earned := cur_award_ei_shadow_rec.date_award_earned;
470: p_appropriation_code := cur_award_ei_shadow_rec.appropriation_code;
471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);
472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);
477: end loop;

Line 474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);

470: p_appropriation_code := cur_award_ei_shadow_rec.appropriation_code;
471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);
472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);
477: end loop;
478:

Line 475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);

471: hr_utility.set_location(' award agency = ' || p_award_agency ,20);
472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);
477: end loop;
478:
479: hr_utility.set_location('Leaving ' || l_proc,35);

Line 476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);

472: hr_utility.set_location(' award type = ' || p_award_type ,20);
473: hr_utility.set_location(' group award = ' || p_group_award ,20);
474: hr_utility.set_location(' tbd = ' || p_tangible_benefit_dollars ,20);
475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);
477: end loop;
478:
479: hr_utility.set_location('Leaving ' || l_proc,35);
480:

Line 479: hr_utility.set_location('Leaving ' || l_proc,35);

475: hr_utility.set_location(' date award = ' || p_date_award_earned ,20);
476: hr_utility.set_location(' Appr Code = ' || p_appropriation_code ,20);
477: end loop;
478:
479: hr_utility.set_location('Leaving ' || l_proc,35);
480:
481: EXCEPTION
482: WHEN others THEN
483: -- Reset IN OUT parameters and set OUT parameters

Line 495: hr_utility.set_location('Leaving ' || l_proc,40);

491: p_tangible_benefit_dollars := Null;
492: p_date_award_earned := Null;
493: p_appropriation_code := Null;
494:
495: hr_utility.set_location('Leaving ' || l_proc,40);
496: RAISE;
497:
498: END get_award_details_shadow;
499:

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

535:
536:
537: BEGIN
538:
539: hr_utility.set_location('Entering ' || l_proc,5);
540: l_effective_date := Null;
541:
542: for cur_ma_rec in cur_ma loop
543: hr_utility.set_location( l_proc,10);

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

539: hr_utility.set_location('Entering ' || l_proc,5);
540: l_effective_date := Null;
541:
542: for cur_ma_rec in cur_ma loop
543: hr_utility.set_location( l_proc,10);
544: l_effective_date := cur_ma_rec.effective_date;
545: end loop;
546:
547: open cur_get_seq;

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

550:
551: l_prog_name := 'GHR_MAW_PKG-' || l_prog_name;
552: g_log_name := l_prog_name;
553:
554: hr_utility.set_location( l_proc,20);
555: upd_elig_flag_bef_selection
556: ( p_mass_award_id => p_mass_award_id,
557: p_rpa_type => l_rpa_type,
558: p_effective_date => l_effective_date);

Line 561: hr_utility.set_location( l_proc,30);

557: p_rpa_type => l_rpa_type,
558: p_effective_date => l_effective_date);
559:
560:
561: hr_utility.set_location( l_proc,30);
562: ghr_mass_awards_elig.get_eligible_employees
563: ( p_mass_award_id => p_mass_award_id,
564: p_action_type => p_action_type,
565: p_errbuf => l_errbuf,

Line 580: hr_utility.set_location( l_proc,40);

576: else
577: l_status_flag := 'E';
578: end if;
579:
580: hr_utility.set_location( l_proc,40);
581: del_elig_flag_aft_selection
582: ( p_mass_award_id => p_mass_award_id,
583: p_rpa_type => l_rpa_type,
584: p_effective_date => l_effective_date);

Line 586: hr_utility.set_location( 'Updating ghr_mass_awards table ...' ||l_proc,50);

582: ( p_mass_award_id => p_mass_award_id,
583: p_rpa_type => l_rpa_type,
584: p_effective_date => l_effective_date);
585:
586: hr_utility.set_location( 'Updating ghr_mass_awards table ...' ||l_proc,50);
587:
588: IF p_action_type = 'FINAL' THEN
589: update ghr_mass_awards set status_flag = l_status_flag
590: where mass_award_id = p_mass_award_id;

Line 593: hr_utility.set_location('Leaving ' || l_proc,60);

589: update ghr_mass_awards set status_flag = l_status_flag
590: where mass_award_id = p_mass_award_id;
591: END IF;
592:
593: hr_utility.set_location('Leaving ' || l_proc,60);
594:
595: EXCEPTION
596: WHEN others THEN
597: -- Reset IN OUT parameters and set OUT parameters

Line 603: hr_utility.set_location('Leaving ' || l_proc,65);

599: p_errbuf := NULL;
600: p_status := NULL;
601: p_retcode := NULL;
602: p_maxcheck := NULL;
603: hr_utility.set_location('Leaving ' || l_proc,65);
604: RAISE;
605:
606: END main_awards;
607:

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

618: l_cntr number;
619:
620: begin
621:
622: hr_utility.set_location('Entering ' || l_proc,5);
623:
624: select count(*) into l_cntr
625: from ghr_pa_requests
626: where mass_action_id = p_mass_award_id

Line 630: hr_utility.set_location('No of rows :' || to_char(l_cntr) || l_proc,10);

626: where mass_action_id = p_mass_award_id
627: and rpa_type = p_rpa_type
628: and pa_notification_id is null;
629:
630: hr_utility.set_location('No of rows :' || to_char(l_cntr) || l_proc,10);
631:
632: update ghr_pa_requests set
633: mass_action_eligible_flag = 'N'
634: where mass_action_id = p_mass_award_id

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

636: and pa_notification_id is null;
637:
638: --- commit; --- Form will commit
639:
640: hr_utility.set_location('Leaving ' || l_proc,15);
641:
642: end;
643:
644: PROCEDURE del_elig_flag_aft_selection

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

661: AND mass_action_eligible_flag = 'N'
662: AND pa_notification_id is null;
663:
664: BEGIN
665: hr_utility.set_location('Entering ' || l_proc,5);
666: FOR cur_rpa_del_rec in cur_rpa_del
667: LOOP
668: hr_utility.set_location( l_proc,10);
669: l_pa_request_id := cur_rpa_del_rec.pa_request_id;

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

664: BEGIN
665: hr_utility.set_location('Entering ' || l_proc,5);
666: FOR cur_rpa_del_rec in cur_rpa_del
667: LOOP
668: hr_utility.set_location( l_proc,10);
669: l_pa_request_id := cur_rpa_del_rec.pa_request_id;
670:
671: -- Delete the shadow extra information
672: hr_utility.set_location( l_proc,15);

Line 672: hr_utility.set_location( l_proc,15);

668: hr_utility.set_location( l_proc,10);
669: l_pa_request_id := cur_rpa_del_rec.pa_request_id;
670:
671: -- Delete the shadow extra information
672: hr_utility.set_location( l_proc,15);
673: delete from ghr_pa_request_ei_shadow
674: where pa_request_id = l_pa_request_id;
675:
676: -- Delete the shadow information

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

673: delete from ghr_pa_request_ei_shadow
674: where pa_request_id = l_pa_request_id;
675:
676: -- Delete the shadow information
677: hr_utility.set_location( l_proc,20);
678: delete from ghr_pa_request_shadow
679: where pa_request_id = l_pa_request_id;
680:
681: -- Delete the database extra information for the given person_id

Line 682: hr_utility.set_location( l_proc,25);

678: delete from ghr_pa_request_shadow
679: where pa_request_id = l_pa_request_id;
680:
681: -- Delete the database extra information for the given person_id
682: hr_utility.set_location( l_proc,25);
683: delete from ghr_pa_request_extra_info
684: where pa_request_id = l_pa_request_id;
685:
686: -- Delete the database RPA award routing history record for the given person_id

Line 687: hr_utility.set_location( l_proc,35);

683: delete from ghr_pa_request_extra_info
684: where pa_request_id = l_pa_request_id;
685:
686: -- Delete the database RPA award routing history record for the given person_id
687: hr_utility.set_location( l_proc,35);
688: delete from ghr_pa_routing_history
689: where pa_request_id = l_pa_request_id;
690:
691: -- Delete the database RPA award record for the given person_id

Line 692: hr_utility.set_location( l_proc,35);

688: delete from ghr_pa_routing_history
689: where pa_request_id = l_pa_request_id;
690:
691: -- Delete the database RPA award record for the given person_id
692: hr_utility.set_location( l_proc,35);
693: delete from ghr_pa_requests
694: where pa_request_id = l_pa_request_id;
695: END LOOP;
696: END del_elig_flag_aft_selection;

Line 796: hr_utility.set_location('Entering ...' || l_proc,120);

792: l_approval_date := sysdate;
793: l_1_approval_status := 'APPROVE';
794: end if;
795:
796: hr_utility.set_location('Entering ...' || l_proc,120);
797: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);
798: get_pa_request_id_ovn
799: ( p_mass_award_id => p_mass_award_id,
800: p_effective_date => p_effective_date,

Line 797: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);

793: l_1_approval_status := 'APPROVE';
794: end if;
795:
796: hr_utility.set_location('Entering ...' || l_proc,120);
797: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);
798: get_pa_request_id_ovn
799: ( p_mass_award_id => p_mass_award_id,
800: p_effective_date => p_effective_date,
801: p_person_id => p_person_id,

Line 818: hr_utility.set_location(l_proc,130);

814:
815: IF l_pa_notification_id is null and l_rpa_type = 'A' then
816: IF l_pa_request_id is null THEN
817: -- Create SF52
818: hr_utility.set_location(l_proc,130);
819: begin
820: l_log_text := p_action_type || '-Error while creating the PA Request Rec. ';
821: g_log_text := p_action_type || '-Error while creating the PA Request Rec. ';
822: hr_utility.set_location('In MAR PA Bef Crt'||l_pa_request_rec.award_amount ,36);

Line 822: hr_utility.set_location('In MAR PA Bef Crt'||l_pa_request_rec.award_amount ,36);

818: hr_utility.set_location(l_proc,130);
819: begin
820: l_log_text := p_action_type || '-Error while creating the PA Request Rec. ';
821: g_log_text := p_action_type || '-Error while creating the PA Request Rec. ';
822: hr_utility.set_location('In MAR PA Bef Crt'||l_pa_request_rec.award_amount ,36);
823: -- Bug 3376761
824: -- check to see if award amount is within 25% of annual basic pay
825: -- other wise pass an error message in comments column.
826: -- Begin Bug# 4748927

Line 857: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);

853:
854: IF l_pa_request_rec.award_percentage IS NOT NULL THEN
855: l_pa_request_rec.award_amount := l_dummy;
856: END IF;
857: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);
858: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);
859:
860: -- End Bug# 4748927
861: /*

Line 858: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);

854: IF l_pa_request_rec.award_percentage IS NOT NULL THEN
855: l_pa_request_rec.award_amount := l_dummy;
856: END IF;
857: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);
858: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);
859:
860: -- End Bug# 4748927
861: /*
862: IF l_pa_request_rec.award_amount > ROUND(l_award_salary * 0.25 , 0) THEN

Line 1081: hr_utility.set_location( ' Sql error : '||sqlerrm(sqlcode) ,132);

1077: -- End of Bug 3376761
1078: );
1079: exception
1080: WHEN OTHERS THEN
1081: hr_utility.set_location( ' Sql error : '||sqlerrm(sqlcode) ,132);
1082: hr_utility.set_location(l_proc,132);
1083: l_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
1084: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
1085: raise ma_rpaerror;

Line 1082: hr_utility.set_location(l_proc,132);

1078: );
1079: exception
1080: WHEN OTHERS THEN
1081: hr_utility.set_location( ' Sql error : '||sqlerrm(sqlcode) ,132);
1082: hr_utility.set_location(l_proc,132);
1083: l_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
1084: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
1085: raise ma_rpaerror;
1086: end;

Line 1088: hr_utility.set_location(l_proc,135);

1084: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
1085: raise ma_rpaerror;
1086: end;
1087:
1088: hr_utility.set_location(l_proc,135);
1089: begin
1090: l_log_text := p_action_type || '-Error After creating the RPA before upd ';
1091: g_log_text := p_action_type || '-Error After creating the RPA before upd ';
1092: ghr_par_upd.upd(

Line 1101: hr_utility.set_location(l_proc,136);

1097: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
1098: p_from_office_symbol => l_pa_request_rec.from_office_symbol);
1099: exception
1100: WHEN OTHERS THEN
1101: hr_utility.set_location(l_proc,136);
1102: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1103: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1104: raise ma_rpaerror;
1105: end;

Line 1107: hr_utility.set_location(l_proc,138);

1103: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1104: raise ma_rpaerror;
1105: end;
1106:
1107: hr_utility.set_location(l_proc,138);
1108: create_shadow_row (p_rpa_data => l_pa_request_rec);
1109: hr_utility.set_location(' Shadow created ...'|| l_proc,138);
1110:
1111: ----Initialize the RPA extra information

Line 1109: hr_utility.set_location(' Shadow created ...'|| l_proc,138);

1105: end;
1106:
1107: hr_utility.set_location(l_proc,138);
1108: create_shadow_row (p_rpa_data => l_pa_request_rec);
1109: hr_utility.set_location(' Shadow created ...'|| l_proc,138);
1110:
1111: ----Initialize the RPA extra information
1112: FOR cur_rpa_ei_rec in cur_rpa_ei(l_pa_request_rec.pa_request_id)
1113: LOOP

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

1110:
1111: ----Initialize the RPA extra information
1112: FOR cur_rpa_ei_rec in cur_rpa_ei(l_pa_request_rec.pa_request_id)
1113: LOOP
1114: hr_utility.set_location( l_proc,10);
1115: l_ei_pa_request_extra_id := cur_rpa_ei_rec.pa_request_extra_info_id;
1116: l_ei_ovn := cur_rpa_ei_rec.object_version_number;
1117: l_ei_dae := cur_rpa_ei_rec.rei_information9;
1118: exit;

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

1135:
1136: ----Initialize the RPA extra information Shadow.
1137: FOR cur_rpa_ei_shadow_rec in cur_rpa_ei_shadow(l_pa_request_rec.pa_request_id)
1138: LOOP
1139: hr_utility.set_location( l_proc,10);
1140: l_ei_shadow_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
1141: exit;
1142: END LOOP;
1143:

Line 1157: hr_utility.set_location(l_proc,140);

1153: END IF;
1154:
1155: ----End Initialize.
1156:
1157: hr_utility.set_location(l_proc,140);
1158: refresh_award_details
1159: (
1160: p_mass_award_id => p_mass_award_id,
1161: p_rpa_type => p_rpa_type,

Line 1173: hr_utility.set_location(l_proc,141);

1169: l_pa_request_rec.award_amount := Null;
1170: l_pa_request_rec.award_uom := Null;
1171: l_pa_request_rec.award_percentage := Null;
1172:
1173: hr_utility.set_location(l_proc,141);
1174: ----- Get Award details from the template and also extra information
1175: get_award_details
1176: ( p_mass_award_id => p_mass_award_id,
1177: p_rpa_type => 'TA',

Line 1192: hr_utility.set_location('l_bt_award_amount' || l_bt_award_amount,142);

1188: p_appropriation_code => l_dummy);
1189:
1190: l_bt_award_amount := l_t_award_amount;
1191: l_bt_award_percentage := l_t_award_percentage;
1192: hr_utility.set_location('l_bt_award_amount' || l_bt_award_amount,142);
1193: hr_utility.set_location(l_proc,142);
1194: ----- Get Award details from the database
1195: get_award_details
1196: ( p_mass_award_id => p_mass_award_id,

Line 1193: hr_utility.set_location(l_proc,142);

1189:
1190: l_bt_award_amount := l_t_award_amount;
1191: l_bt_award_percentage := l_t_award_percentage;
1192: hr_utility.set_location('l_bt_award_amount' || l_bt_award_amount,142);
1193: hr_utility.set_location(l_proc,142);
1194: ----- Get Award details from the database
1195: get_award_details
1196: ( p_mass_award_id => p_mass_award_id,
1197: p_rpa_type => p_rpa_type,

Line 1212: hr_utility.set_location('l_bd_award_amount' || l_bd_award_amount,142);

1208: p_appropriation_code => l_dummy);
1209:
1210: l_bd_award_amount := l_d_award_amount;
1211: l_bd_award_percentage := l_d_award_percentage;
1212: hr_utility.set_location('l_bd_award_amount' || l_bd_award_amount,142);
1213: hr_utility.set_location(l_proc,143);
1214: ----- Get Award details from the shadow
1215: get_award_details_shadow
1216: ( p_pa_request_id => l_pa_request_id,

Line 1213: hr_utility.set_location(l_proc,143);

1209:
1210: l_bd_award_amount := l_d_award_amount;
1211: l_bd_award_percentage := l_d_award_percentage;
1212: hr_utility.set_location('l_bd_award_amount' || l_bd_award_amount,142);
1213: hr_utility.set_location(l_proc,143);
1214: ----- Get Award details from the shadow
1215: get_award_details_shadow
1216: ( p_pa_request_id => l_pa_request_id,
1217: p_award_amount => l_s_award_amount,

Line 1229: hr_utility.set_location('l_bs_award_amount' || l_bs_award_amount,142);

1225: p_appropriation_code => l_dummy );
1226:
1227: l_bs_award_amount := l_s_award_amount;
1228: l_bs_award_percentage := l_s_award_percentage;
1229: hr_utility.set_location('l_bs_award_amount' || l_bs_award_amount,142);
1230:
1231: hr_utility.set_location(l_proc,144);
1232: set_ei
1233: (p_shadow => l_s_award_amount,

Line 1231: hr_utility.set_location(l_proc,144);

1227: l_bs_award_amount := l_s_award_amount;
1228: l_bs_award_percentage := l_s_award_percentage;
1229: hr_utility.set_location('l_bs_award_amount' || l_bs_award_amount,142);
1230:
1231: hr_utility.set_location(l_proc,144);
1232: set_ei
1233: (p_shadow => l_s_award_amount,
1234: p_template => l_t_award_amount,
1235: p_person => l_d_award_amount);

Line 1267: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);

1263: l_pa_request_rec.award_amount := l_d_award_amount;
1264: l_pa_request_rec.award_uom := l_d_award_uom;
1265: l_pa_request_rec.award_percentage := l_d_award_percentage;
1266:
1267: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);
1268: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);
1269: -- End Sundar Test
1270:
1271: -- Bug 3376761

Line 1268: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);

1264: l_pa_request_rec.award_uom := l_d_award_uom;
1265: l_pa_request_rec.award_percentage := l_d_award_percentage;
1266:
1267: hr_utility.set_location('l_pa_request_rec.award_amount' || l_pa_request_rec.award_amount,111);
1268: hr_utility.set_location('l_pa_request_rec.award_salary' || l_pa_request_rec.award_salary,111);
1269: -- End Sundar Test
1270:
1271: -- Bug 3376761
1272: -- check to see if the award amount is within 25% of basic pay

Line 1282: hr_utility.set_location('In MAR PA Bef Upd'||l_pa_request_rec.award_amount ,35);

1278: l_pa_request_rec.mass_action_comments := l_pa_request_rec.mass_action_comments || '; Award percentage cannot be greater than 25% of the basic annual pay.' ;
1279: END IF;
1280: END IF;
1281: */
1282: hr_utility.set_location('In MAR PA Bef Upd'||l_pa_request_rec.award_amount ,35);
1283: --Pradeep Commented the above and added the below for bug 3934195
1284: l_error_flag := FALSE;
1285: check_award_amount (p_noa_code => l_pa_request_rec.first_noa_code,
1286: p_effective_date => l_pa_request_rec.effective_date,

Line 1306: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);

1302: END IF;
1303:
1304: --END OF Bug 3376761 .
1305:
1306: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);
1307: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);
1308:
1309: begin
1310: l_log_text := 'Error while Updating the PA Request Rec. ';

Line 1307: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);

1303:
1304: --END OF Bug 3376761 .
1305:
1306: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);
1307: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);
1308:
1309: begin
1310: l_log_text := 'Error while Updating the PA Request Rec. ';
1311: g_log_text := 'Error while Updating the PA Request Rec. ';

Line 1526: hr_utility.set_location(l_proc,153);

1522: ,p_mass_action_select_flag => NVL(l_mass_action_select_flag,'Y')
1523: );
1524: exception
1525: WHEN OTHERS THEN
1526: hr_utility.set_location(l_proc,153);
1527: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1528: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1529: raise ma_rpaerror;
1530: end;

Line 1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);

1528: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1529: raise ma_rpaerror;
1530: end;
1531:
1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);

Line 1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);

1529: raise ma_rpaerror;
1530: end;
1531:
1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1537: hr_utility.set_location(l_proc,156);

Line 1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);

1530: end;
1531:
1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1537: hr_utility.set_location(l_proc,156);
1538: begin

Line 1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);

1531:
1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1537: hr_utility.set_location(l_proc,156);
1538: begin
1539: l_log_text := p_action_type || '-Error After updating the RPA before upd ';

Line 1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);

1532: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1537: hr_utility.set_location(l_proc,156);
1538: begin
1539: l_log_text := p_action_type || '-Error After updating the RPA before upd ';
1540: g_log_text := p_action_type || '-Error After updating the RPA before upd ';

Line 1537: hr_utility.set_location(l_proc,156);

1533: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1534: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1535: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1536: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1537: hr_utility.set_location(l_proc,156);
1538: begin
1539: l_log_text := p_action_type || '-Error After updating the RPA before upd ';
1540: g_log_text := p_action_type || '-Error After updating the RPA before upd ';
1541: ghr_par_upd.upd(

Line 1550: hr_utility.set_location(l_proc,153);

1546: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
1547: p_from_office_symbol => l_pa_request_rec.from_office_symbol);
1548: exception
1549: WHEN OTHERS THEN
1550: hr_utility.set_location(l_proc,153);
1551: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1552: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1553: raise ma_rpaerror;
1554: end;

Line 1556: hr_utility.set_location(l_proc,158);

1552: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1553: raise ma_rpaerror;
1554: end;
1555:
1556: hr_utility.set_location(l_proc,158);
1557: l_pa_request_rec.award_amount := l_s_award_amount;
1558: l_pa_request_rec.award_uom := l_s_award_uom;
1559: l_pa_request_rec.award_percentage := l_s_award_percentage;
1560:

Line 1566: hr_utility.set_location('Shadow updated ..'|| l_proc,158);

1562: l_pa_request_rec.object_version_number := l_object_version_number;
1563: update_shadow_row (p_rpa_data => l_pa_request_rec,
1564: p_result => l_result);
1565: if l_result then
1566: hr_utility.set_location('Shadow updated ..'|| l_proc,158);
1567: else
1568: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1569: end if;
1570:

Line 1568: hr_utility.set_location('Shadow not found..'|| l_proc,158);

1564: p_result => l_result);
1565: if l_result then
1566: hr_utility.set_location('Shadow updated ..'|| l_proc,158);
1567: else
1568: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1569: end if;
1570:
1571: hr_utility.set_location(l_proc,160);
1572: refresh_award_details

Line 1571: hr_utility.set_location(l_proc,160);

1567: else
1568: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1569: end if;
1570:
1571: hr_utility.set_location(l_proc,160);
1572: refresh_award_details
1573: (
1574: p_mass_award_id => p_mass_award_id,
1575: p_rpa_type => p_rpa_type,

Line 1583: hr_utility.set_location('Leaving ...' || l_proc,161);

1579:
1580: p_pa_request_rec := l_pa_request_rec;
1581: p_log_text := l_log_text;
1582:
1583: hr_utility.set_location('Leaving ...' || l_proc,161);
1584:
1585: END IF; ------ Creation of SF52 and Update of SF52
1586: END IF;
1587: exception when ma_rpaerror then

Line 1594: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),162);

1590: raise;
1591: when others then
1592: p_pa_request_rec := l_pa_request_rec;
1593: p_log_text := l_log_text;
1594: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),162);
1595: l_log_text := p_action_type || '-Error raised in marpa process others ';
1596: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1597: raise ma_rpaerror;
1598: end;

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

1732: loop
1733: l_maw_name := cur_maw_name_rec.name;
1734: end loop;
1735:
1736: hr_utility.set_location('Entering ' || l_proc,5);
1737: l_savepoint := 'P';
1738: savepoint build_rpa_save_preview;
1739: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);
1740: -- The following would be null while creating rpa.

Line 1739: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);

1735:
1736: hr_utility.set_location('Entering ' || l_proc,5);
1737: l_savepoint := 'P';
1738: savepoint build_rpa_save_preview;
1739: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);
1740: -- The following would be null while creating rpa.
1741:
1742: l_pa_request_rec.additional_info_person_id := NULL;
1743: l_pa_request_rec.additional_info_tel_number := NULL;

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

1771: ---l_pa_request_rec.to_adj_basic_pay := 0;
1772: ---l_pa_request_rec.to_basic_pay := 0; --APP-37206 CPDF Edit #370.25.2
1773: ---l_pa_request_rec.to_total_salary := 0;
1774:
1775: hr_utility.set_location(l_proc,10);
1776: l_pa_request_rec.mass_action_id := p_mass_award_id;
1777: l_pa_request_rec.rpa_type := p_rpa_type;
1778: l_pa_request_rec.effective_date := p_effective_date;
1779: l_pa_request_rec.person_id := p_person_id;

Line 1791: hr_utility.set_location(l_proc,15);

1787: l_pa_request_rec.noa_family_code :=
1788: ghr_pa_requests_pkg.get_noa_pm_family
1789: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1790:
1791: hr_utility.set_location(l_proc,15);
1792: get_noa_code_desc
1793: ( p_noa_id => l_pa_request_rec.first_noa_id,
1794: p_effective_date => p_effective_date,
1795: p_noa_code => l_pa_request_rec.first_noa_code,

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

1794: p_effective_date => p_effective_date,
1795: p_noa_code => l_pa_request_rec.first_noa_code,
1796: p_noa_desc => l_pa_request_rec.first_noa_desc );
1797:
1798: hr_utility.set_location(l_proc,20);
1799: ghr_pa_requests_pkg.get_person_details
1800: (p_person_id => p_person_id
1801: ,p_effective_date => p_effective_date
1802: ,p_national_identifier => l_pa_request_rec.employee_national_identifier

Line 1817: hr_utility.set_location(l_proc,25);

1813: (p_person_id => p_person_id,
1814: p_effective_date => p_effective_date);
1815: End if;
1816:
1817: hr_utility.set_location(l_proc,25);
1818: ghr_api.sf52_from_data_elements
1819: (p_person_id => p_person_id
1820: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1821: ,p_effective_date => p_effective_date

Line 1870: hr_utility.set_location(l_proc,30);

1866: -- FWFA Changes
1867: ,p_work_schedule => l_pa_request_rec.work_schedule
1868: );
1869:
1870: hr_utility.set_location(l_proc,30);
1871: hr_utility.set_location('Bef Get Aw Det'||l_pa_request_rec.award_amount ,31);
1872: ----- Get Award details from the template and also extra information
1873: get_award_details
1874: ( p_mass_award_id => p_mass_award_id,

Line 1871: hr_utility.set_location('Bef Get Aw Det'||l_pa_request_rec.award_amount ,31);

1867: ,p_work_schedule => l_pa_request_rec.work_schedule
1868: );
1869:
1870: hr_utility.set_location(l_proc,30);
1871: hr_utility.set_location('Bef Get Aw Det'||l_pa_request_rec.award_amount ,31);
1872: ----- Get Award details from the template and also extra information
1873: get_award_details
1874: ( p_mass_award_id => p_mass_award_id,
1875: p_rpa_type => 'TA',

Line 1893: hr_utility.set_location('Aft Get Aw Det'||l_pa_request_rec.award_amount ,31);

1889: l_pa_request_rec.award_uom := l_t_award_uom;
1890: l_pa_request_rec.award_percentage := l_t_award_percentage;
1891: l_bt_award_amount := l_t_award_amount;
1892: l_bt_award_percentage := l_t_award_percentage;
1893: hr_utility.set_location('Aft Get Aw Det'||l_pa_request_rec.award_amount ,31);
1894: -- Begin Bug# 4748927
1895: /* l_from_basic_pay_pa :=
1896: ghr_pay_calc.convert_amount(l_pa_request_rec.from_basic_pay
1897: ,l_pa_request_rec.from_pay_basis,'PA');*/

Line 1899: hr_utility.set_location(l_proc,35);

1895: /* l_from_basic_pay_pa :=
1896: ghr_pay_calc.convert_amount(l_pa_request_rec.from_basic_pay
1897: ,l_pa_request_rec.from_pay_basis,'PA');*/
1898: --End Bug# 4748927
1899: hr_utility.set_location(l_proc,35);
1900: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1901:
1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1903: (p_location_id => l_duty_station_location_id

Line 1931: hr_utility.set_location(l_proc,40);

1927: l_pa_request_rec.to_position_org_line4 := l_pa_request_rec.from_position_org_line4;
1928: l_pa_request_rec.to_position_org_line5 := l_pa_request_rec.from_position_org_line5;
1929: l_pa_request_rec.to_position_org_line6 := l_pa_request_rec.from_position_org_line6;
1930:
1931: hr_utility.set_location(l_proc,40);
1932: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1933: (p_position_id => p_position_id
1934: ,p_date_Effective => l_pa_request_rec.effective_date
1935: ,p_flsa_category => l_pa_request_rec.flsa_category

Line 1948: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);

1944: ,p_office_symbol => l_pa_request_rec.from_office_symbol
1945: ,p_part_time_hours => l_dummy
1946: );
1947:
1948: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1952:

Line 1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);

1945: ,p_part_time_hours => l_dummy
1946: );
1947:
1948: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1952:
1953: hr_utility.set_location(l_proc,45);

Line 1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);

1946: );
1947:
1948: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1952:
1953: hr_utility.set_location(l_proc,45);
1954: get_business_group

Line 1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);

1947:
1948: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1952:
1953: hr_utility.set_location(l_proc,45);
1954: get_business_group
1955: (p_person_id => p_person_id

Line 1953: hr_utility.set_location(l_proc,45);

1949: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1950: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1951: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1952:
1953: hr_utility.set_location(l_proc,45);
1954: get_business_group
1955: (p_person_id => p_person_id
1956: ,p_effective_date => p_effective_date
1957: ,p_business_group_id => l_business_group_id

Line 1960: hr_utility.set_location(l_proc,50);

1956: ,p_effective_date => p_effective_date
1957: ,p_business_group_id => l_business_group_id
1958: );
1959:
1960: hr_utility.set_location(l_proc,50);
1961: l_pa_request_rec.agency_code := ghr_api.get_position_agency_code_pos
1962: (p_position_id => p_position_id
1963: ,p_business_group_id => l_business_group_id
1964: ,p_effective_date => p_effective_date

Line 1966: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);

1962: (p_position_id => p_position_id
1963: ,p_business_group_id => l_business_group_id
1964: ,p_effective_date => p_effective_date
1965: );
1966: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1967:
1968: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1969: (800
1970: ,'GHR_US_AGENCY_CODE'

Line 1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);

1970: ,'GHR_US_AGENCY_CODE'
1971: ,l_pa_request_rec.agency_code
1972: );
1973:
1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);
1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);

Line 1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);

1971: ,l_pa_request_rec.agency_code
1972: );
1973:
1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);
1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);
1979:

Line 1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);

1972: );
1973:
1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);
1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);
1979:
1980: -- Bug 5041967 Sundar

Line 1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);

1973:
1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);
1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);
1979:
1980: -- Bug 5041967 Sundar
1981: ghr_history_fetch.fetch_asgei(

Line 1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);

1974: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,52);
1975: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1976: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1977: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1978: hr_utility.set_location('l_pa_request_rec.award_amount '||l_pa_request_rec.award_amount ,52);
1979:
1980: -- Bug 5041967 Sundar
1981: ghr_history_fetch.fetch_asgei(
1982: p_assignment_id => l_pa_request_rec.employee_assignment_id,

Line 2007: hr_utility.set_location('Bef MAR PA '||l_pa_request_rec.award_amount ,32);

2003: -- End Bug 5041967 Sundar
2004:
2005: -----------Created marpa_process procedure Call
2006: begin
2007: hr_utility.set_location('Bef MAR PA '||l_pa_request_rec.award_amount ,32);
2008: marpa_process
2009: (
2010: p_mass_award_id => p_mass_award_id
2011: ,p_action_type => p_action_type

Line 2020: hr_utility.set_location('After MAR PA '||l_pa_request_rec.award_amount ,33);

2016: ,p_log_text => l_log_text
2017: ,p_maxcheck => p_maxcheck
2018: );
2019:
2020: hr_utility.set_location('After MAR PA '||l_pa_request_rec.award_amount ,33);
2021: commit;
2022: hr_utility.set_location('commit to have eligibility build_rpa_save_preview ' ,162);
2023: l_savepoint := 'P';
2024: savepoint build_rpa_save_preview;

Line 2022: hr_utility.set_location('commit to have eligibility build_rpa_save_preview ' ,162);

2018: );
2019:
2020: hr_utility.set_location('After MAR PA '||l_pa_request_rec.award_amount ,33);
2021: commit;
2022: hr_utility.set_location('commit to have eligibility build_rpa_save_preview ' ,162);
2023: l_savepoint := 'P';
2024: savepoint build_rpa_save_preview;
2025: hr_utility.set_location('savepoint build_rpa_save_preview - After Preview ' ,162);
2026: exception when ma_rpaerror then raise;

Line 2025: hr_utility.set_location('savepoint build_rpa_save_preview - After Preview ' ,162);

2021: commit;
2022: hr_utility.set_location('commit to have eligibility build_rpa_save_preview ' ,162);
2023: l_savepoint := 'P';
2024: savepoint build_rpa_save_preview;
2025: hr_utility.set_location('savepoint build_rpa_save_preview - After Preview ' ,162);
2026: exception when ma_rpaerror then raise;
2027: when others then raise ma_rpaerror;
2028: end;
2029:

Line 2034: hr_utility.set_location(l_proc,163);

2030: -------commit;
2031: ---------------------Starting Final
2032: ---Recent Modification - Group box id must be commited in order to get call work flow
2033:
2034: hr_utility.set_location(l_proc,163);
2035: -- Employee Data
2036:
2037: get_pa_request_id_ovn
2038: ( p_mass_award_id => p_mass_award_id,

Line 2053: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);

2049: ------ Modified in 115.9
2050: l_pa_request_rec.mass_action_comments := l_mass_action_comments;
2051: l_pa_request_rec.object_version_number := l_object_version_number;
2052: l_pa_request_rec.pa_request_id := l_pa_request_id;
2053: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
2054: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
2055:
2056: -------
2057: if l_rpa_type is null then l_rpa_type := 'A'; end if;

Line 2054: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);

2050: l_pa_request_rec.mass_action_comments := l_mass_action_comments;
2051: l_pa_request_rec.object_version_number := l_object_version_number;
2052: l_pa_request_rec.pa_request_id := l_pa_request_id;
2053: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
2054: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
2055:
2056: -------
2057: if l_rpa_type is null then l_rpa_type := 'A'; end if;
2058:

Line 2070: hr_utility.set_location('Getting Group Box ' || l_proc,170);

2066: l_1_prh_object_version_number := l_i_prh_object_version_number;
2067: end if;
2068:
2069: begin
2070: hr_utility.set_location('Getting Group Box ' || l_proc,170);
2071:
2072: ghr_mass_actions_pkg.get_personnel_off_groupbox
2073: (p_position_id => p_position_id
2074: ,p_effective_date => p_effective_date

Line 2077: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);

2073: (p_position_id => p_position_id
2074: ,p_effective_date => p_effective_date
2075: ,p_groupbox_id => l_groupbox_id
2076: ,p_routing_group_id => l_routing_group_id );
2077: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
2078: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
2079: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
2080:
2081: exception

Line 2078: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);

2074: ,p_effective_date => p_effective_date
2075: ,p_groupbox_id => l_groupbox_id
2076: ,p_routing_group_id => l_routing_group_id );
2077: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
2078: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
2079: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
2080:
2081: exception
2082: WHEN OTHERS THEN

Line 2079: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);

2075: ,p_groupbox_id => l_groupbox_id
2076: ,p_routing_group_id => l_routing_group_id );
2077: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
2078: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
2079: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
2080:
2081: exception
2082: WHEN OTHERS THEN
2083: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);

Line 2083: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);

2079: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
2080:
2081: exception
2082: WHEN OTHERS THEN
2083: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);
2084: l_log_text := 'Error in POI groupbox ' ||' Sql error : '||sqlerrm(sqlcode);
2085:
2086: -- Call ghr_par_upd.upd here
2087:

Line 2098: hr_utility.set_location('Updating prh ' || l_proc,175);

2094: l_prh_object_version_number := routing_history_id.object_version_number;
2095: exit;
2096: end loop;
2097:
2098: hr_utility.set_location('Updating prh ' || l_proc,175);
2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);

Line 2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);

2095: exit;
2096: end loop;
2097:
2098: hr_utility.set_location('Updating prh ' || l_proc,175);
2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
2103:

Line 2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);

2096: end loop;
2097:
2098: hr_utility.set_location('Updating prh ' || l_proc,175);
2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
2103:
2104: ghr_prh_upd.upd(

Line 2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);

2097:
2098: hr_utility.set_location('Updating prh ' || l_proc,175);
2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
2103:
2104: ghr_prh_upd.upd(
2105: p_pa_routing_history_id => l_pa_routing_history_id,

Line 2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);

2098: hr_utility.set_location('Updating prh ' || l_proc,175);
2099: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
2100: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
2101: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
2102: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
2103:
2104: ghr_prh_upd.upd(
2105: p_pa_routing_history_id => l_pa_routing_history_id,
2106: p_groupbox_id => l_groupbox_id,

Line 2109: hr_utility.set_location('Updating par ' || l_proc,180);

2105: p_pa_routing_history_id => l_pa_routing_history_id,
2106: p_groupbox_id => l_groupbox_id,
2107: p_object_version_number => l_prh_object_version_number);
2108:
2109: hr_utility.set_location('Updating par ' || l_proc,180);
2110:
2111: -- Call ghr_par_upd.upd here
2112: ghr_par_upd.upd(
2113: p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2127: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);

2123: ,l_pa_request_rec.from_pay_basis,'PA');
2124:
2125:
2126: commit;
2127: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
2128: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
2129: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
2130:
2131: ---- Recent Modification End;

Line 2128: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);

2124:
2125:
2126: commit;
2127: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
2128: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
2129: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
2130:
2131: ---- Recent Modification End;
2132:

Line 2129: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);

2125:
2126: commit;
2127: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
2128: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
2129: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
2130:
2131: ---- Recent Modification End;
2132:
2133: l_savepoint := 'F';

Line 2135: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);

2131: ---- Recent Modification End;
2132:
2133: l_savepoint := 'F';
2134: savepoint build_rpa_save_final;
2135: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
2136: hr_utility.set_location(l_proc,52);
2137: hr_utility.set_location('Bef Check Award Amt'||l_pa_request_rec.award_amount ,34);
2138: /*
2139: IF l_pa_request_rec.award_amount > ROUND(l_from_basic_pay_pa * 0.25 , 0) THEN

Line 2136: hr_utility.set_location(l_proc,52);

2132:
2133: l_savepoint := 'F';
2134: savepoint build_rpa_save_final;
2135: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
2136: hr_utility.set_location(l_proc,52);
2137: hr_utility.set_location('Bef Check Award Amt'||l_pa_request_rec.award_amount ,34);
2138: /*
2139: IF l_pa_request_rec.award_amount > ROUND(l_from_basic_pay_pa * 0.25 , 0) THEN
2140: RAISE ma_awdpererr;

Line 2137: hr_utility.set_location('Bef Check Award Amt'||l_pa_request_rec.award_amount ,34);

2133: l_savepoint := 'F';
2134: savepoint build_rpa_save_final;
2135: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
2136: hr_utility.set_location(l_proc,52);
2137: hr_utility.set_location('Bef Check Award Amt'||l_pa_request_rec.award_amount ,34);
2138: /*
2139: IF l_pa_request_rec.award_amount > ROUND(l_from_basic_pay_pa * 0.25 , 0) THEN
2140: RAISE ma_awdpererr;
2141: END IF ;

Line 2217: hr_utility.set_location(l_proc,55);

2213: );
2214:
2215: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
2216: -- Bug#3648118 Changes completed.
2217: hr_utility.set_location(l_proc,55);
2218: ghr_pa_requests_pkg.get_SF52_person_ddf_details
2219: (p_person_id => l_pa_request_rec.person_id,
2220: p_date_effective => l_pa_request_rec.effective_date,
2221: p_citizenship => l_pa_request_rec.citizenship,

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

2225: p_scd_leave => l_scd_leave
2226: );
2227:
2228: -- populate service comp date
2229: hr_utility.set_location(l_proc,60);
2230: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
2231:
2232: -- get education details
2233: hr_utility.set_location(l_proc,70);

Line 2233: hr_utility.set_location(l_proc,70);

2229: hr_utility.set_location(l_proc,60);
2230: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
2231:
2232: -- get education details
2233: hr_utility.set_location(l_proc,70);
2234: ghr_api.return_education_Details
2235: (p_person_id => l_pa_request_rec.person_id,
2236: p_effective_date => l_pa_request_rec.effective_date,
2237: p_education_level => l_pa_request_rec.education_level,

Line 2242: hr_utility.set_location(l_proc,80);

2238: p_academic_discipline => l_pa_request_rec.academic_discipline,
2239: p_year_degree_attained => l_pa_request_rec.year_degree_attained
2240: );
2241:
2242: hr_utility.set_location(l_proc,80);
2243: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
2244: (p_assignment_id => l_pa_request_rec.employee_assignment_id
2245: ,p_date_effective => l_pa_request_rec.effective_date
2246: ,p_tenure => l_pa_request_rec.tenure

Line 2269: hr_utility.set_location(l_proc,90);

2265: );
2266:
2267: -- get fegli,retirement_plan
2268:
2269: hr_utility.set_location(l_proc,90);
2270: ghr_api.retrieve_element_entry_value
2271: (p_element_name => 'FEGLI'
2272: ,p_input_value_name => 'FEGLI'
2273: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

Line 2287: hr_utility.set_location(l_proc,100);

2283: );
2284:
2285:
2286: --retirement_plan
2287: hr_utility.set_location(l_proc,100);
2288: ghr_api.retrieve_element_entry_value
2289: (p_element_name => 'Retirement Plan'
2290: ,p_input_value_name => 'Plan'
2291: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

Line 2304: hr_utility.set_location(l_proc,110);

2300: ,l_pa_request_rec.retirement_plan
2301: );
2302:
2303: -- Descriptions for the codes passed in
2304: hr_utility.set_location(l_proc,110);
2305: ghr_mass_actions_pkg.get_personnel_officer_name
2306: (p_personnel_office_id => l_pa_request_rec.personnel_office_id,
2307: p_person_full_name => l_personnel_officer_name,
2308: p_approving_off_work_title => l_approving_off_work_title);

Line 2319: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,110);

2315: l_pa_request_rec.request_number := l_pa_request_num_prefix ||
2316: to_char(l_pa_request_rec.pa_request_id);
2317:
2318:
2319: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,110);
2320: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),110);
2321: -----------Created marpa_process procedure Call
2322: ---- To print NPA correctly ..bug..2356373.
2323:

Line 2320: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),110);

2316: to_char(l_pa_request_rec.pa_request_id);
2317:
2318:
2319: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,110);
2320: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),110);
2321: -----------Created marpa_process procedure Call
2322: ---- To print NPA correctly ..bug..2356373.
2323:
2324: l_pa_request_rec.sf50_approving_ofcl_full_name := l_personnel_officer_name;

Line 2345: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);

2341: exception when ma_rpaerror then raise;
2342: when others then raise ma_rpaerror;
2343: end;
2344:
2345: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
2346: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
2347:
2348: hr_utility.set_location('Creating Remarks ' || l_proc,165);
2349: create_remarks

Line 2346: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);

2342: when others then raise ma_rpaerror;
2343: end;
2344:
2345: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
2346: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
2347:
2348: hr_utility.set_location('Creating Remarks ' || l_proc,165);
2349: create_remarks
2350: (p_mass_award_id => p_mass_award_id

Line 2348: hr_utility.set_location('Creating Remarks ' || l_proc,165);

2344:
2345: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
2346: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
2347:
2348: hr_utility.set_location('Creating Remarks ' || l_proc,165);
2349: create_remarks
2350: (p_mass_award_id => p_mass_award_id
2351: ,p_rpa_type => 'TA'
2352: ,p_effective_date => p_effective_date

Line 2355: hr_utility.set_location('Creating Remarks Over ' || l_proc,165);

2351: ,p_rpa_type => 'TA'
2352: ,p_effective_date => p_effective_date
2353: ,p_pa_request_id => l_pa_request_rec.pa_request_id
2354: );
2355: hr_utility.set_location('Creating Remarks Over ' || l_proc,165);
2356:
2357:
2358: if p_effective_date > sysdate then
2359: l_rpa_action := 'FUTURE_ACTION';

Line 2364: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

2360: else
2361: l_rpa_action := 'UPDATE_HR';
2362: end if;
2363:
2364: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2365:
2366: ---Bug 2356373
2367: ghr_par_upd.upd
2368: (p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

2375: p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
2376: );
2377: ---Bug 2356373 End
2378:
2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2380:
2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

Line 2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);

2377: ---Bug 2356373 End
2378:
2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2380:
2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
2384:
2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);

Line 2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);

2378:
2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2380:
2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
2384:
2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);
2386: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,185);

Line 2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2380:
2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
2384:
2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);
2386: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,185);
2387: ------

Line 2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);

2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
2384:
2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);
2386: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,185);
2387: ------
2388:
2389: ----Update Sf52 for Personnel Action

Line 2386: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,185);

2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
2384:
2385: hr_utility.set_location('employee_dept_or_agency ' || l_pa_request_rec.employee_dept_or_agency ,185);
2386: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,185);
2387: ------
2388:
2389: ----Update Sf52 for Personnel Action
2390: begin

Line 2408: hr_utility.set_location(sqlerrm(sqlcode),1);

2404: p_i_pa_routing_history_id => l_i_pa_routing_history_id,
2405: p_i_prh_object_version_number => l_i_prh_object_version_number);
2406: exception
2407: WHEN OTHERS THEN
2408: hr_utility.set_location(sqlerrm(sqlcode),1);
2409: hr_utility.set_location('Update sf52 final Failure ' || l_proc,190);
2410: l_log_text := 'Error in Update sf52 final ' ||' Sql error : '||sqlerrm(sqlcode);
2411: raise rpaerror;
2412: end;

Line 2409: hr_utility.set_location('Update sf52 final Failure ' || l_proc,190);

2405: p_i_prh_object_version_number => l_i_prh_object_version_number);
2406: exception
2407: WHEN OTHERS THEN
2408: hr_utility.set_location(sqlerrm(sqlcode),1);
2409: hr_utility.set_location('Update sf52 final Failure ' || l_proc,190);
2410: l_log_text := 'Error in Update sf52 final ' ||' Sql error : '||sqlerrm(sqlcode);
2411: raise rpaerror;
2412: end;
2413:

Line 2414: hr_utility.set_location('Action after ' || l_rpa_action || ' ' || l_proc,200);

2410: l_log_text := 'Error in Update sf52 final ' ||' Sql error : '||sqlerrm(sqlcode);
2411: raise rpaerror;
2412: end;
2413:
2414: hr_utility.set_location('Action after ' || l_rpa_action || ' ' || l_proc,200);
2415: p_status := 'SUCCESS';
2416: p_retcode := 0;
2417: l_log_text := 'Last Name: '|| l_pa_request_rec.employee_last_name ||
2418: 'Emp No: '|| l_employee_number ||

Line 2435: hr_utility.set_location('Manual rpa_type ' || l_proc,200);

2431: ELSE
2432: IF l_rpa_type = 'M' then
2433: p_status := 'MANUAL';
2434: p_retcode := 0;
2435: hr_utility.set_location('Manual rpa_type ' || l_proc,200);
2436: ELSIF l_mass_action_select_flag = 'N'
2437: and l_status = 'DESELECTED PRG:' THEN
2438: hr_utility.set_location('Deselected by programatically' || l_proc,200);
2439: p_errbuf := 'DESELECTED PRG:';

Line 2438: hr_utility.set_location('Deselected by programatically' || l_proc,200);

2434: p_retcode := 0;
2435: hr_utility.set_location('Manual rpa_type ' || l_proc,200);
2436: ELSIF l_mass_action_select_flag = 'N'
2437: and l_status = 'DESELECTED PRG:' THEN
2438: hr_utility.set_location('Deselected by programatically' || l_proc,200);
2439: p_errbuf := 'DESELECTED PRG:';
2440: p_retcode := 0;
2441: ELSIF l_mass_action_select_flag = 'N' then
2442: hr_utility.set_location('Deselected by user ' || l_proc,200);

Line 2442: hr_utility.set_location('Deselected by user ' || l_proc,200);

2438: hr_utility.set_location('Deselected by programatically' || l_proc,200);
2439: p_errbuf := 'DESELECTED PRG:';
2440: p_retcode := 0;
2441: ELSIF l_mass_action_select_flag = 'N' then
2442: hr_utility.set_location('Deselected by user ' || l_proc,200);
2443: p_status := 'DESELECTED';
2444: p_retcode := 0;
2445: ELSE
2446: hr_utility.set_location('Already Processed ' || l_proc,200);

Line 2446: hr_utility.set_location('Already Processed ' || l_proc,200);

2442: hr_utility.set_location('Deselected by user ' || l_proc,200);
2443: p_status := 'DESELECTED';
2444: p_retcode := 0;
2445: ELSE
2446: hr_utility.set_location('Already Processed ' || l_proc,200);
2447: p_status := 'PROCESSED';
2448: p_retcode := 0;
2449: END IF;
2450: END IF; ----- For l_pa_notification_id is null and rpa_type = 'A'

Line 2456: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);

2452:
2453: Exception
2454: When groupboxerr then
2455: rollback to build_rpa_save_preview;
2456: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);
2457:
2458: -- Call ghr_par_upd.upd here
2459: begin
2460:

Line 2483: hr_utility.set_location('Error occured in group box ' || l_proc , 1);

2479: exception when others then
2480: l_log_text := substr(l_log_text || ' , Failed in Deselecting, ' ||' Sql error : '||sqlerrm(sqlcode),1,2000);
2481: end;
2482:
2483: hr_utility.set_location('Error occured in group box ' || l_proc , 1);
2484: IF l_log_text is NULL THEN
2485: l_log_text := 'Error while creating / Updating the PA Request Rec.';
2486: END IF;
2487:

Line 2492: hr_utility.set_location('before creating entry in log file',2);

2488: p_retcode := 1;
2489: p_status := 'GROUPBOX';
2490: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
2491:
2492: hr_utility.set_location('before creating entry in log file',2);
2493: -- Bug#3718167 Added SSN in the log text below
2494: --Bug # 9329643 Modified SSN to Emp No
2495: l_log_text := substr(',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2496: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2506: hr_utility.set_location('Groupbox Error ',2);

2502: p_message_name => substr(l_maw_name || '-' || 'GB Err',1,30),
2503: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2504: p_log_date => sysdate);
2505:
2506: hr_utility.set_location('Groupbox Error ',2);
2507: hr_utility.set_location('created entry in log file',2);
2508: commit;
2509:
2510: When rpaerror then

Line 2507: hr_utility.set_location('created entry in log file',2);

2503: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2504: p_log_date => sysdate);
2505:
2506: hr_utility.set_location('Groupbox Error ',2);
2507: hr_utility.set_location('created entry in log file',2);
2508: commit;
2509:
2510: When rpaerror then
2511:

Line 2514: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);

2510: When rpaerror then
2511:
2512: if l_savepoint = 'F' THEN
2513: rollback to build_rpa_save_final;
2514: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);
2515: else
2516: rollback to build_rpa_save_preview;
2517: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
2518: end if;

Line 2517: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);

2513: rollback to build_rpa_save_final;
2514: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);
2515: else
2516: rollback to build_rpa_save_preview;
2517: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
2518: end if;
2519:
2520: hr_utility.set_location('Error occured Final Sf52 ' || l_proc , 1);
2521: IF l_log_text is NULL THEN

Line 2520: hr_utility.set_location('Error occured Final Sf52 ' || l_proc , 1);

2516: rollback to build_rpa_save_preview;
2517: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
2518: end if;
2519:
2520: hr_utility.set_location('Error occured Final Sf52 ' || l_proc , 1);
2521: IF l_log_text is NULL THEN
2522: l_log_text := 'Error while creating / Updating the PA Request Rec.';
2523: END IF;
2524:

Line 2529: hr_utility.set_location('before creating entry in log file',2);

2525: p_retcode := 1;
2526: p_status := 'FAILURE';
2527: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
2528:
2529: hr_utility.set_location('before creating entry in log file',2);
2530: -- Bug#3718167 Added SSN in the following log text
2531: --Bug # 9329643 Modified SSN to Emp No
2532: l_log_text := substr(',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2533: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2542: hr_utility.set_location('FINAL SF52 Error ',2);

2538: p_message_name => substr(l_maw_name || '-' || 'RPA Err',1,30),
2539: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2540: p_log_date => sysdate);
2541:
2542: hr_utility.set_location('FINAL SF52 Error ',2);
2543: hr_utility.set_location('created entry in log file',2);
2544:
2545: hr_utility.set_location('Calling workflow begin entry ',3);
2546: mass_awards_error_handling

Line 2543: hr_utility.set_location('created entry in log file',2);

2539: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2540: p_log_date => sysdate);
2541:
2542: hr_utility.set_location('FINAL SF52 Error ',2);
2543: hr_utility.set_location('created entry in log file',2);
2544:
2545: hr_utility.set_location('Calling workflow begin entry ',3);
2546: mass_awards_error_handling
2547: ( p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2545: hr_utility.set_location('Calling workflow begin entry ',3);

2541:
2542: hr_utility.set_location('FINAL SF52 Error ',2);
2543: hr_utility.set_location('created entry in log file',2);
2544:
2545: hr_utility.set_location('Calling workflow begin entry ',3);
2546: mass_awards_error_handling
2547: ( p_pa_request_id => l_pa_request_rec.pa_request_id,
2548: p_object_version_number => l_pa_request_rec.object_version_number,
2549: p_error => l_log_text,

Line 2555: hr_utility.set_location('before creating entry in log file',4);

2551: if l_result then
2552: l_log_text := 'Error while routing to group box in call workflow ';
2553: p_status := 'OTHER';
2554: p_retcode := 1;
2555: hr_utility.set_location('before creating entry in log file',4);
2556: -- Bug#3718167 Added SSN in the following log text
2557: --Bug # 9329643 Modified SSN to Emp No
2558: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2559: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2568: hr_utility.set_location('FINAL SF52 Error - Call Work flow ',4);

2564: p_message_name => substr(l_maw_name || '-' || 'RPA WF',1,30),
2565: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2566: p_log_date => sysdate);
2567:
2568: hr_utility.set_location('FINAL SF52 Error - Call Work flow ',4);
2569: hr_utility.set_location('created entry in log file',4);
2570: end if;
2571: hr_utility.set_location('Calling workflow end entry ',3);
2572:

Line 2569: hr_utility.set_location('created entry in log file',4);

2565: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2566: p_log_date => sysdate);
2567:
2568: hr_utility.set_location('FINAL SF52 Error - Call Work flow ',4);
2569: hr_utility.set_location('created entry in log file',4);
2570: end if;
2571: hr_utility.set_location('Calling workflow end entry ',3);
2572:
2573: commit;

Line 2571: hr_utility.set_location('Calling workflow end entry ',3);

2567:
2568: hr_utility.set_location('FINAL SF52 Error - Call Work flow ',4);
2569: hr_utility.set_location('created entry in log file',4);
2570: end if;
2571: hr_utility.set_location('Calling workflow end entry ',3);
2572:
2573: commit;
2574:
2575: When ma_rpaerror then

Line 2579: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);

2575: When ma_rpaerror then
2576:
2577: if l_savepoint = 'F' THEN
2578: rollback to build_rpa_save_final;
2579: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
2580: else
2581: rollback to build_rpa_save_preview;
2582: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
2583: end if;

Line 2582: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);

2578: rollback to build_rpa_save_final;
2579: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
2580: else
2581: rollback to build_rpa_save_preview;
2582: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
2583: end if;
2584:
2585: hr_utility.set_location('Error occured in ' || l_proc , 1);
2586: IF g_log_text is NOT NULL then

Line 2585: hr_utility.set_location('Error occured in ' || l_proc , 1);

2581: rollback to build_rpa_save_preview;
2582: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
2583: end if;
2584:
2585: hr_utility.set_location('Error occured in ' || l_proc , 1);
2586: IF g_log_text is NOT NULL then
2587: l_log_text := g_log_text;
2588: END IF;
2589: IF l_log_text is NULL THEN

Line 2597: hr_utility.set_location('before creating entry in log file',2);

2593: p_retcode := 1;
2594: p_status := 'FAILURE';
2595: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
2596:
2597: hr_utility.set_location('before creating entry in log file',2);
2598: -- Bug#3718167 Added SSN in the following log text
2599: --Bug # 9329643 Modified SSN to Emp No
2600: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2601: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2611: hr_utility.set_location('Error Others ',2);

2607: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2608: p_log_date => sysdate);
2609:
2610:
2611: hr_utility.set_location('Error Others ',2);
2612: hr_utility.set_location('created entry in log file',2);
2613:
2614: commit;
2615:

Line 2612: hr_utility.set_location('created entry in log file',2);

2608: p_log_date => sysdate);
2609:
2610:
2611: hr_utility.set_location('Error Others ',2);
2612: hr_utility.set_location('created entry in log file',2);
2613:
2614: commit;
2615:
2616: -- Bug 3376761

Line 2624: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);

2620:
2621:
2622: rollback to build_rpa_save_final;
2623:
2624: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
2625:
2626: hr_utility.set_location('Error occured in ' || l_proc , 1);
2627:
2628: --l_log_text := 'APP-GHR-38611 - Award Percentage cannot be greater than 25% of total annual basic pay.';

Line 2626: hr_utility.set_location('Error occured in ' || l_proc , 1);

2622: rollback to build_rpa_save_final;
2623:
2624: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
2625:
2626: hr_utility.set_location('Error occured in ' || l_proc , 1);
2627:
2628: --l_log_text := 'APP-GHR-38611 - Award Percentage cannot be greater than 25% of total annual basic pay.';
2629: l_log_text := l_comments;
2630:

Line 2635: hr_utility.set_location('before creating entry in log file',2);

2631: p_retcode := 1;
2632: p_status := 'FAILURE';
2633: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
2634:
2635: hr_utility.set_location('before creating entry in log file',2);
2636: -- Bug#3718167 Added SSN in the following log text
2637: --Bug # 9329643 Modified SSN to Emp No
2638: l_log_text := substr(',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2639: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2649: hr_utility.set_location('Award percentage Error ',2);

2645: p_message_name => substr(l_maw_name || '-' || 'RPA MA',1,60),
2646: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2647: p_log_date => sysdate);
2648:
2649: hr_utility.set_location('Award percentage Error ',2);
2650: hr_utility.set_location('created entry in log file',2);
2651:
2652: hr_utility.set_location('Calling workflow begin entry ',3);
2653: mass_awards_error_handling

Line 2650: hr_utility.set_location('created entry in log file',2);

2646: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
2647: p_log_date => sysdate);
2648:
2649: hr_utility.set_location('Award percentage Error ',2);
2650: hr_utility.set_location('created entry in log file',2);
2651:
2652: hr_utility.set_location('Calling workflow begin entry ',3);
2653: mass_awards_error_handling
2654: ( p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2652: hr_utility.set_location('Calling workflow begin entry ',3);

2648:
2649: hr_utility.set_location('Award percentage Error ',2);
2650: hr_utility.set_location('created entry in log file',2);
2651:
2652: hr_utility.set_location('Calling workflow begin entry ',3);
2653: mass_awards_error_handling
2654: ( p_pa_request_id => l_pa_request_rec.pa_request_id,
2655: p_object_version_number => l_pa_request_rec.object_version_number,
2656: p_error => l_log_text,

Line 2662: hr_utility.set_location('before creating entry in log file',4);

2658: if l_result then
2659: l_log_text := 'Error while routing to group box in call workflow ';
2660: p_status := 'OTHER';
2661: p_retcode := 1;
2662: hr_utility.set_location('before creating entry in log file',4);
2663: -- Bug#3718167 Added SSN in the following log text
2664: --Bug # 9329643 Modified SSN to Emp No
2665: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2666: l_pa_request_rec.employee_first_name || ' '||l_pa_request_rec.employee_middle_names||

Line 2675: hr_utility.set_location('Award percentage Error - Call Work flow ',4);

2671: p_message_name => substr(l_maw_name || '-' || 'RPA WF',1,30),
2672: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2673: p_log_date => sysdate);
2674:
2675: hr_utility.set_location('Award percentage Error - Call Work flow ',4);
2676: hr_utility.set_location('created entry in log file',4);
2677: end if;
2678: hr_utility.set_location('Calling workflow end entry ',3);
2679:

Line 2676: hr_utility.set_location('created entry in log file',4);

2672: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2673: p_log_date => sysdate);
2674:
2675: hr_utility.set_location('Award percentage Error - Call Work flow ',4);
2676: hr_utility.set_location('created entry in log file',4);
2677: end if;
2678: hr_utility.set_location('Calling workflow end entry ',3);
2679:
2680: commit;

Line 2678: hr_utility.set_location('Calling workflow end entry ',3);

2674:
2675: hr_utility.set_location('Award percentage Error - Call Work flow ',4);
2676: hr_utility.set_location('created entry in log file',4);
2677: end if;
2678: hr_utility.set_location('Calling workflow end entry ',3);
2679:
2680: commit;
2681:
2682: -- End of Bug 3376761

Line 2688: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);

2684: When others then
2685:
2686: if l_savepoint = 'F' THEN
2687: rollback to build_rpa_save_final;
2688: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);
2689: else
2690: rollback to build_rpa_save_preview;
2691: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
2692: end if;

Line 2691: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);

2687: rollback to build_rpa_save_final;
2688: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);
2689: else
2690: rollback to build_rpa_save_preview;
2691: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
2692: end if;
2693:
2694: hr_utility.set_location('Error occured in ' || l_proc , 1);
2695: IF l_log_text is NULL THEN

Line 2694: hr_utility.set_location('Error occured in ' || l_proc , 1);

2690: rollback to build_rpa_save_preview;
2691: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
2692: end if;
2693:
2694: hr_utility.set_location('Error occured in ' || l_proc , 1);
2695: IF l_log_text is NULL THEN
2696: l_log_text := 'Error while creating / Updating the PA Request Rec.';
2697: END IF;
2698:

Line 2703: hr_utility.set_location('before creating entry in log file',2);

2699: p_retcode := 1;
2700: p_status := 'FAILURE';
2701: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
2702:
2703: hr_utility.set_location('before creating entry in log file',2);
2704: -- Bug#3718167 Added SSN to the following log text
2705: --Bug # 9329643 Modified SSN to Emp No
2706: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
2707: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||

Line 2717: hr_utility.set_location('Error Others ',2);

2713: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
2714: p_log_date => sysdate);
2715:
2716:
2717: hr_utility.set_location('Error Others ',2);
2718: hr_utility.set_location('created entry in log file',2);
2719:
2720: commit;
2721:

Line 2718: hr_utility.set_location('created entry in log file',2);

2714: p_log_date => sysdate);
2715:
2716:
2717: hr_utility.set_location('Error Others ',2);
2718: hr_utility.set_location('created entry in log file',2);
2719:
2720: commit;
2721:
2722: end build_rpa_for_mass_awards;

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

2786: AND pa_request_id = p_pa_request_id;
2787:
2788: BEGIN
2789:
2790: hr_utility.set_location('Entering ' || l_proc,5);
2791: FOR cur_rpa_ei_rec in cur_rpa_ei(p_pa_request_id)
2792: LOOP
2793: hr_utility.set_location( l_proc,10);
2794: l_pa_request_extra_info_id := cur_rpa_ei_rec.pa_request_extra_info_id;

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

2789:
2790: hr_utility.set_location('Entering ' || l_proc,5);
2791: FOR cur_rpa_ei_rec in cur_rpa_ei(p_pa_request_id)
2792: LOOP
2793: hr_utility.set_location( l_proc,10);
2794: l_pa_request_extra_info_id := cur_rpa_ei_rec.pa_request_extra_info_id;
2795: l_pa_object_version_number := cur_rpa_ei_rec.object_version_number;
2796: exit;
2797: END LOOP;

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

2797: END LOOP;
2798:
2799: FOR cur_rpa_ei_shadow_rec in cur_rpa_ei_shadow(p_pa_request_id)
2800: LOOP
2801: hr_utility.set_location( l_proc,10);
2802: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
2803: exit;
2804: END LOOP;
2805:

Line 2806: hr_utility.set_location(l_proc,15);

2802: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
2803: exit;
2804: END LOOP;
2805:
2806: hr_utility.set_location(l_proc,15);
2807: ----- Get Award details from the template and also extra information
2808: get_award_details
2809: ( p_mass_award_id => p_mass_award_id,
2810: p_rpa_type => 'TA',

Line 2823: hr_utility.set_location('p_award_amount - l_dummy' || l_dummy,20);

2819: p_tangible_benefit_dollars => l_t_tbd,
2820: p_date_award_earned => l_t_date_award_earn,
2821: p_appropriation_code => l_t_appropriation_code);
2822:
2823: hr_utility.set_location('p_award_amount - l_dummy' || l_dummy,20);
2824: hr_utility.set_location(l_proc,20);
2825: ----- Get Award details for the employee existing in the database
2826: get_award_details
2827: ( p_mass_award_id => p_mass_award_id,

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

2820: p_date_award_earned => l_t_date_award_earn,
2821: p_appropriation_code => l_t_appropriation_code);
2822:
2823: hr_utility.set_location('p_award_amount - l_dummy' || l_dummy,20);
2824: hr_utility.set_location(l_proc,20);
2825: ----- Get Award details for the employee existing in the database
2826: get_award_details
2827: ( p_mass_award_id => p_mass_award_id,
2828: p_rpa_type => p_rpa_type,

Line 2841: hr_utility.set_location('p_award_amountD - l_dummy' || l_dummy,20);

2837: p_tangible_benefit_dollars => l_d_tbd,
2838: p_date_award_earned => l_d_date_award_earn,
2839: p_appropriation_code => l_d_appropriation_code);
2840:
2841: hr_utility.set_location('p_award_amountD - l_dummy' || l_dummy,20);
2842:
2843: hr_utility.set_location(l_proc,25);
2844: ----- Get Award details from the shadow
2845: get_award_details_shadow

Line 2843: hr_utility.set_location(l_proc,25);

2839: p_appropriation_code => l_d_appropriation_code);
2840:
2841: hr_utility.set_location('p_award_amountD - l_dummy' || l_dummy,20);
2842:
2843: hr_utility.set_location(l_proc,25);
2844: ----- Get Award details from the shadow
2845: get_award_details_shadow
2846: ( p_pa_request_id => p_pa_request_id,
2847: p_award_amount => l_dummy,

Line 2856: hr_utility.set_location('p_award_amountS - l_dummy' || l_dummy,20);

2852: p_group_award => l_s_group_award,
2853: p_tangible_benefit_dollars => l_s_tbd,
2854: p_date_award_earned => l_s_date_award_earn,
2855: p_appropriation_code => l_s_appropriation_code);
2856: hr_utility.set_location('p_award_amountS - l_dummy' || l_dummy,20);
2857: ------------
2858: hr_utility.set_location(l_proc,30);
2859: set_ei
2860: (p_shadow => l_s_award_agency,

Line 2858: hr_utility.set_location(l_proc,30);

2854: p_date_award_earned => l_s_date_award_earn,
2855: p_appropriation_code => l_s_appropriation_code);
2856: hr_utility.set_location('p_award_amountS - l_dummy' || l_dummy,20);
2857: ------------
2858: hr_utility.set_location(l_proc,30);
2859: set_ei
2860: (p_shadow => l_s_award_agency,
2861: p_template => l_t_award_agency,
2862: p_person => l_d_award_agency);

Line 2889: hr_utility.set_location(l_proc,40);

2885: (p_shadow => l_s_appropriation_code,
2886: p_template => l_t_appropriation_code,
2887: p_person => l_d_appropriation_code);
2888:
2889: hr_utility.set_location(l_proc,40);
2890: IF l_pa_request_extra_info_id is null then
2891: hr_utility.set_location(l_proc,45);
2892: ghr_par_extra_info_api.create_pa_request_extra_info
2893: (p_validate => false,

Line 2891: hr_utility.set_location(l_proc,45);

2887: p_person => l_d_appropriation_code);
2888:
2889: hr_utility.set_location(l_proc,40);
2890: IF l_pa_request_extra_info_id is null then
2891: hr_utility.set_location(l_proc,45);
2892: ghr_par_extra_info_api.create_pa_request_extra_info
2893: (p_validate => false,
2894: p_pa_request_id => p_pa_request_id,
2895: p_information_type => l_information_type,

Line 2907: hr_utility.set_location(l_proc,50);

2903: p_pa_request_extra_info_id => l_dummy,
2904: p_object_version_number => l_dummy
2905: );
2906: ELSE
2907: hr_utility.set_location(l_proc,50);
2908:
2909: ghr_par_extra_info_api.update_pa_request_extra_info
2910: (p_validate => false,
2911: p_rei_information3 => l_d_award_agency,

Line 2953: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||

2949:
2950: EXCEPTION
2951:
2952: when others then
2953: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
2954: ' Sql Err is '|| sqlerrm(sqlcode) || l_proc, 60);
2955: --raise mass_awarderror;
2956:
2957: END refresh_award_details;

Line 2974: hr_utility.set_location('in set ei - Y ',5);

2970: l_shadow := p_shadow ;/*NOCOPY CHANGES*/
2971: l_person := p_person ;
2972:
2973: If p_refresh_flag = 'Y' then
2974: hr_utility.set_location('in set ei - Y ',5);
2975: If nvl(p_person,hr_api.g_varchar2) <> nvl(p_template,hr_api.g_varchar2) and
2976: nvl(p_person,hr_api.g_varchar2) = nvl(p_shadow,hr_api.g_varchar2) then
2977: p_person := p_template;
2978: End if;

Line 2980: hr_utility.set_location('in set ei - N ',6);

2976: nvl(p_person,hr_api.g_varchar2) = nvl(p_shadow,hr_api.g_varchar2) then
2977: p_person := p_template;
2978: End if;
2979: Else
2980: hr_utility.set_location('in set ei - N ',6);
2981: p_person := p_template;
2982: End if;
2983: p_shadow := p_template;
2984: EXCEPTION

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

3221:
3222: begin
3223:
3224: -- get template remarks and descriptions
3225: hr_utility.set_location('Entering ' || l_proc,5);
3226:
3227: for cur_rem_tmp_rec in cur_rem_tmp loop
3228: l_pa_remark_id := cur_rem_tmp_rec.pa_remark_id;
3229: l_remark_id := cur_rem_tmp_rec.remark_id;

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

3312:
3313:
3314: begin
3315:
3316: hr_utility.set_location('Entering ..' || l_proc,5);
3317:
3318: l_pa_request_id := p_pa_request_id;
3319: l_object_version_number := p_object_version_number;
3320: l_error := p_error;

Line 3322: hr_utility.set_location('pa_request_id = ' ||to_char( l_pa_request_id),5);

3318: l_pa_request_id := p_pa_request_id;
3319: l_object_version_number := p_object_version_number;
3320: l_error := p_error;
3321:
3322: hr_utility.set_location('pa_request_id = ' ||to_char( l_pa_request_id),5);
3323: hr_utility.set_location('object_version_number = ' ||to_char(l_object_version_number),5);
3324:
3325: ghr_api.call_workflow (
3326: p_pa_request_id => l_pa_request_id,

Line 3323: hr_utility.set_location('object_version_number = ' ||to_char(l_object_version_number),5);

3319: l_object_version_number := p_object_version_number;
3320: l_error := p_error;
3321:
3322: hr_utility.set_location('pa_request_id = ' ||to_char( l_pa_request_id),5);
3323: hr_utility.set_location('object_version_number = ' ||to_char(l_object_version_number),5);
3324:
3325: ghr_api.call_workflow (
3326: p_pa_request_id => l_pa_request_id,
3327: p_action_taken => 'CONTINUE',

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

3327: p_action_taken => 'CONTINUE',
3328: p_error => l_error);
3329:
3330: for cur_rpa_rec in cur_rpa loop
3331: hr_utility.set_location( l_proc,10);
3332: l_object_version_number := cur_rpa_rec.object_version_number;
3333: l_person_id := cur_rpa_rec.person_id;
3334: l_employee_last_name := cur_rpa_rec.employee_last_name;
3335: l_employee_first_name := cur_rpa_rec.employee_first_name;

Line 3339: hr_utility.set_location('object_version_number = ' ||to_char( l_object_version_number),10);

3335: l_employee_first_name := cur_rpa_rec.employee_first_name;
3336: l_employee_middle_names := cur_rpa_rec.employee_middle_names;
3337: l_employee_national_identifier := cur_rpa_rec.employee_national_identifier;
3338: l_effective_date := cur_rpa_rec.effective_date;
3339: hr_utility.set_location('object_version_number = ' ||to_char( l_object_version_number),10);
3340: end loop;
3341:
3342:
3343: --Bug # 9329643

Line 3356: hr_utility.set_location( 'Made Manual RPA' || to_char(l_pa_request_id) ,20);

3352: p_pa_request_id => l_pa_request_id,
3353: p_rpa_type => 'M',
3354: p_object_version_number => l_object_version_number);
3355:
3356: hr_utility.set_location( 'Made Manual RPA' || to_char(l_pa_request_id) ,20);
3357: hr_utility.set_location( 'Leaving ' || l_proc ,25);
3358: -- Bug#3718167 Added SSN to the following log text
3359: --Bug # 9329643 Modified SSN to Emp No
3360: l_log_text := ' ,' || l_employee_last_name || ', ' || l_employee_first_name||' '||l_employee_middle_names

Line 3357: hr_utility.set_location( 'Leaving ' || l_proc ,25);

3353: p_rpa_type => 'M',
3354: p_object_version_number => l_object_version_number);
3355:
3356: hr_utility.set_location( 'Made Manual RPA' || to_char(l_pa_request_id) ,20);
3357: hr_utility.set_location( 'Leaving ' || l_proc ,25);
3358: -- Bug#3718167 Added SSN to the following log text
3359: --Bug # 9329643 Modified SSN to Emp No
3360: l_log_text := ' ,' || l_employee_last_name || ', ' || l_employee_first_name||' '||l_employee_middle_names
3361: ||'Emp No: '|| l_employee_number;