DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on GHR_MTO_INT

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

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

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

2472: l_records_found:=FALSE;
2473: -- hr_utility.trace_on(null,'venkat');
2474: hr_utility.set_location('Entering:'||l_proc, 10);
2475: --
2476: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2477: --
2478: IF p_end_date > p_start_Date THEN
2479:
2480: FOR cur_get_pars_rec IN cur_get_pars

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

4132:
4133: EXCEPTION
4134: WHEN EHRI_DYNRPT_ERROR THEN
4135: hr_utility.set_location('Inside EHRI_DYNRPT_ERROR exception ',30);
4136: ghr_mto_int.log_message(p_procedure => l_message_name,
4137: p_message => l_log_text
4138: );
4139: COMMIT;
4140: WHEN OTHERS THEN

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

4148: ' ; first NOAC/Second NOAC: '||
4149: l_ghr_pa_requests_rec.first_noa_code || ' / '||
4150: l_ghr_pa_requests_rec.second_noa_code ||
4151: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
4152: ghr_mto_int.log_message(p_procedure => l_message_name,
4153: p_message => l_log_text
4154: );
4155: COMMIT;
4156:

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

4160:
4161: IF NOT l_records_found THEN
4162: l_message_name:='RECORDS_NOT_FOUND';
4163: l_log_text:= 'No Records found for the period '||p_start_Date||' - '||p_end_date;
4164: ghr_mto_int.log_message(p_procedure => l_message_name,
4165: p_message => l_log_text
4166: );
4167:
4168: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;

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

4174: l_message_name:= 'CHECK_REPORT_FROM_TO_DATES';
4175: l_log_text:='The Report To Date: '||p_end_date||' is less than the Report From Date: '||p_start_date||
4176: '. Please enter a value for Report To Date greater than or equal to the Report Start Date';
4177:
4178: ghr_mto_int.log_message(p_procedure => l_message_name,
4179: p_message => l_log_text
4180: );
4181: END IF;
4182:

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

4234: WHEN OTHERS THEN
4235: l_message_name := 'Unhandled Error';
4236: l_log_text := 'Unhandled Error under procedure ehri_dynamics_main'||
4237: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
4238: ghr_mto_int.log_message(p_procedure => l_message_name,
4239: p_message => l_log_text
4240: );
4241: COMMIT;
4242: END ehri_dynamics_main;