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_MASTER dependencies on BEN_DM_MASTER

Line 1: PACKAGE BODY ben_dm_master AS

1: PACKAGE BODY ben_dm_master AS
2: /* $Header: benfdmdmas.pkb 120.0 2006/05/04 04:47:39 nkkrishn noship $ */
3:
4:
5: g_delimiter varchar2(1) := fnd_global.local_chr(01);

Line 86: ben_dm_utility.message('ROUT','entry:ben_dm_master.controller_init', 5);

82: --
83: BEGIN
84: --
85:
86: ben_dm_utility.message('ROUT','entry:ben_dm_master.controller_init', 5);
87: ben_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
88: ')(r_migration_data - record' ||
89: ')(p_request_data - ' || p_request_data || ')', 10);
90:

Line 173: ben_dm_utility.message('ROUT','exit:ben_dm_master.controller_init', 25);

169:
170:
171: ben_dm_utility.message('INFO','Main controller initialized', 15);
172: ben_dm_utility.message('SUMM','Main controller initialized', 20);
173: ben_dm_utility.message('ROUT','exit:ben_dm_master.controller_init', 25);
174: ben_dm_utility.message('PARA','(none)', 30);
175:
176:
177:

Line 185: ' in ben_dm_master.main_controller', 'M');

181: ben_dm_utility.error(SQLCODE,'hr_dm_range.main_controller',
182: l_fatal_error_message,'R');
183: report_error(l_phase_name, p_migration_id,
184: l_fatal_error_message ||
185: ' in ben_dm_master.main_controller', 'M');
186: RAISE;
187: WHEN OTHERS THEN
188: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller',
189: '(none)','R');

Line 188: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller',

184: l_fatal_error_message ||
185: ' in ben_dm_master.main_controller', 'M');
186: RAISE;
187: WHEN OTHERS THEN
188: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller',
189: '(none)','R');
190: report_error(l_phase_name, p_migration_id,
191: 'Untrapped error in ben_dm_master.main_controller', 'M');
192: RAISE;

Line 191: 'Untrapped error in ben_dm_master.main_controller', 'M');

187: WHEN OTHERS THEN
188: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller',
189: '(none)','R');
190: report_error(l_phase_name, p_migration_id,
191: 'Untrapped error in ben_dm_master.main_controller', 'M');
192: RAISE;
193:
194:
195: --

Line 269: ben_dm_utility.message('ROUT','entry:ben_dm_master.insert_request', 5);

265: --
266: BEGIN
267: --
268:
269: ben_dm_utility.message('ROUT','entry:ben_dm_master.insert_request', 5);
270: ben_dm_utility.message('PARA','(p_phase - ' || p_phase ||
271: ')(p_request_id - ' || p_request_id ||
272: ')(p_master_slave - ' || p_master_slave ||
273: ')(p_migration_id - ' || p_migration_id ||

Line 311: ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);

307: COMMIT;
308:
309: ben_dm_utility.message('INFO','Inserted into ben_dm_migration_requests', 15);
310: ben_dm_utility.message('SUMM','Inserted into ben_dm_migration_requests', 20);
311: ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);
312: ben_dm_utility.message('PARA','(none)', 30);
313:
314: -- error handling
315: EXCEPTION

Line 317: ben_dm_utility.error(SQLCODE,'ben_dm_master.insert_request','(none)','R');

313:
314: -- error handling
315: EXCEPTION
316: WHEN OTHERS THEN
317: ben_dm_utility.error(SQLCODE,'ben_dm_master.insert_request','(none)','R');
318: RAISE;
319:
320:
321: --

Line 370: ben_dm_utility.message('ROUT','entry:ben_dm_master.spawn_slaves', 5);

366: --
367: BEGIN
368: --
369:
370: ben_dm_utility.message('ROUT','entry:ben_dm_master.spawn_slaves', 5);
371: ben_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
372: ')(r_migration_data - record)', 10);
373:
374:

Line 518: ben_dm_utility.message('ROUT','exit:ben_dm_master.spawn_slaves', 25);

514: END LOOP;
515:
516: ben_dm_utility.message('INFO','Spawned slaves', 15);
517: ben_dm_utility.message('SUMM','Spawned slaves', 20);
518: ben_dm_utility.message('ROUT','exit:ben_dm_master.spawn_slaves', 25);
519: ben_dm_utility.message('PARA','(none)', 30);
520:
521: EXCEPTION
522: WHEN e_fatal_error THEN

Line 523: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves',

519: ben_dm_utility.message('PARA','(none)', 30);
520:
521: EXCEPTION
522: WHEN e_fatal_error THEN
523: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves',
524: l_fatal_error_message,'R');
525: report_error(p_current_phase, r_migration_data.migration_id,
526: 'Error in ben_dm_master.spawn_slaves', 'P');
527: RAISE;

Line 526: 'Error in ben_dm_master.spawn_slaves', 'P');

522: WHEN e_fatal_error THEN
523: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves',
524: l_fatal_error_message,'R');
525: report_error(p_current_phase, r_migration_data.migration_id,
526: 'Error in ben_dm_master.spawn_slaves', 'P');
527: RAISE;
528: WHEN OTHERS THEN
529: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves','(none)','R');
530: report_error(p_current_phase, r_migration_data.migration_id,

Line 529: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves','(none)','R');

525: report_error(p_current_phase, r_migration_data.migration_id,
526: 'Error in ben_dm_master.spawn_slaves', 'P');
527: RAISE;
528: WHEN OTHERS THEN
529: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves','(none)','R');
530: report_error(p_current_phase, r_migration_data.migration_id,
531: 'Untrapped error in ben_dm_master.spawn_slaves', 'P');
532: RAISE;
533:

Line 531: 'Untrapped error in ben_dm_master.spawn_slaves', 'P');

527: RAISE;
528: WHEN OTHERS THEN
529: ben_dm_utility.error(SQLCODE,'ben_dm_master.spawn_slaves','(none)','R');
530: report_error(p_current_phase, r_migration_data.migration_id,
531: 'Untrapped error in ben_dm_master.spawn_slaves', 'P');
532: RAISE;
533:
534: --
535: END spawn_slaves;

Line 586: ben_dm_utility.message('ROUT','entry:ben_dm_master.slave_status', 5);

582: --
583: BEGIN
584: --
585:
586: ben_dm_utility.message('ROUT','entry:ben_dm_master.slave_status', 5);
587: ben_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
588: ')(r_migration_data - record)', 10);
589:
590: -- get the current phase_id

Line 619: ben_dm_utility.message('ROUT','exit:ben_dm_master.spawn_slaves', 25);

615:
616:
617: ben_dm_utility.message('INFO','Slave status request', 15);
618: ben_dm_utility.message('SUMM','Slave status request', 20);
619: ben_dm_utility.message('ROUT','exit:ben_dm_master.spawn_slaves', 25);
620: ben_dm_utility.message('PARA','(l_slave_error - ' || l_slave_error ||
621: ')', 30);
622:
623:

Line 629: ben_dm_utility.error(SQLCODE,'ben_dm_master.slave_status','(none)','R');

625:
626: -- error handling
627: EXCEPTION
628: WHEN OTHERS THEN
629: ben_dm_utility.error(SQLCODE,'ben_dm_master.slave_status','(none)','R');
630: report_error(p_current_phase, r_migration_data.migration_id,
631: 'Untrapped error in ben_dm_master.slave_status', 'P');
632: RAISE;
633:

Line 631: 'Untrapped error in ben_dm_master.slave_status', 'P');

627: EXCEPTION
628: WHEN OTHERS THEN
629: ben_dm_utility.error(SQLCODE,'ben_dm_master.slave_status','(none)','R');
630: report_error(p_current_phase, r_migration_data.migration_id,
631: 'Untrapped error in ben_dm_master.slave_status', 'P');
632: RAISE;
633:
634: --
635: END slave_status;

Line 672: ben_dm_utility.message('ROUT','entry:ben_dm_master.report_error', 5);

668: --
669: BEGIN
670: --
671:
672: ben_dm_utility.message('ROUT','entry:ben_dm_master.report_error', 5);
673: ben_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
674: ')(p_migration - ' || p_migration ||
675: ')(p_error_message - ' || p_error_message ||
676: ')(p_stage - ' || p_stage || ')', 10);

Line 694: ben_dm_utility.message('ROUT','exit:ben_dm_master.report_error', 25);

690:
691:
692: ben_dm_utility.message('INFO','Error reported', 15);
693: ben_dm_utility.message('SUMM','Error reported', 20);
694: ben_dm_utility.message('ROUT','exit:ben_dm_master.report_error', 25);
695: ben_dm_utility.message('PARA','(none)', 30);
696:
697:
698: --

Line 751: ben_dm_utility.message('ROUT','entry:ben_dm_master.work_required', 5);

747: --
748: BEGIN
749: --
750:
751: ben_dm_utility.message('ROUT','entry:ben_dm_master.work_required', 5);
752: ben_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
753: ')(r_migration_data - record)', 10);
754:
755: ben_dm_utility.message('INFO','Migration Id ' || r_migration_data.migration_id, 17);

Line 787: ben_dm_utility.message('ROUT','exit:ben_dm_master.work_required', 25);

783:
784:
785: ben_dm_utility.message('INFO','Check work required for phase', 15);
786: ben_dm_utility.message('SUMM','Check work required for phase', 20);
787: ben_dm_utility.message('ROUT','exit:ben_dm_master.work_required', 25);
788: ben_dm_utility.message('PARA','(l_work - ' || l_work || ')', 30);
789:
790:
791: RETURN(l_work);

Line 796: ben_dm_utility.error(SQLCODE,'ben_dm_master.work_required','(none)','R');

792:
793: -- error handling
794: EXCEPTION
795: WHEN OTHERS THEN
796: ben_dm_utility.error(SQLCODE,'ben_dm_master.work_required','(none)','R');
797: report_error(p_current_phase, r_migration_data.migration_id,
798: 'Untrapped error in ben_dm_master.work_required', 'P');
799: RAISE;
800:

Line 798: 'Untrapped error in ben_dm_master.work_required', 'P');

794: EXCEPTION
795: WHEN OTHERS THEN
796: ben_dm_utility.error(SQLCODE,'ben_dm_master.work_required','(none)','R');
797: report_error(p_current_phase, r_migration_data.migration_id,
798: 'Untrapped error in ben_dm_master.work_required', 'P');
799: RAISE;
800:
801: --
802: END work_required;

Line 875: ben_dm_utility.message('ROUT','entry:ben_dm_master.master', 5);

871: --
872: BEGIN
873: --
874:
875: ben_dm_utility.message('ROUT','entry:ben_dm_master.master', 5);
876: ben_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
877: ')(p_previous_phase - ' || p_previous_phase ||
878: ')(r_migration_data - record)', 10);
879:

Line 992: ben_dm_utility.message('ROUT','exit:ben_dm_master.master', 25);

988: END IF;
989:
990: ben_dm_utility.message('INFO','Master concurrent program', 15);
991: ben_dm_utility.message('SUMM','Master concurrent program', 20);
992: ben_dm_utility.message('ROUT','exit:ben_dm_master.master', 25);
993: ben_dm_utility.message('PARA','(none)', 30);
994:
995:
996:

Line 1003: 'Untrapped error in ben_dm_master.master', 'P');

999: WHEN e_fatal_error THEN
1000: ben_dm_utility.error(SQLCODE,'hr_dm_range.master',
1001: l_fatal_error_message,'R');
1002: report_error(p_current_phase, r_migration_data.migration_id,
1003: 'Untrapped error in ben_dm_master.master', 'P');
1004: RAISE;
1005: WHEN OTHERS THEN
1006: ben_dm_utility.error(SQLCODE,'ben_dm_master.master','(none)','R');
1007: report_error(p_current_phase, r_migration_data.migration_id,

Line 1006: ben_dm_utility.error(SQLCODE,'ben_dm_master.master','(none)','R');

1002: report_error(p_current_phase, r_migration_data.migration_id,
1003: 'Untrapped error in ben_dm_master.master', 'P');
1004: RAISE;
1005: WHEN OTHERS THEN
1006: ben_dm_utility.error(SQLCODE,'ben_dm_master.master','(none)','R');
1007: report_error(p_current_phase, r_migration_data.migration_id,
1008: 'Untrapped error in ben_dm_master.master', 'P');
1009: RAISE;
1010: --

Line 1008: 'Untrapped error in ben_dm_master.master', 'P');

1004: RAISE;
1005: WHEN OTHERS THEN
1006: ben_dm_utility.error(SQLCODE,'ben_dm_master.master','(none)','R');
1007: report_error(p_current_phase, r_migration_data.migration_id,
1008: 'Untrapped error in ben_dm_master.master', 'P');
1009: RAISE;
1010: --
1011: END master;
1012: --

Line 1479: ben_dm_utility.message('ROUT','entry:ben_dm_master.main_controller', 5);

1475: ben_dm_utility.message('SUMM','l_migration_id : '||l_migration_id, 15);
1476:
1477: -- p_migration_id := l_migration_id;
1478:
1479: ben_dm_utility.message('ROUT','entry:ben_dm_master.main_controller', 5);
1480: ben_dm_utility.message('PARA','(p_migration_id - ' ||
1481: l_migration_id || ')', 10);
1482:
1483:

Line 1648: ben_dm_utility.message('ROUT','exit:ben_dm_master.main_controller', 25);

1644: END IF;
1645:
1646: ben_dm_utility.message('INFO','Main controller', 15);
1647: ben_dm_utility.message('SUMM','Main controller', 20);
1648: ben_dm_utility.message('ROUT','exit:ben_dm_master.main_controller', 25);
1649: ben_dm_utility.message('PARA','(retcode - ' || retcode ||
1650: ')(errbuf - ' || errbuf || ')', 30);
1651:
1652: EXCEPTION

Line 1660: l_fatal_error_message || ' in ben_dm_master.main_controller',

1656: ' for detailed reports.';
1657: ben_dm_utility.error(SQLCODE,'hr_dm_range.main_controller',
1658: l_fatal_error_message,'R');
1659: report_error(l_phase_name, l_migration_id,
1660: l_fatal_error_message || ' in ben_dm_master.main_controller',
1661: 'M');
1662: WHEN OTHERS THEN
1663: retcode := 2;
1664: errbuf := 'An error occurred during the migration - examine logfiles' ||

Line 1666: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller','(none)','R');

1662: WHEN OTHERS THEN
1663: retcode := 2;
1664: errbuf := 'An error occurred during the migration - examine logfiles' ||
1665: ' for detailed reports.';
1666: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller','(none)','R');
1667: report_error(l_phase_name, l_migration_id,
1668: 'Untrapped error in ben_dm_master.main_controller', 'M');
1669:
1670: --

Line 1668: 'Untrapped error in ben_dm_master.main_controller', 'M');

1664: errbuf := 'An error occurred during the migration - examine logfiles' ||
1665: ' for detailed reports.';
1666: ben_dm_utility.error(SQLCODE,'ben_dm_master.main_controller','(none)','R');
1667: report_error(l_phase_name, l_migration_id,
1668: 'Untrapped error in ben_dm_master.main_controller', 'M');
1669:
1670: --
1671: END main_controller;
1672: --

Line 1674: end ben_dm_master;

1670: --
1671: END main_controller;
1672: --
1673:
1674: end ben_dm_master;