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_UTILITY

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 104: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||

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);
108:

Line 244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);

240: ELSIF (l_parameter10 = ':secgrp') THEN l_parameter10 := l_security_group;
241: END IF;
242:
243:
244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);

Line 245: hr_dm_utility.message('INFO','program ' || l_program, 115);

241: END IF;
242:
243:
244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);

Line 246: hr_dm_utility.message('INFO','sub_request TRUE', 115);

242:
243:
244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);

Line 247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);

243:
244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);

Line 248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);

244: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);

Line 249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);

245: hr_dm_utility.message('INFO','program ' || l_program, 115);
246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);

Line 250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);

246: hr_dm_utility.message('INFO','sub_request TRUE', 115);
247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);

Line 251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);

247: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);

Line 252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);

248: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);

Line 253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);

249: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
257:

Line 254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);

250: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
257:
258:

Line 255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);

251: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
257:
258:
259:

Line 256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);

252: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
253: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
254: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
255: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
256: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
257:
258:
259:
260: l_request_id := fnd_request.submit_request(

Line 334: hr_dm_utility.message('INFO','Slave request ID#' || l_request_id, 15);

330: p_phase_item_id => p_phase_item_id);
331:
332: COMMIT;
333:
334: hr_dm_utility.message('INFO','Slave request ID#' || l_request_id, 15);
335: IF (l_request_id = 0) THEN
336: l_fatal_error_message := 'Unable to start slave process';
337: hr_dm_master.report_error('DA', p_migration_id,
338: l_fatal_error_message, 'P');

Line 343: hr_dm_utility.message('INFO','Spawned DA slave', 115);

339: RAISE e_fatal_error;
340: END IF;
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:

Line 344: hr_dm_utility.message('SUMM','Spawned DA slave', 120);

340: END IF;
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:

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 346: hr_dm_utility.message('PARA','(none)', 130);

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
350: EXCEPTION

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 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 479: hr_dm_utility.message_init;

475: --
476:
477: -- initialize messaging (only for concurrent processing)
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 ||

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 483: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||

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:
487: -- get the current phase_id

Line 488: l_phase_id := hr_dm_utility.get_phase_id('DA', p_migration_id);

484: ')(p_last_migration_date - ' ||
485: p_last_migration_date || ')', 10);
486:
487: -- get the current phase_id
488: l_phase_id := hr_dm_utility.get_phase_id('DA', p_migration_id);
489:
490: -- get the business_group_id
491: OPEN csr_migration_info;
492: FETCH csr_migration_info INTO l_business_group_id;

Line 502: l_no_of_threads := hr_dm_utility.number_of_threads(l_business_group_id);

498: END IF;
499: CLOSE csr_migration_info;
500:
501: -- get the number of threads to enable modulus locking
502: l_no_of_threads := hr_dm_utility.number_of_threads(l_business_group_id);
503:
504:
505: -- see if this is the first run? (l_request_data = NULL or '?')
506: -- or

Line 510: hr_dm_utility.message('INFO','l_request_data ' || l_request_data, 11);

506: -- or
507: -- is it a restart after a slave has finished? (l_request_data =
508: -- paused phase item code)
509: l_request_data := fnd_conc_global.request_data;
510: hr_dm_utility.message('INFO','l_request_data ' || l_request_data, 11);
511: IF (l_request_data IS NOT NULL) THEN
512: -- unpaused processing...
513:
514: -- check for error in slave

Line 529: hr_dm_utility.update_phase_items(p_new_status => 'E',

525: -- make sure that each slave is complete and normal, if not then log
526: IF ( NOT( (l_dev_phase = 'COMPLETE') AND (l_dev_status = 'NORMAL') )) THEN
527:
528: -- update status to error
529: hr_dm_utility.update_phase_items(p_new_status => 'E',
530: p_id => l_phase_item_id);
531: l_fatal_error_message := 'Sub-slave process in error - slave exiting';
532: RAISE e_fatal_error;
533: ELSE

Line 535: hr_dm_utility.update_phase_items(p_new_status => 'C',

531: l_fatal_error_message := 'Sub-slave process in error - slave exiting';
532: RAISE e_fatal_error;
533: ELSE
534: -- update status to completed
535: hr_dm_utility.update_phase_items(p_new_status => 'C',
536: p_id => l_phase_item_id);
537: END IF;
538:
539: -- reset request data flag

Line 546: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('DA',

542:
543:
544: -- get status of DA phase, is phase completed?
545: -- if null returned, then assume it is NS.
546: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('DA',
547: p_migration_id), 'NS');
548:
549: -- if status is error, then raise an exception
550: IF (l_current_phase_status = 'E') THEN

Line 566: hr_dm_utility.update_phase_items(p_new_status => 'S',

562: l_status;
563: IF (csr_get_pi%FOUND) THEN
564:
565: -- update status to started
566: hr_dm_utility.update_phase_items(p_new_status => 'S',
567: p_id => l_phase_item_id);
568:
569: -- send info on current table to logfile
570: hr_dm_utility.message('INFO','Processing - ' || l_loader_name, 13);

Line 570: hr_dm_utility.message('INFO','Processing - ' || l_loader_name, 13);

566: hr_dm_utility.update_phase_items(p_new_status => 'S',
567: p_id => l_phase_item_id);
568:
569: -- send info on current table to logfile
570: hr_dm_utility.message('INFO','Processing - ' || l_loader_name, 13);
571:
572:
573: -- call code for AOL loader
574: spawn_down(p_migration_id => p_migration_id,

Line 603: hr_dm_utility.message('INFO','DA - main controller', 15);

599: errbuf := 'Slave Controller is paused.';
600: END IF;
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);

Line 604: hr_dm_utility.message('SUMM','DA - main controller', 20);

600: END IF;
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:

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 606: hr_dm_utility.message('PARA','(retcode - ' || retcode ||

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
610: EXCEPTION

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 617: hr_dm_utility.update_phase_items(p_new_status => 'E',

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');
620: WHEN e_fatal_error2 THEN
621: retcode := 0;

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 626: hr_dm_utility.update_phases(p_new_status => 'E',

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');
629: WHEN OTHERS THEN
630: retcode := 2;

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 634: hr_dm_utility.update_phase_items(p_new_status => 'E',

630: retcode := 2;
631: errbuf := 'An error occurred during the migration - ' ||
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:

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;