229: EXCEPTION
230:
231: WHEN MOD_DIST_FAIL THEN
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
234: fnd_message.set_token('API_NAME',l_api_name);
235: x_new_from_dist_id := NULL;
236: x_new_to_dist_id := NULL;
237:
230:
231: WHEN MOD_DIST_FAIL THEN
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
234: fnd_message.set_token('API_NAME',l_api_name);
235: x_new_from_dist_id := NULL;
236: x_new_to_dist_id := NULL;
237:
238: WHEN OTHERS THEN
713: EXCEPTION
714:
715: WHEN NO_DIST_EXISTS THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: fnd_message.set_name('CSE', 'CSE_NO_FA_DIST_FOR_ADJ');
718: x_error_msg := fnd_message.get;
719: x_new_dist_id := NULL;
720:
721: WHEN UPDATE_FAIL THEN
714:
715: WHEN NO_DIST_EXISTS THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: fnd_message.set_name('CSE', 'CSE_NO_FA_DIST_FOR_ADJ');
718: x_error_msg := fnd_message.get;
719: x_new_dist_id := NULL;
720:
721: WHEN UPDATE_FAIL THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
724: x_new_dist_id := NULL;
725:
726: WHEN MOD_DIST_FAIL THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
729: fnd_message.set_token('API_NAME',l_api_name);
730: x_error_msg := fnd_message.get;
731: x_new_dist_id := NULL;
732:
725:
726: WHEN MOD_DIST_FAIL THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
729: fnd_message.set_token('API_NAME',l_api_name);
730: x_error_msg := fnd_message.get;
731: x_new_dist_id := NULL;
732:
733: WHEN OTHERS THEN
726: WHEN MOD_DIST_FAIL THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
729: fnd_message.set_token('API_NAME',l_api_name);
730: x_error_msg := fnd_message.get;
731: x_new_dist_id := NULL;
732:
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;