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

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

37: l_index number := g_package_body.first;
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);

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

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',
60: '(none)','R');

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

82: l_proc varchar2(75) ;
83: begin
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:

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

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,
126: '(l_loop_cnt - ' || l_loop_cnt ||

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

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

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

252:
253: -- add the body of this procedure to the package.
254: add_to_package_body( l_proc_body_tbl );
255: ben_dm_utility.message('ROUT',l_proc, 25);
256: hr_utility.set_location('Leaving:'||l_proc, 10);
257: exception
258: when others then
259: ben_dm_utility.error(SQLCODE,l_proc ,
260: '(none)','R');

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

305: l_proc varchar2(75) ;
306:
307: begin
308: l_proc := g_package || 'generate_update_dml' ;
309: hr_utility.set_location('Entering : ' || l_proc , 5 ) ;
310: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
311:
312: -- input parameters for the procedure
313:

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

310: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);
311:
312: -- input parameters for the procedure
313:
314: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ;
315:
316: for i in c_cols Loop
317:
318: if i.SURROGATE_PK_COLUMN_NAME is not null then

Line 319: l_cursor := l_cursor ||indent(l_indent)||'hr_utility.set_location(''update : ' ||i.table_name||''''||' ,5) ; '||indent(l_indent);

315:
316: for i in c_cols Loop
317:
318: if i.SURROGATE_PK_COLUMN_NAME is not null then
319: l_cursor := l_cursor ||indent(l_indent)||'hr_utility.set_location(''update : ' ||i.table_name||''''||' ,5) ; '||indent(l_indent);
320: l_cursor := l_cursor || '-- open the curosr to fetch the values from result table ' || indent(l_indent) ;
321: l_cursor := l_cursor || 'for l_rslt in ' || l_cursor_name || '(''' || i.table_name||''')' || indent(l_indent) ;
322: l_indent := 4 ;
323: l_cursor := l_cursor || 'Loop ' ;

Line 376: l_proc_body_tbl(l_proc_index) := indent( l_indent) || 'hr_utility.set_location(''Leaving : '' || l_proc,5) ; ' ;

372:
373: l_proc_body_tbl(l_proc_index) := l_cursor||indent(l_indent) ;
374: l_proc_index := l_proc_index + 1;
375:
376: l_proc_body_tbl(l_proc_index) := indent( l_indent) || 'hr_utility.set_location(''Leaving : '' || l_proc,5) ; ' ;
377: l_proc_index := l_proc_index + 1;
378:
379: add_to_package_body( l_proc_body_tbl );
380:

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

378:
379: add_to_package_body( l_proc_body_tbl );
380:
381: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
382: hr_utility.set_location('Leaving '|| l_proc , 5 ) ;
383:
384: exception
385: when others then
386: ben_dm_utility.error(SQLCODE,l_proc , '(none)','R');

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

413: l_proc varchar2(75) ;
414: begin
415:
416: l_proc := g_package||'main' ;
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: ben_dm_utility.message('ROUT','entry:'||l_proc , 5);
419:
420:
421:

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

545: raise;
546: end;
547:
548: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);
549: hr_utility.set_location('Leaving:'||l_proc, 10);
550:
551: exception
552: when others then
553: ben_dm_utility.error(SQLCODE,l_proc, '(none)','R');