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_CLEANUP dependencies on HR_DM_CLEANUP

Line 1: PACKAGE BODY hr_dm_cleanup AS

1: PACKAGE BODY hr_dm_cleanup AS
2: /* $Header: perdmclu.pkb 120.0 2005/05/31 17:05:41 appldev noship $ */
3:
4:
5: /*--------------------------- PRIVATE ROUTINES ---------------------------*/

Line 80: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.spawn_cleanup', 5);

76: --
77: BEGIN
78: --
79:
80: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.spawn_cleanup', 5);
81: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
82: '(p_phase_id - ' || p_phase_id ||
83: '(p_phase_item_id - ' || p_phase_item_id ||
84: ')', 10);

Line 165: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.spawn_cleanup', 125);

161:
162:
163: hr_dm_utility.message('INFO','Spawned C slave', 115);
164: hr_dm_utility.message('SUMM','Spawned C slave', 120);
165: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.spawn_cleanup', 125);
166: hr_dm_utility.message('PARA','(none)', 130);
167:
168:
169: -- error handling

Line 172: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup',

168:
169: -- error handling
170: EXCEPTION
171: WHEN e_fatal_error THEN
172: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup',
173: l_fatal_error_message,'R');
174: hr_dm_master.report_error('C', p_migration_id,
175: 'Error in hr_dm_cleanup.spawn_cleanup', 'P');
176: RAISE;

Line 175: 'Error in hr_dm_cleanup.spawn_cleanup', 'P');

171: WHEN e_fatal_error THEN
172: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup',
173: l_fatal_error_message,'R');
174: hr_dm_master.report_error('C', p_migration_id,
175: 'Error in hr_dm_cleanup.spawn_cleanup', 'P');
176: RAISE;
177: WHEN OTHERS THEN
178: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup','(none)','R');
179: hr_dm_master.report_error('C', p_migration_id,

Line 178: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup','(none)','R');

174: hr_dm_master.report_error('C', p_migration_id,
175: 'Error in hr_dm_cleanup.spawn_cleanup', 'P');
176: RAISE;
177: WHEN OTHERS THEN
178: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup','(none)','R');
179: hr_dm_master.report_error('C', p_migration_id,
180: 'Untrapped error in hr_dm_cleanup.spawn_cleanup',
181: 'P');
182: RAISE;

Line 180: 'Untrapped error in hr_dm_cleanup.spawn_cleanup',

176: RAISE;
177: WHEN OTHERS THEN
178: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.spawn_cleanup','(none)','R');
179: hr_dm_master.report_error('C', p_migration_id,
180: 'Untrapped error in hr_dm_cleanup.spawn_cleanup',
181: 'P');
182: RAISE;
183:
184: --

Line 278: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.main', 5);

274: IF (p_concurrent_process = 'Y') THEN
275: hr_dm_utility.message_init;
276: END IF;
277:
278: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.main', 5);
279: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
280: ')(p_last_migration_date - ' ||
281: p_last_migration_date ||
282: ')', 10);

Line 293: l_fatal_error_message := 'hr_dm_cleanup.main :- Migration Id ' ||

289: OPEN csr_migration_info;
290: FETCH csr_migration_info INTO l_business_group_id;
291: IF csr_migration_info%NOTFOUND THEN
292: CLOSE csr_migration_info;
293: l_fatal_error_message := 'hr_dm_cleanup.main :- Migration Id ' ||
294: TO_CHAR(p_migration_id) || ' not found.';
295: RAISE e_fatal_error2;
296: END IF;
297: CLOSE csr_migration_info;

Line 412: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.main', 25);

408:
409:
410: hr_dm_utility.message('INFO','C - main controller', 15);
411: hr_dm_utility.message('SUMM','C - main controller', 20);
412: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.main', 25);
413: hr_dm_utility.message('PARA','(retcode - ' || retcode ||
414: ')(errbuf - ' || errbuf || ')', 30);
415:
416: -- error handling

Line 422: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,

418: WHEN e_fatal_error THEN
419: retcode := 2;
420: errbuf := 'An error occurred during the migration - examine logfiles ' ||
421: 'for detailed reports.';
422: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,
423: 'C');
424: hr_dm_utility.update_phase_items(p_new_status => 'E',
425: p_id => l_phase_item_id);
426: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');

Line 426: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');

422: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,
423: 'C');
424: hr_dm_utility.update_phase_items(p_new_status => 'E',
425: p_id => l_phase_item_id);
426: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');
427: WHEN e_fatal_error2 THEN
428: retcode := 0;
429: errbuf := 'An error occurred during the migration - examine logfiles ' ||
430: 'for detailed reports.';

Line 431: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,

427: WHEN e_fatal_error2 THEN
428: retcode := 0;
429: errbuf := 'An error occurred during the migration - examine logfiles ' ||
430: 'for detailed reports.';
431: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,
432: 'C');
433: hr_dm_utility.update_phase_items(p_new_status => 'E',
434: p_id => l_phase_item_id);
435: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');

Line 435: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');

431: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main',l_fatal_error_message,
432: 'C');
433: hr_dm_utility.update_phase_items(p_new_status => 'E',
434: p_id => l_phase_item_id);
435: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');
436: WHEN OTHERS THEN
437: retcode := 2;
438: errbuf := 'An error occurred during the migration - examine logfiles ' ||
439: 'for detailed reports.';

Line 443: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');

439: 'for detailed reports.';
440: -- update status to error
441: hr_dm_utility.update_phase_items(p_new_status => 'E',
442: p_id => l_phase_item_id);
443: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.main','(none)','R');
444:
445:
446: --
447: END main;

Line 476: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.post_cleanup_process', 5);

472: --
473: BEGIN
474: --
475:
476: hr_dm_utility.message('ROUT','entry:hr_dm_cleanup.post_cleanup_process', 5);
477: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
478:
479:
480: --

Line 490: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.post_cleanup_process', 25);

486:
487:
488: hr_dm_utility.message('INFO','Clean Up - non CM', 15);
489: hr_dm_utility.message('SUMM','Clean Up - non CM', 20);
490: hr_dm_utility.message('ROUT','exit:hr_dm_cleanup.post_cleanup_process', 25);
491: hr_dm_utility.message('PARA','(none)', 30);
492:
493: -- error handling
494: EXCEPTION

Line 496: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.post_cleanup_process',

492:
493: -- error handling
494: EXCEPTION
495: WHEN OTHERS THEN
496: hr_dm_utility.error(SQLCODE,'hr_dm_cleanup.post_cleanup_process',
497: '(none)','R');
498: RAISE;
499:
500: --

Line 505: END hr_dm_cleanup;

501: END post_cleanup_process;
502: --
503:
504:
505: END hr_dm_cleanup;