Need help for building a storeprocedure

Hi all, Urgent help is required. 

There are two pages now in my application. One is buildingblock page and another is volume page. Now in the buildingblock page I am choosing building blocks(Origin/destination type). Under each BB there are locations which are called as OriginCX/Destination Cx based on which BB type it is.

I am making all possible pairs of them like origin - destination combinations and then in volume page I am displaying them as records in a grid with some other input fields.

Example scenarios which are NOT passing now- Consider choosing 1 OriginCx and 1destinationCx of each BB type and they are the same location then after going to Volume page we can find a single record. When we are saving the record data and coming back to BB page then if we are deselecting either one location and saving data in BB page. Then moving forward no alert is being shown that location has been modified

Another scenario which is also failing now is - If I am choosing a single BB location maybe as origin/destination and saving in BB page and moving forward to volume then we can find a dropdown with all available cities location to choose. Here if I am choosing any city and saving the data then alert is coming as Location has been modified. This condition no alert should come.

This is all of my business logic