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;
108:
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;
108:
109: END insert_retirement ;
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;
108:
109: END insert_retirement ;
110:
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;
108:
109: END insert_retirement ;
110:
111:
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;
191:
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;
191:
192: END create_inv_rets ;
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;
191:
192: END create_inv_rets ;
193:
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;
191:
192: END create_inv_rets ;
193:
194: