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

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

272:
273: --Bug # 9329643
274: l_employee_number per_people_f.employee_number%type;
275: BEGIN
276: hr_utility.set_location('Entering ' || l_proc,5);
277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
279: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
280: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);

Line 277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);

273: --Bug # 9329643
274: l_employee_number per_people_f.employee_number%type;
275: BEGIN
276: hr_utility.set_location('Entering ' || l_proc,5);
277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
279: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
280: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
281:

Line 278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||

274: l_employee_number per_people_f.employee_number%type;
275: BEGIN
276: hr_utility.set_location('Entering ' || l_proc,5);
277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
279: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
280: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
281:
282: p_retcode := 0;

Line 280: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);

276: hr_utility.set_location('Entering ' || l_proc,5);
277: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
278: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
279: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
280: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
281:
282: p_retcode := 0;
283:
284: for ghr_mti_rec in ghr_mti_cur (p_mtin_id)

Line 291: hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');

287: exit;
288: END LOOP;
289:
290: if l_pa_request_id is null then
291: hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
292: hr_utility.raise_error;
293: END IF;
294:
295: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,

Line 292: hr_utility.raise_error;

288: END LOOP;
289:
290: if l_pa_request_id is null then
291: hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
292: hr_utility.raise_error;
293: END IF;
294:
295: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,
296: l_lac_sf52_rec);

Line 298: hr_utility.set_location('After get_lac_dtls ' || l_proc, 44);

294:
295: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,
296: l_lac_sf52_rec);
297:
298: hr_utility.set_location('After get_lac_dtls ' || l_proc, 44);
299: for per_ext_rec in PER_EXTRA_CUR (p_mtin_id)
300: LOOP
301: BEGIN
302: savepoint EXECUTE_MRE_IN_SP;

Line 320: hr_utility.set_location('After fetch people ' || l_proc , 45);

316:
317: exit;
318: END LOOP;
319:
320: hr_utility.set_location('After fetch people ' || l_proc , 45);
321: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
322: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
323: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
324:

Line 321: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);

317: exit;
318: END LOOP;
319:
320: hr_utility.set_location('After fetch people ' || l_proc , 45);
321: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
322: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
323: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
324:
325: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop

Line 322: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);

318: END LOOP;
319:
320: hr_utility.set_location('After fetch people ' || l_proc , 45);
321: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
322: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
323: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
324:
325: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop
326: l_RETIREMENT_PLAN := per_mt_int.RETIREMENT_PLAN;

Line 323: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);

319:
320: hr_utility.set_location('After fetch people ' || l_proc , 45);
321: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
322: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
323: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
324:
325: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop
326: l_RETIREMENT_PLAN := per_mt_int.RETIREMENT_PLAN;
327: l_RETENTION_ALLOWANCE := per_mt_int.RETENTION_ALLOWANCE;

Line 396: hr_utility.set_location('After fetch from int' || l_proc, 65);

392: --End Bug# 8724192
393: exit;
394: end loop;
395:
396: hr_utility.set_location('After fetch from int' || l_proc, 65);
397: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
398: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
399: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
400:

Line 397: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);

393: exit;
394: end loop;
395:
396: hr_utility.set_location('After fetch from int' || l_proc, 65);
397: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
398: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
399: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
400:
401: if nvl(l_mt_status,'U') = 'P' THEN

Line 398: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);

394: end loop;
395:
396: hr_utility.set_location('After fetch from int' || l_proc, 65);
397: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
398: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
399: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
400:
401: if nvl(l_mt_status,'U') = 'P' THEN
402:

Line 399: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);

395:
396: hr_utility.set_location('After fetch from int' || l_proc, 65);
397: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
398: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
399: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
400:
401: if nvl(l_mt_status,'U') = 'P' THEN
402:
403: if check_eligibility(l_person_id,p_effective_date) then

Line 424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);

420: ,p_position_org_line5 => l_org5
421: ,p_position_org_line6 => l_org6
422: ,p_duty_station_id => l_duty_station_id);
423:
424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);

Line 425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);

421: ,p_position_org_line6 => l_org6
422: ,p_duty_station_id => l_duty_station_id);
423:
424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);

Line 426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);

422: ,p_duty_station_id => l_duty_station_id);
423:
424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
430:

Line 427: hr_utility.set_location('Occ ' || l_occ_code, 85);

423:
424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
430:
431: begin

Line 428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);

424: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
430:
431: begin
432: ghr_pa_requests_pkg.get_duty_station_details

Line 429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);

425: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
426: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
427: hr_utility.set_location('Occ ' || l_occ_code, 85);
428: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
429: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
430:
431: begin
432: ghr_pa_requests_pkg.get_duty_station_details
433: (p_duty_station_id => l_duty_station_id

Line 439: hr_utility.set_location('Err get duty station_det '||

435: ,p_duty_station_code => l_duty_station_code
436: ,p_duty_station_desc => l_duty_station_desc);
437: exception
438: when others then
439: hr_utility.set_location('Err get duty station_det '||
440: ' Sql Err is '|| sqlerrm(sqlcode), 95);
441: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
442: --Bug # 9329643 Modified SSN to Emp No
443: l_mass_errbuf := 'Error in ghr_pa_req.get duty station_det for '||l_full_name||' Emp No: '||l_employee_number||

Line 448: hr_utility.set_location('After duty stat ' || l_proc, 115);

444: ' Sql Err is '|| sqlerrm(sqlcode);
445: raise mass_error;
446: end;
447:
448: hr_utility.set_location('After duty stat ' || l_proc, 115);
449: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
450: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
451:
452: begin

Line 449: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);

445: raise mass_error;
446: end;
447:
448: hr_utility.set_location('After duty stat ' || l_proc, 115);
449: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
450: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
451:
452: begin
453: ghr_history_fetch.fetch_positionei

Line 450: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);

446: end;
447:
448: hr_utility.set_location('After duty stat ' || l_proc, 115);
449: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
450: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
451:
452: begin
453: ghr_history_fetch.fetch_positionei
454: (p_position_id => l_position_id

Line 460: hr_utility.set_location('Err fetch_posnei-POS_GRP1'||

456: ,p_date_effective => p_effective_date
457: ,p_pos_ei_data => l_pos_grp1_rec);
458: exception
459: when others then
460: hr_utility.set_location('Err fetch_posnei-POS_GRP1'||
461: ' Sql Err is '|| sqlerrm(sqlcode) , 125);
462: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
463: --Bug # 9329643 Modified SSN to Emp No
464: l_mass_errbuf := 'Error in fetch_positionei -POS_GRP1 for '||l_full_name||' Emp No: '||l_employee_number||

Line 479: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);

475: -- l_work_schedule := l_pos_grp1_rec.poei_information10;
476: -- l_functional_class := l_pos_grp1_rec.poei_information11;
477: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
478:
479: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
480: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
481: hr_utility.set_location('work sch ' || l_work_schedule, 135);
482: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
483:

Line 480: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);

476: -- l_functional_class := l_pos_grp1_rec.poei_information11;
477: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
478:
479: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
480: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
481: hr_utility.set_location('work sch ' || l_work_schedule, 135);
482: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
483:
484: l_position_title := ghr_api.get_position_title_pos

Line 481: hr_utility.set_location('work sch ' || l_work_schedule, 135);

477: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
478:
479: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
480: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
481: hr_utility.set_location('work sch ' || l_work_schedule, 135);
482: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
483:
484: l_position_title := ghr_api.get_position_title_pos
485: (p_position_id => l_position_id

Line 482: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);

478:
479: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
480: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
481: hr_utility.set_location('work sch ' || l_work_schedule, 135);
482: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
483:
484: l_position_title := ghr_api.get_position_title_pos
485: (p_position_id => l_position_id
486: ,p_business_group_id => p_business_group_id ) ;

Line 505: hr_utility.set_location('Err fetch peopleei-SCDINFO'||

501: ,p_date_effective => p_effective_date
502: ,p_per_ei_data => l_per_ei2_data);
503: exception
504: when others then
505: hr_utility.set_location('Err fetch peopleei-SCDINFO'||
506: ' Sql Err is '|| sqlerrm(sqlcode) , 145);
507: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
508: --Bug # 9329643 Modified SSN to Emp No
509: l_mass_errbuf := 'Error in fetch peopleei - SCD INFO for '||l_full_name||' Emp No: '||l_employee_number||

Line 516: hr_utility.set_location('Serv comp date ' || l_proc, 155);

512: end;
513:
514: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
515:
516: hr_utility.set_location('Serv comp date ' || l_proc, 155);
517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);

Line 517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);

513:
514: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
515:
516: hr_utility.set_location('Serv comp date ' || l_proc, 155);
517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:

Line 518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);

514: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
515:
516: hr_utility.set_location('Serv comp date ' || l_proc, 155);
517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);

Line 519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);

515:
516: hr_utility.set_location('Serv comp date ' || l_proc, 155);
517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);

Line 520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);

516: hr_utility.set_location('Serv comp date ' || l_proc, 155);
517: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);

Line 522: hr_utility.set_location('us per separate retire ' || l_proc,175);

518: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
525: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
526:

Line 523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);

519: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
525: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
526:
527: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim

Line 524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);

520: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
525: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
526:
527: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim
528: (l_person_id,p_effective_date)

Line 525: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);

521:
522: hr_utility.set_location('us per separate retire ' || l_proc,175);
523: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
524: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
525: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
526:
527: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim
528: (l_person_id,p_effective_date)
529: LOOP

Line 609: hr_utility.set_location('Others err in assign_sf52'||

605: l_sf52_rec.part_time_hours := l_part_time_hours;
606:
607: exception
608: when others then
609: hr_utility.set_location('Others err in assign_sf52'||
610: ' Sql Err is '|| sqlerrm(sqlcode) , 185);
611: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
612: --Bug # 9329643 Modified SSN to Emp No
613: l_mass_errbuf := 'Others error in assign_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

Line 618: hr_utility.set_location('After assign to sf52 rec' || l_proc, 195);

614: ' Sql Err is '|| sqlerrm(sqlcode);
615: raise mass_error;
616: end;
617:
618: hr_utility.set_location('After assign to sf52 rec' || l_proc, 195);
619:
620: begin
621: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
622: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);

Line 621: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);

617:
618: hr_utility.set_location('After assign to sf52 rec' || l_proc, 195);
619:
620: begin
621: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
622: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);
623: hr_utility.set_location('Calling create_sf52 ' || l_proc, 197);
624:
625: -- Adding the following code to keep track of the RPA type and Mass action id

Line 623: hr_utility.set_location('Calling create_sf52 ' || l_proc, 197);

619:
620: begin
621: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
622: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);
623: hr_utility.set_location('Calling create_sf52 ' || l_proc, 197);
624:
625: -- Adding the following code to keep track of the RPA type and Mass action id
626: --
627: l_sf52_rec.rpa_type := 'MTI';

Line 637: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||

633: p_errbuf => l_errbuf,
634: p_retcode => l_retcode);
635: exception
636: when others then
637: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
638: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
639: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
640: --Bug # 9329643 Modified SSN to Emp No
641: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

Line 648: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||

644: raise mass_error;
645: end;
646:
647: if l_errbuf is not null then
648: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
649: l_errbuf , 215);
650: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
651: --Bug # 9329643 Modified SSN to Emp No
652: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

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

800: end if;
801: --end Bug# 8724192
802: exception
803: when others then
804: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
805: ' Sql Err is '|| sqlerrm(sqlcode) , 225);
806: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
807: --Bug # 9329643 Modified SSN to Emp No
808: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req for '||l_full_name||' Emp No: '||l_employee_number||

Line 812: hr_utility.set_location('After create pa_req_extra_info' || l_proc, 235);

808: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req for '||l_full_name||' Emp No: '||l_employee_number||
809: ' Sql Err is '|| sqlerrm(sqlcode);
810: raise mass_error;
811: end;
812: hr_utility.set_location('After create pa_req_extra_info' || l_proc, 235);
813: else
814:
815:
816: -- We do not Update the flag to NULL like in other Mass Actions

Line 829: hr_utility.set_location('Mass error raised ' || l_mass_errbuf , 245);

825: end if; ---- for mt_status != 'P'
826:
827: EXCEPTION
828: when mass_error then
829: hr_utility.set_location('Mass error raised ' || l_mass_errbuf , 245);
830: begin
831: ROLLBACK TO EXECUTE_MRE_IN_SP;
832: exception
833: when others then null;

Line 850: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');

846: p_message => l_mass_errbuf);
847: commit;
848: exception
849: when others then
850: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
851: hr_utility.raise_error;
852: end;
853:
854: WHEN OTHERS THEN

Line 851: hr_utility.raise_error;

847: commit;
848: exception
849: when others then
850: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
851: hr_utility.raise_error;
852: end;
853:
854: WHEN OTHERS THEN
855: hr_utility.set_location('Err (Oth) Sql error '||sqlerrm(sqlcode),30);

Line 855: hr_utility.set_location('Err (Oth) Sql error '||sqlerrm(sqlcode),30);

851: hr_utility.raise_error;
852: end;
853:
854: WHEN OTHERS THEN
855: hr_utility.set_location('Err (Oth) Sql error '||sqlerrm(sqlcode),30);
856: l_mass_errbuf := 'Error in '||l_proc|| ' Sql Err is '||sqlerrm(sqlcode);
857: begin
858: ROLLBACK TO EXECUTE_MRE_IN_SP;
859: exception

Line 877: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');

873: p_message => l_mass_errbuf);
874: commit;
875: exception
876: when others then
877: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
878: hr_utility.raise_error;
879: end;
880: END;
881: END LOOP;

Line 878: hr_utility.raise_error;

874: commit;
875: exception
876: when others then
877: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
878: hr_utility.raise_error;
879: end;
880: END;
881: END LOOP;
882:

Line 897: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);

893: where mass_transfer_id = p_mtin_id;
894: commit;
895: EXCEPTION
896: when others then
897: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
898: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
899: hr_utility.raise_error;
900: END;
901: else

Line 898: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');

894: commit;
895: EXCEPTION
896: when others then
897: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
898: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
899: hr_utility.raise_error;
900: END;
901: else
902: update ghr_mass_transfers

Line 899: hr_utility.raise_error;

895: EXCEPTION
896: when others then
897: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
898: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
899: hr_utility.raise_error;
900: END;
901: else
902: update ghr_mass_transfers
903: set status = 'E'

Line 913: hr_utility.set_location('Mass error raised' || l_mass_errbuf , 245);

909: end if;
910:
911: EXCEPTION
912: when mass_error then
913: hr_utility.set_location('Mass error raised' || l_mass_errbuf , 245);
914: ROLLBACK TO EXECUTE_MRE_IN_SP;
915:
916: update ghr_mass_transfers
917: set status = 'E'

Line 929: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');

925: p_message => l_mass_errbuf);
926: commit;
927: exception
928: when others then
929: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
930: hr_utility.raise_error;
931: end;
932: WHEN OTHERS THEN
933: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);

Line 930: hr_utility.raise_error;

926: commit;
927: exception
928: when others then
929: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
930: hr_utility.raise_error;
931: end;
932: WHEN OTHERS THEN
933: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
934: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);

Line 933: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);

929: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
930: hr_utility.raise_error;
931: end;
932: WHEN OTHERS THEN
933: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
934: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);
935: l_mass_errbuf := 'Error in '||l_proc||
936: ' Sql Err is '||sqlerrm(sqlcode);
937: begin

Line 934: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);

930: hr_utility.raise_error;
931: end;
932: WHEN OTHERS THEN
933: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
934: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);
935: l_mass_errbuf := 'Error in '||l_proc||
936: ' Sql Err is '||sqlerrm(sqlcode);
937: begin
938: ROLLBACK TO EXECUTE_MRE_IN_SP;

Line 959: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');

955: EXCEPTION
956: WHEN OTHERS THEN
957: p_errbuf := NULL;
958: p_retcode := NULL;
959: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
960: hr_utility.raise_error;
961: END;
962: END populate_and_create_52;
963:

Line 960: hr_utility.raise_error;

956: WHEN OTHERS THEN
957: p_errbuf := NULL;
958: p_retcode := NULL;
959: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
960: hr_utility.raise_error;
961: END;
962: END populate_and_create_52;
963:
964: --

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

1059: l_proc varchar2(72)
1060: := g_package || '.assign_to_sf52_rec';
1061: begin
1062:
1063: hr_utility.set_location('Entering ' || l_proc,5);
1064:
1065: p_sf52_rec.pa_request_id := null;
1066: p_sf52_rec.pa_notification_id := null;
1067: p_sf52_rec.noa_family_code := 'APP';

Line 1289: hr_utility.set_location('Exiting ' || l_proc,10);

1285: p_sf52_rec.to_total_salary := p_to_total_salary;
1286: END IF;
1287: -- End Changes 4093771
1288:
1289: hr_utility.set_location('Exiting ' || l_proc,10);
1290:
1291: EXCEPTION
1292: WHEN others THEN
1293: -- Reset IN OUT parameters and set OUT parameters

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

1293: -- Reset IN OUT parameters and set OUT parameters
1294:
1295: p_sf52_rec := NULL;
1296:
1297: hr_utility.set_location('Leaving ' || l_proc,60);
1298: RAISE;
1299:
1300: end assign_to_sf52_rec;
1301: