119: if l_report_lines = 0 then
120: --
121: -- Obtain translated report title text from the messages dictionary
122: --
123: fnd_message.set_name('PER', p_title_message_name);
124: l_title := fnd_message.get;
125: fnd_message.set_name('PER', 'HR_51988_AHR_CREATED_ON');
126: l_created_on := fnd_message.get;
127: --
120: --
121: -- Obtain translated report title text from the messages dictionary
122: --
123: fnd_message.set_name('PER', p_title_message_name);
124: l_title := fnd_message.get;
125: fnd_message.set_name('PER', 'HR_51988_AHR_CREATED_ON');
126: l_created_on := fnd_message.get;
127: --
128: -- Output the report header, the translated version of:
121: -- Obtain translated report title text from the messages dictionary
122: --
123: fnd_message.set_name('PER', p_title_message_name);
124: l_title := fnd_message.get;
125: fnd_message.set_name('PER', 'HR_51988_AHR_CREATED_ON');
126: l_created_on := fnd_message.get;
127: --
128: -- Output the report header, the translated version of:
129: -- Translated Report Title
122: --
123: fnd_message.set_name('PER', p_title_message_name);
124: l_title := fnd_message.get;
125: fnd_message.set_name('PER', 'HR_51988_AHR_CREATED_ON');
126: l_created_on := fnd_message.get;
127: --
128: -- Output the report header, the translated version of:
129: -- Translated Report Title
130: -- =======================
192: hr_utility.set_location('Entering:'|| l_proc, 10);
193: --
194: -- Obtain translated text from the messages dictionary
195: --
196: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
193: --
194: -- Obtain translated text from the messages dictionary
195: --
196: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
194: -- Obtain translated text from the messages dictionary
195: --
196: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
195: --
196: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
196: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
197: p_module_name_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
205: p_success_text := fnd_message.get;
198: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
205: p_success_text := fnd_message.get;
206: --
199: p_module_type_text := fnd_message.get;
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
205: p_success_text := fnd_message.get;
206: --
207: hr_utility.set_location(' Leaving:'|| l_proc, 20);
200: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
205: p_success_text := fnd_message.get;
206: --
207: hr_utility.set_location(' Leaving:'|| l_proc, 20);
208: end get_translated_prompts;
201: p_hook_text := fnd_message.get;
202: fnd_message.set_name('PER', 'HR_51992_AHR_HOOK_PKG');
203: p_hook_pkg_text := fnd_message.get;
204: fnd_message.set_name('PER', 'HR_52545_AHR_SUCCESS');
205: p_success_text := fnd_message.get;
206: --
207: hr_utility.set_location(' Leaving:'|| l_proc, 20);
208: end get_translated_prompts;
209: --
304: hr_utility.set_location('Entering:'|| l_proc, 10);
305: --
306: -- Obtain translated text from the message dictionary
307: --
308: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
305: --
306: -- Obtain translated text from the message dictionary
307: --
308: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
306: -- Obtain translated text from the message dictionary
307: --
308: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
307: --
308: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
315: l_no_dtype_text := fnd_message.get;
308: fnd_message.set_name('PER', 'HR_51989_AHR_MOD_NAME');
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
315: l_no_dtype_text := fnd_message.get;
316: hr_utility.set_location(l_proc, 20);
309: l_mod_name_text := fnd_message.get;
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
315: l_no_dtype_text := fnd_message.get;
316: hr_utility.set_location(l_proc, 20);
317: --
310: fnd_message.set_name('PER', 'HR_51990_AHR_MOD_TYPE');
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
315: l_no_dtype_text := fnd_message.get;
316: hr_utility.set_location(l_proc, 20);
317: --
318: -- Output report header
311: l_mod_type_text := fnd_message.get;
312: fnd_message.set_name('PER', 'HR_51991_AHR_HOOK');
313: l_hook_text := fnd_message.get;
314: fnd_message.set_name('PER', 'HR_52038_AHR_DTYPE_NOT_REC');
315: l_no_dtype_text := fnd_message.get;
316: hr_utility.set_location(l_proc, 20);
317: --
318: -- Output report header
319: --
646: open cur_ahk_err(l_hook.api_hook_id);
647: fetch cur_ahk_err into l_encoded_error;
648: if cur_ahk_err%found then
649: -- An error has occurred
650: fnd_message.set_encoded(l_encoded_error);
651: l_read_error := fnd_message.get;
652: report_line(l_read_error);
653: end if;
654: close cur_ahk_err;
647: fetch cur_ahk_err into l_encoded_error;
648: if cur_ahk_err%found then
649: -- An error has occurred
650: fnd_message.set_encoded(l_encoded_error);
651: l_read_error := fnd_message.get;
652: report_line(l_read_error);
653: end if;
654: close cur_ahk_err;
655: --
655: --
656: -- Output details of any hook call level application errors
657: --
658: for l_ahc_err in cur_ahc_err(l_hook.api_hook_id) loop
659: fnd_message.set_encoded(l_ahc_err.encoded_error);
660: l_read_error := fnd_message.get;
661: l_line := '(' || l_ahc_err.call_package || '.' ||
662: l_ahc_err.call_procedure || ') ' ||
663: substr(l_read_error, 1, 1925);
656: -- Output details of any hook call level application errors
657: --
658: for l_ahc_err in cur_ahc_err(l_hook.api_hook_id) loop
659: fnd_message.set_encoded(l_ahc_err.encoded_error);
660: l_read_error := fnd_message.get;
661: l_line := '(' || l_ahc_err.call_package || '.' ||
662: l_ahc_err.call_procedure || ') ' ||
663: substr(l_read_error, 1, 1925);
664: report_line(l_line);