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_UPLOAD dependencies on HR_DM_UPLOAD

Line 1: PACKAGE BODY hr_dm_upload AS

1: PACKAGE BODY hr_dm_upload AS
2: /* $Header: perdmup.pkb 120.0 2005/05/30 21:17:52 appldev noship $ */
3:
4:
5: /*---------------------------- PRIVATE ROUTINES -----------------------------*/

Line 26: hr_dm_utility.message('ROUT','entry:hr_dm_upload.spawn_slave', 5);

22: --
23: BEGIN
24: --
25:
26: hr_dm_utility.message('ROUT','entry:hr_dm_upload.spawn_slave', 5);
27:
28: -- set up local data
29: l_application := 'PER';
30: l_program := 'DATAPUMP';

Line 62: hr_dm_utility.message('ROUT','exit:hr_dm_upload.spawn_slave', 25);

58:
59:
60: hr_dm_utility.message('INFO','Spawned datapump as slave process', 15);
61: hr_dm_utility.message('SUMM','Spawned datapump as slave process', 20);
62: hr_dm_utility.message('ROUT','exit:hr_dm_upload.spawn_slave', 25);
63: hr_dm_utility.message('PARA','(none)', 30);
64:
65:
66: -- error handling

Line 69: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave',l_fatal_error_message,'R');

65:
66: -- error handling
67: EXCEPTION
68: WHEN e_fatal_error THEN
69: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave',l_fatal_error_message,'R');
70: hr_dm_master.report_error(p_current_phase, p_migration_id,
71: 'Error in hr_dm_upload.spawn_slave', 'P');
72: RAISE;
73: WHEN OTHERS THEN

Line 71: 'Error in hr_dm_upload.spawn_slave', 'P');

67: EXCEPTION
68: WHEN e_fatal_error THEN
69: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave',l_fatal_error_message,'R');
70: hr_dm_master.report_error(p_current_phase, p_migration_id,
71: 'Error in hr_dm_upload.spawn_slave', 'P');
72: RAISE;
73: WHEN OTHERS THEN
74: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave','(none)','R');
75: hr_dm_master.report_error(p_current_phase, p_migration_id,

Line 74: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave','(none)','R');

70: hr_dm_master.report_error(p_current_phase, p_migration_id,
71: 'Error in hr_dm_upload.spawn_slave', 'P');
72: RAISE;
73: WHEN OTHERS THEN
74: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave','(none)','R');
75: hr_dm_master.report_error(p_current_phase, p_migration_id,
76: 'Untrapped error in hr_dm_upload.spawn_slave', 'P');
77: RAISE;
78: --

Line 76: 'Untrapped error in hr_dm_upload.spawn_slave', 'P');

72: RAISE;
73: WHEN OTHERS THEN
74: hr_dm_utility.error(SQLCODE,'hr_dm_upload.spawn_slave','(none)','R');
75: hr_dm_master.report_error(p_current_phase, p_migration_id,
76: 'Untrapped error in hr_dm_upload.spawn_slave', 'P');
77: RAISE;
78: --
79: END spawn_slave;
80: --

Line 201: hr_dm_utility.message('ROUT','entry:hr_dm_upload.main', 5);

197: IF (p_concurrent_process = 'Y') THEN
198: hr_dm_utility.message_init;
199: END IF;
200:
201: hr_dm_utility.message('ROUT','entry:hr_dm_upload.main', 5);
202: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
203: ')(p_last_migration_date - ' || p_last_migration_date ||
204: ')', 10);
205:

Line 397: hr_dm_utility.message('ROUT','exit:hr_dm_upload.main', 25);

393:
394:
395: hr_dm_utility.message('INFO','UP - main controller', 15);
396: hr_dm_utility.message('SUMM','UP - main controller', 20);
397: hr_dm_utility.message('ROUT','exit:hr_dm_upload.main', 25);
398: hr_dm_utility.message('PARA','(retcode - ' || retcode ||
399: ')(errbuf - ' || errbuf || ')', 30);
400:
401: -- error handling

Line 406: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');

402: EXCEPTION
403: WHEN e_fatal_error THEN
404: retcode := 2;
405: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
406: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');
407: hr_dm_utility.update_phase_items(p_new_status => 'E',
408: p_id => l_phase_item_id);
409: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
410: WHEN e_slave_error THEN

Line 409: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');

405: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
406: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');
407: hr_dm_utility.update_phase_items(p_new_status => 'E',
408: p_id => l_phase_item_id);
409: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
410: WHEN e_slave_error THEN
411: retcode := 0;
412: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
413: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');

Line 413: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');

409: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
410: WHEN e_slave_error THEN
411: retcode := 0;
412: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
413: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');
414: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
415: WHEN OTHERS THEN
416: retcode := 2;
417: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';

Line 414: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');

410: WHEN e_slave_error THEN
411: retcode := 0;
412: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
413: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main',l_fatal_error_message,'R');
414: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
415: WHEN OTHERS THEN
416: retcode := 2;
417: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
418: -- update status to error

Line 421: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');

417: errbuf := 'An error occurred during the migration - examine logfiles for detailed reports.';
418: -- update status to error
419: hr_dm_utility.update_phase_items(p_new_status => 'E',
420: p_id => l_phase_item_id);
421: hr_dm_utility.error(SQLCODE,'hr_dm_upload.main','(none)','R');
422:
423: --
424: END main;
425: --

Line 459: hr_dm_utility.message('ROUT','entry:hr_dm_upload.set_globals', 5);

455: --
456: BEGIN
457: --
458:
459: hr_dm_utility.message('ROUT','entry:hr_dm_upload.set_globals', 5);
460: hr_dm_utility.message('PARA','(none)', 10);
461:
462: -- Set the variable so as to disable the trigger on the table.
463: hr_general.g_data_migrator_mode := 'Y';

Line 473: FETCH csr_src_db INTO hr_dm_upload.g_data_migrator_source_db;

469:
470: -- store the current migration's source_database_name
471: -- for access from the TUPS
472: OPEN csr_src_db;
473: FETCH csr_src_db INTO hr_dm_upload.g_data_migrator_source_db;
474: CLOSE csr_src_db;
475:
476: HR_DATA_PUMP.message('source db is - ' ||
477: NVL(hr_dm_upload.g_data_migrator_source_db, ''));

Line 477: NVL(hr_dm_upload.g_data_migrator_source_db, ''));

473: FETCH csr_src_db INTO hr_dm_upload.g_data_migrator_source_db;
474: CLOSE csr_src_db;
475:
476: HR_DATA_PUMP.message('source db is - ' ||
477: NVL(hr_dm_upload.g_data_migrator_source_db, ''));
478:
479: IF hr_dm_upload.g_data_migrator_source_db IS NULL THEN
480: l_fatal_error_message := 'No Started migration could be identified.';
481: RAISE e_fatal_error;

Line 479: IF hr_dm_upload.g_data_migrator_source_db IS NULL THEN

475:
476: HR_DATA_PUMP.message('source db is - ' ||
477: NVL(hr_dm_upload.g_data_migrator_source_db, ''));
478:
479: IF hr_dm_upload.g_data_migrator_source_db IS NULL THEN
480: l_fatal_error_message := 'No Started migration could be identified.';
481: RAISE e_fatal_error;
482: END IF;
483:

Line 488: hr_dm_utility.message('ROUT','exit:hr_dm_upload.set_globals', 25);

484:
485:
486: hr_dm_utility.message('INFO','UP - main controller', 15);
487: hr_dm_utility.message('SUMM','UP - main controller', 20);
488: hr_dm_utility.message('ROUT','exit:hr_dm_upload.set_globals', 25);
489: hr_dm_utility.message('PARA','(1 - 1)', 30);
490:
491:
492: RETURN(1);

Line 496: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals',

492: RETURN(1);
493:
494: EXCEPTION
495: WHEN e_fatal_error THEN
496: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals',
497: l_fatal_error_message,'R');
498:
499: WHEN OTHERS THEN
500: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals','(none)','R');

Line 500: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals','(none)','R');

496: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals',
497: l_fatal_error_message,'R');
498:
499: WHEN OTHERS THEN
500: hr_dm_utility.error(SQLCODE,'hr_dm_upload.set_globals','(none)','R');
501: RAISE;
502:
503: --
504: END set_globals;

Line 508: END hr_dm_upload;

504: END set_globals;
505: --
506:
507:
508: END hr_dm_upload;