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

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

483: pr('Mass Realignment id is '||p_mass_realignment_id,' Action is '|| p_action);
484:
485: g_proc := 'execute_mre';
486:
487: hr_utility.set_location('Entering ' || l_proc,5);
488: l_ind := 10;
489:
490: BEGIN
491: FOR mre IN ghr_mre (p_mass_realignment_id)

Line 514: hr_utility.set_location('Mass Realignment is in use',1);

510: exit;
511: END LOOP;
512: EXCEPTION
513: when REC_BUSY then
514: hr_utility.set_location('Mass Realignment is in use',1);
515: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
516: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MRE');
517: hr_utility.raise_error;
518: when others then

Line 516: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MRE');

512: EXCEPTION
513: when REC_BUSY then
514: hr_utility.set_location('Mass Realignment is in use',1);
515: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
516: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MRE');
517: hr_utility.raise_error;
518: when others then
519: hr_utility.set_location
520: ('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);

Line 517: hr_utility.raise_error;

513: when REC_BUSY then
514: hr_utility.set_location('Mass Realignment is in use',1);
515: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
516: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MRE');
517: hr_utility.raise_error;
518: when others then
519: hr_utility.set_location
520: ('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
521: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);

Line 519: hr_utility.set_location

515: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
516: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MRE');
517: hr_utility.raise_error;
518: when others then
519: hr_utility.set_location
520: ('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
521: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
522: raise mass_error;
523: END;

Line 539: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');

535: --End Bug# 3163576
536: l_ind := 20;
537: IF UPPER(p_action) = 'CREATE' then
538: if l_pa_request_id is null then
539: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
540: hr_utility.raise_error;
541: END IF;
542: END IF;
543:

Line 540: hr_utility.raise_error;

536: l_ind := 20;
537: IF UPPER(p_action) = 'CREATE' then
538: if l_pa_request_id is null then
539: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
540: hr_utility.raise_error;
541: END IF;
542: END IF;
543:
544: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,

Line 551: hr_utility.set_location('After fetch mre '||to_char(l_effective_DATE),1);

547: --purge_old_data(p_mass_realignment_id);
548:
549: l_ind := 30;
550:
551: hr_utility.set_location('After fetch mre '||to_char(l_effective_DATE),1);
552:
553: if p_old_organization_id is not null then
554: l_check_org_pos := 'O';
555: l_org_pos_id := p_old_organization_id;

Line 698: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

694: l_part_time_hour);
695: EXCEPTION
696: when others then
697: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
698: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
699: 'Err is '||sqlerrm(sqlcode),20);
700: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
701: sqlerrm(sqlcode);
702: raise mass_error;

Line 716: l_mslerrbuf := hr_utility.get_message;

712: l_pay_basis);
713: EXCEPTION
714: --Bug#4179270,4126137,4086677 Added the get_message call.
715: when ghr_msl_pkg.msl_error then
716: l_mslerrbuf := hr_utility.get_message;
717: raise mass_error;
718: END;
719: l_ind := 70;
720: BEGIN

Line 727: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

723: ,p_duty_station_id => l_duty_station_id);
724: EXCEPTION
725: when others then
726: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
727: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
728: 'Err is '||sqlerrm(sqlcode),20);
729: -- Bug 3718167 Added Person,SSN in the message instead of person_id
730: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
731: sqlerrm(sqlcode);

Line 752: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

748: ,p_duty_station_desc => l_duty_station_desc);
749: EXCEPTION
750: when others then
751: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
752: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
753: 'Err is '||sqlerrm(sqlcode),20);
754: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
755: sqlerrm(sqlcode);
756: raise mass_error;

Line 879: l_mslerrbuf := hr_utility.get_message;

875: l_pay_basis);
876: EXCEPTION
877: --Bug#4179270,4126137,4086677 Added the get_message call.
878: when ghr_msl_pkg.msl_error then
879: l_mslerrbuf := hr_utility.get_message;
880: raise mass_error;
881: END;
882: l_ind := 200;
883: pr('Bef assign to sf52 rec');

Line 989: hr_utility.set_location('l_pay_calc_in_data.pay_basis ' || l_pay_calc_in_data.pay_basis,1000);

985: ghr_pc_basic_pay.get_retained_grade_details
986: ( per.person_id,
987: l_effective_DATE);
988: l_pay_calc_in_data.pay_basis := p_retained_grade.pay_basis;
989: hr_utility.set_location('l_pay_calc_in_data.pay_basis ' || l_pay_calc_in_data.pay_basis,1000);
990: EXCEPTION
991: WHEN OTHERS THEN
992: l_mslerrbuf := 'Preview - Others error in Get retained grade '||
993: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);

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

1002: ,l_message_set
1003: ,l_calculated);
1004:
1005: IF l_message_set THEN
1006: hr_utility.set_location( l_proc, 40);
1007: l_calculated := FALSE;
1008: --Begin Bug#4114068
1009: hr_utility.get_message_details(l_mslerrbuf,l_appl_id);
1010: --Bug# 10194273 added GHR_38260,38253,39261,38262

Line 1009: hr_utility.get_message_details(l_mslerrbuf,l_appl_id);

1005: IF l_message_set THEN
1006: hr_utility.set_location( l_proc, 40);
1007: l_calculated := FALSE;
1008: --Begin Bug#4114068
1009: hr_utility.get_message_details(l_mslerrbuf,l_appl_id);
1010: --Bug# 10194273 added GHR_38260,38253,39261,38262
1011: IF l_mslerrbuf in ('GHR_38260_NO_CALC_PAY_PLAN', 'GHR_38254_NO_CALC_PRD','GHR_38253_NO_PAY_PLAN_VALUE',
1012: 'GHR_38261_NO_CALC_FAMILY','GHR_38262_NO_CALC_PAY_BASIS') THEN
1013: raise ghr_pay_calc.unable_to_calculate;

Line 1068: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||

1064: l_new_other_pay_amount := null;
1065: END IF;
1066: --end Bug#4114068
1067: when others then
1068: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1069: 'Err is '||sqlerrm(sqlcode),20);
1070: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||
1071: sqlerrm(sqlcode);
1072: raise mass_error;

Line 1139: hr_utility.set_location('Error in ghr_pay_caps.do_pay_caps_main ' ||

1135: EXCEPTION
1136: when mass_error then
1137: raise;
1138: when others then
1139: hr_utility.set_location('Error in ghr_pay_caps.do_pay_caps_main ' ||
1140: 'Err is '||sqlerrm(sqlcode),23);
1141: l_mslerrbuf := 'Error in do_pay_caps_main Sql Err is '|| sqlerrm(sqlcode);
1142: raise mass_error;
1143: END;

Line 1190: hr_utility.set_location('Before COMMITing',2);

1186: pr('Create sf52 success');
1187:
1188: if l_errbuf is null then
1189: pr('No error in create sf52 sel flg is '||l_sel_flg);
1190: hr_utility.set_location('Before COMMITing',2);
1191:
1192: ghr_mto_int.log_message(
1193: p_procedure => 'Successful Completion',
1194: p_message => 'Name: '||per.full_name ||

Line 1205: hr_utility.set_location('Error in '||to_char(per.position_id),20);

1201: upd_ext_info_to_null(per.position_id,l_effective_DATE);
1202: COMMIT;
1203: ELSE
1204: pr('Error in create sf52',l_errbuf);
1205: hr_utility.set_location('Error in '||to_char(per.position_id),20);
1206: l_mslerrbuf := 'Error in create sf52 '|| l_errbuf;
1207: --l_recs_failed := l_recs_failed + 1;
1208: raise mass_error;
1209: END IF;

Line 1384: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

1380: END IF;
1381: END IF;
1382: EXCEPTION
1383: WHEN mass_ERROR THEN
1384: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1385:
1386: BEGIN
1387: ROLLBACK TO EXECUTE_MRE_SP;
1388: EXCEPTION

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

1394: ' For Mass Realignment Name : '||p_mass_realignment_name||
1395: ' for Name : '||per.full_name ||
1396: ' Emp No: ' || per.employee_number||
1397: l_mslerrbuf;
1398: hr_utility.set_location('before creating entry in log file',10);
1399: l_recs_failed := l_recs_failed + 1;
1400:
1401: BEGIN
1402: ghr_mto_int.log_message(

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

1404: p_message => l_log_text);
1405: COMMIT;
1406: EXCEPTION
1407: when others then
1408: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1409: hr_utility.raise_error;
1410: END;
1411:
1412: --6997689

Line 1409: hr_utility.raise_error;

1405: COMMIT;
1406: EXCEPTION
1407: when others then
1408: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1409: hr_utility.raise_error;
1410: END;
1411:
1412: --6997689
1413: BEGIN

Line 1425: hr_utility.set_location('Error (Others) occurred in '||l_proc||

1421: null;
1422: END;
1423: --6997689
1424: WHEN others then
1425: hr_utility.set_location('Error (Others) occurred in '||l_proc||
1426: ' Sql error '||sqlerrm(sqlcode),20);
1427:
1428: BEGIN
1429: ROLLBACK TO EXECUTE_MRE_SP;

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

1436: ' For Mass Realignment Name : '||p_mass_realignment_name||
1437: ' for Name : '||per.full_name ||
1438: ' Emp No: ' || per.employee_number||
1439: ' Sql Err is '||sqlerrm(sqlcode);
1440: hr_utility.set_location('before creating entry in log file',20);
1441: l_recs_failed := l_recs_failed + 1;
1442: p_retcode := 2;
1443: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1444:

Line 1452: hr_utility.set_message(8301, 'Create Error Log failed');

1448: p_message => l_log_text);
1449: COMMIT;
1450: EXCEPTION
1451: when others then
1452: hr_utility.set_message(8301, 'Create Error Log failed');
1453: hr_utility.raise_error;
1454: END;
1455: END;
1456: END IF;

Line 1453: hr_utility.raise_error;

1449: COMMIT;
1450: EXCEPTION
1451: when others then
1452: hr_utility.set_message(8301, 'Create Error Log failed');
1453: hr_utility.raise_error;
1454: END;
1455: END;
1456: END IF;
1457: END LOOP;

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

1613: p_procedure => 'Invalid_Duty_Station',
1614: p_message => l_log_text);
1615: EXCEPTION
1616: when others then
1617: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1618: hr_utility.raise_error;
1619: END;
1620: l_log_text := NULL;
1621: l_recs_failed := l_recs_failed + 1;

Line 1618: hr_utility.raise_error;

1614: p_message => l_log_text);
1615: EXCEPTION
1616: when others then
1617: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1618: hr_utility.raise_error;
1619: END;
1620: l_log_text := NULL;
1621: l_recs_failed := l_recs_failed + 1;
1622: ELSE

Line 1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);

1784: raise mass_error;
1785: END;
1786: -- Bug#4388288
1787:
1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);

Line 1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);

1785: END;
1786: -- Bug#4388288
1787:
1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1793:

Line 1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);

1786: -- Bug#4388288
1787:
1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1793:
1794: IF check_eligibility(

Line 1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);

1787:
1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1793:
1794: IF check_eligibility(
1795: p_org_structure_id,

Line 1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);

1788: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1789: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1790: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1791: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1792: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1793:
1794: IF check_eligibility(
1795: p_org_structure_id,
1796: p_office_symbol,

Line 1807: hr_utility.set_location('Vac Pos Selected ' || l_position_title,5);

1803: null,
1804: l_effective_DATE,
1805: null) THEN
1806: -----AVR
1807: hr_utility.set_location('Vac Pos Selected ' || l_position_title,5);
1808: ---dbms_output.put_line('After assigning agency code');
1809: -- Added by Dinkar for Updating Position details for vacant positions
1810: -- Getting Pos group2 data.
1811:

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

1888: p_procedure => 'Invalid_Duty_Station',
1889: p_message => l_log_text);
1890: EXCEPTION
1891: when others then
1892: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1893: hr_utility.raise_error;
1894: END;
1895: l_log_text := NULL;
1896: l_recs_failed := l_recs_failed + 1;

Line 1893: hr_utility.raise_error;

1889: p_message => l_log_text);
1890: EXCEPTION
1891: when others then
1892: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1893: hr_utility.raise_error;
1894: END;
1895: l_log_text := NULL;
1896: l_recs_failed := l_recs_failed + 1;
1897: ELSE

Line 2001: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

1997: -- even after any error it will continue with next vacant position
1998: EXCEPTION
1999: WHEN mass_ERROR THEN
2000:
2001: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
2002: BEGIN
2003: ROLLBACK TO EXECUTE_MRE_SP;
2004: EXCEPTION
2005: WHEN OTHERS THEN NULL;

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

2005: WHEN OTHERS THEN NULL;
2006: END;
2007: l_log_text := 'Error in '||l_proc||' '||
2008: ' For Mass Realignment Name : '||p_mass_realignment_name||l_mslerrbuf;
2009: hr_utility.set_location('before creating entry in log file',10);
2010: l_recs_failed := l_recs_failed + 1;
2011: p_retcode := 2;
2012: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2013:

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

2017: p_message => l_log_text);
2018: COMMIT;
2019: EXCEPTION
2020: when others then
2021: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
2022: hr_utility.raise_error;
2023: END;
2024:
2025:

Line 2022: hr_utility.raise_error;

2018: COMMIT;
2019: EXCEPTION
2020: when others then
2021: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
2022: hr_utility.raise_error;
2023: END;
2024:
2025:
2026: WHEN OTHERS THEN

Line 2027: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);

2023: END;
2024:
2025:
2026: WHEN OTHERS THEN
2027: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
2028: BEGIN
2029: ROLLBACK TO EXECUTE_MRE_SP;
2030: EXCEPTION
2031: WHEN OTHERS THEN NULL;

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

2033: l_log_text := 'Error in '||l_proc||
2034: ' For Mass Realignment Name : '||p_mass_realignment_name||
2035: ' Sql Err is '||sqlerrm(sqlcode);
2036: l_recs_failed := l_recs_failed + 1;
2037: hr_utility.set_location('before creating entry in log file',30);
2038:
2039: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2040: p_retcode := 2;
2041:

Line 2049: hr_utility.set_message(8301, 'Create Error Log failed');

2045: p_message => l_log_text);
2046: COMMIT;
2047: EXCEPTION
2048: when others then
2049: hr_utility.set_message(8301, 'Create Error Log failed');
2050: hr_utility.raise_error;
2051: END;
2052: END;
2053: END LOOP;

Line 2050: hr_utility.raise_error;

2046: COMMIT;
2047: EXCEPTION
2048: when others then
2049: hr_utility.set_message(8301, 'Create Error Log failed');
2050: hr_utility.raise_error;
2051: END;
2052: END;
2053: END LOOP;
2054: EXCEPTION

Line 2077: HR_UTILITY.SET_LOCATION('Error in UpDATE ghr_mre Sql error '||sqlerrm(sqlcode),30);

2073: set status = 'P'
2074: WHERE mass_realignment_id = p_mass_realignment_id;
2075: EXCEPTION
2076: when others then
2077: HR_UTILITY.SET_LOCATION('Error in UpDATE ghr_mre Sql error '||sqlerrm(sqlcode),30);
2078: hr_utility.set_message(8301, 'GHR_38570_UPD_GHR_MRE_FAILURE');
2079: hr_utility.raise_error;
2080: END;
2081: END IF;

Line 2078: hr_utility.set_message(8301, 'GHR_38570_UPD_GHR_MRE_FAILURE');

2074: WHERE mass_realignment_id = p_mass_realignment_id;
2075: EXCEPTION
2076: when others then
2077: HR_UTILITY.SET_LOCATION('Error in UpDATE ghr_mre Sql error '||sqlerrm(sqlcode),30);
2078: hr_utility.set_message(8301, 'GHR_38570_UPD_GHR_MRE_FAILURE');
2079: hr_utility.raise_error;
2080: END;
2081: END IF;
2082: END IF;

Line 2079: hr_utility.raise_error;

2075: EXCEPTION
2076: when others then
2077: HR_UTILITY.SET_LOCATION('Error in UpDATE ghr_mre Sql error '||sqlerrm(sqlcode),30);
2078: hr_utility.set_message(8301, 'GHR_38570_UPD_GHR_MRE_FAILURE');
2079: hr_utility.raise_error;
2080: END;
2081: END IF;
2082: END IF;
2083: COMMIT;

Line 2101: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

2097: END IF;
2098: END IF;
2099: EXCEPTION
2100: WHEN mass_ERROR THEN
2101: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
2102: BEGIN
2103: ROLLBACK TO EXECUTE_MRE_SP;
2104: EXCEPTION
2105: WHEN OTHERS THEN NULL;

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

2112: END IF;
2113: l_log_text := 'Error in '||l_proc||' '||
2114: ' For Mass Realignment Name : '||p_mass_realignment_name||
2115: l_mslerrbuf;
2116: hr_utility.set_location('before creating entry in log file',10);
2117: l_recs_failed := l_recs_failed + 1;
2118: p_retcode := 2;
2119: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2120:

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

2124: p_message => l_log_text);
2125: COMMIT;
2126: EXCEPTION
2127: when others then
2128: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
2129: hr_utility.raise_error;
2130: END;
2131:
2132:

Line 2129: hr_utility.raise_error;

2125: COMMIT;
2126: EXCEPTION
2127: when others then
2128: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
2129: hr_utility.raise_error;
2130: END;
2131:
2132:
2133: WHEN OTHERS THEN

Line 2134: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);

2130: END;
2131:
2132:
2133: WHEN OTHERS THEN
2134: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
2135: BEGIN
2136: ROLLBACK TO EXECUTE_MRE_SP;
2137: EXCEPTION
2138: WHEN OTHERS THEN NULL;

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

2140: l_log_text := 'Error in '||l_proc||
2141: ' For Mass Realignment Name : '||p_mass_realignment_name||
2142: ' Sql Err is '||sqlerrm(sqlcode);
2143: l_recs_failed := l_recs_failed + 1;
2144: hr_utility.set_location('before creating entry in log file',30);
2145:
2146: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2147: p_retcode := 2;
2148: IF UPPER(p_action) = 'CREATE' THEN

Line 2162: hr_utility.set_message(8301, 'Create Error Log failed');

2158: p_message => l_log_text);
2159: COMMIT;
2160: EXCEPTION
2161: when others then
2162: hr_utility.set_message(8301, 'Create Error Log failed');
2163: hr_utility.raise_error;
2164: END;
2165: END EXECUTE_MRE;
2166:

Line 2163: hr_utility.raise_error;

2159: COMMIT;
2160: EXCEPTION
2161: when others then
2162: hr_utility.set_message(8301, 'Create Error Log failed');
2163: hr_utility.raise_error;
2164: END;
2165: END EXECUTE_MRE;
2166:
2167: --

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

2236: := g_package || '.pop_dtls_from_pa_req';
2237: BEGIN
2238: g_proc := 'pop_dtls_from_pa_req';
2239:
2240: hr_utility.set_location('Entering ' || l_proc,5);
2241: for pa_req_rec in ghr_pa_req_cur
2242: loop
2243: create_mass_act_prev (p_effective_DATE,
2244: pa_req_rec.employee_DATE_of_birth,

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

2272: pa_req_rec.EMPLOYEE_ASSIGNMENT_ID,
2273: pa_req_rec.PAY_RATE_DETERMINANT);
2274: exit;
2275: END LOOP;
2276: hr_utility.set_location('Exiting ' || l_proc,10);
2277: EXCEPTION
2278: when mass_error then raise;
2279: when others then
2280: pr('Error in '||l_proc);

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

2277: EXCEPTION
2278: when mass_error then raise;
2279: when others then
2280: pr('Error in '||l_proc);
2281: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2282: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2283: raise mass_error;
2284: END pop_dtls_from_pa_req;
2285:

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

2307: --Initilization for NOCOPY Changes
2308: --
2309: l_sel_flg := p_sel_flg;
2310: --
2311: hr_utility.set_location('Entering ' || l_proc,5);
2312: pr('in '||l_proc);
2313: l_line := 5;
2314: get_extra_info_comments(p_position_id,p_effective_DATE,l_sel_flg,
2315: l_comments,l_mre_id);

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

2359: -- Reset IN OUT params and Set OUT params to null
2360: p_sel_flg := l_sel_flg;
2361: --
2362: pr('Error in '||l_proc);
2363: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2364: l_mslerrbuf := 'Error in '||l_proc||' @'||to_char(l_line)||' Sql Err is '|| sqlerrm(sqlcode);
2365:
2366: raise mass_error;
2367: END;

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

2390: l_proc VARCHAR2(72) := g_package || '.ins_upd_pos_extra_info';
2391: l_eff_DATE DATE;
2392:
2393: BEGIN
2394: hr_utility.set_location('Entering ' || l_proc,5);
2395: g_proc := 'ins_upd_pos_extra_info';
2396:
2397: if p_effective_DATE > sysDATE then
2398: l_eff_DATE := sysDATE;

Line 2435: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);

2431: ,p_poei_INFORMATION4 => p_comment
2432: ,p_poei_INFORMATION14 => to_char(p_mre_id)
2433: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
2434: EXCEPTION when others then
2435: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
2436: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2437: END;
2438: ----- Reset the global variable
2439: ghr_api.g_api_dml := FALSE;

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

2432: ,p_poei_INFORMATION14 => to_char(p_mre_id)
2433: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
2434: EXCEPTION when others then
2435: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
2436: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2437: END;
2438: ----- Reset the global variable
2439: ghr_api.g_api_dml := FALSE;
2440:

Line 2459: hr_utility.set_location('Exiting ' || l_proc,30);

2455: --Bug#4215231 Reset the global variable
2456: ghr_api.g_api_dml := FALSE;
2457:
2458: END IF;
2459: hr_utility.set_location('Exiting ' || l_proc,30);
2460:
2461: -- There is a trigger on Position extra Info. Whenever UPDATEd/created the
2462: -- main position associated with it becomes invalid.
2463: -- We shall call valiDATE_perwsdpo procedure to set the status = VALID.

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

2472: EXCEPTION
2473: when mass_error then raise;
2474: when others then
2475: pr('Error in '||l_proc);
2476: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2477: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2478: raise mass_error;
2479: END ins_upd_pos_extra_info;
2480:

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

2492: l_mre_name VARCHAR2(150);
2493: l_proc VARCHAR2(72) := g_package || '.get_mre_name';
2494: BEGIN
2495: g_proc := 'get_mre_name';
2496: hr_utility.set_location('Entering ' || l_proc,5);
2497: FOR mre_REC IN mre_cur
2498: LOOP
2499: l_mre_name := mre_rec.name;
2500: exit;

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

2511: := g_package || '.purge_old_data';
2512: BEGIN
2513: g_proc := 'purge_old_data';
2514:
2515: hr_utility.set_location('Entering ' || l_proc,5);
2516: delete from ghr_mass_actions_preview
2517: WHERE mass_action_type = 'REALIGNMENT'
2518: and session_id = userenv('sessionid');
2519: COMMIT;

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

2516: delete from ghr_mass_actions_preview
2517: WHERE mass_action_type = 'REALIGNMENT'
2518: and session_id = userenv('sessionid');
2519: COMMIT;
2520: hr_utility.set_location('Exiting ' || l_proc,10);
2521: EXCEPTION
2522: when mass_error then raise;
2523: when others then
2524: pr('Error in '||l_proc);

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

2521: EXCEPTION
2522: when mass_error then raise;
2523: when others then
2524: pr('Error in '||l_proc);
2525: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2526: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2527: raise mass_error;
2528: END;
2529:

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

2540: l_eff_DATE DATE;
2541: BEGIN
2542: g_proc := 'UPDATE_sel_flg';
2543:
2544: hr_utility.set_location('Entering ' || l_proc,5);
2545: if p_effective_DATE > sysDATE then
2546: l_eff_DATE := sysDATE;
2547: ELSE
2548: l_eff_DATE := p_effective_DATE;

Line 2574: hr_utility.set_location('UPDATE posei error 2' || l_proc,10);

2570: ,p_poei_INFORMATION5 => NULL
2571: ,p_poei_INFORMATION6 => NULL
2572: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
2573: EXCEPTION when others then
2574: hr_utility.set_location('UPDATE posei error 2' || l_proc,10);
2575: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2576: END;
2577:
2578: ----- Reset the global variable

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

2571: ,p_poei_INFORMATION6 => NULL
2572: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
2573: EXCEPTION when others then
2574: hr_utility.set_location('UPDATE posei error 2' || l_proc,10);
2575: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2576: END;
2577:
2578: ----- Reset the global variable
2579: ghr_api.g_api_dml := FALSE;

Line 2587: hr_utility.set_location('Exiting ' || l_proc,30);

2583: ---- ghr_valiDATE_perwsdpo.valiDATE_perwsdpo(p_position_id);
2584: ---- ghr_valiDATE_perwsdpo.UPDATE_posn_status(p_position_id);
2585:
2586: END IF;
2587: hr_utility.set_location('Exiting ' || l_proc,30);
2588: EXCEPTION
2589: when mass_error then raise;
2590: when others then
2591: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

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

2587: hr_utility.set_location('Exiting ' || l_proc,30);
2588: EXCEPTION
2589: when mass_error then raise;
2590: when others then
2591: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2592: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2593: raise mass_error;
2594: END UPDATE_sel_flg;
2595:

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

2614: l_row_cnt NUMBER := 0;
2615: l_proc VARCHAR2(72) := g_package || '.check_eligibility';
2616: BEGIN
2617: g_proc := 'check_eligibility';
2618: hr_utility.set_location('Entering ' || l_proc,5);
2619:
2620: if p_org_structure_id is not null then
2621: if p_org_structure_id <> nvl(p_l_org_structure_id,'NULL!~') then
2622: return false;

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

2680: EXCEPTION
2681: when mass_error then raise;
2682: when others then
2683: pr('Error in '||l_proc);
2684: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2685: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2686: raise mass_error;
2687: END check_eligibility;
2688:

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

2844:
2845: BEGIN
2846: g_proc := 'get_pos_grp1_ddf';
2847:
2848: hr_utility.set_location('Entering ' || l_proc,5);
2849: ghr_history_fetch.fetch_positionei
2850: (p_position_id => p_position_id
2851: ,p_information_type => 'GHR_US_POS_GRP1'
2852: ,p_DATE_effective => p_effective_DATE

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

2856: p_office_symbol := p_pos_ei_data.poei_information4;
2857: p_org_structure_id := p_pos_ei_data.poei_information5;
2858: p_position_organization := p_pos_ei_data.poei_information21;
2859:
2860: hr_utility.set_location('Exiting ' || l_proc,10);
2861: EXCEPTION
2862: when mass_error then raise;
2863: when others then
2864: -- NOCOPY changes

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

2869: p_position_organization := NULL;
2870: p_pos_ei_data := NULL;
2871:
2872: pr('Error in '||l_proc);
2873: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2874: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2875: raise mass_error;
2876: END get_pos_grp1_ddf;
2877:

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

2893: l_pos_ei_data per_position_extra_info%rowtype;
2894:
2895: BEGIN
2896: g_proc := 'get_pos_grp2_ddf';
2897: hr_utility.set_location('Entering ' || l_proc,5);
2898: ghr_history_fetch.fetch_positionei
2899: (p_position_id => p_position_id
2900: ,p_information_type => 'GHR_US_POS_GRP2'
2901: ,p_DATE_effective => p_effective_DATE

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

2904: p_org_func_code := l_pos_ei_data.poei_information4;
2905: p_appropriation_code1 := l_pos_ei_data.poei_information13;
2906: p_appropriation_code2 := l_pos_ei_data.poei_information14;
2907:
2908: hr_utility.set_location('Exiting ' || l_proc,10);
2909: EXCEPTION
2910: when mass_error then raise;
2911: when others then
2912: -- NOCOPY changes

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

2915: p_appropriation_code1 := NULL;
2916: p_appropriation_code2 := NULL;
2917: --
2918: pr('Error in '||l_proc);
2919: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2920: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2921: raise mass_error;
2922: END get_pos_grp2_ddf;
2923:

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

2949: := g_package || '.get_field_desc';
2950: BEGIN
2951: g_proc := 'GET_FIELD_DESC';
2952:
2953: hr_utility.set_location('Entering ' || l_proc,5);
2954: p_agency_desc := GET_FND_COMMON_LOOKUP (p_agency_code,'GHR_US_AGENCY_CODE');
2955: p_to_agency_desc := GET_FND_COMMON_LOOKUP (p_to_agency_code,
2956: 'GHR_US_AGENCY_CODE');
2957: p_approp_code1_desc := GET_FND_COMMON_LOOKUP (p_approp_code1,

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

3002: l_proc VARCHAR2(72) := g_package || '.get_fnd_common_lookup';
3003: BEGIN
3004: g_proc := 'GET_FND_COMMON_LOOKUP';
3005:
3006: hr_utility.set_location('Entering ' || l_proc,5);
3007: FOR lookup_rec IN CUR_lookup
3008: LOOP
3009: l_meaning := lookup_rec.meaning;
3010: exit;

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

3026: l_pp_desc VARCHAR2(150);
3027: l_proc VARCHAR2(72) := g_package || '.get_pp_name';
3028: BEGIN
3029: g_proc := 'GET_PP_NAME';
3030: hr_utility.set_location('Entering ' || l_proc,5);
3031: FOR PP_REC IN CUR_PP
3032: LOOP
3033: l_pp_desc := pp_rec.description;
3034: exit;

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

3050: l_poi_desc VARCHAR2(150);
3051: l_proc VARCHAR2(72) := g_package || '.get_poi_name';
3052: BEGIN
3053: g_proc := 'GET_POI_NAME';
3054: hr_utility.set_location('Entering ' || l_proc,5);
3055: FOR POI_REC IN CUR_POI
3056: LOOP
3057: l_poi_desc := poi_rec.description;
3058: exit;

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

3081: l_proc VARCHAR2(72)
3082: := g_package || '.get_organization_name';
3083: BEGIN
3084: g_proc := 'get_organization_name';
3085: hr_utility.set_location('Entering ' || l_proc,5);
3086: for mre_rec in mre_org_cur (p_org_id)
3087: LOOP
3088: l_org_name := mre_rec.name;
3089: l_org_id := mre_rec.organization_id;

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

3112: l_char_mre_id VARCHAR2(30);
3113:
3114: BEGIN
3115: g_proc := 'get_extra_info_comments';
3116: hr_utility.set_location('Entering ' || l_proc,5);
3117: pr('In '||l_proc);
3118:
3119: -- Initialization for NOCOPY Changes
3120: l_sel_flag := p_sel_flag;

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

3166: p_comments := l_comments;
3167: p_mre_id := l_mre_id;
3168: --
3169: pr('Error in '||l_proc);
3170: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3171: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3172: raise mass_error;
3173: END;
3174:

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

3241:
3242: BEGIN
3243: g_proc := 'create_mass_act_prev';
3244:
3245: hr_utility.set_location('Entering ' || l_proc,5);
3246:
3247: pr('Inside ghr_cpdf_temp insert realign id ',to_char(p_mass_realignment_id),null);
3248: pr('t_pos_org is',t_position_organization);
3249:

Line 3285: hr_utility.set_location('Error in Mass Act Custom '||

3281: p_cust_rec => l_cust_rec);
3282:
3283: EXCEPTION
3284: when others then
3285: hr_utility.set_location('Error in Mass Act Custom '||
3286: 'Err is '||sqlerrm(sqlcode),20);
3287: l_mslerrbuf := 'Error in Mass Act Custom '||
3288: 'Err is '|| sqlerrm(sqlcode);
3289: raise mass_error;

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

3480: l_cust_rec.user_attribute29,
3481: l_cust_rec.user_attribute30
3482: );
3483:
3484: hr_utility.set_location('Exiting ' || l_proc,10);
3485: EXCEPTION
3486: when mass_error then raise;
3487: when others then
3488: pr('Error in '||l_proc);

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

3486: when mass_error then raise;
3487: when others then
3488: pr('Error in '||l_proc);
3489: pr('Position title is '||p_position_title||' Length is '||to_char(length(p_position_title)));
3490: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3491: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3492: raise mass_error;
3493: END create_mass_act_prev;
3494:

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

3818: BEGIN
3819:
3820: g_proc := 'assign_to_sf52_rec';
3821:
3822: hr_utility.set_location('Entering ' || l_proc,5);
3823: p_sf52_rec.person_id := p_person_id;
3824: p_sf52_rec.employee_first_name := p_first_name;
3825: p_sf52_rec.employee_last_name := p_last_name;
3826: p_sf52_rec.employee_middle_names := p_middle_names;

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

3862: p_sf52_rec.FIRST_ACTION_LA_CODE2 := p_lac_sf52_rec.FIRST_ACTION_LA_CODE2;
3863: p_sf52_rec.FIRST_ACTION_LA_DESC1 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC1;
3864: p_sf52_rec.FIRST_ACTION_LA_DESC2 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC2;
3865:
3866: hr_utility.set_location('Exiting ' || l_proc,10);
3867:
3868: EXCEPTION
3869: when mass_error then raise;
3870: when others then

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

3873: --
3874: p_sf52_rec := null;
3875: --
3876: pr('Error in '||l_proc);
3877: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3878: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3879: raise mass_error;
3880: END assign_to_sf52_rec;
3881:

Line 3943: hr_utility.set_location('UPDATE posei error 3' || l_proc,10);

3939: ,P_POEI_INFORMATION13 => null
3940: ,P_POEI_INFORMATION14 => null
3941: ,P_POEI_INFORMATION18 => null);
3942: EXCEPTION when others then
3943: hr_utility.set_location('UPDATE posei error 3' || l_proc,10);
3944: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3945: END;
3946:
3947: ----- Reset the global variable

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

3940: ,P_POEI_INFORMATION14 => null
3941: ,P_POEI_INFORMATION18 => null);
3942: EXCEPTION when others then
3943: hr_utility.set_location('UPDATE posei error 3' || l_proc,10);
3944: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3945: END;
3946:
3947: ----- Reset the global variable
3948: ghr_api.g_api_dml := FALSE;

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

3981: l_eff_DATE DATE;
3982:
3983: BEGIN
3984: g_proc := 'upd_ext_info_api';
3985: hr_utility.set_location('Entering ' || l_proc,5);
3986: if p_effective_DATE > sysDATE then
3987: l_eff_DATE := sysDATE;
3988: ELSE
3989: l_eff_DATE := p_effective_DATE;

Line 4050: hr_utility.set_location('UPDATE posei error 4' || l_proc,10);

4046: ,P_POEI_INFORMATION12 => info12
4047: ,P_POEI_INFORMATION13 => info13
4048: ,P_POEI_INFORMATION18 => info18);
4049: EXCEPTION when others then
4050: hr_utility.set_location('UPDATE posei error 4' || l_proc,10);
4051: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4052: END;
4053:
4054: ----- Reset the global variable

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

4047: ,P_POEI_INFORMATION13 => info13
4048: ,P_POEI_INFORMATION18 => info18);
4049: EXCEPTION when others then
4050: hr_utility.set_location('UPDATE posei error 4' || l_proc,10);
4051: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4052: END;
4053:
4054: ----- Reset the global variable
4055: ghr_api.g_api_dml := FALSE;

Line 4077: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);

4073: ---DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
4074: EXCEPTION
4075: when others then
4076: pr('Error in '||'pr');
4077: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
4078: l_mslerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);
4079: raise mass_error;
4080: END;
4081:

Line 4086: hr_utility.set_location('Entering ' || l_proc, 10);

4082: Procedure UPDATE_position_info
4083: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is
4084: l_proc VARCHAR2(30):='UPDATE_position_info';
4085: Begin
4086: hr_utility.set_location('Entering ' || l_proc, 10);
4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);
4088: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);

Line 4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);

4083: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is
4084: l_proc VARCHAR2(30):='UPDATE_position_info';
4085: Begin
4086: hr_utility.set_location('Entering ' || l_proc, 10);
4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);
4088: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);
4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);

Line 4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);

4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);
4088: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);
4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
4092: ghr_history_api.post_UPDATE_process;
4093: hr_utility.set_location('Leaving ' || l_proc, 100);
4094:
4095: END;

Line 4093: hr_utility.set_location('Leaving ' || l_proc, 100);

4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);
4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
4092: ghr_history_api.post_UPDATE_process;
4093: hr_utility.set_location('Leaving ' || l_proc, 100);
4094:
4095: END;
4096:
4097: