196:
197: -- bug no 9248094 starts here
198:
199: if p_date_of_death is not null and trunc(p_date_of_death) > trunc(sysdate) then
200: fnd_message.set_name('PER','PER_289974_TCA_PERSON');
201: fnd_message.set_token('PROCEDURE','per_people11_pkg.insert_row1');
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
197: -- bug no 9248094 starts here
198:
199: if p_date_of_death is not null and trunc(p_date_of_death) > trunc(sysdate) then
200: fnd_message.set_name('PER','PER_289974_TCA_PERSON');
201: fnd_message.set_token('PROCEDURE','per_people11_pkg.insert_row1');
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
205: fnd_message.set_token('ERROR', l_msg);
198:
199: if p_date_of_death is not null and trunc(p_date_of_death) > trunc(sysdate) then
200: fnd_message.set_name('PER','PER_289974_TCA_PERSON');
201: fnd_message.set_token('PROCEDURE','per_people11_pkg.insert_row1');
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
205: fnd_message.set_token('ERROR', l_msg);
206: fnd_message.raise_error;
199: if p_date_of_death is not null and trunc(p_date_of_death) > trunc(sysdate) then
200: fnd_message.set_name('PER','PER_289974_TCA_PERSON');
201: fnd_message.set_token('PROCEDURE','per_people11_pkg.insert_row1');
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
205: fnd_message.set_token('ERROR', l_msg);
206: fnd_message.raise_error;
207: end if;
201: fnd_message.set_token('PROCEDURE','per_people11_pkg.insert_row1');
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
205: fnd_message.set_token('ERROR', l_msg);
206: fnd_message.raise_error;
207: end if;
208:
209: -- bug no 9248094 ends here
202: fnd_message.set_token('STEP','1');
203: l_msg := fnd_message.get_string('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
204: l_msg := replace(l_msg,'&COLUMN',' DATE_OF_DEATH ');
205: fnd_message.set_token('ERROR', l_msg);
206: fnd_message.raise_error;
207: end if;
208:
209: -- bug no 9248094 ends here
210: