202: close csr_rowid;
203: else
204: close csr_rowid;
205: -- booking_id is invalid, raise error
206: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
207: fnd_message.raise_error;
208: end if;
209: p_rowid := l_oldrec.row_id;
210: IF p_comments = hr_api.g_varchar2 THEN
203: else
204: close csr_rowid;
205: -- booking_id is invalid, raise error
206: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
207: fnd_message.raise_error;
208: end if;
209: p_rowid := l_oldrec.row_id;
210: IF p_comments = hr_api.g_varchar2 THEN
211: p_rec.comments := l_oldrec.comments;
419: close csr_rowid;
420: else
421: close csr_rowid;
422: -- booking_id is invalid, raise error
423: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
424: fnd_message.raise_error;
425: end if;
426: --
427: -- Call API
420: else
421: close csr_rowid;
422: -- booking_id is invalid, raise error
423: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
424: fnd_message.raise_error;
425: end if;
426: --
427: -- Call API
428: --