958: p_start_date => x_date_start,
959: p_end_date => x_date_end);
960: --
961: Exception
962: When hr_api.check_integrity_violated Then
963: -- A check constraint has been violated
964: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
965: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
966: When hr_api.parent_integrity_violated Then
961: Exception
962: When hr_api.check_integrity_violated Then
963: -- A check constraint has been violated
964: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
965: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
966: When hr_api.parent_integrity_violated Then
967: -- Parent integrity has been violated
968: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
969: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
962: When hr_api.check_integrity_violated Then
963: -- A check constraint has been violated
964: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
965: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
966: When hr_api.parent_integrity_violated Then
967: -- Parent integrity has been violated
968: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
969: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
970: When hr_api.unique_integrity_violated Then
965: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
966: When hr_api.parent_integrity_violated Then
967: -- Parent integrity has been violated
968: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
969: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
970: When hr_api.unique_integrity_violated Then
971: -- Unique integrity has been violated
972: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
973: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
966: When hr_api.parent_integrity_violated Then
967: -- Parent integrity has been violated
968: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
969: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
970: When hr_api.unique_integrity_violated Then
971: -- Unique integrity has been violated
972: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
973: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
974: When Others Then
969: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
970: When hr_api.unique_integrity_violated Then
971: -- Unique integrity has been violated
972: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
973: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
974: When Others Then
975: Raise;
976: END Insert_Row;
977:
1692: p_start_date => x_date_start,
1693: p_end_date => x_date_end);
1694: --
1695: Exception
1696: When hr_api.check_integrity_violated Then
1697: -- A check constraint has been violated
1698: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1699: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1700: When hr_api.parent_integrity_violated Then
1695: Exception
1696: When hr_api.check_integrity_violated Then
1697: -- A check constraint has been violated
1698: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1699: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1700: When hr_api.parent_integrity_violated Then
1701: -- Parent integrity has been violated
1702: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1703: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1696: When hr_api.check_integrity_violated Then
1697: -- A check constraint has been violated
1698: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1699: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1700: When hr_api.parent_integrity_violated Then
1701: -- Parent integrity has been violated
1702: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1703: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1704: When hr_api.unique_integrity_violated Then
1699: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1700: When hr_api.parent_integrity_violated Then
1701: -- Parent integrity has been violated
1702: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1703: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1704: When hr_api.unique_integrity_violated Then
1705: -- Unique integrity has been violated
1706: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1707: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1700: When hr_api.parent_integrity_violated Then
1701: -- Parent integrity has been violated
1702: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1703: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1704: When hr_api.unique_integrity_violated Then
1705: -- Unique integrity has been violated
1706: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1707: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1708: When Others Then
1703: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1704: When hr_api.unique_integrity_violated Then
1705: -- Unique integrity has been violated
1706: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1707: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1708: When Others Then
1709: Raise;
1710: END Update_Row;
1711: