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_AOL_DOWN dependencies on HR_DM_AOL_DOWN

Line 1: PACKAGE BODY hr_dm_aol_down AS

1: PACKAGE BODY hr_dm_aol_down AS
2: /* $Header: perdmadl.pkb 120.0 2005/05/31 17:03:06 appldev noship $ */
3:
4:
5: /*--------------------------- PRIVATE ROUTINES --------------------------*/

Line 103: hr_dm_utility.message('ROUT','entry:hr_dm_aol_down.spawn_down', 5);

99: --
100: BEGIN
101: --
102:
103: hr_dm_utility.message('ROUT','entry:hr_dm_aol_down.spawn_down', 5);
104: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
105: '(p_phase_id - ' || p_phase_id ||
106: '(p_phase_item_id - ' || p_phase_item_id ||
107: ')',10);

Line 280: -- insert details into view HR_DM_AOL_DOWN_V

276:
277: COMMIT;
278:
279: --
280: -- insert details into view HR_DM_AOL_DOWN_V
281: --
282:
283: -- get the destination database name
284: SELECT source_database_instance

Line 303: INSERT INTO HR_DM_AOL_DOWN_V

299: l_parameter8 || ' ' ||
300: l_parameter9 || ' ' ||
301: l_parameter10;
302:
303: INSERT INTO HR_DM_AOL_DOWN_V
304: (
305: exp_imp_id
306: ,table_name
307: ,migration_id

Line 313: ,'HR_DM_AOL_DOWN_V'

309: ,code
310: )
311: SELECT
312: hr_dm_exp_imps_s.nextval
313: ,'HR_DM_AOL_DOWN_V'
314: ,p_migration_id
315: ,p_phase_item_id
316: ,l_aol_command
317: FROM dual;

Line 345: hr_dm_utility.message('ROUT','exit:hr_dm_aol_down.spawn_slaves', 125);

341:
342:
343: hr_dm_utility.message('INFO','Spawned DA slave', 115);
344: hr_dm_utility.message('SUMM','Spawned DA slave', 120);
345: hr_dm_utility.message('ROUT','exit:hr_dm_aol_down.spawn_slaves', 125);
346: hr_dm_utility.message('PARA','(none)', 130);
347:
348:
349: -- error handling

Line 352: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down',

348:
349: -- error handling
350: EXCEPTION
351: WHEN e_fatal_error THEN
352: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down',
353: l_fatal_error_message,'R');
354: hr_dm_master.report_error('DA', p_migration_id,
355: 'Error in hr_dm_aol_down.spawn_down', 'P');
356: RAISE;

Line 355: 'Error in hr_dm_aol_down.spawn_down', 'P');

351: WHEN e_fatal_error THEN
352: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down',
353: l_fatal_error_message,'R');
354: hr_dm_master.report_error('DA', p_migration_id,
355: 'Error in hr_dm_aol_down.spawn_down', 'P');
356: RAISE;
357: WHEN OTHERS THEN
358: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down','(none)','R');
359: hr_dm_master.report_error('DA', p_migration_id,

Line 358: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down','(none)','R');

354: hr_dm_master.report_error('DA', p_migration_id,
355: 'Error in hr_dm_aol_down.spawn_down', 'P');
356: RAISE;
357: WHEN OTHERS THEN
358: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down','(none)','R');
359: hr_dm_master.report_error('DA', p_migration_id,
360: 'Untrapped error in hr_dm_aol_down.spawn_down',
361: 'P');
362: RAISE;

Line 360: 'Untrapped error in hr_dm_aol_down.spawn_down',

356: RAISE;
357: WHEN OTHERS THEN
358: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.spawn_down','(none)','R');
359: hr_dm_master.report_error('DA', p_migration_id,
360: 'Untrapped error in hr_dm_aol_down.spawn_down',
361: 'P');
362: RAISE;
363:
364: --

Line 482: hr_dm_utility.message('ROUT','entry:hr_dm_aol_down.main', 5);

478: IF (p_concurrent_process = 'Y') THEN
479: hr_dm_utility.message_init;
480: END IF;
481:
482: hr_dm_utility.message('ROUT','entry:hr_dm_aol_down.main', 5);
483: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
484: ')(p_last_migration_date - ' ||
485: p_last_migration_date || ')', 10);
486:

Line 495: l_fatal_error_message := 'hr_dm_aol_down.main :- Migration Id ' ||

491: OPEN csr_migration_info;
492: FETCH csr_migration_info INTO l_business_group_id;
493: IF csr_migration_info%NOTFOUND THEN
494: CLOSE csr_migration_info;
495: l_fatal_error_message := 'hr_dm_aol_down.main :- Migration Id ' ||
496: TO_CHAR(p_migration_id) || ' not found.';
497: RAISE e_fatal_error2;
498: END IF;
499: CLOSE csr_migration_info;

Line 605: hr_dm_utility.message('ROUT','exit:hr_dm_aol_down.main', 25);

601:
602:
603: hr_dm_utility.message('INFO','DA - main controller', 15);
604: hr_dm_utility.message('SUMM','DA - main controller', 20);
605: hr_dm_utility.message('ROUT','exit:hr_dm_aol_down.main', 25);
606: hr_dm_utility.message('PARA','(retcode - ' || retcode ||
607: ')(errbuf - ' || errbuf || ')', 30);
608:
609: -- error handling

Line 615: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',

611: WHEN e_fatal_error THEN
612: retcode := 2;
613: errbuf := 'An error occurred during the migration - ' ||
614: 'examine logfiles for detailed reports.';
615: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',
616: l_fatal_error_message,'DA');
617: hr_dm_utility.update_phase_items(p_new_status => 'E',
618: p_id => l_phase_item_id);
619: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');

Line 619: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');

615: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',
616: l_fatal_error_message,'DA');
617: hr_dm_utility.update_phase_items(p_new_status => 'E',
618: p_id => l_phase_item_id);
619: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');
620: WHEN e_fatal_error2 THEN
621: retcode := 0;
622: errbuf := 'An error occurred during the migration - ' ||
623: 'examine logfiles for detailed reports.';

Line 624: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',

620: WHEN e_fatal_error2 THEN
621: retcode := 0;
622: errbuf := 'An error occurred during the migration - ' ||
623: 'examine logfiles for detailed reports.';
624: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',
625: l_fatal_error_message,'DA');
626: hr_dm_utility.update_phases(p_new_status => 'E',
627: p_id => l_phase_id);
628: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');

Line 628: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');

624: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main',
625: l_fatal_error_message,'DA');
626: hr_dm_utility.update_phases(p_new_status => 'E',
627: p_id => l_phase_id);
628: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');
629: WHEN OTHERS THEN
630: retcode := 2;
631: errbuf := 'An error occurred during the migration - ' ||
632: 'examine logfiles for detailed reports.';

Line 636: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');

632: 'examine logfiles for detailed reports.';
633: -- update status to error
634: hr_dm_utility.update_phase_items(p_new_status => 'E',
635: p_id => l_phase_item_id);
636: hr_dm_utility.error(SQLCODE,'hr_dm_aol_down.main','(none)','R');
637:
638:
639: --
640: END main;

Line 644: END hr_dm_aol_down;

640: END main;
641: --
642:
643:
644: END hr_dm_aol_down;