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.PER_ABSENCE_ATTENDANCES_PKG dependencies on HR_API

Line 440: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.actual_birth_date, 12)) then

436: --
437: /* Bug fix 12850183 start. Added validations for APL duration checks. */
438: if l_maternity.leave_type = 'AB' then
439:
440: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.actual_birth_date, 12)) then
441: hr_utility.set_location ('End date beyond 12 months of birth date:'||l_maternity.actual_birth_date,2);
442: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
443: fnd_message.raise_error;
444: end if;

Line 454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then

450: and l_maternity.due_date between ele1.effective_start_date
451: and ele1.effective_end_date;
452:
453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
457: fnd_message.raise_error;
458: end if;

Line 463: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.placement_date, 12)) then

459:
460: end if; -- End of leave type AB validations
461:
462: if l_maternity.leave_type = 'AA' then
463: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.placement_date, 12)) then
464: hr_utility.set_location ('End date beyond 12 months of placement date:'||l_maternity.placement_date,2);
465: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
466: fnd_message.raise_error;
467: end if;

Line 477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then

473: and l_maternity.due_date between ele1.effective_start_date
474: and ele1.effective_end_date;
475:
476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
480: fnd_message.raise_error;
481: end if;

Line 1066: When hr_api.check_integrity_violated Then

1062: p_start_date => x_date_start,
1063: p_end_date => x_date_end);
1064: --
1065: Exception
1066: When hr_api.check_integrity_violated Then
1067: -- A check constraint has been violated
1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then

Line 1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1065: Exception
1066: When hr_api.check_integrity_violated Then
1067: -- A check constraint has been violated
1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1070: When hr_api.parent_integrity_violated Then

1066: When hr_api.check_integrity_violated Then
1067: -- A check constraint has been violated
1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then

Line 1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1074: When hr_api.unique_integrity_violated Then

1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1078: When Others Then

Line 1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1078: When Others Then
1079: Raise;
1080: END Insert_Row;
1081:

Line 1800: When hr_api.check_integrity_violated Then

1796: p_start_date => x_date_start,
1797: p_end_date => x_date_end);
1798: --
1799: Exception
1800: When hr_api.check_integrity_violated Then
1801: -- A check constraint has been violated
1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then

Line 1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1799: Exception
1800: When hr_api.check_integrity_violated Then
1801: -- A check constraint has been violated
1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1804: When hr_api.parent_integrity_violated Then

1800: When hr_api.check_integrity_violated Then
1801: -- A check constraint has been violated
1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then

Line 1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 1808: When hr_api.unique_integrity_violated Then

1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1812: When Others Then

Line 1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1812: When Others Then
1813: Raise;
1814: END Update_Row;
1815: