87: from jtf_terr_all
88: where terr_id = p_terr_id;
89:
90: EXCEPTION
91: when FND_API.G_EXC_ERROR then
92: x_return_status := 'E';
93: x_msg_data := substr(sqlerrm, 1, 200) ;
94: return;
95:
518: commit;
519: x_return_status := 'S';
520:
521: EXCEPTION
522: when FND_API.G_EXC_ERROR then
523:
524: x_return_status := 'E';
525: x_msg_data := substr(sqlerrm, 1, 200) ;
526: return;