APPS.IGW_PROPOSALS_ALL_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_PROPOSALS_ALL_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 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 357: x_return_status := FND_API.G_RET_STS_ERROR;

353:
354: if (sql%notfound) then
355: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
356: FND_MSG_PUB.Add;
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: end if;
359:
360: EXCEPTION
361: WHEN OTHERS THEN

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
367: end UPDATE_ROW;
368:

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

384: WHERE proposal_id = p_proposal_id;
385:
386: begin
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: IF l_row_id IS NULL THEN
391: OPEN get_row_id;
392: FETCH get_row_id INTO l_row_id;

Line 408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
411:
412: ---------------------------------------------------------------------------------

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

441: WHERE proposal_id = x_proposal_id;
442:
443: begin
444:
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: IF l_row_id IS NULL THEN
448: OPEN get_row_id;
449: FETCH get_row_id INTO l_row_id;

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493:
494: if (sql%notfound) then
495: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
496: FND_MSG_PUB.Add;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: end if;
499:
500: if x_sponsor_action_date <> l_old_sponsor_action_date or
501: nvl(x_sponsor_action_code,'_') <> nvl(l_old_sponsor_action_code,'_') or

Line 539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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: