DBA Data[Home] [Help]

APPS.PER_GB_PENSRV_SVPN dependencies on FND_DATE

Line 391: fnd_date.date_to_canonical(l_effective_start_date)

387: -- want to rollback the update to the assignment in the event that
388: -- the FTE processing fails for some reason.
389: hr_utility.trace('Inside '||gv_package_name||'.AUTO_CALC_FTE'||
390: l_assignment_id||' on '||
391: fnd_date.date_to_canonical(l_effective_start_date)
392: );
393: FOR this_abvm IN csr_abvm_uoms_to_process
394: (p_business_group_id => l_business_group_id
395: ,p_legislation_code => l_legislation_code

Line 474: fnd_date.date_to_canonical(l_effective_start_date)

470:
471: IF g_debug THEN -- BUG: 5287675
472: hr_utility.trace('Leaving '||gv_package_name||'.AUTO_CALC_FTE'||' for '||
473: l_assignment_id||' on '||
474: fnd_date.date_to_canonical(l_effective_start_date)
475: );
476: END IF;
477: END IF; -- IF (l_assignment_id IS NOT NULL AND l_assignment_type = 'E')
478:

Line 484: fnd_date.date_to_canonical(l_effective_start_date)

480: EXCEPTION
481: WHEN OTHERS THEN
482: hr_utility.trace('Error in '||gv_package_name||'.AUTO_CALC_FTE'||' for '||
483: l_assignment_id||' on '||
484: fnd_date.date_to_canonical(l_effective_start_date)
485: );
486: --fnd_message.RETRIEVE;
487: l_error_message := fnd_message.get;
488: l_error_message := NVL(RTRIM(LTRIM(l_error_message)),'SQLERRM:'||SQLERRM);