1: PACKAGE BODY per_no_sickleavemonitoring AS
2: /* $Header: pernoslmr.pkb 120.2.12020000.1 2012/07/18 07:28:38 asudhaka noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: EOL VARCHAR2(5) := fnd_global.newline();
5: -------------------------------------------------------------------------------+
6: /* Function used to default User table value in Org DFF */
7: FUNCTION get_default_followup_days(p_date IN DATE
297:
298: EXCEPTION
299: WHEN others THEN
300: IF g_debug THEN
301: hr_utility.trace('Error in process_absence_details: '||sqlerrm);
302: END IF;
303: END process_absence_details;
304:
305: --#FUNC2
340:
341: ------------------------------------------------------------------------------+
342: BEGIN
343: IF g_debug THEN
344: hr_utility.set_location(' Entering Procedure GENERATE',1);
345: hr_utility.trace('p_employer : '||p_employer);
346: hr_utility.trace('p_from : '||p_from);
347: hr_utility.trace('p_to : '||p_to);
348: hr_utility.trace('p_template_name: '||p_template_name);
341: ------------------------------------------------------------------------------+
342: BEGIN
343: IF g_debug THEN
344: hr_utility.set_location(' Entering Procedure GENERATE',1);
345: hr_utility.trace('p_employer : '||p_employer);
346: hr_utility.trace('p_from : '||p_from);
347: hr_utility.trace('p_to : '||p_to);
348: hr_utility.trace('p_template_name: '||p_template_name);
349: END IF;
342: BEGIN
343: IF g_debug THEN
344: hr_utility.set_location(' Entering Procedure GENERATE',1);
345: hr_utility.trace('p_employer : '||p_employer);
346: hr_utility.trace('p_from : '||p_from);
347: hr_utility.trace('p_to : '||p_to);
348: hr_utility.trace('p_template_name: '||p_template_name);
349: END IF;
350:
343: IF g_debug THEN
344: hr_utility.set_location(' Entering Procedure GENERATE',1);
345: hr_utility.trace('p_employer : '||p_employer);
346: hr_utility.trace('p_from : '||p_from);
347: hr_utility.trace('p_to : '||p_to);
348: hr_utility.trace('p_template_name: '||p_template_name);
349: END IF;
350:
351:
344: hr_utility.set_location(' Entering Procedure GENERATE',1);
345: hr_utility.trace('p_employer : '||p_employer);
346: hr_utility.trace('p_from : '||p_from);
347: hr_utility.trace('p_to : '||p_to);
348: hr_utility.trace('p_template_name: '||p_template_name);
349: END IF;
350:
351:
352: l_action_from := fnd_date.canonical_to_date(p_from);
455: p_xml := l_xml;
456: dbms_lob.freeTemporary(l_xml);
457:
458: IF g_debug THEN
459: hr_utility.set_location(' Leaving Procedure GENERATE',2);
460: END IF;
461: EXCEPTION
462: WHEN others THEN
463: IF g_debug THEN
460: END IF;
461: EXCEPTION
462: WHEN others THEN
463: IF g_debug THEN
464: hr_utility.set_location('Error raised in GENERATE ',9);
465: hr_utility.trace('Error: '||sqlerrm);
466: END IF;
467: RAISE;
468: END generate;
461: EXCEPTION
462: WHEN others THEN
463: IF g_debug THEN
464: hr_utility.set_location('Error raised in GENERATE ',9);
465: hr_utility.trace('Error: '||sqlerrm);
466: END IF;
467: RAISE;
468: END generate;
469: