332: close c_next_placement_st_date;
333:
334: if l_next_placement_st_date is not null then
335: if (l_next_placement_st_date - l_step_end_date) > 1 then
336: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');
337: fnd_message.set_token('END_DATE',l_step_end_date);
338: fnd_message.raise_error;
339: end if;
340: else
333:
334: if l_next_placement_st_date is not null then
335: if (l_next_placement_st_date - l_step_end_date) > 1 then
336: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');
337: fnd_message.set_token('END_DATE',l_step_end_date);
338: fnd_message.raise_error;
339: end if;
340: else
341: update per_spinal_point_placements_f
334: if l_next_placement_st_date is not null then
335: if (l_next_placement_st_date - l_step_end_date) > 1 then
336: fnd_message.set_name('PER', 'HR_50439_SP_GAP_ERROR');
337: fnd_message.set_token('END_DATE',l_step_end_date);
338: fnd_message.raise_error;
339: end if;
340: else
341: update per_spinal_point_placements_f
342: set effective_end_date = l_step_end_date