APPS.GHR_SS_RPA_CREATION dependencies on HR_API

Line 100: ghr_api.retrieve_element_entry_value

96: if chk_fegli_exists%notfound then
97:
98: --Bug # 12397367 This has been added to avoid FEGLI RPA not to be created during Appointment
99: -- as 881 RPA is not required if existing element entry value and modified FEGLI code are same
100: ghr_api.retrieve_element_entry_value
101: (p_element_name => 'FEGLI',
102: p_input_value_name => 'FEGLI',
103: p_assignment_id => p_assignment_id,
104: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 171: ghr_api.retrieve_element_entry_value

167: END;
168:
169: --Eligibility Expiration
170: BEGIN
171: ghr_api.retrieve_element_entry_value
172: (p_element_name => 'FEGLI',
173: p_input_value_name => 'Eligibility Expiration',
174: p_assignment_id => p_assignment_id,
175: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 380: ghr_api.sf52_from_data_elements

376:
377:
378:
379: BEGIN
380: ghr_api.sf52_from_data_elements
381: (p_person_id => l_sf52_rec.person_id
382: ,p_assignment_id => l_sf52_rec.employee_assignment_id
383: ,p_effective_date => l_sf52_rec.effective_date
384: ,p_altered_pa_request_id => null

Line 427: hr_utility.set_location('Error in ghr_api.sf52_from_data_elements'||

423: ,p_work_schedule => l_dummy_char
424: );
425: EXCEPTION
426: WHEN OTHERS THEN
427: hr_utility.set_location('Error in ghr_api.sf52_from_data_elements'||
428: 'Err is'||sqlerrm(sqlcode),20);
429: l_log_text := 'Error in sf52_from_data_elements for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
430: || '; SQL Error: '|| sqlerrm(sqlcode);
431: raise fegli_error;

Line 485: ghr_api.return_education_Details

481: raise fegli_error;
482: END;
483:
484: BEGIN
485: ghr_api.return_education_Details
486: (p_person_id => l_sf52_rec.person_id,
487: p_effective_date => l_sf52_rec.effective_date,
488: p_education_level => l_sf52_rec.education_level,
489: p_academic_discipline => l_sf52_rec.academic_discipline,

Line 494: hr_utility.set_location('Error in ghr_api.return_education_Details'||

490: p_year_degree_attained => l_sf52_rec.year_degree_attained
491: );
492: EXCEPTION
493: WHEN OTHERS THEN
494: hr_utility.set_location('Error in ghr_api.return_education_Details'||
495: 'Err is '||sqlerrm(sqlcode),20);
496: l_log_text := 'Error in return_education_Details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
497: || '; SQL Error:'|| sqlerrm(sqlcode);
498: raise fegli_error;

Line 540: ghr_api.retrieve_element_entry_value

536: ,'GHR_US_FEGLI'
537: ,l_sf52_rec.fegli
538: );
539:
540: ghr_api.retrieve_element_entry_value
541: (p_element_name => 'Retirement Plan'
542: ,p_input_value_name => 'Plan'
543: ,p_assignment_id => l_sf52_rec.employee_assignment_id
544: ,p_effective_date => l_sf52_rec.effective_date

Line 830: ghr_api.retrieve_element_entry_value

826:
827: hr_utility.set_location('l_sf52_rec.fegli'||l_sf52_rec.fegli,1000);
828: BEGIN
829: --Fetching the actual Fegli code from Element Entry
830: ghr_api.retrieve_element_entry_value
831: (p_element_name => 'FEGLI',
832: p_input_value_name => 'FEGLI',
833: p_assignment_id => p_assignment_id,
834: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1254: ghr_api.retrieve_element_entry_value

1250: p_object_version_number => l_sf52_rec.object_version_number);
1251:
1252: BEGIN
1253: --Fetching the actual Fegli code from Element Entry
1254: ghr_api.retrieve_element_entry_value
1255: (p_element_name => 'FEGLI',
1256: p_input_value_name => 'FEGLI',
1257: p_assignment_id => p_assignment_id,
1258: p_effective_date => nvl(p_effective_date,trunc(sysdate)),