120: per_assignments_v8_pkg.delete_record(X_ROWID);
121: end if;
122: --
123:
124: hr_utility.set_location('Enterring:per_assignments_v8_pkg.insert_row',10);
125:
126: INSERT INTO PER_ASSIGNMENTS_F(
127: assignment_id,
128: effective_start_date,
970: if p_start_date > p_effective_start_date
971: then
972: FND_MESSAGE.SET_NAME('PA','PA_ALL_START_DATE_AFTER');
973: FND_MESSAGE.SET_TOKEN('S_DATE',to_char(p_start_date,'DD-MON-YYYY'));
974: HR_UTILITY.RAISE_ERROR;
975: elsif ((p_termination_date is not null)
976: and (p_effective_start_date > p_termination_date))
977: then
978: FND_MESSAGE.SET_NAME('PA','PA_ALL_START_DATE_BEFORE');
977: then
978: FND_MESSAGE.SET_NAME('PA','PA_ALL_START_DATE_BEFORE');
979: FND_MESSAGE.SET_TOKEN('T_DATE',
980: to_char(p_termination_date,'DD-MON-YYYY'));
981: HR_UTILITY.RAISE_ERROR;
982: end if;
983: end;
984: END PER_ASSIGNMENTS_V8_PKG;