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.HR_DM_MASTER dependencies on HR_DM_MASTER

Line 1: PACKAGE BODY hr_dm_master AS

1: PACKAGE BODY hr_dm_master AS
2: /* $Header: perdmmas.pkb 120.0 2005/05/31 17:11:52 appldev noship $ */
3:
4:
5: /*-------------------------- PRIVATE ROUTINES ----------------------------*/

Line 81: hr_dm_utility.message('ROUT','entry:hr_dm_master.controller_init', 5);

77: --
78: BEGIN
79: --
80:
81: hr_dm_utility.message('ROUT','entry:hr_dm_master.controller_init', 5);
82: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
83: ')(r_migration_data - record' ||
84: ')(p_request_data - ' || p_request_data || ')', 10);
85:

Line 181: hr_dm_utility.message('ROUT','exit:hr_dm_master.controller_init', 25);

177:
178:
179: hr_dm_utility.message('INFO','Main controller initialized', 15);
180: hr_dm_utility.message('SUMM','Main controller initialized', 20);
181: hr_dm_utility.message('ROUT','exit:hr_dm_master.controller_init', 25);
182: hr_dm_utility.message('PARA','(none)', 30);
183:
184:
185:

Line 193: ' in hr_dm_master.main_controller', 'M');

189: hr_dm_utility.error(SQLCODE,'hr_dm_range.main_controller',
190: l_fatal_error_message,'R');
191: report_error(l_phase_name, p_migration_id,
192: l_fatal_error_message ||
193: ' in hr_dm_master.main_controller', 'M');
194: RAISE;
195: WHEN OTHERS THEN
196: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller',
197: '(none)','R');

Line 196: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller',

192: l_fatal_error_message ||
193: ' in hr_dm_master.main_controller', 'M');
194: RAISE;
195: WHEN OTHERS THEN
196: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller',
197: '(none)','R');
198: report_error(l_phase_name, p_migration_id,
199: 'Untrapped error in hr_dm_master.main_controller', 'M');
200: RAISE;

Line 199: 'Untrapped error in hr_dm_master.main_controller', 'M');

195: WHEN OTHERS THEN
196: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller',
197: '(none)','R');
198: report_error(l_phase_name, p_migration_id,
199: 'Untrapped error in hr_dm_master.main_controller', 'M');
200: RAISE;
201:
202:
203: --

Line 244: hr_dm_utility.message('ROUT','entry:hr_dm_master.insert_request', 5);

240: --
241: BEGIN
242: --
243:
244: hr_dm_utility.message('ROUT','entry:hr_dm_master.insert_request', 5);
245: hr_dm_utility.message('PARA','(p_phase - ' || p_phase ||
246: ')(p_request_id - ' || p_request_id ||
247: ')(p_master_slave - ' || p_master_slave ||
248: ')(p_migration_id - ' || p_migration_id ||

Line 286: hr_dm_utility.message('ROUT','exit:hr_dm_master.insert_request', 25);

282: COMMIT;
283:
284: hr_dm_utility.message('INFO','Inserted into hr_dm_migration_requests', 15);
285: hr_dm_utility.message('SUMM','Inserted into hr_dm_migration_requests', 20);
286: hr_dm_utility.message('ROUT','exit:hr_dm_master.insert_request', 25);
287: hr_dm_utility.message('PARA','(none)', 30);
288:
289: -- error handling
290: EXCEPTION

Line 292: hr_dm_utility.error(SQLCODE,'hr_dm_master.insert_request','(none)','R');

288:
289: -- error handling
290: EXCEPTION
291: WHEN OTHERS THEN
292: hr_dm_utility.error(SQLCODE,'hr_dm_master.insert_request','(none)','R');
293: RAISE;
294:
295:
296: --

Line 336: hr_dm_utility.message('ROUT','entry:hr_dm_master.spawn_slaves', 5);

332: --
333: BEGIN
334: --
335:
336: hr_dm_utility.message('ROUT','entry:hr_dm_master.spawn_slaves', 5);
337: hr_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
338: ')(r_migration_data - record)', 10);
339:
340:

Line 406: hr_dm_utility.message('ROUT','exit:hr_dm_master.spawn_slaves', 25);

402: END LOOP;
403:
404: hr_dm_utility.message('INFO','Spawned slaves', 15);
405: hr_dm_utility.message('SUMM','Spawned slaves', 20);
406: hr_dm_utility.message('ROUT','exit:hr_dm_master.spawn_slaves', 25);
407: hr_dm_utility.message('PARA','(none)', 30);
408:
409:
410:

Line 414: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves',

410:
411: -- error handling
412: EXCEPTION
413: WHEN e_fatal_error THEN
414: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves',
415: l_fatal_error_message,'R');
416: report_error(p_current_phase, r_migration_data.migration_id,
417: 'Error in hr_dm_master.spawn_slaves', 'P');
418: RAISE;

Line 417: 'Error in hr_dm_master.spawn_slaves', 'P');

413: WHEN e_fatal_error THEN
414: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves',
415: l_fatal_error_message,'R');
416: report_error(p_current_phase, r_migration_data.migration_id,
417: 'Error in hr_dm_master.spawn_slaves', 'P');
418: RAISE;
419: WHEN OTHERS THEN
420: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves','(none)','R');
421: report_error(p_current_phase, r_migration_data.migration_id,

Line 420: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves','(none)','R');

416: report_error(p_current_phase, r_migration_data.migration_id,
417: 'Error in hr_dm_master.spawn_slaves', 'P');
418: RAISE;
419: WHEN OTHERS THEN
420: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves','(none)','R');
421: report_error(p_current_phase, r_migration_data.migration_id,
422: 'Untrapped error in hr_dm_master.spawn_slaves', 'P');
423: RAISE;
424:

Line 422: 'Untrapped error in hr_dm_master.spawn_slaves', 'P');

418: RAISE;
419: WHEN OTHERS THEN
420: hr_dm_utility.error(SQLCODE,'hr_dm_master.spawn_slaves','(none)','R');
421: report_error(p_current_phase, r_migration_data.migration_id,
422: 'Untrapped error in hr_dm_master.spawn_slaves', 'P');
423: RAISE;
424:
425: --
426: END spawn_slaves;

Line 477: hr_dm_utility.message('ROUT','entry:hr_dm_master.slave_status', 5);

473: --
474: BEGIN
475: --
476:
477: hr_dm_utility.message('ROUT','entry:hr_dm_master.slave_status', 5);
478: hr_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
479: ')(r_migration_data - record)', 10);
480:
481: -- get the current phase_id

Line 505: hr_dm_utility.message('ROUT','exit:hr_dm_master.spawn_slaves', 25);

501:
502:
503: hr_dm_utility.message('INFO','Slave status request', 15);
504: hr_dm_utility.message('SUMM','Slave status request', 20);
505: hr_dm_utility.message('ROUT','exit:hr_dm_master.spawn_slaves', 25);
506: hr_dm_utility.message('PARA','(l_slave_error - ' || l_slave_error ||
507: ')', 30);
508:
509:

Line 515: hr_dm_utility.error(SQLCODE,'hr_dm_master.slave_status','(none)','R');

511:
512: -- error handling
513: EXCEPTION
514: WHEN OTHERS THEN
515: hr_dm_utility.error(SQLCODE,'hr_dm_master.slave_status','(none)','R');
516: report_error(p_current_phase, r_migration_data.migration_id,
517: 'Untrapped error in hr_dm_master.slave_status', 'P');
518: RAISE;
519:

Line 517: 'Untrapped error in hr_dm_master.slave_status', 'P');

513: EXCEPTION
514: WHEN OTHERS THEN
515: hr_dm_utility.error(SQLCODE,'hr_dm_master.slave_status','(none)','R');
516: report_error(p_current_phase, r_migration_data.migration_id,
517: 'Untrapped error in hr_dm_master.slave_status', 'P');
518: RAISE;
519:
520: --
521: END slave_status;

Line 558: hr_dm_utility.message('ROUT','entry:hr_dm_master.report_error', 5);

554: --
555: BEGIN
556: --
557:
558: hr_dm_utility.message('ROUT','entry:hr_dm_master.report_error', 5);
559: hr_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
560: ')(p_migration - ' || p_migration ||
561: ')(p_error_message - ' || p_error_message ||
562: ')(p_stage - ' || p_stage || ')', 10);

Line 580: hr_dm_utility.message('ROUT','exit:hr_dm_master.report_error', 25);

576:
577:
578: hr_dm_utility.message('INFO','Error reported', 15);
579: hr_dm_utility.message('SUMM','Error reported', 20);
580: hr_dm_utility.message('ROUT','exit:hr_dm_master.report_error', 25);
581: hr_dm_utility.message('PARA','(none)', 30);
582:
583:
584: --

Line 647: hr_dm_utility.message('ROUT','entry:hr_dm_master.work_required', 5);

643: --
644: BEGIN
645: --
646:
647: hr_dm_utility.message('ROUT','entry:hr_dm_master.work_required', 5);
648: hr_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
649: ')(r_migration_data - record)', 10);
650:
651: -- get the current phase_id

Line 729: hr_dm_utility.message('ROUT','exit:hr_dm_master.work_required', 25);

725:
726:
727: hr_dm_utility.message('INFO','Check work required for phase', 15);
728: hr_dm_utility.message('SUMM','Check work required for phase', 20);
729: hr_dm_utility.message('ROUT','exit:hr_dm_master.work_required', 25);
730: hr_dm_utility.message('PARA','(l_work - ' || l_work || ')', 30);
731:
732: RETURN(l_work);
733:

Line 737: hr_dm_utility.error(SQLCODE,'hr_dm_master.work_required','(none)','R');

733:
734: -- error handling
735: EXCEPTION
736: WHEN OTHERS THEN
737: hr_dm_utility.error(SQLCODE,'hr_dm_master.work_required','(none)','R');
738: report_error(p_current_phase, r_migration_data.migration_id,
739: 'Untrapped error in hr_dm_master.work_required', 'P');
740: RAISE;
741:

Line 739: 'Untrapped error in hr_dm_master.work_required', 'P');

735: EXCEPTION
736: WHEN OTHERS THEN
737: hr_dm_utility.error(SQLCODE,'hr_dm_master.work_required','(none)','R');
738: report_error(p_current_phase, r_migration_data.migration_id,
739: 'Untrapped error in hr_dm_master.work_required', 'P');
740: RAISE;
741:
742: --
743: END work_required;

Line 816: hr_dm_utility.message('ROUT','entry:hr_dm_master.master', 5);

812: --
813: BEGIN
814: --
815:
816: hr_dm_utility.message('ROUT','entry:hr_dm_master.master', 5);
817: hr_dm_utility.message('PARA','(p_current_phase - ' || p_current_phase ||
818: ')(p_previous_phase - ' || p_previous_phase ||
819: ')(r_migration_data - record)', 10);
820:

Line 983: hr_dm_utility.message('ROUT','exit:hr_dm_master.master', 25);

979: END IF;
980:
981: hr_dm_utility.message('INFO','Master concurrent program', 15);
982: hr_dm_utility.message('SUMM','Master concurrent program', 20);
983: hr_dm_utility.message('ROUT','exit:hr_dm_master.master', 25);
984: hr_dm_utility.message('PARA','(none)', 30);
985:
986:
987:

Line 994: 'Untrapped error in hr_dm_master.master', 'P');

990: WHEN e_fatal_error THEN
991: hr_dm_utility.error(SQLCODE,'hr_dm_range.master',
992: l_fatal_error_message,'R');
993: report_error(p_current_phase, r_migration_data.migration_id,
994: 'Untrapped error in hr_dm_master.master', 'P');
995: RAISE;
996: WHEN OTHERS THEN
997: hr_dm_utility.error(SQLCODE,'hr_dm_master.master','(none)','R');
998: report_error(p_current_phase, r_migration_data.migration_id,

Line 997: hr_dm_utility.error(SQLCODE,'hr_dm_master.master','(none)','R');

993: report_error(p_current_phase, r_migration_data.migration_id,
994: 'Untrapped error in hr_dm_master.master', 'P');
995: RAISE;
996: WHEN OTHERS THEN
997: hr_dm_utility.error(SQLCODE,'hr_dm_master.master','(none)','R');
998: report_error(p_current_phase, r_migration_data.migration_id,
999: 'Untrapped error in hr_dm_master.master', 'P');
1000: RAISE;
1001: --

Line 999: 'Untrapped error in hr_dm_master.master', 'P');

995: RAISE;
996: WHEN OTHERS THEN
997: hr_dm_utility.error(SQLCODE,'hr_dm_master.master','(none)','R');
998: report_error(p_current_phase, r_migration_data.migration_id,
999: 'Untrapped error in hr_dm_master.master', 'P');
1000: RAISE;
1001: --
1002: END master;
1003: --

Line 1086: hr_dm_utility.message('ROUT','entry:hr_dm_master.main_controller', 5);

1082:
1083: -- initialize messaging
1084: hr_dm_utility.message_init;
1085:
1086: hr_dm_utility.message('ROUT','entry:hr_dm_master.main_controller', 5);
1087: hr_dm_utility.message('PARA','(p_migration_id - ' ||
1088: p_migration_id || ')', 10);
1089:
1090:

Line 1245: hr_dm_utility.message('ROUT','exit:hr_dm_master.main_controller', 25);

1241:
1242:
1243: hr_dm_utility.message('INFO','Main controller', 15);
1244: hr_dm_utility.message('SUMM','Main controller', 20);
1245: hr_dm_utility.message('ROUT','exit:hr_dm_master.main_controller', 25);
1246: hr_dm_utility.message('PARA','(retcode - ' || retcode ||
1247: ')(errbuf - ' || errbuf || ')', 30);
1248:
1249:

Line 1259: l_fatal_error_message || ' in hr_dm_master.main_controller',

1255: ' for detailed reports.';
1256: hr_dm_utility.error(SQLCODE,'hr_dm_range.main_controller',
1257: l_fatal_error_message,'R');
1258: report_error(l_phase_name, p_migration_id,
1259: l_fatal_error_message || ' in hr_dm_master.main_controller',
1260: 'M');
1261: WHEN OTHERS THEN
1262: retcode := 2;
1263: errbuf := 'An error occurred during the migration - examine logfiles' ||

Line 1265: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller','(none)','R');

1261: WHEN OTHERS THEN
1262: retcode := 2;
1263: errbuf := 'An error occurred during the migration - examine logfiles' ||
1264: ' for detailed reports.';
1265: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller','(none)','R');
1266: report_error(l_phase_name, p_migration_id,
1267: 'Untrapped error in hr_dm_master.main_controller', 'M');
1268:
1269: --

Line 1267: 'Untrapped error in hr_dm_master.main_controller', 'M');

1263: errbuf := 'An error occurred during the migration - examine logfiles' ||
1264: ' for detailed reports.';
1265: hr_dm_utility.error(SQLCODE,'hr_dm_master.main_controller','(none)','R');
1266: report_error(l_phase_name, p_migration_id,
1267: 'Untrapped error in hr_dm_master.main_controller', 'M');
1268:
1269: --
1270: END main_controller;
1271: --

Line 1275: end hr_dm_master;

1271: --
1272:
1273:
1274:
1275: end hr_dm_master;