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_UTILITY

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

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

Line 107: hr_dm_utility.message('INFO','Spawning ' || l_loader_name, 15);

103: CLOSE csr_data;
104:
105:
106:
107: hr_dm_utility.message('INFO','Spawning ' || l_loader_name, 15);
108:
109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);

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

105:
106:
107: hr_dm_utility.message('INFO','Spawning ' || l_loader_name, 15);
108:
109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);

Line 110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);

106:
107: hr_dm_utility.message('INFO','Spawning ' || l_loader_name, 15);
108:
109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);

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

107: hr_dm_utility.message('INFO','Spawning ' || l_loader_name, 15);
108:
109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);

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

108:
109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);

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

109: hr_dm_utility.message('INFO','application ' || l_loader_application, 115);
110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);

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

110: hr_dm_utility.message('INFO','program ' || l_loader_conc_program, 115);
111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);

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

111: hr_dm_utility.message('INFO','sub_request TRUE', 115);
112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);

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

112: hr_dm_utility.message('INFO','argument1 ' || l_parameter1, 115);
113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);

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

113: hr_dm_utility.message('INFO','argument2 ' || l_parameter2, 115);
114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
121: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);

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

114: hr_dm_utility.message('INFO','argument3 ' || l_parameter3, 115);
115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
121: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
122:

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

115: hr_dm_utility.message('INFO','argument4 ' || l_parameter4, 115);
116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
121: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
122:
123:

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

116: hr_dm_utility.message('INFO','argument5 ' || l_parameter5, 115);
117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
121: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
122:
123:
124: l_request_id := fnd_request.submit_request(

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

117: hr_dm_utility.message('INFO','argument6 ' || l_parameter6, 115);
118: hr_dm_utility.message('INFO','argument7 ' || l_parameter7, 115);
119: hr_dm_utility.message('INFO','argument8 ' || l_parameter8, 115);
120: hr_dm_utility.message('INFO','argument9 ' || l_parameter9, 115);
121: hr_dm_utility.message('INFO','argument10 ' || l_parameter10, 115);
122:
123:
124: l_request_id := fnd_request.submit_request(
125: application => l_loader_application,

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

149:
150:
151: COMMIT;
152:
153: hr_dm_utility.message('INFO','Slave request ID#' || l_request_id, 15);
154: IF (l_request_id = 0) THEN
155: l_fatal_error_message := 'Unable to start slave process';
156: hr_dm_master.report_error('C', p_migration_id, l_fatal_error_message,
157: 'P');

Line 163: hr_dm_utility.message('INFO','Spawned C slave', 115);

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

Line 164: hr_dm_utility.message('SUMM','Spawned C slave', 120);

160:
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:

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

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

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

271: --
272:
273: -- initialize messaging (only for concurrent processing)
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 ||

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

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

Line 285: l_phase_id := hr_dm_utility.get_phase_id('C', p_migration_id);

281: p_last_migration_date ||
282: ')', 10);
283:
284: -- get the current phase_id
285: l_phase_id := hr_dm_utility.get_phase_id('C', p_migration_id);
286:
287:
288: -- get the business_group_id
289: OPEN csr_migration_info;

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

296: END IF;
297: CLOSE csr_migration_info;
298:
299: -- get the number of threads to enable modulus locking
300: l_no_of_threads := hr_dm_utility.number_of_threads(l_business_group_id);
301:
302:
303: -- get status of C phase, is phase completed?
304: -- if null returned, then assume it is NS.

Line 305: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('C',

301:
302:
303: -- get status of C phase, is phase completed?
304: -- if null returned, then assume it is NS.
305: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('C',
306: p_migration_id), 'NS');
307:
308: -- if status is error, then raise an exception
309: IF (l_current_phase_status = 'E') THEN

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

316: -- or
317: -- is it a restart after a slave has finished? (l_request_data = paused phase
318: -- item code)
319: l_request_data := fnd_conc_global.request_data;
320: hr_dm_utility.message('INFO','l_request_data ' || l_request_data, 11);
321: IF (NVL(l_request_data, '?') IS NOT NULL) THEN
322: -- unpaused processing...
323:
324: -- check for error in slave

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

334: l_dev_status, l_message);
335: -- make sure that each slave is complete and normal, if not then log
336: IF ( NOT( (l_dev_phase = 'COMPLETE') AND (l_dev_status = 'NORMAL') )) THEN
337: -- update status to error
338: hr_dm_utility.update_phase_items(p_new_status => 'E',
339: p_id => l_phase_item_id);
340: l_fatal_error_message := 'Sub-slave process in error - slave exiting';
341: RAISE e_fatal_error;
342: ELSE

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

340: l_fatal_error_message := 'Sub-slave process in error - slave exiting';
341: RAISE e_fatal_error;
342: ELSE
343: -- update status to completed
344: hr_dm_utility.update_phase_items(p_new_status => 'C',
345: p_id => l_phase_item_id);
346: END IF;
347:
348: END IF;

Line 353: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('C',

349:
350:
351: -- get status of C phase, is phase completed?
352: -- if null returned, then assume it is NS.
353: l_current_phase_status := NVL(hr_dm_utility.get_phase_status('C',
354: p_migration_id), 'NS');
355:
356: -- if status is error, then raise an exception
357: IF (l_current_phase_status = 'E') THEN

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

369: l_status;
370: IF (csr_get_pi%FOUND) THEN
371:
372: -- update status to started
373: hr_dm_utility.update_phase_items(p_new_status => 'S',
374: p_id => l_phase_item_id);
375:
376: -- send info on current table to logfile
377: hr_dm_utility.message('INFO','Processing - ' || l_loader_name, 13);

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

373: hr_dm_utility.update_phase_items(p_new_status => 'S',
374: p_id => l_phase_item_id);
375:
376: -- send info on current table to logfile
377: hr_dm_utility.message('INFO','Processing - ' || l_loader_name, 13);
378:
379:
380: -- call code for cleanup item
381: spawn_cleanup(p_migration_id => p_migration_id,

Line 410: hr_dm_utility.message('INFO','C - main controller', 15);

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

Line 411: hr_dm_utility.message('SUMM','C - main controller', 20);

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

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

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

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

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

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

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

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

437: retcode := 2;
438: errbuf := 'An error occurred during the migration - examine logfiles ' ||
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:

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 468: hr_dm_utility.r_migration_rec) IS

464: -- ------------------------------------------------------------------------
465:
466: --
467: PROCEDURE post_cleanup_process(r_migration_data IN
468: hr_dm_utility.r_migration_rec) IS
469: --
470:
471:
472: --

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 477: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);

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: --
481: -- non-concurrent program code for clean up phase

Line 488: hr_dm_utility.message('INFO','Clean Up - non CM', 15);

484: -- ...if required
485: --
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:

Line 489: hr_dm_utility.message('SUMM','Clean Up - non CM', 20);

485: --
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

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

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
495: WHEN OTHERS THEN

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