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 BEN_DM_UTILITY

Line 40: ben_dm_utility.error(SQLCODE,l_proc ,

36: p_newline => p_newline);
37: return l_spaces;
38: exception
39: when others then
40: ben_dm_utility.error(SQLCODE,l_proc ,
41: '(p_indent_spaces - ' || p_indent_spaces ||
42: ')(p_newline - ' || p_newline || ')',
43: 'R');
44: end indent;

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

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.
60: while l_index is not null loop
61: g_package_body.delete(l_index);

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

62: l_index := g_package_body.next(l_index);
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');

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

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;
72: end init_package_body;
73:
74:

Line 167: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.format_comment',

163: end if;
164: return l_comment_text;
165: exception
166: when others then
167: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.format_comment',
168: '(p_ins_blank_lines - ' || p_ins_blank_lines ||
169: ')(p_indent_spaces - ' || p_indent_spaces ||
170: ')(p_comment_text - ' || p_comment_text || ')'
171: ,'R');

Line 198: ben_dm_utility.message('ROUT','entry:hr_dm_gen_tds.add_to_package_body-1', 5);

194: l_string_index number; -- variable to read the string characters
195: l_loop_cnt number;
196: begin
197:
198: ben_dm_utility.message('ROUT','entry:hr_dm_gen_tds.add_to_package_body-1', 5);
199: ben_dm_utility.message('PARA','(p_proc_body_tbl - table of varchar2' ,10);
200:
201: while l_proc_index is not null loop
202:

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

195: l_loop_cnt number;
196: begin
197:
198: ben_dm_utility.message('ROUT','entry:hr_dm_gen_tds.add_to_package_body-1', 5);
199: ben_dm_utility.message('PARA','(p_proc_body_tbl - table of varchar2' ,10);
200:
201: while l_proc_index is not null loop
202:
203: l_string_index := 1;

Line 225: ben_dm_utility.message('INFO',

221: l_loop_cnt := l_loop_cnt + 1;
222: end loop;
223: l_proc_index := p_proc_body_tbl.next(l_proc_index);
224: end loop;
225: ben_dm_utility.message('INFO',
226: '(l_loop_cnt - ' || l_loop_cnt ||
227: ')(l_string_index - ' ||l_string_index ||
228: ')( g_package_index - ' || g_package_index || ')'
229: ,15);

Line 230: ben_dm_utility.message('ROUT','exit:hr_dm_gen_tds.add_to_package_body -1',

226: '(l_loop_cnt - ' || l_loop_cnt ||
227: ')(l_string_index - ' ||l_string_index ||
228: ')( g_package_index - ' || g_package_index || ')'
229: ,15);
230: ben_dm_utility.message('ROUT','exit:hr_dm_gen_tds.add_to_package_body -1',
231: 25);
232: exception
233: when others then
234: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.add_to_package_body-1',

Line 234: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.add_to_package_body-1',

230: ben_dm_utility.message('ROUT','exit:hr_dm_gen_tds.add_to_package_body -1',
231: 25);
232: exception
233: when others then
234: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.add_to_package_body-1',
235: '(l_loop_cnt - ' || l_loop_cnt ||
236: ')(l_string_index - ' ||l_string_index ||
237: ')( g_package_index - ' || g_package_index || ')'
238: ,'R');

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

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 ||
270: ')', 10);
271:

Line 268: ben_dm_utility.message('PARA','(p_from_clause - ' || p_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 ||
270: ')', 10);
271:
272: l_derive_sql := p_table_info.derive_sql;

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

296: exit;
297: end if;
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

Line 301: ben_dm_utility.message('PARA','(p_from_clause - ' || p_from_clause || ')',30);

297: end if;
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',

Line 305: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.get_derive_from_clause',

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 ||
307: ')(l_end_ptr - ' || l_end_ptr ||
308: ')(p_from_clause - ' || p_from_clause || ')'
309: ,'R');

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

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 ;
339: if l_derive_sql is not null then
340:

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

371: end if;
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',

Line 379: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.get_dt_cursor_where_clause',

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');
381: raise;
382: end get_dt_cursor_where_clause;
383:

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

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:
409: l_columns_tbl := g_columns_tbl;

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

445: l_cursor_select_cols || indent ||
446: /* l_cursor_select_from || indent || */
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

Line 450: ben_dm_utility.message('PARA','(p_cursor - ' || p_cursor || ')' ,30);

446: /* l_cursor_select_from || indent || */
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',

Line 454: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.prepare_download_cursor',

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');
456: raise;
457: end prepare_download_cursor;
458:

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

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';
540:

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

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)||
587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;

Line 584: 'ben_dm_utility.message(''PARA'', '' ( Person - '' || p_person_id || '')'' , 10) ;'|| indent(l_indent) ||

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)||
587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
588:

Line 585: 'ben_dm_utility.message(''PARA'', '' ( Source BG - '' || p_business_group_id || '')'' , 10) ;'|| 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)||
587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
588:
589: l_proc_index := l_proc_index + 1;

Line 586: 'ben_dm_utility.message(''PARA'', '' ( Target BG - '' || p_business_group_name || '')'' , 10) ;'|| 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)||
587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
588:
589: l_proc_index := l_proc_index + 1;
590: /*

Line 587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| 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)||
587: 'ben_dm_utility.message(''PARA'', '' ( group_order - '' || p_group_order || '')'' , 10) ; '|| indent(l_indent) ;
588:
589: l_proc_index := l_proc_index + 1;
590: /*
591: add_debug_messages (p_table_info => p_table_info,

Line 653: 'ben_dm_utility.message(''INFO'','' Record Inserterd '' ||l_rec_inserted_cnt,5) ; '

649: l_indent := 3;
650: l_proc_body_tbl(l_proc_index) := indent(l_indent) ||
651: 'end loop;' || indent(l_indent ) /*|| 'commit;' */ || indent(l_indent ) ||
652: 'p_rec_downloaded := l_rec_inserted_cnt;' || indent(l_indent) ||
653: 'ben_dm_utility.message(''INFO'','' Record Inserterd '' ||l_rec_inserted_cnt,5) ; '
654: || indent(l_indent) ;
655: l_proc_index := l_proc_index + 1;
656:
657: --l_indent := 0;

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

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;
663:

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

674:
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');

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

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;
684: end generate_download;
685:
686:

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

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:
761: -- opne the tabl curso and get the table informatons
762: open c_tbl ;

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

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

Line 851: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.create_tds_pacakge',

847: l_header := l_header || 'end ' || l_package_name || ';';
848: -- l_body := l_body || 'end ' || l_package_name || ';';
849: exception
850: when plsql_value_error then
851: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.create_tds_pacakge',
852: 'Either TDS package code size is too big or ' ||
853: ' a value error)',
854: 'R');
855: raise;

Line 880: ben_dm_utility.error(SQLCODE,'Error in compiling TDS for ' ||

876: hr_dm_library.check_compile (p_object_name => l_package_name,
877: p_object_type => 'PACKAGE BODY' );
878: exception
879: when others then
880: ben_dm_utility.error(SQLCODE,'Error in compiling TDS for ' ||
881: l_tbl_rec.table_name ,'(none)','R');
882: raise;
883: end;
884:

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

881: l_tbl_rec.table_name ,'(none)','R');
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 ',

Line 889: ben_dm_utility.error(SQLCODE,'hr_dm_gen_tds.create_tds_pacakge ',

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');
891: raise;
892: end main ;
893: