1: package body IGW_PROPOSALS_ALL_TBH as
2: /* $Header: igwtbasb.pls 115.9 2002/11/14 18:50:04 vmedikon ship $ */
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY rowid,
5: X_PROPOSAL_ID in NUMBER,
195: close c;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
200: ,p_procedure_name => 'INSERT_ROW' );
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: RAISE;
203:
358: end if;
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
363: ,p_procedure_name => 'UPDATE_ROW' );
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: RAISE;
366:
402: FND_MSG_PUB.Add;
403: end if;
404: EXCEPTION
405: WHEN OTHERS THEN
406: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
407: ,p_procedure_name => 'DELETE_ROW' );
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409: RAISE;
410: end DELETE_ROW;
533: end if;
534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
538: ,p_procedure_name => 'UPDATE_SPONSOR_ACTION' );
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540: RAISE;
541:
542: end UPDATE_SPONSOR_ACTION;
543:
544: ---------------------------------------------------------------------------------
545:
546: end IGW_PROPOSALS_ALL_TBH;