DBA Data[Home] [Help]

APPS.BEN_DM_GEN_SELF_REF 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 184: ben_dm_utility.message('ROUT','entry:' || l_proc , 5);

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 ||
188: '(p_migration_id in number' || indent ||

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

251: || indent || 'begin' || indent ;
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 ,

Line 259: ben_dm_utility.error(SQLCODE,l_proc ,

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');
261: raise;
262: end generate_reference;
263:

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

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:
314: l_cursor := indent( l_indent) || 'hr_utility.set_location(''Entering : '' || l_proc,5) ; ' || indent(l_indent) ;

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

377: l_proc_index := l_proc_index + 1;
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

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

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');
387: raise;
388: end generate_update_dml;
389:
390: -- ------------------------- main ------------------------

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

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:
422: l_package_name := 'ben_dm_resolve_reference' ;

Line 518: ben_dm_utility.error(SQLCODE,l_proc ,

514: l_header := l_header || 'end ' || l_package_name || ';';
515: l_body := l_body || 'end ' || l_package_name || ';';
516: exception
517: when plsql_value_error then
518: ben_dm_utility.error(SQLCODE,l_proc ,
519: 'Either TDS package code size is too big or ' ||
520: ' a value error)',
521: 'R');
522: raise;

Line 544: ben_dm_utility.error(SQLCODE,'Error in compiling '|| l_proc ,'(none)','R');

540: hr_dm_library.check_compile (p_object_name => l_package_name,
541: p_object_type => 'PACKAGE BODY' );
542: exception
543: when others then
544: ben_dm_utility.error(SQLCODE,'Error in compiling '|| l_proc ,'(none)','R');
545: raise;
546: end;
547:
548: ben_dm_utility.message('ROUT','exit:'|| l_proc , 25);

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

544: ben_dm_utility.error(SQLCODE,'Error in compiling '|| l_proc ,'(none)','R');
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

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

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');
554: raise;
555: end main ;
556:
557: end BEN_DM_GEN_SELF_REF;