99:
100: EXCEPTION
101: WHEN OTHERS
102: THEN
103: x_return_status := fnd_api.G_RET_STS_ERROR ;
104: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
105: fnd_message.set_token('API_NAME',l_api_name);
106: fnd_message.set_token('SQL_ERROR',SQLERRM);
107: x_error_msg := fnd_message.get;
182: END LOOP ;
183: EXCEPTION
184: WHEN OTHERS
185: THEN
186: x_return_status := fnd_api.G_RET_STS_ERROR ;
187: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
188: fnd_message.set_token('API_NAME',l_api_name);
189: fnd_message.set_token('SQL_ERROR',SQLERRM);
190: x_error_msg := fnd_message.get;