APPS.GHR_EEOC_STATUS_REPORT dependencies on HR_UTILITY

Line 135: hr_utility.set_location('Inside EEOC_STATUS_RPT_ERR exception ',30);

131:
132: insert_row;
133: EXCEPTION
134: WHEN EEOC_STATUS_RPT_ERR THEN
135: hr_utility.set_location('Inside EEOC_STATUS_RPT_ERR exception ',30);
136: ghr_mto_int.log_message(p_procedure => g_message_name,
137: p_message => l_log_text);
138: COMMIT;
139: END;

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

175: WHERE p_person_id = pap.person_id
176: AND p_report_date between pap.effective_start_date AND pap.effective_end_date;
177:
178: BEGIN
179: hr_utility.set_location('Entering:'||l_proc,5);
180: g_message_name := 'Fetch Person Details';
181:
182: FOR per_rec in c_per_det
183: LOOP

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

207: WHERE grade_definition_id = (SELECT MAX(grade_definition_id)
208: FROM per_grades
209: WHERE grade_id = p_grade_id);
210: BEGIN
211: hr_utility.set_location('Entering:'||l_proc,5);
212: g_message_name := 'Grade Details';
213:
214: FOR l_grade_rec IN c_grade_def
215: LOOP

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

225: l_proc VARCHAR2(30) := 'fetch_perei_details';
226: l_perei_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
227: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
228: BEGIN
229: hr_utility.set_location('Entering:'||l_proc,5);
230:
231: g_message_name := 'Person EIT: Person Group1';
232: l_perei_data := null;
233: ghr_history_fetch.fetch_peopleei(p_person_id => p_person_id,

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

299: p_report_date IN DATE) IS
300: l_proc VARCHAR2(30) := 'fetch_posei_details';
301: l_posei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
302: BEGIN
303: hr_utility.set_location('Entering:'||l_proc,5);
304: g_message_name := 'Position EIT: Position Group1';
305: l_posei_data := NULL;
306: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,
307: p_information_type => 'GHR_US_POS_GRP1',

Line 330: hr_utility.set_location('mani l_posei_data.poei_information17'||l_posei_data.poei_information17,100);

326: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,
327: p_information_type => 'GHR_US_POS_GRP2',
328: p_date_effective => p_report_date,
329: p_pos_ei_data => l_posei_data);
330: hr_utility.set_location('mani l_posei_data.poei_information17'||l_posei_data.poei_information17,100);
331: IF NVL(l_posei_data.poei_information17,'@') = 'APPR' THEN
332: g_temp_rec.cont_pay_type_code := 'APF';
333: ELSE
334: g_temp_rec.cont_pay_type_code := 'NAF';

Line 336: hr_utility.set_location('mani g_temp_rec.cont_pay_type_code'||g_temp_rec.cont_pay_type_code,100);

332: g_temp_rec.cont_pay_type_code := 'APF';
333: ELSE
334: g_temp_rec.cont_pay_type_code := 'NAF';
335: END IF;
336: hr_utility.set_location('mani g_temp_rec.cont_pay_type_code'||g_temp_rec.cont_pay_type_code,100);
337:
338: END FETCH_POSEI_DETAILS;
339:
340: PROCEDURE FETCH_ASGEI_DETAILS(p_assignment_id in NUMBER,

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

342:
343: l_proc VARCHAR2(30) := 'fetch_asgei_details';
344: l_asgnei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
345: BEGIN
346: hr_utility.set_location('Entering:'||l_proc,5);
347:
348: g_message_name := 'Assignment EIT: Asg SF52';
349: l_asgnei_data := NULL;
350: GHR_HISTORY_FETCH.fetch_asgei(p_assignment_id => p_assignment_id,

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

371: l_proc varchar2(30) := 'Fetch_Element_Details';
372: l_value VARCHAR2(250);
373: l_effective_start_date DATE;
374: BEGIN
375: hr_utility.set_location('Entering:'||l_proc,5);
376:
377: g_message_name := 'Fetch Element: Basic Salary';
378: l_value := NULL;
379: ghr_per_sum.get_element_details (p_element_name => 'Basic Salary Rate'

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

446:
447: PROCEDURE cleanup_table(p_type in VARCHAR2) IS
448: l_proc varchar2(30) := 'cleanup_table';
449: BEGIN
450: hr_utility.set_location('Entering:'||l_proc,5);
451: DELETE FROM ghr_cpdf_temp
452: WHERE report_type = p_type
453: AND session_id = userenv('SESSIONID');
454: END cleanup_table;

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

458: l_log_text ghr_process_log.log_text%type;
459: l_message_name ghr_process_log.message_name%type;
460:
461: BEGIN
462: hr_utility.set_location('Entering:'||l_proc,5);
463:
464: INSERT INTO ghr_cpdf_temp(report_type
465: ,session_id
466: ,agency_code