APPS.IGW_CREATE_PROPOSAL_TBH dependencies on FND_API

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: X_LAST_UPDATE_DATE DATE;
58: X_LAST_UPDATED_BY NUMBER;
59: X_LAST_UPDATE_LOGIN NUMBER;
60: begin
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62: X_LAST_UPDATE_DATE := SYSDATE;
63: if(X_MODE = 'I') then
64: X_LAST_UPDATED_BY := 1;
65: X_LAST_UPDATE_LOGIN := 0;

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
204: end INSERT_ROW;
205:

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: WHERE proposal_id = p_proposal_id;
222:
223: begin
224:
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: IF l_row_id IS NULL THEN
228: OPEN get_row_id;
229: FETCH get_row_id INTO l_row_id;

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
248:
249: ---------------------------------------------------------------------------------

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: WHERE proposal_id = x_proposal_id;
272:
273: begin
274:
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277: IF l_row_id IS NULL THEN
278: OPEN get_row_id;
279: FETCH get_row_id INTO l_row_id;

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

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
319: WHEN OTHERS THEN

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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: