APPS.IGW_BUDGET_PERIODS_TBH dependencies on FND_API

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 126: x_return_status := FND_API.G_RET_STS_SUCCESS;

122: AND version_id = p_version_id
123: AND budget_period_id = p_budget_period_id;
124:
125: begin
126: x_return_status := FND_API.G_RET_STS_SUCCESS;
127:
128: IF l_row_id IS NULL THEN
129: OPEN get_row_id;
130: FETCH get_row_id INTO l_row_id;

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

156: exception
157: when others then
158: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
159: ,p_procedure_name => 'UPDATE_ROW' );
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: RAISE;
162: end update_row;
163: --------------------------------------------------------------------------------------------------
164:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: AND budget_period_id = p_budget_period_id;
181:
182: begin
183:
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF l_row_id IS NULL THEN
187: OPEN get_row_id;
188: FETCH get_row_id INTO l_row_id;

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

202: EXCEPTION
203: WHEN OTHERS THEN
204: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
205: ,p_procedure_name => 'DELETE_ROW' );
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
207: RAISE;
208: end DELETE_ROW;
209:
210: