109: FROM jtf_terr_all
110: WHERE geo_territory_id = p_geo_terr_id;
111:
112: EXCEPTION
113: when FND_API.G_EXC_ERROR then
114: -- Add proper error logging
115: --dbms_output.put_line(' exc err sqlerrm:' || sqlerrm);
116: NULL;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
113: when FND_API.G_EXC_ERROR then
114: -- Add proper error logging
115: --dbms_output.put_line(' exc err sqlerrm:' || sqlerrm);
116: NULL;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: -- Add proper error logging
119: --dbms_output.put_line('unexp err sqlerrm:' || sqlerrm);
120: NULL;
121: when no_data_found then
203: where geo_territory_id = p_geo_terr_id;
204: --dbms_output.put_line('terr_group_id:'||l_geo_terr_group_id);
205:
206: EXCEPTION
207: when FND_API.G_EXC_ERROR then
208: -- Add proper error logging
209: NULL;
210: when FND_API.G_EXC_UNEXPECTED_ERROR then
211: -- Add proper error logging
206: EXCEPTION
207: when FND_API.G_EXC_ERROR then
208: -- Add proper error logging
209: NULL;
210: when FND_API.G_EXC_UNEXPECTED_ERROR then
211: -- Add proper error logging
212: NULL;
213: when others then
214: --dbms_output.put_line('SQL Error ' || sqlerrm);