DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on GHR_MTO_INT

Line 663: ghr_mto_int.log_message(null,l_err_msg);

659: If get_elig_chc_id%ISOPEN Then
660: close get_elig_chc_id;
661: End If;
662: rollback;
663: ghr_mto_int.log_message(null,l_err_msg);
664: /*ghr_wgi_pkg.create_ghr_errorlog
665: (p_program_name => 'FEHB_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
666: p_log_text => l_err_msg,
667: p_message_name => null,

Line 683: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));

679: End If;
680: rollback;
681: --Bug # 9329643 Modified SSN to Emp No
682: l_err_msg := 'Name :'|| l_name||' Emp No : '||l_employee_number;
683: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
684: /*ghr_wgi_pkg.create_ghr_errorlog
685: (p_program_name => 'FEHB_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
686: p_log_text => 'PERSON ID:'||p_person_id || ' ' || sqlerrm(sqlcode),
687: p_message_name => null,

Line 1043: ghr_mto_int.log_message(null,l_err_msg);

1039: When ben_Enrt_Exists Then
1040: null;
1041: When Nothing_to_do Then
1042: rollback;
1043: ghr_mto_int.log_message(null,l_err_msg);
1044: /*
1045: ghr_wgi_pkg.create_ghr_errorlog
1046: (p_program_name => 'TSP_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
1047: p_log_text => l_err_msg,

Line 1057: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));

1053: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1054: rollback;
1055: --Bug # 9329643 Modified SSN to Emp No
1056: l_err_msg := 'Name :'|| l_name||' Emp No : '||l_employee_number;
1057: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
1058: /* ghr_wgi_pkg.create_ghr_errorlog
1059: (p_program_name => 'TSP_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
1060: p_log_text => 'PERSON ID:'||p_person_id || ' ' || sqlerrm(sqlcode),
1061: p_message_name => null,

Line 1405: ghr_mto_int.log_message(null,l_err_msg);

1401: When ben_Enrt_Exists Then
1402: null;
1403: When Nothing_to_do Then
1404: rollback;
1405: ghr_mto_int.log_message(null,l_err_msg);
1406: --dbms_output.put_line('Data Issue... Nothing_to_do! ');
1407: When others then
1408: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1409: rollback;

Line 1412: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));

1408: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1409: rollback;
1410: --Bug # 9329643 Modified SSN to Emp No
1411: l_err_msg := 'Name :'|| l_name||' Emp No : '||l_employee_number;
1412: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
1413: End ghr_tsp_catchup_migrate;
1414:
1415: end ghr_general;