DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on GHR_MTO_INT

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

648: If get_elig_chc_id%ISOPEN Then
649: close get_elig_chc_id;
650: End If;
651: rollback;
652: ghr_mto_int.log_message(null,l_err_msg);
653: /*ghr_wgi_pkg.create_ghr_errorlog
654: (p_program_name => 'FEHB_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
655: p_log_text => l_err_msg,
656: p_message_name => null,

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

667: close get_elig_chc_id;
668: End If;
669: rollback;
670: l_err_msg := 'Name :'|| l_name||' SSN :'||l_ssn;
671: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
672: /*ghr_wgi_pkg.create_ghr_errorlog
673: (p_program_name => 'FEHB_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
674: p_log_text => 'PERSON ID:'||p_person_id || ' ' || sqlerrm(sqlcode),
675: p_message_name => null,

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

1016: When ben_Enrt_Exists Then
1017: null;
1018: When Nothing_to_do Then
1019: rollback;
1020: ghr_mto_int.log_message(null,l_err_msg);
1021: /*
1022: ghr_wgi_pkg.create_ghr_errorlog
1023: (p_program_name => 'TSP_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
1024: p_log_text => l_err_msg,

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

1029: When others then
1030: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1031: rollback;
1032: l_err_msg := 'Name :'|| l_name||' SSN :'||l_ssn;
1033: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
1034: /* ghr_wgi_pkg.create_ghr_errorlog
1035: (p_program_name => 'TSP_MIG-'||to_char(sysdate,'MM/DD/YYYY'),
1036: p_log_text => 'PERSON ID:'||p_person_id || ' ' || sqlerrm(sqlcode),
1037: p_message_name => null,

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

1367: When ben_Enrt_Exists Then
1368: null;
1369: When Nothing_to_do Then
1370: rollback;
1371: ghr_mto_int.log_message(null,l_err_msg);
1372: --dbms_output.put_line('Data Issue... Nothing_to_do! ');
1373: When others then
1374: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1375: rollback;

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

1373: When others then
1374: --dbms_output.put_line('Script Failed. Contact Your System Administrator.! ');
1375: rollback;
1376: l_err_msg := 'Name :'|| l_name||' SSN :'||l_ssn;
1377: ghr_mto_int.log_message(null,l_err_msg||' '||sqlerrm(sqlcode));
1378: End ghr_tsp_catchup_migrate;
1379:
1380: end ghr_general;