APPS.IGW_AWARD_BUDGETS_TBH dependencies on FND_API

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
28: l_last_update_date DATE := SYSDATE;
29:
30: begin
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: insert into igw_award_budgets(
34: award_budget_id
35: ,proposal_installment_id

Line 86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

82: exception
83: when others then
84: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
85: ,p_procedure_name => 'INSERT_ROW' );
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
87: RAISE;
88: end insert_row;
89:
90:

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

118: from igw_award_budgets
119: where award_budget_id = p_award_budget_id;
120:
121: begin
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: IF l_row_id IS NULL THEN
125: OPEN get_row_id;
126: FETCH get_row_id INTO l_row_id;

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

152: exception
153: when others then
154: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
155: ,p_procedure_name => 'UPDATE_ROW' );
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157: RAISE;
158: end update_row;
159: --------------------------------------------------------------------------------------------------
160:

Line 177: x_return_status := FND_API.G_RET_STS_SUCCESS;

173: where award_budget_id = p_award_budget_id;
174:
175: begin
176:
177: x_return_status := FND_API.G_RET_STS_SUCCESS;
178:
179: IF l_row_id IS NULL THEN
180: OPEN get_row_id;
181: FETCH get_row_id INTO l_row_id;

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

195: EXCEPTION
196: WHEN OTHERS THEN
197: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
198: ,p_procedure_name => 'DELETE_ROW' );
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: RAISE;
201: end DELETE_ROW;
202:
203: