1: package body IGW_CREATE_PROPOSAL_TBH as
2: /* $Header: igwtcprb.pls 115.4 2002/11/14 18:44:11 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_CREATE_PROPOSAL_TBH'
200: ,p_procedure_name => 'INSERT_ROW' );
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: RAISE;
203:
239: FND_MSG_PUB.Add;
240: end if;
241: EXCEPTION
242: WHEN OTHERS THEN
243: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_CREATE_PROPOSAL_TBH'
244: ,p_procedure_name => 'DELETE_ROW' );
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246: RAISE;
247: end DELETE_ROW;
316: end if;
317:
318: EXCEPTION
319: WHEN OTHERS THEN
320: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_CREATE_PROPOSAL_TBH'
321: ,p_procedure_name => 'UPDATE_SPONSOR_ACTION' );
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: RAISE;
324:
325: end UPDATE_SPONSOR_ACTION;
326:
327: ---------------------------------------------------------------------------------
328:
329: end IGW_CREATE_PROPOSAL_TBH;