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 244: hr_utility.set_location('Entering ' || l_proc,5);

240: l_recs_failed number := 0;
241: l_mt_status_err_cnt number := 0;
242: l_capped_other_pay number := hr_api.g_number;
243: BEGIN
244: hr_utility.set_location('Entering ' || l_proc,5);
245: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
246: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
247: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
248: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);

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

241: l_mt_status_err_cnt number := 0;
242: l_capped_other_pay number := hr_api.g_number;
243: BEGIN
244: hr_utility.set_location('Entering ' || l_proc,5);
245: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
246: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
247: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
248: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
249:

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

242: l_capped_other_pay number := hr_api.g_number;
243: BEGIN
244: hr_utility.set_location('Entering ' || l_proc,5);
245: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
246: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
247: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
248: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
249:
250: p_retcode := 0;

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

244: hr_utility.set_location('Entering ' || l_proc,5);
245: hr_utility.set_location('Inside populate and create 52' || l_proc, 15);
246: hr_utility.set_location('Mt in id '||to_char(p_mtin_id) ||' Mt in Name '||p_mtin_name ||
247: 'p_business_grp id '||to_char(p_business_group_id) || l_proc, 25);
248: hr_utility.set_location('Eff date ' || to_char(p_effective_date) || l_proc, 35);
249:
250: p_retcode := 0;
251:
252: for ghr_mti_rec in ghr_mti_cur (p_mtin_id)

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

255: exit;
256: END LOOP;
257:
258: if l_pa_request_id is null then
259: hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
260: hr_utility.raise_error;
261: END IF;
262:
263: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,

Line 260: hr_utility.raise_error;

256: END LOOP;
257:
258: if l_pa_request_id is null then
259: hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
260: hr_utility.raise_error;
261: END IF;
262:
263: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,
264: l_lac_sf52_rec);

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

262:
263: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,
264: l_lac_sf52_rec);
265:
266: hr_utility.set_location('After get_lac_dtls ' || l_proc, 44);
267: for per_ext_rec in PER_EXTRA_CUR (p_mtin_id)
268: LOOP
269: BEGIN
270: savepoint EXECUTE_MRE_IN_SP;

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

282:
283: exit;
284: END LOOP;
285:
286: hr_utility.set_location('After fetch people ' || l_proc , 45);
287: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
288: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
289: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
290:

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

283: exit;
284: END LOOP;
285:
286: hr_utility.set_location('After fetch people ' || l_proc , 45);
287: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
288: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
289: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
290:
291: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop

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

284: END LOOP;
285:
286: hr_utility.set_location('After fetch people ' || l_proc , 45);
287: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
288: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
289: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
290:
291: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop
292: l_RETIREMENT_PLAN := per_mt_int.RETIREMENT_PLAN;

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

285:
286: hr_utility.set_location('After fetch people ' || l_proc , 45);
287: hr_utility.set_location('Last Name ' || substr(l_last_name,1,40) , 45);
288: hr_utility.set_location('Date of Birth ' || l_date_of_birth , 45);
289: hr_utility.set_location('Bef fetch from intface ' || to_char(l_person_id) || p_mtin_name , 55);
290:
291: for per_mt_int in ghr_mt_int (l_national_identifier,p_mtin_name) loop
292: l_RETIREMENT_PLAN := per_mt_int.RETIREMENT_PLAN;
293: l_RETENTION_ALLOWANCE := per_mt_int.RETENTION_ALLOWANCE;

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

353:
354: exit;
355: end loop;
356:
357: hr_utility.set_location('After fetch from int' || l_proc, 65);
358: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
359: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
360: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
361:

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

354: exit;
355: end loop;
356:
357: hr_utility.set_location('After fetch from int' || l_proc, 65);
358: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
359: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
360: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
361:
362: if nvl(l_mt_status,'U') = 'P' THEN

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

355: end loop;
356:
357: hr_utility.set_location('After fetch from int' || l_proc, 65);
358: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
359: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
360: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
361:
362: if nvl(l_mt_status,'U') = 'P' THEN
363:

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

356:
357: hr_utility.set_location('After fetch from int' || l_proc, 65);
358: hr_utility.set_location('Retirement plan ' || l_retirement_plan, 65);
359: hr_utility.set_location('Appointment Type ' || l_appointment_type, 65);
360: hr_utility.set_location('Position Id ' || to_char(l_position_id) ,65);
361:
362: if nvl(l_mt_status,'U') = 'P' THEN
363:
364: if check_eligibility(l_person_id,p_effective_date) then

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

381: ,p_position_org_line5 => l_org5
382: ,p_position_org_line6 => l_org6
383: ,p_duty_station_id => l_duty_station_id);
384:
385: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);

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

382: ,p_position_org_line6 => l_org6
383: ,p_duty_station_id => l_duty_station_id);
384:
385: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);

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

383: ,p_duty_station_id => l_duty_station_id);
384:
385: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
391:

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

384:
385: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
391:
392: begin

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

385: hr_utility.set_location('after sf52 to data grade ' || l_proc, 75);
386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
391:
392: begin
393: ghr_pa_requests_pkg.get_duty_station_details

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

386: hr_utility.set_location('Grade ID ' || l_grade_id, 75);
387: hr_utility.set_location('Pay Plan ' || l_pay_plan, 75);
388: hr_utility.set_location('Occ ' || l_occ_code, 85);
389: hr_utility.set_location('Grade Or Level ' || l_grade_or_level, 85);
390: hr_utility.set_location('Pay Basis ' || l_pay_basis, 85);
391:
392: begin
393: ghr_pa_requests_pkg.get_duty_station_details
394: (p_duty_station_id => l_duty_station_id

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

396: ,p_duty_station_code => l_duty_station_code
397: ,p_duty_station_desc => l_duty_station_desc);
398: exception
399: when others then
400: hr_utility.set_location('Err get duty station_det '||
401: ' Sql Err is '|| sqlerrm(sqlcode), 95);
402: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
403: l_mass_errbuf := 'Error in ghr_pa_req.get duty station_det for '||l_full_name||' SSN: '||l_national_identifier||
404: ' Sql Err is '|| sqlerrm(sqlcode);

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

404: ' Sql Err is '|| sqlerrm(sqlcode);
405: raise mass_error;
406: end;
407:
408: hr_utility.set_location('After duty stat ' || l_proc, 115);
409: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
410: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
411:
412: begin

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

405: raise mass_error;
406: end;
407:
408: hr_utility.set_location('After duty stat ' || l_proc, 115);
409: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
410: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
411:
412: begin
413: ghr_history_fetch.fetch_positionei

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

406: end;
407:
408: hr_utility.set_location('After duty stat ' || l_proc, 115);
409: hr_utility.set_location('Duty Station Code ' || l_duty_station_code, 115);
410: hr_utility.set_location('Duty Station Desc ' || l_duty_station_desc, 115);
411:
412: begin
413: ghr_history_fetch.fetch_positionei
414: (p_position_id => l_position_id

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

416: ,p_date_effective => p_effective_date
417: ,p_pos_ei_data => l_pos_grp1_rec);
418: exception
419: when others then
420: hr_utility.set_location('Err fetch_posnei-POS_GRP1'||
421: ' Sql Err is '|| sqlerrm(sqlcode) , 125);
422: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
423: l_mass_errbuf := 'Error in fetch_positionei -POS_GRP1 for '||l_full_name||' SSN: '||l_national_identifier||
424: ' Sql Err is '|| sqlerrm(sqlcode);

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

434: -- l_work_schedule := l_pos_grp1_rec.poei_information10;
435: -- l_functional_class := l_pos_grp1_rec.poei_information11;
436: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
437:
438: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
439: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
440: hr_utility.set_location('work sch ' || l_work_schedule, 135);
441: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
442:

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

435: -- l_functional_class := l_pos_grp1_rec.poei_information11;
436: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
437:
438: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
439: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
440: hr_utility.set_location('work sch ' || l_work_schedule, 135);
441: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
442:
443: l_position_title := ghr_api.get_position_title_pos

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

436: -- l_supervisory_status := l_pos_grp1_rec.poei_information16;
437:
438: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
439: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
440: hr_utility.set_location('work sch ' || l_work_schedule, 135);
441: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
442:
443: l_position_title := ghr_api.get_position_title_pos
444: (p_position_id => l_position_id

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

437:
438: hr_utility.set_location('After pos grp1 poi ' || l_proc, 135);
439: hr_utility.set_location('Personnel Office id ' || l_personnel_office_id, 135);
440: hr_utility.set_location('work sch ' || l_work_schedule, 135);
441: hr_utility.set_location('bargain ' || l_bargaining_unit_status, 135);
442:
443: l_position_title := ghr_api.get_position_title_pos
444: (p_position_id => l_position_id
445: ,p_business_group_id => p_business_group_id ) ;

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

460: ,p_date_effective => p_effective_date
461: ,p_per_ei_data => l_per_ei2_data);
462: exception
463: when others then
464: hr_utility.set_location('Err fetch peopleei-SCDINFO'||
465: ' Sql Err is '|| sqlerrm(sqlcode) , 145);
466: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
467: l_mass_errbuf := 'Error in fetch peopleei - SCD INFO for '||l_full_name||' SSN: '||l_national_identifier||
468: ' Sql Err is '|| sqlerrm(sqlcode);

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

470: end;
471:
472: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
473:
474: hr_utility.set_location('Serv comp date ' || l_proc, 155);
475: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);

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

471:
472: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
473:
474: hr_utility.set_location('Serv comp date ' || l_proc, 155);
475: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:

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

472: l_serv_comp_date := l_per_ei2_data.pei_INFORMATION3;
473:
474: hr_utility.set_location('Serv comp date ' || l_proc, 155);
475: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);

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

473:
474: hr_utility.set_location('Serv comp date ' || l_proc, 155);
475: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);

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

474: hr_utility.set_location('Serv comp date ' || l_proc, 155);
475: hr_utility.set_location('Serv comp date ' || l_serv_comp_date, 155);
476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
482: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);

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

476: hr_utility.set_location('Pos Occ ' || l_position_occupied, 155);
477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
482: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
483: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
484:

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

477: hr_utility.set_location('appr 1 ' || l_appropriation_code1, 155);
478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
482: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
483: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
484:
485: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim

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

478: hr_utility.set_location('appr 2 ' || l_appropriation_code2, 155);
479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
482: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
483: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
484:
485: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim
486: (l_person_id,p_effective_date)

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

479:
480: hr_utility.set_location('us per separate retire ' || l_proc,175);
481: hr_utility.set_location('prev ret cov ' || l_previous_retirement_coverage, 175);
482: hr_utility.set_location('Frozen Service ' || l_frozen_service, 175);
483: hr_utility.set_location('FERS Coverage ' || l_fers_coverage, 175);
484:
485: FOR c_asg_by_per_id_not_prim_rec in c_asg_by_per_id_not_prim
486: (l_person_id,p_effective_date)
487: LOOP

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

563: l_sf52_rec.part_time_hours := l_part_time_hours;
564:
565: exception
566: when others then
567: hr_utility.set_location('Others err in assign_sf52'||
568: ' Sql Err is '|| sqlerrm(sqlcode) , 185);
569: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
570: l_mass_errbuf := 'Others error in assign_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
571: ' Sql Err is '|| sqlerrm(sqlcode);

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

571: ' Sql Err is '|| sqlerrm(sqlcode);
572: raise mass_error;
573: end;
574:
575: hr_utility.set_location('After assign to sf52 rec' || l_proc, 195);
576:
577: begin
578: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
579: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);

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

574:
575: hr_utility.set_location('After assign to sf52 rec' || l_proc, 195);
576:
577: begin
578: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
579: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);
580: hr_utility.set_location('Calling create_sf52 ' || l_proc, 197);
581:
582: -- Adding the following code to keep track of the RPA type and Mass action id

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

576:
577: begin
578: hr_utility.set_location('Calling Redo Pay Calc ' || l_proc, 196);
579: ghr_process_Sf52.redo_pay_calc(l_sf52_rec,l_capped_other_pay);
580: hr_utility.set_location('Calling create_sf52 ' || l_proc, 197);
581:
582: -- Adding the following code to keep track of the RPA type and Mass action id
583: --
584: l_sf52_rec.rpa_type := 'MTI';

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

590: p_errbuf => l_errbuf,
591: p_retcode => l_retcode);
592: exception
593: when others then
594: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
595: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
596: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
597: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
598: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||

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

600: raise mass_error;
601: end;
602:
603: if l_errbuf is not null then
604: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
605: l_errbuf , 215);
606: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
607: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
608: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||

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

688: p_object_version_number => l_pa_OBJECT_VERSION_NUMBER);
689: end if;
690: exception
691: when others then
692: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
693: ' Sql Err is '|| sqlerrm(sqlcode) , 225);
694: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
695: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req for '||l_full_name||' SSN: '||l_national_identifier||
696: ' Sql Err is '|| sqlerrm(sqlcode);

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

695: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req for '||l_full_name||' SSN: '||l_national_identifier||
696: ' Sql Err is '|| sqlerrm(sqlcode);
697: raise mass_error;
698: end;
699: hr_utility.set_location('After create pa_req_extra_info' || l_proc, 235);
700: else
701:
702:
703: -- We do not Update the flag to NULL like in other Mass Actions

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

712: end if; ---- for mt_status != 'P'
713:
714: EXCEPTION
715: when mass_error then
716: hr_utility.set_location('Mass error raised ' || l_mass_errbuf , 245);
717: begin
718: ROLLBACK TO EXECUTE_MRE_IN_SP;
719: exception
720: when others then null;

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

733: p_message => l_mass_errbuf);
734: commit;
735: exception
736: when others then
737: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
738: hr_utility.raise_error;
739: end;
740:
741: WHEN OTHERS THEN

Line 738: hr_utility.raise_error;

734: commit;
735: exception
736: when others then
737: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
738: hr_utility.raise_error;
739: end;
740:
741: WHEN OTHERS THEN
742: hr_utility.set_location('Err (Oth) Sql error '||sqlerrm(sqlcode),30);

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

738: hr_utility.raise_error;
739: end;
740:
741: WHEN OTHERS THEN
742: hr_utility.set_location('Err (Oth) Sql error '||sqlerrm(sqlcode),30);
743: l_mass_errbuf := 'Error in '||l_proc|| ' Sql Err is '||sqlerrm(sqlcode);
744: begin
745: ROLLBACK TO EXECUTE_MRE_IN_SP;
746: exception

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

760: p_message => l_mass_errbuf);
761: commit;
762: exception
763: when others then
764: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
765: hr_utility.raise_error;
766: end;
767: END;
768: END LOOP;

Line 765: hr_utility.raise_error;

761: commit;
762: exception
763: when others then
764: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
765: hr_utility.raise_error;
766: end;
767: END;
768: END LOOP;
769:

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

780: where mass_transfer_id = p_mtin_id;
781: commit;
782: EXCEPTION
783: when others then
784: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
785: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
786: hr_utility.raise_error;
787: END;
788: else

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

781: commit;
782: EXCEPTION
783: when others then
784: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
785: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
786: hr_utility.raise_error;
787: END;
788: else
789: update ghr_mass_transfers

Line 786: hr_utility.raise_error;

782: EXCEPTION
783: when others then
784: hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
785: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
786: hr_utility.raise_error;
787: END;
788: else
789: update ghr_mass_transfers
790: set status = 'E'

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

796: end if;
797:
798: EXCEPTION
799: when mass_error then
800: hr_utility.set_location('Mass error raised' || l_mass_errbuf , 245);
801: ROLLBACK TO EXECUTE_MRE_IN_SP;
802:
803: update ghr_mass_transfers
804: set status = 'E'

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

812: p_message => l_mass_errbuf);
813: commit;
814: exception
815: when others then
816: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
817: hr_utility.raise_error;
818: end;
819: WHEN OTHERS THEN
820: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);

Line 817: hr_utility.raise_error;

813: commit;
814: exception
815: when others then
816: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
817: hr_utility.raise_error;
818: end;
819: WHEN OTHERS THEN
820: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
821: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);

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

816: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
817: hr_utility.raise_error;
818: end;
819: WHEN OTHERS THEN
820: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
821: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);
822: l_mass_errbuf := 'Error in '||l_proc||
823: ' Sql Err is '||sqlerrm(sqlcode);
824: begin

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

817: hr_utility.raise_error;
818: end;
819: WHEN OTHERS THEN
820: hr_utility.set_location('Err (Others) occurred in Sql error '|| sqlerrm(sqlcode),30);
821: hr_utility.set_location('Error others '||' Err is '||sqlerrm(sqlcode),20);
822: l_mass_errbuf := 'Error in '||l_proc||
823: ' Sql Err is '||sqlerrm(sqlcode);
824: begin
825: ROLLBACK TO EXECUTE_MRE_IN_SP;

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

842: EXCEPTION
843: WHEN OTHERS THEN
844: p_errbuf := NULL;
845: p_retcode := NULL;
846: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
847: hr_utility.raise_error;
848: END;
849: END populate_and_create_52;
850:

Line 847: hr_utility.raise_error;

843: WHEN OTHERS THEN
844: p_errbuf := NULL;
845: p_retcode := NULL;
846: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
847: hr_utility.raise_error;
848: END;
849: END populate_and_create_52;
850:
851: --

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

946: l_proc varchar2(72)
947: := g_package || '.assign_to_sf52_rec';
948: begin
949:
950: hr_utility.set_location('Entering ' || l_proc,5);
951:
952: p_sf52_rec.pa_request_id := null;
953: p_sf52_rec.pa_notification_id := null;
954: p_sf52_rec.noa_family_code := 'APP';

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

1172: p_sf52_rec.to_total_salary := p_to_total_salary;
1173: END IF;
1174: -- End Changes 4093771
1175:
1176: hr_utility.set_location('Exiting ' || l_proc,10);
1177:
1178: EXCEPTION
1179: WHEN others THEN
1180: -- Reset IN OUT parameters and set OUT parameters

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

1180: -- Reset IN OUT parameters and set OUT parameters
1181:
1182: p_sf52_rec := NULL;
1183:
1184: hr_utility.set_location('Leaving ' || l_proc,60);
1185: RAISE;
1186:
1187: end assign_to_sf52_rec;
1188: