DBA Data[Home] [Help]

APPS.HR_DU_MASTER dependencies on HR_DU_MASTER

Line 1: PACKAGE BODY hr_du_master AS

1: PACKAGE BODY hr_du_master AS
2: /* $Header: perdumas.pkb 115.13 2002/11/28 16:01:15 apholt noship $ */
3:
4:
5: /*-------------------------- PRIVATE ROUTINES ----------------------------*/

Line 43: hr_du_utility.message('ROUT','entry:hr_du_master.create_upload', 5);

39: --
40: BEGIN
41: --
42:
43: hr_du_utility.message('ROUT','entry:hr_du_master.create_upload', 5);
44: hr_du_utility.message('PARA','(r_upload_data - record)', 10);
45:
46: -- get the module id for the spreedsheet input module
47: OPEN csr_module;

Line 97: hr_du_utility.message('ROUT','exit:hr_du_master.create_upload', 25);

93:
94:
95: hr_du_utility.message('INFO','created upload', 15);
96: hr_du_utility.message('SUMM','created upload', 20);
97: hr_du_utility.message('ROUT','exit:hr_du_master.create_upload', 25);
98: hr_du_utility.message('PARA','(none)', 30);
99:
100:
101: -- error handling

Line 107: hr_du_utility.error(SQLCODE,'hr_du_master.create_upload','(none)','R');

103: WHEN OTHERS THEN
104: -- update status to error
105: hr_du_utility.update_uploads(p_new_status => 'E',
106: p_id => r_upload_data.upload_id);
107: hr_du_utility.error(SQLCODE,'hr_du_master.create_upload','(none)','R');
108: RAISE;
109:
110: --
111: END create_upload;

Line 157: hr_du_utility.message('ROUT','entry:hr_du_master.main', 5);

153: -- initialize messaging
154: hr_du_utility.message_init;
155: END IF;
156:
157: hr_du_utility.message('ROUT','entry:hr_du_master.main', 5);
158: hr_du_utility.message('PARA','(p_filename - ' ||
159: p_filename || ')', 10);
160:
161:

Line 218: hr_du_utility.message('ROUT','exit:hr_du_master.main', 25);

214:
215:
216: hr_du_utility.message('INFO','Main controller', 15);
217: hr_du_utility.message('SUMM','Main controller', 20);
218: hr_du_utility.message('ROUT','exit:hr_du_master.main', 25);
219: hr_du_utility.message('PARA','(retcode - ' || retcode ||
220: ')(errbuf - ' || errbuf || ')', 30);
221:
222:

Line 230: hr_du_utility.error(SQLCODE,'hr_du_master.main',

226: retcode := 2;
227: errbuf := 'An error occurred during the upload - examine logfiles' ||
228: ' for detailed reports. Current process is ' ||
229: l_process || '.';
230: hr_du_utility.error(SQLCODE,'hr_du_master.main',
231: l_process,'R');
232: hr_du_utility.update_uploads(p_new_status => 'E',p_id => r_upload_data.upload_id);
233: WHEN OTHERS THEN
234: retcode := 2;

Line 238: hr_du_utility.error(SQLCODE,'hr_du_master.main','(none)','R');

234: retcode := 2;
235: errbuf := 'An error occurred during the upload - examine logfiles' ||
236: ' for detailed reports. Current process is ' ||
237: l_process || '.';
238: hr_du_utility.error(SQLCODE,'hr_du_master.main','(none)','R');
239: hr_du_utility.update_uploads(p_new_status => 'E',p_id => r_upload_data.upload_id);
240:
241: --
242: END main;

Line 247: end hr_du_master;

243: --
244:
245:
246:
247: end hr_du_master;