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_UPLOAD dependencies on BEN_DM_UTILITY

Line 42: ben_dm_utility.message('ROUT','entry:'|| l_proc , 5);

38: l_proc varchar2(75) ;
39: begin
40: l_proc := g_package || 'init_package_body' ;
41: hr_utility.set_location('Entering:'||l_proc, 5);
42: ben_dm_utility.message('ROUT','entry:'|| l_proc , 5);
43: -- delete all elements from package body pl/sql table.
44: while l_index is not null loop
45: g_package_body.delete(l_index);
46: l_index := g_package_body.next(l_index);

Line 55: ben_dm_utility.message('ROUT','exit:' || l_proc , 25);

51: --initialize the index
52: g_package_index := 0;
53:
54:
55: ben_dm_utility.message('ROUT','exit:' || l_proc , 25);
56: hr_utility.set_location('Leaving:'||l_proc, 10);
57: exception
58: when others then
59: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.init_package_body',

Line 59: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.init_package_body',

55: ben_dm_utility.message('ROUT','exit:' || l_proc , 25);
56: hr_utility.set_location('Leaving:'||l_proc, 10);
57: exception
58: when others then
59: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.init_package_body',
60: '(none)','R');
61: raise;
62: end init_package_body;
63:

Line 88: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);

84:
85: l_proc := g_package||'add_to_package_body' ;
86: hr_utility.set_location('Entering:'||l_proc, 5);
87:
88: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
89: ben_dm_utility.message('PARA','(p_proc_body_tbl - table of varchar2',10);
90:
91: while l_proc_index is not null loop
92:

Line 89: ben_dm_utility.message('PARA','(p_proc_body_tbl - table of varchar2',10);

85: l_proc := g_package||'add_to_package_body' ;
86: hr_utility.set_location('Entering:'||l_proc, 5);
87:
88: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
89: ben_dm_utility.message('PARA','(p_proc_body_tbl - table of varchar2',10);
90:
91: while l_proc_index is not null loop
92:
93: l_string_index := 1;

Line 116: ben_dm_utility.message('INFO',

112: end loop;
113:
114: l_proc_index := p_proc_body_tbl.next(l_proc_index);
115: end loop;
116: ben_dm_utility.message('INFO',
117: '(l_loop_cnt - ' || l_loop_cnt ||
118: ')(l_string_index - ' ||l_string_index ||
119: ')( g_package_index - ' || g_package_index || ')'
120: ,15);

Line 121: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);

117: '(l_loop_cnt - ' || l_loop_cnt ||
118: ')(l_string_index - ' ||l_string_index ||
119: ')( g_package_index - ' || g_package_index || ')'
120: ,15);
121: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
122: hr_utility.set_location('Leaving:'||l_proc, 5);
123: exception
124: when others then
125: ben_dm_utility.error(SQLCODE,l_proc,

Line 125: ben_dm_utility.error(SQLCODE,l_proc,

121: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
122: hr_utility.set_location('Leaving:'||l_proc, 5);
123: exception
124: when others then
125: ben_dm_utility.error(SQLCODE,l_proc,
126: '(l_loop_cnt - ' || l_loop_cnt ||
127: ')(l_string_index - ' ||l_string_index ||
128: ')( g_package_index - ' || g_package_index || ')'
129: ,'R');

Line 182: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);

178: l_proc varchar2(75) ;
179: begin
180: l_proc := g_package|| 'generate_upload' ;
181: hr_utility.set_location('Entering : ' || l_proc , 5 ) ;
182: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
183:
184:
185: l_interface := indent ||
186: '(p_migration_id in number' || indent ||

Line 282: ben_dm_utility.message('ROUT',l_proc, 25);

278: || indent || 'begin' || indent ;
279:
280: -- add the body of this procedure to the package.
281: add_to_package_body( l_proc_body_tbl );
282: ben_dm_utility.message('ROUT',l_proc, 25);
283: hr_utility.set_location('Leaving:'||l_proc, 10);
284: exception
285: when others then
286: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.generate_upload',

Line 286: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.generate_upload',

282: ben_dm_utility.message('ROUT',l_proc, 25);
283: hr_utility.set_location('Leaving:'||l_proc, 10);
284: exception
285: when others then
286: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tups.generate_upload',
287: '(none)','R');
288: raise;
289: end generate_upload;
290:

Line 373: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);

369:
370: begin
371: l_proc := g_package || 'generate_insert_dml' ;
372: hr_utility.set_location('Entering : ' || l_proc , 5 ) ;
373: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
374:
375: -- input parameters for the procedure
376:
377: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||

Line 378: ' ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||

374:
375: -- input parameters for the procedure
376:
377: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||
378: ' ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||
379: ' ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||
380: ' ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||
381: ' ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
382:

Line 379: ' ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||

375: -- input parameters for the procedure
376:
377: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||
378: ' ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||
379: ' ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||
380: ' ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||
381: ' ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
382:
383: -- decide the table has any pig year relation

Line 380: ' ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||

376:
377: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||
378: ' ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||
379: ' ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||
380: ' ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||
381: ' ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
382:
383: -- decide the table has any pig year relation
384: l_h_hierarcy := 'N' ;

Line 381: ' ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;

377: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||
378: ' ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||
379: ' ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||
380: ' ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||
381: ' ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
382:
383: -- decide the table has any pig year relation
384: l_h_hierarcy := 'N' ;
385: open c_H_hier(p_table_info.table_id) ;

Line 467: --l_cursor := l_cursor || ' ben_dm_utility.message(''INFO'','' Primary KEY '' ||l_rslt.PM_KEY ,5) ; ' || indent(l_indent) ;

463: l_cursor := l_cursor || ',p_business_group_name => p_business_group_name' || indent(l_indent) ;
464: l_cursor := l_cursor || ' ); ' || indent(l_indent) ;
465:
466: end if ;
467: --l_cursor := l_cursor || ' ben_dm_utility.message(''INFO'','' Primary KEY '' ||l_rslt.PM_KEY ,5) ; ' || indent(l_indent) ;
468: l_indent := 4 ;
469: l_cursor := l_cursor || indent(l_indent) ;
470:
471: --l_indent := 6 ;

Line 686: ||l_locals||';'||indent(l_indent)||'utl_file.put_line(ben_dm_utility.g_out_file_handle,l_text);'||indent(l_indent) || indent(l_indent-2)

682:
683: l_indent := 6 ;
684:
685: l_proc_body_tbl(l_proc_index) := l_cursor||indent(l_indent)||indent(l_indent)
686: ||l_locals||';'||indent(l_indent)||'utl_file.put_line(ben_dm_utility.g_out_file_handle,l_text);'||indent(l_indent) || indent(l_indent-2)
687: || 'End Loop ; -- for geting record informations ' || indent(l_indent-2) ;
688:
689: l_proc_index := l_proc_index + 1;
690:

Line 692: indent(l_indent) || ' ben_dm_utility.message(''ROUT'','' Exit '' ||l_proc,5) ; ' ;

688:
689: l_proc_index := l_proc_index + 1;
690:
691: l_proc_body_tbl(l_proc_index) := indent( l_indent)|| 'hr_utility.set_location(''Leaving : '' || l_proc,5) ; ' ||
692: indent(l_indent) || ' ben_dm_utility.message(''ROUT'','' Exit '' ||l_proc,5) ; ' ;
693: l_proc_index := l_proc_index + 1;
694:
695: add_to_package_body( l_proc_body_tbl );
696:

Line 697: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);

693: l_proc_index := l_proc_index + 1;
694:
695: add_to_package_body( l_proc_body_tbl );
696:
697: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
698: hr_utility.set_location('Leaving '|| l_proc , 5 ) ;
699: exception
700: when others then
701: ben_dm_utility.error(SQLCODE,l_proc , '(none)','R');

Line 701: ben_dm_utility.error(SQLCODE,l_proc , '(none)','R');

697: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
698: hr_utility.set_location('Leaving '|| l_proc , 5 ) ;
699: exception
700: when others then
701: ben_dm_utility.error(SQLCODE,l_proc , '(none)','R');
702: raise;
703: end generate_insert_dml;
704:
705: -- ------------------------- main ------------------------

Line 755: ben_dm_utility.message('ROUT','entry:'||l_proc , 5);

751: begin
752:
753: l_proc := g_package||'main' ;
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: ben_dm_utility.message('ROUT','entry:'||l_proc , 5);
756:
757:
758:
759: -- open the table cursor and get the table informatons

Line 771: ben_dm_utility.message('PARA','(Table Name - '||l_tbl_rec.table_name|| ')', 10);

767:
768:
769: l_package_name := 'ben_dmu' || lower(l_tbl_rec.short_name ) ;
770:
771: ben_dm_utility.message('PARA','(Table Name - '||l_tbl_rec.table_name|| ')', 10);
772:
773: -- inialize the global package body pl/sql table by deleting all elements.
774: init_package_body;
775:

Line 810: -- add in call to ben_dm_utility.set_globals to set the global variables

806: l_header :=
807: 'create or replace package ' || l_package_name || ' as' || indent ||
808: l_header_comment || indent;
809:
810: -- add in call to ben_dm_utility.set_globals to set the global variables
811: l_header := l_header || indent || '--' || indent ||
812: '-- call to hr_dm_upload.set_globals to set the global variables'
813: || indent || '--' || indent ||
814: '--g_temp_var NUMBER := hr_dm_upload.set_globals;' || indent;

Line 868: ben_dm_utility.error(SQLCODE,l_proc ,

864: l_header := l_header || 'end ' || l_package_name || ';';
865: l_body := l_body || 'end ' || l_package_name || ';';
866: exception
867: when plsql_value_error then
868: ben_dm_utility.error(SQLCODE,l_proc ,
869: 'Either TDS package code size is too big or ' ||
870: ' a value error)',
871: 'R');
872: raise;

Line 887: ' ben_dm_utility.message(''INFO'','' Error '' ||substr(sqlerrm,1,100) ,5) ; '||

883: g_package_index := g_package_index+1;
884:
885: g_package_body(g_package_index ) := indent(2) || 'Exception ' || indent(4) ||
886: 'When others then ' ||indent(6) ||
887: ' ben_dm_utility.message(''INFO'','' Error '' ||substr(sqlerrm,1,100) ,5) ; '||
888: indent(6)|| ' Raise ; ' || indent(2) ||
889: 'End upload ;' || indent || 'end ' ||
890: l_package_name || ';';
891:

Line 904: ben_dm_utility.error(SQLCODE,'Error in compiling TUPS for ' ||

900: exception
901: when others then
902:
903: hr_utility.set_location('Error :'||l_tbl_rec.table_name, 10);
904: ben_dm_utility.error(SQLCODE,'Error in compiling TUPS for ' ||
905: l_tbl_rec.table_name ,'(none)','R');
906: raise;
907: end;
908:

Line 916: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);

912: -- ,p_version => l_generator_version
913: -- ) ;
914: --
915:
916: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
917: hr_utility.set_location('Leaving:'||l_proc, 10);
918:
919: exception
920: when others then

Line 921: ben_dm_utility.error(SQLCODE,l_proc, '(none)','R');

917: hr_utility.set_location('Leaving:'||l_proc, 10);
918:
919: exception
920: when others then
921: ben_dm_utility.error(SQLCODE,l_proc, '(none)','R');
922: raise;
923: end main ;
924:
925: end BEN_DM_GEN_UPLOAD;