1: package body IGW_PROP_USERS_TBH as
2: /* $Header: igwtprub.pls 115.4 2002/11/15 00:46:34 ashkumar ship $*/
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid out NOCOPY VARCHAR2,
77: close c;
78:
79: EXCEPTION
80: when others then
81: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
82: p_procedure_name => 'INSERT_ROW',
83: p_error_text => SUBSTRB(SQLERRM, 1, 240));
84: x_return_status := fnd_api.g_ret_sts_unexp_error;
85: raise;
146:
147:
148: EXCEPTION
149: when others then
150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
151: p_procedure_name => 'UPDATE_ROW',
152: p_error_text => SUBSTRB(SQLERRM, 1, 240));
153: x_return_status := fnd_api.g_ret_sts_unexp_error;
154: raise;
177:
178:
179: EXCEPTION
180: when others then
181: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
182: p_procedure_name => 'DELETE_ROW',
183: p_error_text => SUBSTRB(SQLERRM, 1, 240));
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: raise;
295: return;
296: end LOCK_ROW;
297: */
298:
299: END IGW_PROP_USERS_TBH;