DBA Data[Home] [Help]

APPS.GHR_EEOC_STATUS_REPORT dependencies on GHR_MTO_INT

Line 136: ghr_mto_int.log_message(p_procedure => g_message_name,

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;
140: END LOOP;

Line 146: ghr_mto_int.log_message(p_procedure => g_message_name,

142:
143: IF NOT l_records_found THEN
144: g_message_name:='RECORDS_NOT_FOUND';
145: l_log_text:= 'No Records found for the given Report Date '||p_report_date;
146: ghr_mto_int.log_message(p_procedure => g_message_name,
147: p_message => l_log_text
148: );
149:
150: l_mesgbuff1:='No Records found for the given Report Date '||p_report_date;

Line 527: ghr_mto_int.log_message(p_procedure => g_message_name,

523: WHEN OTHERS THEN
524: g_message_name := 'Unhandled Error';
525: l_log_text := 'Unhandled Error under procedure insert_row'||
526: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
527: ghr_mto_int.log_message(p_procedure => g_message_name,
528: p_message => l_log_text);
529: COMMIT;
530:
531: END insert_row;

Line 910: ghr_mto_int.set_log_program_name('GHR_EEOC_STATUS_RPT');

906: l_report_name VARCHAR2(80);
907: BEGIN
908:
909:
910: ghr_mto_int.set_log_program_name('GHR_EEOC_STATUS_RPT');
911: l_report_date := fnd_date.canonical_to_date(p_report_date);
912:
913: l_ret_code := 0;
914: INSERT INTO fnd_sessions

Line 949: ghr_mto_int.log_message(p_procedure => g_message_name,

945: WHEN OTHERS THEN
946: g_message_name := 'Unhandled Error';
947: l_log_text := 'Unhandled Error under procedure eeoc_status_main Date '||p_report_date||
948: ' ** Error Message ** : ' ||substr(sqlerrm,1,1000);
949: ghr_mto_int.log_message(p_procedure => g_message_name,
950: p_message => l_log_text);
951: COMMIT;
952:
953: END;