339:
340: begin
341: l_proc := g_package || 'download' ;
342: hr_utility.set_location('Entering:'||l_proc, 10);
343: hr_general.g_data_migrator_mode := 'Y';
344: l_pre_fix := 'BEN_DMD' ;
345: l_last_migration_date := to_date(p_last_migration_date, 'YYYY/MM/DD HH24:MI:SS');
346: -- initialize messaging
347: if p_concurrent_process = 'Y' then
471: l_input_file_rec.source_person_id || ', SSN - ' ||
472: l_input_file_rec.SOURCE_NATIONAL_IDENTIFIER,90);
473:
474: End Loop ;
475: hr_general.g_data_migrator_mode := 'N';
476: hr_utility.set_location('Leaving:'||l_proc, 10);
477: ben_dm_utility.message('ROUT','EXIT ' || l_proc ,100);
478: Exception
479:
477: ben_dm_utility.message('ROUT','EXIT ' || l_proc ,100);
478: Exception
479:
480: when e_fatal_error2 then
481: hr_general.g_data_migrator_mode := 'N';
482: retcode := 0;
483: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
484: ben_dm_utility.error(SQLCODE,l_proc , l_fatal_error_message,'R');
485:
489: end if;
490:
491: ben_dm_utility.error(SQLCODE,l_proc,'(none)','R');
492: when others then
493: hr_general.g_data_migrator_mode := 'N';
494: retcode := 2;
495: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
496: -- update status to error
497: ben_dm_utility.update_phase_items(p_new_status => 'E',
573:
574: begin
575: l_proc := g_package || 'upload' ;
576: hr_utility.set_location('Entering:'||l_proc, 10);
577: hr_general.g_data_migrator_mode := 'Y';
578: l_pre_fix := 'BEN_DMU' ;
579: l_last_migration_date := to_date(p_last_migration_date, 'YYYY/MM/DD HH24:MI:SS');
580: -- initialize messaging
581: if p_concurrent_process = 'Y' then
768: -- clear the fk cache
769: ben_dm_data_util.g_fk_maping_tbl.delete ;
770:
771: ben_dm_utility.message('ROUT','EXIT ' || l_proc,100);
772: hr_general.g_data_migrator_mode := 'N';
773: hr_utility.set_location('Leaving:'||l_proc, 10);
774: Exception
775: when e_fatal_error2 then
776: hr_general.g_data_migrator_mode := 'N';
772: hr_general.g_data_migrator_mode := 'N';
773: hr_utility.set_location('Leaving:'||l_proc, 10);
774: Exception
775: when e_fatal_error2 then
776: hr_general.g_data_migrator_mode := 'N';
777: retcode := 0;
778: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
779: ben_dm_utility.error(SQLCODE,l_proc , l_fatal_error_message,'R');
780:
787: end if;
788:
789: ben_dm_utility.error(SQLCODE,l_proc,'(none)','R');
790: when others then
791: hr_general.g_data_migrator_mode := 'N';
792: retcode := 2;
793: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
794: -- update status to error
795: ben_dm_utility.update_phase_items(p_new_status => 'E',