77: close c_rates;
78:
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;
133: --and record_version_number = p_record_version_number;
134:
135: if (sql%notfound) then
136: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
137: FND_MSG_PUB.Add;
138: X_RETURN_STATUS := 'E';
139: end if;
140:
141: exception
139: end if;
140:
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;
191: --and record_version_number = p_record_version_number;
192:
193: if (sql%notfound) then
194: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
195: FND_MSG_PUB.Add;
196: X_RETURN_STATUS := 'E';
197: end if;
198:
199: EXCEPTION
197: end if;
198:
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;