DBA Data[Home] [Help]

APPS.FF_FORMULA_WEBUI_PKG dependencies on FF_FORMULA_WEBUI_PKG

Line 1: package body FF_FORMULA_WEBUI_PKG as

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

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 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 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 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 798: 'FF_FORMULA_WEBUI_PKG.run_formula');

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;
802: end if;

Line 878: 'FF_FORMULA_WEBUI_PKG.run_formula');

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;
882: end if;

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

Line 988: end FF_FORMULA_WEBUI_PKG;

984: return l_param_list;
985: --
986: end list_function_params;
987: --
988: end FF_FORMULA_WEBUI_PKG;