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_INIT dependencies on BEN_DM_INIT

Line 1: PACKAGE BODY ben_dm_init AS

1: PACKAGE BODY ben_dm_init AS
2: /* $Header: benfdmdini.pkb 120.0 2006/06/13 14:56:19 nkkrishn noship $ */
3:
4: -- ------------------------- populate_pi_table_i ------------------------
5: -- Description: The phase items for the initialization phase are seeded

Line 27: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_i', 5);

23: --
24: BEGIN
25: --
26:
27: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_i', 5);
28: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
29:
30: --
31: -- phase specific code to be inserted here

Line 38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);

34: --
35:
36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);
39: ben_dm_utility.message('PARA','(none)', 30);
40:
41: -- error handling
42: EXCEPTION

Line 44: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_i','(none)',

40:
41: -- error handling
42: EXCEPTION
43: WHEN OTHERS THEN
44: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_i','(none)',
45: 'R');
46: RAISE;
47:
48: --

Line 131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);

127: --
128: BEGIN
129: --
130:
131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);
132: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
133:
134: -- get phase id
135: l_phase_id := ben_dm_utility.get_phase_id('G',

Line 186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);

182: CLOSE csr_select_pi;
183:
184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);
187: ben_dm_utility.message('PARA','(none)', 30);
188:
189: -- error handling
190: EXCEPTION

Line 192: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_g','(none)',

188:
189: -- error handling
190: EXCEPTION
191: WHEN OTHERS THEN
192: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_g','(none)',
193: 'R');
194: RAISE;
195:
196: --

Line 238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);

234: --
235: BEGIN
236: --
237:
238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);
239: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
240:
241: l_phase_id := ben_dm_utility.get_phase_id('DP',
242: r_migration_data.migration_id);

Line 293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);

289:
290:
291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);
294: ben_dm_utility.message('PARA','(none)', 30);
295:
296: -- error handling
297: EXCEPTION

Line 299: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_dp','(none)',

295:
296: -- error handling
297: EXCEPTION
298: WHEN OTHERS THEN
299: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_dp','(none)',
300: 'R');
301: RAISE;
302:
303: --

Line 342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);

338: --
339: BEGIN
340: --
341:
342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);
343: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
344:
345: l_phase_id := ben_dm_utility.get_phase_id('UP',
346: r_migration_data.migration_id);

Line 393: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_up','(none)',

389:
390: -- error handling
391: EXCEPTION
392: WHEN OTHERS THEN
393: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_up','(none)',
394: 'R');
395: RAISE;
396:
397: --

Line 427: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table', 5);

423: --
424: BEGIN
425: --
426:
427: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table', 5);
428: ben_dm_utility.message('PARA','(r_migration_data - record' ||
429: ')(p_phase_name - ' || p_phase_name || ')', 10);
430:
431: IF (p_phase_name = 'I') THEN

Line 445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);

441: ben_dm_utility.message('INFO','Populate Phase Items table -' ||
442: ' calling phase code', 15);
443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||
444: ' calling phase code', 20);
445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);
446: ben_dm_utility.message('PARA','(none)', 30);
447:
448: -- error handling
449: EXCEPTION

Line 451: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table','(none)','R');

447:
448: -- error handling
449: EXCEPTION
450: WHEN OTHERS THEN
451: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table','(none)','R');
452: RAISE;
453:
454: --
455: END populate_pi_table;

Line 497: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phase_items', 5);

493: --
494: BEGIN
495: --
496:
497: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phase_items', 5);
498: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
499:
500: -- seed first phase
501: l_search_phase := 'START';

Line 520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);

516: CLOSE csr_phase_rule;
517: END LOOP;
518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);
521: ben_dm_utility.message('PARA','(none)', 30);
522:
523: -- error handling
524: EXCEPTION

Line 526: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phase_items',

522:
523: -- error handling
524: EXCEPTION
525: WHEN OTHERS THEN
526: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phase_items',
527: '(none)','R');
528: RAISE;
529:
530: --

Line 559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);

555: --
556: BEGIN
557: --
558:
559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);
560: ben_dm_utility.message('PARA','(r_migration_data - record' ||
561: ')(p_phase_name - ' || p_phase_name || ')', 10);
562:
563: INSERT INTO ben_dm_phases (PHASE_ID,

Line 595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);

591: COMMIT;
592:
593: ben_dm_utility.message('INFO','Populate Phases table', 15);
594: ben_dm_utility.message('SUMM','Populate Phases table', 20);
595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);
596: ben_dm_utility.message('PARA','(none)', 30);
597:
598: -- error handling
599: EXCEPTION

Line 601: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_p_table','(none)','R');

597:
598: -- error handling
599: EXCEPTION
600: WHEN OTHERS THEN
601: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_p_table','(none)','R');
602: RAISE;
603:
604: --
605: END populate_p_table;

Line 645: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phases', 5);

641: --
642: BEGIN
643: --
644:
645: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phases', 5);
646: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
647:
648:
649: OPEN csr_phase_rule;

Line 659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);

655: CLOSE csr_phase_rule;
656:
657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);
660: ben_dm_utility.message('PARA','(none)', 30);
661:
662: -- error handling
663: EXCEPTION

Line 665: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phases','(none)','R');

661:
662: -- error handling
663: EXCEPTION
664: WHEN OTHERS THEN
665: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phases','(none)','R');
666: RAISE;
667:
668: --
669: END populate_phases;

Line 702: ben_dm_utility.message('ROUT','entry:ben_dm_init.main', 5);

698: --
699: BEGIN
700: --
701:
702: ben_dm_utility.message('ROUT','entry:ben_dm_init.main', 5);
703: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
704:
705:
706: -- get status of initialization phase, is phase completed?

Line 748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);

744: END IF;
745:
746: ben_dm_utility.message('INFO','Initialization Phase', 15);
747: ben_dm_utility.message('SUMM','Initialization Phase', 20);
748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);
749: ben_dm_utility.message('PARA','(none)', 30);
750:
751: -- error handling
752: EXCEPTION

Line 754: ben_dm_utility.error(SQLCODE,'ben_dm_init.main','(none)','R');

750:
751: -- error handling
752: EXCEPTION
753: WHEN OTHERS THEN
754: ben_dm_utility.error(SQLCODE,'ben_dm_init.main','(none)','R');
755: RAISE;
756:
757: --
758: END main;

Line 761: END ben_dm_init;

757: --
758: END main;
759: --
760:
761: END ben_dm_init;