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_DOWNLOAD dependencies on HR_UTILITY

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

51: l_index number := g_package_body.first;
52: l_proc varchar2(75) ;
53: begin
54: l_proc := g_package|| 'init_package_body' ;
55: hr_utility.set_location('Entering : ' || l_proc , 5 ) ;
56:
57: ben_dm_utility.message('ROUT','entry: '|| l_proc , 5);
58:
59: -- delete all elements from package body pl/sql table.

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

63: end loop;
64: --initialize the index
65: g_package_index := 0;
66: ben_dm_utility.message('ROUT','exit :' || l_proc , 25);
67: hr_utility.set_location('Leaving : ' || l_proc , 10 ) ;
68: exception
69: when others then
70: ben_dm_utility.error(SQLCODE,l_proc, '(none)','R');
71: raise;

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

261: l_proc varchar2(75) ;
262: begin
263: l_proc := g_package||'get_derive_from_clause' ;
264:
265: hr_utility.set_location('Entering '|| l_proc, 5) ;
266:
267: ben_dm_utility.message('ROUT','entry: '|| l_proc , 5);
268: ben_dm_utility.message('PARA','(p_from_clause - ' || p_from_clause ||
269: ')(p_lpad_spaces - ' || p_lpad_spaces ||

Line 302: hr_utility.set_location('Leaving '|| l_proc, 5) ;

298: end loop;
299:
300: ben_dm_utility.message('ROUT','exit: ' || l_proc , 25);
301: ben_dm_utility.message('PARA','(p_from_clause - ' || p_from_clause || ')',30);
302: hr_utility.set_location('Leaving '|| l_proc, 5) ;
303: exception
304: when others then
305: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.get_derive_from_clause',
306: '(l_derive_sql - ' || l_derive_sql ||

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

330:
331: begin
332:
333: l_proc := g_package|| 'get_dt_cursor_where_clause' ;
334: hr_utility.set_location(' Entering '|| l_proc, 5 ) ;
335:
336: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
337:
338: l_derive_sql := p_table_info.derive_sql ;

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

372: p_where_clause := lpad(' ',p_lpad_spaces) || ' ';
373:
374:
375: ben_dm_utility.message('ROUT','exit:' || l_proc , 25);
376: hr_utility.set_location('Leaving '|| l_proc, 10 ) ;
377: exception
378: when others then
379: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.get_dt_cursor_where_clause',
380: '(none)','R');

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

400: l_prefix_col varchar2(30);
401: l_proc varchar2(75) ;
402: begin
403: l_proc := g_package || 'prepare_download_cursor' ;
404: hr_utility.set_location('Entering '|| l_proc, 5 ) ;
405: ben_dm_utility.message('ROUT','entry: ' || l_proc , 5);
406:
407:
408:

Line 451: hr_utility.set_location('Leaving '|| l_proc, 5 ) ;

447: l_cursor_select_where || indent;
448:
449: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
450: ben_dm_utility.message('PARA','(p_cursor - ' || p_cursor || ')' ,30);
451: hr_utility.set_location('Leaving '|| l_proc, 5 ) ;
452: exception
453: when others then
454: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.prepare_download_cursor',
455: '(none)','R');

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

531: l_proc varchar2(75) ;
532: begin
533: l_proc := g_package||'generate_download' ;
534:
535: hr_utility.set_location('Entering '|| l_proc , 5 ) ;
536: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
537:
538: l_columns_tbl := g_columns_tbl;
539: l_func_name := 'download';

Line 582: 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||

578:
579: l_indent := 3;
580: l_proc_body_tbl(l_proc_index) := indent(l_indent) ||
581: 'l_rec_inserted_cnt := 0;' || indent(l_indent) || indent(l_indent) ||
582: 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ||
583: 'ben_dm_utility.message(''ROUT'','' Entering '' ||l_proc,5) ; ' || indent(l_indent) ||
584: 'ben_dm_utility.message(''PARA'', '' ( Person - '' || p_person_id || '')'' , 10) ;'|| indent(l_indent) ||
585: 'ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| indent(l_indent) ||
586: 'ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| indent(l_indent)||

Line 658: l_debug_message_text := indent(l_indent) || 'hr_utility.set_location(''Leaving : '' || l_proc,5) ; '||

654: || indent(l_indent) ;
655: l_proc_index := l_proc_index + 1;
656:
657: --l_indent := 0;
658: l_debug_message_text := indent(l_indent) || 'hr_utility.set_location(''Leaving : '' || l_proc,5) ; '||
659: indent(l_indent) ||' ben_dm_utility.message(''ROUT'','' Exit '' ||l_proc,5) ; ' ||
660: indent || 'End ' || l_func_name || ' ; ' ;
661: l_proc_body_tbl(l_proc_index) := l_debug_message_text;
662: l_proc_index := l_proc_index + 1;

Line 679: hr_utility.set_location('Leaving '|| l_proc , 5 ) ;

675: -- add the body of this procedure to the package.
676: add_to_package_body( l_proc_body_tbl );
677:
678: ben_dm_utility.message('ROUT','exit:'||l_proc, 25);
679: hr_utility.set_location('Leaving '|| l_proc , 5 ) ;
680: exception
681: when others then
682: ben_dm_utility.error(SQLCODE,l_proc, '(none)','R');
683: raise;

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

752:
753: begin
754:
755: l_proc := g_package || 'main' ;
756: hr_utility.set_location('Entering:'||l_proc, 5);
757:
758: ben_dm_utility.message('ROUT','entry:'||l_proc , 5);
759:
760:

Line 862: hr_utility.set_location('PACKAGE BODY :'||l_package_name, 5);

858: g_package_index := g_package_index+1;
859: g_package_body(g_package_index ) := indent || 'end ' ||
860: l_package_name || ';';
861:
862: hr_utility.set_location('PACKAGE BODY :'||l_package_name, 5);
863: --
864: -- Compile the header and body.
865: --
866:

Line 873: hr_utility.set_location('PACKAGE BODY :'||l_package_name, 5);

869: g_package_index);
870:
871:
872: -- check the status of the package
873: hr_utility.set_location('PACKAGE BODY :'||l_package_name, 5);
874: -- check the status of the package
875: begin
876: hr_dm_library.check_compile (p_object_name => l_package_name,
877: p_object_type => 'PACKAGE BODY' );

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

882: raise;
883: end;
884:
885: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
886: hr_utility.set_location('Leaving:'||l_proc, 10);
887: exception
888: when others then
889: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.create_tds_pacakge ',
890: '(none)','R');