DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on GHR_MTO_INT

Line 417: ghr_mto_int.log_message(p_procedure => 'No US Fed Perf Appraisal Info',

413: -- Generate entry in PROCESS_LOG
414: OPEN c_per;
415: FETCH c_per INTO l_emp_number;
416: CLOSE c_per;
417: ghr_mto_int.log_message(p_procedure => 'No US Fed Perf Appraisal Info',
418: p_message => 'Employee number ' || l_emp_number ||
419: ' does not have US Fed Perf Appraisal ' ||
420: 'on ' || TO_CHAR(p_effective_date, 'DD-MON-YYYY'));*/
421: END;

Line 2661: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');

2657: l_records_found:=FALSE;
2658: -- hr_utility.trace_on(null,'venkat');
2659: hr_utility.set_location('Entering:'||l_proc, 10);
2660: --
2661: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2662: --
2663: IF p_end_date > p_start_Date THEN
2664: --8486208 added fot the ne wparameter
2665: if p_agency_group is not null then

Line 4434: ghr_mto_int.log_message(p_procedure => l_message_name,

4430:
4431: EXCEPTION
4432: WHEN EHRI_DYNRPT_ERROR THEN
4433: hr_utility.set_location('Inside EHRI_DYNRPT_ERROR exception ',30);
4434: ghr_mto_int.log_message(p_procedure => l_message_name,
4435: p_message => l_log_text
4436: );
4437: COMMIT;
4438: WHEN OTHERS THEN

Line 4451: ghr_mto_int.log_message(p_procedure => l_message_name,

4447: ' ; first NOAC/Second NOAC: '||
4448: l_ghr_pa_requests_rec.first_noa_code || ' / '||
4449: l_ghr_pa_requests_rec.second_noa_code ||
4450: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
4451: ghr_mto_int.log_message(p_procedure => l_message_name,
4452: p_message => l_log_text
4453: );
4454: COMMIT;
4455:

Line 4463: ghr_mto_int.log_message(p_procedure => l_message_name,

4459:
4460: IF NOT l_records_found THEN
4461: l_message_name:='RECORDS_NOT_FOUND';
4462: l_log_text:= 'No Records found for the period '||p_start_Date||' - '||p_end_date;
4463: ghr_mto_int.log_message(p_procedure => l_message_name,
4464: p_message => l_log_text
4465: );
4466:
4467: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;

Line 4477: ghr_mto_int.log_message(p_procedure => l_message_name,

4473: l_message_name:= 'CHECK_REPORT_FROM_TO_DATES';
4474: l_log_text:='The Report To Date: '||p_end_date||' is less than the Report From Date: '||p_start_date||
4475: '. Please enter a value for Report To Date greater than or equal to the Report Start Date';
4476:
4477: ghr_mto_int.log_message(p_procedure => l_message_name,
4478: p_message => l_log_text
4479: );
4480: END IF;
4481:

Line 4550: ghr_mto_int.log_message(p_procedure => l_message_name,

4546: WHEN OTHERS THEN
4547: l_message_name := 'Unhandled Error';
4548: l_log_text := 'Unhandled Error under procedure ehri_dynamics_main'||
4549: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
4550: ghr_mto_int.log_message(p_procedure => l_message_name,
4551: p_message => l_log_text
4552: );
4553: COMMIT;
4554: END ehri_dynamics_main;