APPS.BEN_DM_CREATE_CONTROL_FILES dependencies on BEN_DM_UTILITY

Line 227: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.main', 5);

223: l_dummy number;
224:
225: begin
226:
227: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.main', 5);
228:
229: touch_files
230: (p_dir_name => p_dir_name,
231: p_no_of_threads => p_no_of_threads,

Line 555: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.main', 5);

551: close c7;
552: utl_file.put_line(l_file_handle,')');
553: utl_file.fclose(l_file_handle);
554:
555: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.main', 5);
556:
557: end main;
558:
559: procedure rebuild_indexes is

Line 574: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.rebuild_indexes', 5);

570: c1_rec c1%rowtype;
571:
572: begin
573:
574: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.rebuild_indexes', 5);
575: open c1;
576: loop
577: fetch c1 into c1_rec;
578: if c1%notfound then

Line 582: ben_dm_utility.message('INFO','rebuilding index '||c1_rec.index_name, 5);

578: if c1%notfound then
579: exit;
580: end if;
581:
582: ben_dm_utility.message('INFO','rebuilding index '||c1_rec.index_name, 5);
583: execute immediate 'alter index '||c1_rec.owner||'.'||c1_rec.index_name||' rebuild';
584:
585: end loop;
586: close c1;

Line 591: ben_dm_utility.message('INFO','some indexes failed to rebuild',5);

587:
588: open c1;
589: fetch c1 into c1_rec;
590: if c1%found then
591: ben_dm_utility.message('INFO','some indexes failed to rebuild',5);
592: end if;
593: close c1;
594:
595: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.rebuild_indexes', 5);

Line 595: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.rebuild_indexes', 5);

591: ben_dm_utility.message('INFO','some indexes failed to rebuild',5);
592: end if;
593: close c1;
594:
595: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.rebuild_indexes', 5);
596: end rebuild_indexes;
597:
598: function set_dm_flag(p_person_id number)
599: return number is