eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_GEN_MASTER dependencies on HR_UTILITY

Line 68: hr_utility.set_location('Entering:'||l_proc, 5);

64: begin
65:
66: l_proc := g_package || 'main_generator' ;
67:
68: hr_utility.set_location('Entering:'||l_proc, 5);
69:
70:
71: l_last_migration_date := to_date(p_last_migration_date, 'YYYY/MM/DD HH24:MI:SS');
72: -- initialize messaging

Line 139: hr_utility.set_location('Calling Upload for :'||l_csr_get_table_rec.table_alias , 40);

135: l_csr_get_table_rec.table_id,30);
136: --
137: -- Call TUPS genrator to create TUPS for the table
138: --
139: hr_utility.set_location('Calling Upload for :'||l_csr_get_table_rec.table_alias , 40);
140: ben_dm_utility.message('INFO',' Started Generating TUPS for ' ||
141: l_csr_get_table_rec.table_name,50);
142:
143: BEN_DM_GEN_UPLOAD.main (

Line 158: hr_utility.set_location('Calling Download for :'||l_csr_get_table_rec.table_alias , 10);

154: --
155: ben_dm_utility.message('INFO',' Started Generating TDS for ' ||
156: l_csr_get_table_rec.table_name,70);
157:
158: hr_utility.set_location('Calling Download for :'||l_csr_get_table_rec.table_alias , 10);
159:
160: BEN_DM_GEN_DOWNLOAD.main (
161: p_table_alias => l_csr_get_table_rec.table_alias,
162: p_migration_id => p_migration_id

Line 208: hr_utility.set_location('Leaving:'||l_proc, 10);

204: retcode := 0;
205: errbuf := 'No errors - examine logfiles for detailed reports.';
206:
207: ben_dm_utility.message('ROUT','exit:' || l_proc , 150);
208: hr_utility.set_location('Leaving:'||l_proc, 10);
209: -- error handling
210: exception
211: when e_fatal_error then
212: if csr_get_table%isopen then

Line 342: hr_utility.set_location('Entering:'||l_proc, 10);

338: e_fatal_error2 exception;
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

Line 476: hr_utility.set_location('Leaving:'||l_proc, 10);

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:
480: when e_fatal_error2 then

Line 576: hr_utility.set_location('Entering:'||l_proc, 10);

572: e_fatal_error2 exception;
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

Line 669: hr_utility.set_location(' starting ' || l_input_file_rec.group_order , 99 ) ;

665: raise e_fatal_error2;
666: end if ;
667:
668:
669: hr_utility.set_location(' starting ' || l_input_file_rec.group_order , 99 ) ;
670:
671: ben_dm_utility.message('INFO','Started upload data for ' ||
672: l_input_file_rec.group_order || ', Group - BG ' ||
673: l_input_file_rec.target_business_group_name,40);

Line 684: hr_utility.set_location(' building sql for ' || t_tab_short_name(i), 99 ) ;

680: -- for every table for the group order loop through tables
681: for i in 1..t_tab_short_name.count
682: Loop
683:
684: hr_utility.set_location(' building sql for ' || t_tab_short_name(i), 99 ) ;
685: ben_dm_utility.message('INFO',' Building SQL for ' || t_tab_short_name(i),70);
686:
687: lstring := 'Begin ' || l_pre_fix||t_tab_short_name(i)||'.UPLOAD(' ;
688: lstring := lstring || 'p_migration_id => :1 ' ;

Line 696: hr_utility.set_location(' executing sql for ' || t_tab_short_name(i), 99 ) ;

692: lstring := lstring || ',p_delimiter => :5 ' ;
693: lstring := lstring || ' ) ; END ; ' ;
694:
695:
696: hr_utility.set_location(' executing sql for ' || t_tab_short_name(i), 99 ) ;
697: ben_dm_utility.message('INFO',' Executing ' || t_tab_short_name(i),70);
698: begin
699: execute immediate lstring using
700: p_migration_id ,

Line 715: hr_utility.set_location(' upload completed for ' || t_tab_short_name(i), 99 ) ;

711: raise e_fatal_error2;
712:
713: end;
714:
715: hr_utility.set_location(' upload completed for ' || t_tab_short_name(i), 99 ) ;
716: ben_dm_utility.message('INFO',' Upload Completed for ' || t_tab_short_name(i),70);
717:
718: end loop ;
719:

Line 724: hr_utility.set_location(' upload completed for ' || l_input_file_rec.group_order , 99 ) ;

720:
721: /*
722:
723: -- call this for every order once , if the order changed to loop , move below the loop
724: hr_utility.set_location(' upload completed for ' || l_input_file_rec.group_order , 99 ) ;
725: ben_dm_utility.message('INFO','Call for Self reference :'||l_phase_rec.group_order , 60);
726:
727: lstring := 'Begin ben_dm_resolve_reference.main( ' ;
728: lstring := lstring || 'p_migration_id => :1 ' ;

Line 756: hr_utility.set_location(' download completed for ' || l_phase_rec.group_order , 99 ) ;

752: -- clear the cache for every group order
753: ben_dm_data_util.g_pk_maping_tbl.delete ;
754:
755:
756: hr_utility.set_location(' download completed for ' || l_phase_rec.group_order , 99 ) ;
757:
758: ben_dm_utility.message('INFO','Uploded succesfully for ' || l_phase_rec.group_order,70);
759:
760:

Line 773: hr_utility.set_location('Leaving:'||l_proc, 10);

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';
777: retcode := 0;