APPS.IGW_BUDGET_PERSONNEL_TBH dependencies on FND_API

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
32: l_last_update_date DATE := SYSDATE;
33:
34: begin
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: insert into igw_budget_personnel_details(
38: proposal_id
39: ,version_id

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

94: exception
95: when others then
96: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
97: ,p_procedure_name => 'INSERT_ROW' );
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: RAISE;
100: end insert_row;
101:
102:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: from igw_budget_personnel_details
135: where budget_personnel_detail_id = p_budget_personnel_detail_id;
136:
137: begin
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: IF l_row_id IS NULL THEN
141: OPEN get_row_id;
142: FETCH get_row_id INTO l_row_id;

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

169: exception
170: when others then
171: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
172: ,p_procedure_name => 'UPDATE_ROW' );
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: RAISE;
175: end update_row;
176: --------------------------------------------------------------------------------------------------
177:

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: where budget_personnel_detail_id = p_budget_personnel_detail_id;
197:
198: begin
199:
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: IF l_row_id IS NULL THEN
203: OPEN get_row_id;
204: FETCH get_row_id INTO l_row_id;

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218: EXCEPTION
219: WHEN OTHERS THEN
220: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
221: ,p_procedure_name => 'DELETE_ROW' );
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223: RAISE;
224: end DELETE_ROW;
225:
226: