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.2 2006/05/26 16:08:42 swinton noship $ */
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: l_retval := fnd_transaction.synchronous(
384: timeout => l_timeout,

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

399: --
400: if l_retval = 1 then
401: --
402: -- Timeout error
403: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
404: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
405: hr_utility.raise_error;
406: --
407: elsif l_retval = 2 then

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

400: if l_retval = 1 then
401: --
402: -- Timeout error
403: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
404: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
405: hr_utility.raise_error;
406: --
407: elsif l_retval = 2 then
408: --

Line 405: hr_utility.raise_error;

401: --
402: -- Timeout error
403: hr_utility.set_message(802, 'FF_WEB_TX_MGR_TIMEOUT_ERROR');
404: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
405: hr_utility.raise_error;
406: --
407: elsif l_retval = 2 then
408: --
409: -- No transaction manager error

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

406: --
407: elsif l_retval = 2 then
408: --
409: -- No transaction manager error
410: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
411: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
412: hr_utility.raise_error;
413: --
414: elsif l_retval = 3 then

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

407: elsif l_retval = 2 then
408: --
409: -- No transaction manager error
410: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
411: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
412: hr_utility.raise_error;
413: --
414: elsif l_retval = 3 then
415: --

Line 412: hr_utility.raise_error;

408: --
409: -- No transaction manager error
410: hr_utility.set_message(802, 'FF_WEB_NO_TX_MGR_ERROR');
411: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
412: hr_utility.raise_error;
413: --
414: elsif l_retval = 3 then
415: --
416: -- Generic error

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

413: --
414: elsif l_retval = 3 then
415: --
416: -- Generic error
417: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
418: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
419: hr_utility.raise_error;
420: --
421: end if;

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

414: elsif l_retval = 3 then
415: --
416: -- Generic error
417: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
418: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
419: hr_utility.raise_error;
420: --
421: end if;
422: elsif l_outcome = 'SUCCESS' then

Line 419: hr_utility.raise_error;

415: --
416: -- Generic error
417: hr_utility.set_message(802, 'FF_WEB_GENERIC_TX_MGR_ERROR');
418: hr_utility.set_message_token(802, 'ERROR_MESSAGE', l_message);
419: hr_utility.raise_error;
420: --
421: end if;
422: elsif l_outcome = 'SUCCESS' then
423: -- Formula compilation was successful

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

428: p_message := l_message;
429: end if;
430: --
431: if g_debug then
432: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula',20);
433: end if;
434: --
435: exception
436: --

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

520: --
521: begin
522: --
523: if g_debug then
524: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula_autonomously',10);
525: end if;
526: --
527: -- Enable multi-messaging
528: hr_multi_message.enable_message_list;

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

564: p_effective_end_date => p_effective_end_date
565: );
566: --
567: if g_debug then
568: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula_autonomously',20);
569: end if;
570: --
571: -- Get the return status and disable multi-messaging
572: p_return_status := hr_multi_message.get_return_status_disable;

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

715: --
716: begin
717: --
718: if g_debug then
719: hr_utility.set_location('Entering ff_formula_webui_pkg.run_formula',10);
720: end if;
721: --
722: -- Enable multi-messaging
723: hr_multi_message.enable_message_list;

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

792: elsif upper(v_inputs(i).name) = upper(p_input_name30) then
793: v_inputs(i).value := p_input_value30;
794: else
795: -- Input name not recognized
796: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
797: hr_utility.set_message_token('PROCEDURE',
798: 'FF_FORMULA_WEBUI_PKG.run_formula');
799: hr_utility.set_message_token('STEP','10');
800: if hr_multi_message.exception_add then

Line 797: hr_utility.set_message_token('PROCEDURE',

793: v_inputs(i).value := p_input_value30;
794: else
795: -- Input name not recognized
796: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
797: hr_utility.set_message_token('PROCEDURE',
798: 'FF_FORMULA_WEBUI_PKG.run_formula');
799: hr_utility.set_message_token('STEP','10');
800: if hr_multi_message.exception_add then
801: hr_utility.raise_error;

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

795: -- Input name not recognized
796: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
797: hr_utility.set_message_token('PROCEDURE',
798: 'FF_FORMULA_WEBUI_PKG.run_formula');
799: hr_utility.set_message_token('STEP','10');
800: if hr_multi_message.exception_add then
801: hr_utility.raise_error;
802: end if;
803: end if;

Line 801: hr_utility.raise_error;

797: hr_utility.set_message_token('PROCEDURE',
798: 'FF_FORMULA_WEBUI_PKG.run_formula');
799: hr_utility.set_message_token('STEP','10');
800: if hr_multi_message.exception_add then
801: hr_utility.raise_error;
802: end if;
803: end if;
804: --
805: end loop;

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

872: elsif v_output_name = upper(p_output_name30) then
873: p_output_value30 := v_outputs(i).value;
874: else
875: -- Output name not recognized
876: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
877: hr_utility.set_message_token('PROCEDURE',
878: 'FF_FORMULA_WEBUI_PKG.run_formula');
879: hr_utility.set_message_token('STEP','20');
880: if hr_multi_message.exception_add then

Line 877: hr_utility.set_message_token('PROCEDURE',

873: p_output_value30 := v_outputs(i).value;
874: else
875: -- Output name not recognized
876: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
877: hr_utility.set_message_token('PROCEDURE',
878: 'FF_FORMULA_WEBUI_PKG.run_formula');
879: hr_utility.set_message_token('STEP','20');
880: if hr_multi_message.exception_add then
881: hr_utility.raise_error;

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

875: -- Output name not recognized
876: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
877: hr_utility.set_message_token('PROCEDURE',
878: 'FF_FORMULA_WEBUI_PKG.run_formula');
879: hr_utility.set_message_token('STEP','20');
880: if hr_multi_message.exception_add then
881: hr_utility.raise_error;
882: end if;
883: end if;

Line 881: hr_utility.raise_error;

877: hr_utility.set_message_token('PROCEDURE',
878: 'FF_FORMULA_WEBUI_PKG.run_formula');
879: hr_utility.set_message_token('STEP','20');
880: if hr_multi_message.exception_add then
881: hr_utility.raise_error;
882: end if;
883: end if;
884: --
885: end loop;

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

884: --
885: end loop;
886: --
887: if g_debug then
888: hr_utility.set_location('Leaving ff_formula_webui_pkg.run_formula',20);
889: end if;
890: --
891: -- Get the return status and disable multi-messaging
892: p_return_status := hr_multi_message.get_return_status_disable;

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

919: --
920: begin
921: --
922: if g_debug then
923: hr_utility.set_location('Entering ff_formula_webui_pkg.isFormulaCompiled',10);
924: end if;
925: --
926: open c_formula_compiled_info;
927: fetch c_formula_compiled_info into l_formula_is_compiled;

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

928: close c_formula_compiled_info;
929: --
930: --
931: if g_debug then
932: hr_utility.set_location('Leaving ff_formula_webui_pkg.isFormulaCompiled',20);
933: end if;
934: return l_formula_is_compiled;
935: end isFormulaCompiled;
936: --

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

957: --
958: begin
959: --
960: if g_debug then
961: hr_utility.set_location('Entering ff_formula_webui_pkg.list_function_params',10);
962: end if;
963: --
964: open c_fn_name(p_function_id);
965: fetch c_fn_name into l_param_list;

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

976: --
977: l_param_list := l_param_list || ')';
978: --
979: if g_debug then
980: hr_utility.trace('l_param_list: '||l_param_list);
981: hr_utility.set_location('Leaving ff_formula_webui_pkg.list_function_params',20);
982: end if;
983: --
984: return l_param_list;

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

977: l_param_list := l_param_list || ')';
978: --
979: if g_debug then
980: hr_utility.trace('l_param_list: '||l_param_list);
981: hr_utility.set_location('Leaving ff_formula_webui_pkg.list_function_params',20);
982: end if;
983: --
984: return l_param_list;
985: --