1: package body IGW_PROP_PERSON_QUESTIONS_TBH as
2: /* $Header: igwtppqb.pls 115.5 2002/11/15 00:42:17 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid out NOCOPY VARCHAR2,
87: close c;
88:
89: EXCEPTION
90: when others then
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
92: p_procedure_name => 'INSERT_ROW',
93: p_error_text => SUBSTRB(SQLERRM, 1, 240));
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: raise;
162:
163:
164: EXCEPTION
165: when others then
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
167: p_procedure_name => 'UPDATE_ROW',
168: p_error_text => SUBSTRB(SQLERRM, 1, 240));
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: raise;
193:
194:
195: EXCEPTION
196: when others then
197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
198: p_procedure_name => 'DELETE_ROW',
199: p_error_text => SUBSTRB(SQLERRM, 1, 240));
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: raise;
201: raise;
202:
203: END DELETE_ROW;
204:
205: END IGW_PROP_PERSON_QUESTIONS_TBH;