392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
404: WHEN NO_DATA_FOUND THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
404: WHEN NO_DATA_FOUND THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
412: , p_count => x_msg_count
413: , p_data => x_msg_data);
414: IF (x_msg_data IS NULL) THEN
415: x_msg_data := 'BIS_CUSTOMIZATIONS_PVT.delete_region_customizations: ' || SQLERRM;