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:
235: and record_version_number = p_record_version_number;
236:
237: if (sql%notfound) then
238: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
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'
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;
310: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
311:
312: if (sql%notfound) then
313: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
314: FND_MSG_PUB.Add;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: end if;
317:
318: EXCEPTION
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: