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_API_USER_HOOKS_UTILITY dependencies on HR_UTILITY

Line 43: hr_utility.set_location('Entering:'|| l_proc, 10);

39: (p_text in varchar2
40: ) is
41: l_proc varchar2(72) := g_package||'report_line';
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Insert into reports table
46: --
47: insert into hr_api_user_hook_reports

Line 58: hr_utility.set_location(' Leaving:'|| l_proc, 20);

54: p_text);
55: --
56: g_number := g_number + 1;
57: --
58: hr_utility.set_location(' Leaving:'|| l_proc, 20);
59: end report_line;
60: --
61: -- ----------------------------------------------------------------------------
62: -- |------------------------------< report_title >----------------------------|

Line 110: hr_utility.set_location('Entering:'|| l_proc, 10);

106: l_created_on varchar2(2000);
107: l_report_lines varchar2(30);
108: l_proc varchar2(72) := g_package||'report_title';
109: begin
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Output the report title if a report has not
113: -- already started for the current database session
114: --

Line 147: hr_utility.set_location(' Leaving:'|| l_proc, 20);

143: --
144: g_error_detected := false;
145: --
146: end if;
147: hr_utility.set_location(' Leaving:'|| l_proc, 20);
148: end report_title;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |------------------------< get_translated_prompts >------------------------|

Line 192: hr_utility.set_location('Entering:'|| l_proc, 10);

188: l_title varchar2(2000);
189: l_created_on varchar2(2000);
190: l_proc varchar2(72) := g_package||'get_translated_prompts';
191: begin
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');

Line 207: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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: --
210: -- ----------------------------------------------------------------------------
211: -- |------------------------< write_hook_parameter_list >---------------------|

Line 304: hr_utility.set_location('Entering:'|| l_proc, 10);

300: l_proc varchar2(72) := g_package||'write_hook_parameter_list';
301: c_new_line constant varchar2(1) default '
302: ';
303: begin
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');

Line 316: hr_utility.set_location(l_proc, 20);

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

Line 323: hr_utility.set_location(l_proc, 30);

319: --
320: report_title
321: (p_title_message_name => 'HR_51985_AHR_PARM_LIST'
322: );
323: hr_utility.set_location(l_proc, 30);
324: --
325: -- Loop for all API Modules
326: --
327: for l_module in csr_modules loop

Line 421: hr_utility.set_message(800, 'HR_51960_AHK_HK_PKG_NOT_FOUND');

417: -- database. Either the package header has not been loaded into the
418: -- database or the hook package name specified in the HR_API_HOOKS
419: -- table is incorrect. This API module will not execute until this
420: -- problem has been resolved.
421: hr_utility.set_message(800, 'HR_51960_AHK_HK_PKG_NOT_FOUND');
422: when Proc_Not_In_Package then
423: -- Error: The hook procedure does not exist in the hook package.
424: -- This API module will not execute until this problem has been
425: -- resolved.

Line 426: hr_utility.set_message(800, 'HR_51961_AHK_HK_PRO_NO_EXIST');

422: when Proc_Not_In_Package then
423: -- Error: The hook procedure does not exist in the hook package.
424: -- This API module will not execute until this problem has been
425: -- resolved.
426: hr_utility.set_message(800, 'HR_51961_AHK_HK_PRO_NO_EXIST');
427: when Remote_Object then
428: -- Error: Remote objects cannot used for API hook package
429: -- procedures. This API module will not execute until this problem
430: -- has been resolved.

Line 431: hr_utility.set_message(800, 'HR_51962_AHK_HK_REMOTE_OBJ');

427: when Remote_Object then
428: -- Error: Remote objects cannot used for API hook package
429: -- procedures. This API module will not execute until this problem
430: -- has been resolved.
431: hr_utility.set_message(800, 'HR_51962_AHK_HK_REMOTE_OBJ');
432: when Invalid_Package then
433: -- Error: The hook package code in the database is invalid.
434: -- This API module will not execute until this problem has been
435: -- resolved.

Line 436: hr_utility.set_message(800, 'HR_51963_AHK_HK_PKG_INVALID');

432: when Invalid_Package then
433: -- Error: The hook package code in the database is invalid.
434: -- This API module will not execute until this problem has been
435: -- resolved.
436: hr_utility.set_message(800, 'HR_51963_AHK_HK_PKG_INVALID');
437: when Invalid_Object_Name then
438: -- Error: An error has occurred while attempting to parse the name
439: -- of the hook package and hook procedure. Check the package and
440: -- procedure names. This API module will not execute until this

Line 442: hr_utility.set_message(800, 'HR_51964_AHK_HK_PARSE');

438: -- Error: An error has occurred while attempting to parse the name
439: -- of the hook package and hook procedure. Check the package and
440: -- procedure names. This API module will not execute until this
441: -- problem has been resolved.
442: hr_utility.set_message(800, 'HR_51964_AHK_HK_PARSE');
443: end;
444: end loop; -- End Hook Loop
445: end loop; -- End Module Loop
446: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 446: hr_utility.set_location(' Leaving:'|| l_proc, 40);

442: hr_utility.set_message(800, 'HR_51964_AHK_HK_PARSE');
443: end;
444: end loop; -- End Hook Loop
445: end loop; -- End Module Loop
446: hr_utility.set_location(' Leaving:'|| l_proc, 40);
447: end write_hook_parameter_list;
448: --
449: -- ----------------------------------------------------------------------------
450: -- |--------------------------< write_module_errors >-------------------------|

Line 600: hr_utility.set_location('Entering:'|| l_proc, 10);

596: -- has been detected with the
597: -- current module.
598: l_proc varchar2(72) := g_package||'write_module_errors';
599: begin
600: hr_utility.set_location('Entering:'|| l_proc, 10);
601: --
602: -- Loop for all hook packages in a particular API module
603: --
604: for l_hook_pkgs in csr_hook_pkgs loop

Line 683: hr_utility.set_location(' Leaving:'|| l_proc, 20);

679: report_line(p_module_name || '(' || p_module_type_meaning || ') ' ||
680: p_success_text);
681: end if;
682: end if;
683: hr_utility.set_location(' Leaving:'|| l_proc, 20);
684: end write_module_errors;
685: --
686: -- ----------------------------------------------------------------------------
687: -- |------------------------< write_all_errors_report >-----------------------|

Line 712: hr_utility.set_location('Entering:'|| l_proc, 10);

708: l_hook_pkg_text varchar2(2000);
709: l_success_text varchar2(2000);
710: l_proc varchar2(72) := g_package||'write_all_errors_report';
711: begin
712: hr_utility.set_location('Entering:'|| l_proc, 10);
713: --
714: -- Output report header
715: --
716: report_title

Line 719: hr_utility.set_location(l_proc, 20);

715: --
716: report_title
717: (p_title_message_name => 'HR_51986_AHR_ALL_ERR_TITLE'
718: );
719: hr_utility.set_location(l_proc, 20);
720: --
721: -- Obtain translated text prompts
722: --
723: get_translated_prompts

Line 730: hr_utility.set_location(l_proc, 30);

726: ,p_hook_text => l_hook_text
727: ,p_hook_pkg_text => l_hook_pkg_text
728: ,p_success_text => l_success_text
729: );
730: hr_utility.set_location(l_proc, 30);
731: --
732: -- Loop for all API Modules
733: --
734: for l_module in csr_modules loop

Line 747: hr_utility.set_location(' Leaving:'|| l_proc, 40);

743: ,p_success_text => l_success_text
744: ,p_include_success => false
745: );
746: end loop; -- End Module Loop
747: hr_utility.set_location(' Leaving:'|| l_proc, 40);
748: end write_all_errors_report;
749: --
750: -- ----------------------------------------------------------------------------
751: -- |------------------------< write_one_errors_report >-----------------------|

Line 781: hr_utility.set_location('Entering:'|| l_proc, 10);

777: l_hook_pkg_text varchar2(2000);
778: l_success_text varchar2(2000);
779: l_proc varchar2(72) := g_package||'write_one_errors_report';
780: begin
781: hr_utility.set_location('Entering:'|| l_proc, 10);
782: --
783: -- Validate this API module actually exists
784: --
785: open cur_module;

Line 794: hr_utility.set_location(l_proc, 20);

790: --
791: report_title
792: (p_title_message_name => 'HR_51987_AHR_ONE_ERR_TITLE'
793: );
794: hr_utility.set_location(l_proc, 20);
795: --
796: -- Obtain translated text prompts
797: --
798: get_translated_prompts

Line 805: hr_utility.set_location(l_proc, 30);

801: ,p_hook_text => l_hook_text
802: ,p_hook_pkg_text => l_hook_pkg_text
803: ,p_success_text => l_success_text
804: );
805: hr_utility.set_location(l_proc, 30);
806: --
807: -- Output report details for the API module
808: --
809: write_module_errors

Line 820: hr_utility.set_location(l_proc, 40);

816: ,p_hook_pkg_text => l_hook_pkg_text
817: ,p_success_text => l_success_text
818: ,p_include_success => true
819: );
820: hr_utility.set_location(l_proc, 40);
821: end if;
822: close cur_module;
823: hr_utility.set_location(' Leaving:'|| l_proc, 50);
824: end write_one_errors_report;

Line 823: hr_utility.set_location(' Leaving:'|| l_proc, 50);

819: );
820: hr_utility.set_location(l_proc, 40);
821: end if;
822: close cur_module;
823: hr_utility.set_location(' Leaving:'|| l_proc, 50);
824: end write_one_errors_report;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< clear_hook_report >--------------------------|

Line 850: hr_utility.set_location('Entering:'|| l_proc, 10);

846: c_header_lines constant number := 4;
847: l_exists varchar2(1);
848: l_proc varchar2(72) := g_package||'clear_hook_report';
849: begin
850: hr_utility.set_location('Entering:'|| l_proc, 10);
851: --
852: -- Delete rows in the report table for this session
853: --
854: delete from hr_api_user_hook_reports

Line 894: hr_utility.set_location(' Leaving:'|| l_proc, 20);

890: if g_error_detected then
891: raise program_error;
892: end if;
893: --
894: hr_utility.set_location(' Leaving:'|| l_proc, 20);
895: end clear_hook_report;
896: --
897: -- ----------------------------------------------------------------------------
898: -- |------------------------< create_hooks_all_modules >----------------------|

Line 913: hr_utility.set_location('Entering:'|| l_proc, 10);

909: -- Local variables
910: --
911: l_proc varchar2(72) := g_package||'create_hooks_all_modules';
912: begin
913: hr_utility.set_location('Entering:'|| l_proc, 10);
914: --
915: -- Create each hook package which is defined in the HR_API_HOOKS table
916: -- Commit after each package has been created to ensure any error
917: -- information written to the HR_API_HOOKS and HR_API_HOOK_CALLS tables

Line 925: hr_utility.set_location(' Leaving:'|| l_proc, 20);

921: hr_api_user_hooks.create_package_body(l_hook.hook_package);
922: dbms_session.free_unused_user_memory;
923: commit;
924: end loop;
925: hr_utility.set_location(' Leaving:'|| l_proc, 20);
926: end create_hooks_all_modules;
927: --
928: -- ----------------------------------------------------------------------------
929: -- |------------------------< create_hooks_one_module >-----------------------|

Line 957: hr_utility.set_location('Entering:'|| l_proc, 10);

953: --
954: l_exists varchar2(30);
955: l_proc varchar2(72) := g_package||'create_hooks_one_module';
956: begin
957: hr_utility.set_location('Entering:'|| l_proc, 10);
958: --
959: -- Validate this API module actually exists
960: --
961: open cur_module;

Line 977: hr_utility.set_location(' Leaving:'|| l_proc, 20);

973: commit;
974: end loop;
975: end if;
976: close cur_module;
977: hr_utility.set_location(' Leaving:'|| l_proc, 20);
978: end create_hooks_one_module;
979: --
980: -- ----------------------------------------------------------------------------
981: -- |------------------------< create_hooks_add_report >-----------------------|

Line 992: hr_utility.set_location('Entering:'|| l_proc, 10);

988: -- Local variables
989: --
990: l_proc varchar2(72) := g_package||'create_hooks_add_report';
991: begin
992: hr_utility.set_location('Entering:'|| l_proc, 10);
993: --
994: create_hooks_one_module
995: (p_api_module_id => p_api_module_id
996: );

Line 1002: hr_utility.set_location(' Leaving:'|| l_proc, 20);

998: write_one_errors_report
999: (p_api_module_id => p_api_module_id
1000: );
1001: --
1002: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1003: end create_hooks_add_report;
1004: --
1005: end hr_api_user_hooks_utility;