DBA Data[Home] [Help]

APPS.HR_DM_AOL_UP dependencies on HR_DM_AOL_UP

Line 1: PACKAGE BODY hr_dm_aol_up AS

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

Line 99: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.add_details', 5);

95: --
96: BEGIN
97: --
98:
99: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.add_details', 5);
100: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
101: '(p_phase_id - ' || p_phase_id ||
102: '(p_phase_item_id - ' || p_phase_item_id ||
103: ')', 10);

Line 292: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.add_details', 125);

288: utl_file.put_line(p_file_handle, l_string);
289:
290: hr_dm_utility.message('INFO','Added UA entry', 115);
291: hr_dm_utility.message('SUMM','Added UA entry', 120);
292: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.add_details', 125);
293: hr_dm_utility.message('PARA','(none)', 130);
294:
295:
296: -- error handling

Line 299: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details',

295:
296: -- error handling
297: EXCEPTION
298: WHEN e_fatal_error THEN
299: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details',
300: l_fatal_error_message, 'R');
301: hr_dm_master.report_error('UA', p_migration_id,
302: 'Error in hr_dm_aol_up.add_details', 'P');
303: RAISE;

Line 302: 'Error in hr_dm_aol_up.add_details', 'P');

298: WHEN e_fatal_error THEN
299: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details',
300: l_fatal_error_message, 'R');
301: hr_dm_master.report_error('UA', p_migration_id,
302: 'Error in hr_dm_aol_up.add_details', 'P');
303: RAISE;
304: WHEN OTHERS THEN
305: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details','(none)','R');
306: hr_dm_master.report_error('UA', p_migration_id,

Line 305: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details','(none)','R');

301: hr_dm_master.report_error('UA', p_migration_id,
302: 'Error in hr_dm_aol_up.add_details', 'P');
303: RAISE;
304: WHEN OTHERS THEN
305: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details','(none)','R');
306: hr_dm_master.report_error('UA', p_migration_id,
307: 'Untrapped error in hr_dm_aol_up.add_details',
308: 'P');
309: RAISE;

Line 307: 'Untrapped error in hr_dm_aol_up.add_details',

303: RAISE;
304: WHEN OTHERS THEN
305: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.add_details','(none)','R');
306: hr_dm_master.report_error('UA', p_migration_id,
307: 'Untrapped error in hr_dm_aol_up.add_details',
308: 'P');
309: RAISE;
310:
311: --

Line 358: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.post_aol_process', 5);

354: --
355: BEGIN
356: --
357:
358: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.post_aol_process', 5);
359: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
360: ')', 10);
361:
362: SELECT business_group_id

Line 425: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.post_aol_process', 25);

421:
422: COMMIT;
423:
424:
425: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.post_aol_process', 25);
426: hr_dm_utility.message('PARA','(none)', 10);
427: EXCEPTION
428: WHEN OTHERS THEN
429: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.post_aol_process',

Line 429: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.post_aol_process',

425: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.post_aol_process', 25);
426: hr_dm_utility.message('PARA','(none)', 10);
427: EXCEPTION
428: WHEN OTHERS THEN
429: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.post_aol_process',
430: '(none)','R');
431: RAISE;
432:
433: --

Line 562: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.main', 5);

558: IF (p_concurrent_process = 'Y') THEN
559: hr_dm_utility.message_init;
560: END IF;
561:
562: hr_dm_utility.message('ROUT','entry:hr_dm_aol_up.main', 5);
563: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
564: ')(p_last_migration_date - ' ||
565: p_last_migration_date || ')', 10);
566:

Line 734: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.main', 25);

730:
731:
732: hr_dm_utility.message('INFO','UA - main controller', 15);
733: hr_dm_utility.message('SUMM','UA - main controller', 20);
734: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.main', 25);
735: hr_dm_utility.message('PARA','(retcode - ' || retcode ||
736: ')(errbuf - ' || errbuf || ')', 30);
737:
738: -- error handling

Line 744: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',

740: WHEN e_fatal_error THEN
741: retcode := 2;
742: errbuf := 'An error occurred during the migration - ' ||
743: 'examine logfiles for detailed reports.';
744: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',
745: l_fatal_error_message,'UA');
746: hr_dm_utility.update_phase_items(p_new_status => 'E',
747: p_id => l_phase_item_id);
748: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');

Line 748: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');

744: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',
745: l_fatal_error_message,'UA');
746: hr_dm_utility.update_phase_items(p_new_status => 'E',
747: p_id => l_phase_item_id);
748: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');
749: WHEN e_fatal_error2 THEN
750: retcode := 0;
751: errbuf := 'An error occurred during the migration - ' ||
752: 'examine logfiles for detailed reports.';

Line 753: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',

749: WHEN e_fatal_error2 THEN
750: retcode := 0;
751: errbuf := 'An error occurred during the migration - ' ||
752: 'examine logfiles for detailed reports.';
753: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',
754: l_fatal_error_message,'UA');
755: hr_dm_utility.update_phases(p_new_status => 'E',
756: p_id => l_phase_id);
757: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');

Line 757: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');

753: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main',
754: l_fatal_error_message,'UA');
755: hr_dm_utility.update_phases(p_new_status => 'E',
756: p_id => l_phase_id);
757: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');
758: WHEN OTHERS THEN
759: retcode := 2;
760: errbuf := 'An error occurred during the migration - ' ||
761: 'examine logfiles for detailed reports.';

Line 765: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');

761: 'examine logfiles for detailed reports.';
762: -- update status to error
763: hr_dm_utility.update_phase_items(p_new_status => 'E',
764: p_id => l_phase_item_id);
765: hr_dm_utility.error(SQLCODE,'hr_dm_aol_up.main','(none)','R');
766:
767:
768: --
769: END main;

Line 773: END hr_dm_aol_up;

769: END main;
770: --
771:
772:
773: END hr_dm_aol_up;