950: Close c_old_rec;
951: --
952: -- The primary key is invalid therefore we must error
953: --
954: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
955: fnd_message.raise_error;
956: End If;
957: Close c_old_rec;
958: --
951: --
952: -- The primary key is invalid therefore we must error
953: --
954: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
955: fnd_message.raise_error;
956: End If;
957: Close c_old_rec;
958: --
959: -- Enforce datetrack mode to 'CORRECTION' if certain columns are updated.
1003: --
1004: -- Update not allowed if element has already been date-effectively
1005: -- updated.
1006: --
1007: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1008: fnd_message.raise_error;
1009: End If;
1010: --
1011: If nvl(p_datetrack_update_mode,hr_api.g_correction)
1004: -- Update not allowed if element has already been date-effectively
1005: -- updated.
1006: --
1007: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1008: fnd_message.raise_error;
1009: End If;
1010: --
1011: If nvl(p_datetrack_update_mode,hr_api.g_correction)
1012: <> hr_api.g_correction Then