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.FF_FORMULA_WEBUI_PKG dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: package body FF_FORMULA_WEBUI_PKG as
2: /* $Header: fffwebpk.pkb 120.5 2012/02/08 15:04:11 asnell ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5: --
6: procedure generate_unique_formula_name(
7: p_formula_type_id in varchar2,
8: p_business_group_id in number,

Line 21: hr_utility.set_location('Entering ff_formula_webui_pkg.generate_unique_formula_name',10);

17: --
18: begin
19: --
20: if g_debug then
21: hr_utility.set_location('Entering ff_formula_webui_pkg.generate_unique_formula_name',10);
22: end if;
23: --
24: -- Loop until we have a unique name
25: loop

Line 80: hr_utility.trace('p_formula_name: '||p_formula_name);

76: end;
77: end loop;
78: --
79: if g_debug then
80: hr_utility.trace('p_formula_name: '||p_formula_name);
81: hr_utility.set_location('Leaving ff_formula_webui_pkg.generate_unique_formula_name',30);
82: end if;
83: --
84: p_formula_name := l_tmp_name;

Line 81: hr_utility.set_location('Leaving ff_formula_webui_pkg.generate_unique_formula_name',30);

77: end loop;
78: --
79: if g_debug then
80: hr_utility.trace('p_formula_name: '||p_formula_name);
81: hr_utility.set_location('Leaving ff_formula_webui_pkg.generate_unique_formula_name',30);
82: end if;
83: --
84: p_formula_name := l_tmp_name;
85: --

Line 109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);

105: --
106: begin
107: --
108: if g_debug then
109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);
110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);

Line 110: hr_utility.trace('p_formula_name: '||p_formula_name);

106: begin
107: --
108: if g_debug then
109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);
110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));

Line 111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));

107: --
108: if g_debug then
109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);
110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));
115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));

Line 112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

108: if g_debug then
109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);
110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));
115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));
116: end if;

Line 113: hr_utility.trace('p_legislation_code: '||p_legislation_code);

109: hr_utility.set_location('Entering ff_formula_webui_pkg.validate_formula_name',10);
110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));
115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));
116: end if;
117: --

Line 114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));

110: hr_utility.trace('p_formula_name: '||p_formula_name);
111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));
115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));
116: end if;
117: --
118: l_formula_name := p_formula_name;

Line 115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));

111: hr_utility.trace('p_formula_type_id: '||to_char(p_formula_type_id));
112: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
113: hr_utility.trace('p_legislation_code: '||p_legislation_code);
114: hr_utility.trace('p_effective_start_date: '||fnd_date.date_to_canonical(p_effective_start_date));
115: hr_utility.trace('p_effective_end_date: '||fnd_date.date_to_canonical(p_effective_end_date));
116: end if;
117: --
118: l_formula_name := p_formula_name;
119: l_formula_type_id := p_formula_type_id;

Line 142: hr_utility.set_location('Leaving ff_formula_webui_pkg.validate_formula_name',20);

138: p_formula_name := l_formula_name;
139: p_effective_end_date := l_effective_end_date;
140: --
141: if g_debug then
142: hr_utility.set_location('Leaving ff_formula_webui_pkg.validate_formula_name',20);
143: end if;
144: --
145: -- Get the return status and disable multi-messaging
146: p_return_status := hr_multi_message.get_return_status_disable;

Line 179: hr_utility.set_location('Entering ff_formula_webui_pkg.insert_formula',10);

175: --
176: begin
177: --
178: if g_debug then
179: hr_utility.set_location('Entering ff_formula_webui_pkg.insert_formula',10);
180: end if;
181: --
182: -- Enable multi-messaging
183: hr_multi_message.enable_message_list;

Line 203: hr_utility.set_location('Leaving ff_formula_webui_pkg.insert_formula',20);

199: x_last_update_date => p_last_update_date
200: );
201: --
202: if g_debug then
203: hr_utility.set_location('Leaving ff_formula_webui_pkg.insert_formula',20);
204: end if;
205: --
206: -- Get the return status and disable multi-messaging
207: p_return_status := hr_multi_message.get_return_status_disable;

Line 240: hr_utility.set_location('Entering ff_formula_webui_pkg.update_formula',10);

236: --
237: begin
238: --
239: if g_debug then
240: hr_utility.set_location('Entering ff_formula_webui_pkg.update_formula',10);
241: end if;
242: --
243: -- Enable multi-messaging
244: hr_multi_message.enable_message_list;

Line 263: hr_utility.set_location('Leaving ff_formula_webui_pkg.update_formula',20);

259: x_last_update_date => p_last_update_date
260: );
261: --
262: if g_debug then
263: hr_utility.set_location('Leaving ff_formula_webui_pkg.update_formula',20);
264: end if;
265: --
266: -- Get the return status and disable multi-messaging
267: p_return_status := hr_multi_message.get_return_status_disable;

Line 293: hr_utility.set_location('Entering ff_formula_webui_pkg.delete_formula',10);

289: is
290: begin
291: --
292: if g_debug then
293: hr_utility.set_location('Entering ff_formula_webui_pkg.delete_formula',10);
294: end if;
295: --
296: -- Enable multi-messaging
297: hr_multi_message.enable_message_list;

Line 309: hr_utility.set_location('Leaving ff_formula_webui_pkg.delete_formula',20);

305: x_effective_date => p_effective_date
306: );
307: --
308: if g_debug then
309: hr_utility.set_location('Leaving ff_formula_webui_pkg.delete_formula',20);
310: end if;
311: --
312: -- Get the return status and disable multi-messaging
313: p_return_status := hr_multi_message.get_return_status_disable;

Line 335: hr_utility.set_location('Entering ff_formula_webui_pkg.lock_formula',10);

331: is
332: begin
333: --
334: if g_debug then
335: hr_utility.set_location('Entering ff_formula_webui_pkg.lock_formula',10);
336: end if;
337: --
338: -- Enable multi-messaging
339: hr_multi_message.enable_message_list;

Line 347: hr_utility.set_location('Leaving ff_formula_webui_pkg.lock_formula',20);

343: x_last_update_date => p_last_update_date
344: );
345: --
346: if g_debug then
347: hr_utility.set_location('Leaving ff_formula_webui_pkg.lock_formula',20);
348: end if;
349: --
350: -- Get the return status and disable multi-messaging
351: p_return_status := hr_multi_message.get_return_status_disable;

Line 380: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula',10);

376: --
377: begin
378: --
379: if g_debug then
380: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula',10);
381: end if;
382:
383: --
384: -- Bug 11849712 Test if online patching is in progress, if so, block execution

Line 412: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');

408: --
409: if l_retval = 1 then
410: --
411: -- Timeout error
412: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
413: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
414: hr_utility.raise_error;
415: --
416: elsif l_retval = 2 then

Line 413: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);

409: if l_retval = 1 then
410: --
411: -- Timeout error
412: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
413: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
414: hr_utility.raise_error;
415: --
416: elsif l_retval = 2 then
417: --

Line 414: hr_utility.raise_error;

410: --
411: -- Timeout error
412: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
413: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
414: hr_utility.raise_error;
415: --
416: elsif l_retval = 2 then
417: --
418: -- No transaction manager error

Line 419: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');

415: --
416: elsif l_retval = 2 then
417: --
418: -- No transaction manager error
419: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
420: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
421: hr_utility.raise_error;
422: --
423: elsif l_retval = 3 then

Line 420: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);

416: elsif l_retval = 2 then
417: --
418: -- No transaction manager error
419: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
420: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
421: hr_utility.raise_error;
422: --
423: elsif l_retval = 3 then
424: --

Line 421: hr_utility.raise_error;

417: --
418: -- No transaction manager error
419: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
420: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
421: hr_utility.raise_error;
422: --
423: elsif l_retval = 3 then
424: --
425: -- Generic error

Line 426: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');

422: --
423: elsif l_retval = 3 then
424: --
425: -- Generic error
426: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
427: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
428: hr_utility.raise_error;
429: --
430: end if;

Line 427: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);

423: elsif l_retval = 3 then
424: --
425: -- Generic error
426: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
427: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
428: hr_utility.raise_error;
429: --
430: end if;
431: elsif l_outcome = 'SUCCESS' then

Line 428: hr_utility.raise_error;

424: --
425: -- Generic error
426: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
427: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
428: hr_utility.raise_error;
429: --
430: end if;
431: elsif l_outcome = 'SUCCESS' then
432: -- Formula compilation was successful

Line 441: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula',20);

437: p_message := l_message;
438: end if;
439: --
440: if g_debug then
441: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula',20);
442: end if;
443: --
444: exception
445: --

Line 533: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula_autonomously',10);

529: --
530: begin
531: --
532: if g_debug then
533: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula_autonomously',10);
534: end if;
535:
536: --
537: -- Bug 11849712 Test if online patching is in progress, if so, block execution

Line 587: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula_autonomously',20);

583: p_effective_end_date => p_effective_end_date
584: );
585: --
586: if g_debug then
587: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula_autonomously',20);
588: end if;
589: --
590: -- Get the return status and disable multi-messaging
591: p_return_status := hr_multi_message.get_return_status_disable;

Line 738: hr_utility.set_location('Entering ff_formula_webui_pkg.run_formula',10);

734: --
735: begin
736: --
737: if g_debug then
738: hr_utility.set_location('Entering ff_formula_webui_pkg.run_formula',10);
739: end if;
740: --
741: -- Enable multi-messaging
742: hr_multi_message.enable_message_list;

Line 815: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

811: elsif upper(v_inputs(i).name) = upper(p_input_name30) then
812: v_inputs(i).value := p_input_value30;
813: else
814: -- Input name not recognized
815: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
816: hr_utility.set_message_token('PROCEDURE',
817: 'FF_FORMULA_WEBUI_PKG.run_formula');
818: hr_utility.set_message_token('STEP','10');
819: if hr_multi_message.exception_add then

Line 816: hr_utility.set_message_token('PROCEDURE',

812: v_inputs(i).value := p_input_value30;
813: else
814: -- Input name not recognized
815: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
816: hr_utility.set_message_token('PROCEDURE',
817: 'FF_FORMULA_WEBUI_PKG.run_formula');
818: hr_utility.set_message_token('STEP','10');
819: if hr_multi_message.exception_add then
820: hr_utility.raise_error;

Line 818: hr_utility.set_message_token('STEP','10');

814: -- Input name not recognized
815: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
816: hr_utility.set_message_token('PROCEDURE',
817: 'FF_FORMULA_WEBUI_PKG.run_formula');
818: hr_utility.set_message_token('STEP','10');
819: if hr_multi_message.exception_add then
820: hr_utility.raise_error;
821: end if;
822: end if;

Line 820: hr_utility.raise_error;

816: hr_utility.set_message_token('PROCEDURE',
817: 'FF_FORMULA_WEBUI_PKG.run_formula');
818: hr_utility.set_message_token('STEP','10');
819: if hr_multi_message.exception_add then
820: hr_utility.raise_error;
821: end if;
822: end if;
823: --
824: end loop;

Line 895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

891: elsif v_output_name = upper(p_output_name30) then
892: p_output_value30 := v_outputs(i).value;
893: else
894: -- Output name not recognized
895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
896: hr_utility.set_message_token('PROCEDURE',
897: 'FF_FORMULA_WEBUI_PKG.run_formula');
898: hr_utility.set_message_token('STEP','20');
899: if hr_multi_message.exception_add then

Line 896: hr_utility.set_message_token('PROCEDURE',

892: p_output_value30 := v_outputs(i).value;
893: else
894: -- Output name not recognized
895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
896: hr_utility.set_message_token('PROCEDURE',
897: 'FF_FORMULA_WEBUI_PKG.run_formula');
898: hr_utility.set_message_token('STEP','20');
899: if hr_multi_message.exception_add then
900: hr_utility.raise_error;

Line 898: hr_utility.set_message_token('STEP','20');

894: -- Output name not recognized
895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
896: hr_utility.set_message_token('PROCEDURE',
897: 'FF_FORMULA_WEBUI_PKG.run_formula');
898: hr_utility.set_message_token('STEP','20');
899: if hr_multi_message.exception_add then
900: hr_utility.raise_error;
901: end if;
902: end if;

Line 900: hr_utility.raise_error;

896: hr_utility.set_message_token('PROCEDURE',
897: 'FF_FORMULA_WEBUI_PKG.run_formula');
898: hr_utility.set_message_token('STEP','20');
899: if hr_multi_message.exception_add then
900: hr_utility.raise_error;
901: end if;
902: end if;
903: --
904: end loop;

Line 907: hr_utility.set_location('Leaving ff_formula_webui_pkg.run_formula',20);

903: --
904: end loop;
905: --
906: if g_debug then
907: hr_utility.set_location('Leaving ff_formula_webui_pkg.run_formula',20);
908: end if;
909: --
910: -- Get the return status and disable multi-messaging
911: p_return_status := hr_multi_message.get_return_status_disable;

Line 942: hr_utility.set_location('Entering ff_formula_webui_pkg.isFormulaCompiled',10);

938: --
939: begin
940: --
941: if g_debug then
942: hr_utility.set_location('Entering ff_formula_webui_pkg.isFormulaCompiled',10);
943: end if;
944: --
945: open c_formula_compiled_info;
946: fetch c_formula_compiled_info into l_formula_is_compiled;

Line 951: hr_utility.set_location('Leaving ff_formula_webui_pkg.isFormulaCompiled',20);

947: close c_formula_compiled_info;
948: --
949: --
950: if g_debug then
951: hr_utility.set_location('Leaving ff_formula_webui_pkg.isFormulaCompiled',20);
952: end if;
953: return l_formula_is_compiled;
954: end isFormulaCompiled;
955: --

Line 980: hr_utility.set_location('Entering ff_formula_webui_pkg.list_function_params',10);

976: --
977: begin
978: --
979: if g_debug then
980: hr_utility.set_location('Entering ff_formula_webui_pkg.list_function_params',10);
981: end if;
982: --
983: open c_fn_name(p_function_id);
984: fetch c_fn_name into l_param_list;

Line 999: hr_utility.trace('l_param_list: '||l_param_list);

995: --
996: l_param_list := l_param_list || ')';
997: --
998: if g_debug then
999: hr_utility.trace('l_param_list: '||l_param_list);
1000: hr_utility.set_location('Leaving ff_formula_webui_pkg.list_function_params',20);
1001: end if;
1002: --
1003: return l_param_list;

Line 1000: hr_utility.set_location('Leaving ff_formula_webui_pkg.list_function_params',20);

996: l_param_list := l_param_list || ')';
997: --
998: if g_debug then
999: hr_utility.trace('l_param_list: '||l_param_list);
1000: hr_utility.set_location('Leaving ff_formula_webui_pkg.list_function_params',20);
1001: end if;
1002: --
1003: return l_param_list;
1004: --

Line 1018: hr_utility.set_location('Entering ff_formula_webui_pkg.submit_singlecompile',10);

1014: --
1015: begin
1016: --
1017: if g_debug then
1018: hr_utility.set_location('Entering ff_formula_webui_pkg.submit_singlecompile',10);
1019: end if;
1020:
1021: --
1022: -- Bug 13435428 Test if online patching is in progress, if so, block execution

Line 1026: hr_utility.trace('ff_formula_webui_pkg.submit_singlecompile patch in progress , cant submit formula compile');

1022: -- Bug 13435428 Test if online patching is in progress, if so, block execution
1023: --
1024: if ad_zd.get_edition('PATCH') is not null then
1025: -- an online patch is in progress, return error
1026: hr_utility.trace('ff_formula_webui_pkg.submit_singlecompile patch in progress , cant submit formula compile');
1027: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
1028: raise_application_error ('-20000', fnd_message.get);
1029: end if;
1030: --

Line 1038: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Request Id :'||l_request_id, 25);

1034: ,argument1 => p_formula_type
1035: ,argument2 => p_formula_name);
1036:
1037: if g_debug then
1038: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Request Id :'||l_request_id, 25);
1039: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 30);
1040: end if;
1041: return l_request_id;
1042:

Line 1039: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 30);

1035: ,argument2 => p_formula_name);
1036:
1037: if g_debug then
1038: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Request Id :'||l_request_id, 25);
1039: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 30);
1040: end if;
1041: return l_request_id;
1042:
1043: exception

Line 1045: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Entering exception when others ', 80);

1041: return l_request_id;
1042:
1043: exception
1044: when others then
1045: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Entering exception when others ', 80);
1046: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 90);
1047: raise;
1048:
1049: end submit_singlecompile;

Line 1046: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 90);

1042:
1043: exception
1044: when others then
1045: hr_utility.set_location('ff_formula_webui_pkg.submit_singlecompile. Entering exception when others ', 80);
1046: hr_utility.set_location('Leaving: ff_formula_webui_pkg.submit_singlecompile', 90);
1047: raise;
1048:
1049: end submit_singlecompile;
1050: --