DBA Data[Home] [Help]

APPS.PER_NO_SICKLEAVEMONITORING dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

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

Line 301: hr_utility.trace('Error in process_absence_details: '||sqlerrm);

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

Line 344: hr_utility.set_location(' Entering Procedure GENERATE',1);

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);

Line 345: hr_utility.trace('p_employer : '||p_employer);

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;

Line 346: hr_utility.trace('p_from : '||p_from);

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:

Line 347: hr_utility.trace('p_to : '||p_to);

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:

Line 348: hr_utility.trace('p_template_name: '||p_template_name);

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);

Line 459: hr_utility.set_location(' Leaving Procedure GENERATE',2);

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

Line 464: hr_utility.set_location('Error raised in GENERATE ',9);

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;

Line 465: hr_utility.trace('Error: '||sqlerrm);

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: