APPS.IGW_PROP_RATES_TBH dependencies on FND_API

Line 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

118: and activity_type_code = p_activity_type_code
119: and fiscal_year = p_fiscal_year;
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 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

141: exception
142: when others then
143: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
144: ,p_procedure_name => 'UPDATE_ROW' );
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: RAISE;
147: end update_row;
148: -------------------------------------------------------------------------------------------
149:

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: and fiscal_year = p_fiscal_year;
178:
179: begin
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF l_row_id IS NULL THEN
184: OPEN get_row_id;
185: FETCH get_row_id INTO l_row_id;

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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