101: EXCEPTION
102: WHEN OTHERS
103: THEN
104: x_return_status := fnd_api.G_RET_STS_ERROR ;
105: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
106: fnd_message.set_token('API_NAME',l_api_name);
107: fnd_message.set_token('SQL_ERROR',SQLERRM);
108: x_error_msg := fnd_message.get;
109:
102: WHEN OTHERS
103: THEN
104: x_return_status := fnd_api.G_RET_STS_ERROR ;
105: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
106: fnd_message.set_token('API_NAME',l_api_name);
107: fnd_message.set_token('SQL_ERROR',SQLERRM);
108: x_error_msg := fnd_message.get;
109:
110: END insert_retirement ;
103: THEN
104: x_return_status := fnd_api.G_RET_STS_ERROR ;
105: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
106: fnd_message.set_token('API_NAME',l_api_name);
107: fnd_message.set_token('SQL_ERROR',SQLERRM);
108: x_error_msg := fnd_message.get;
109:
110: END insert_retirement ;
111:
104: x_return_status := fnd_api.G_RET_STS_ERROR ;
105: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
106: fnd_message.set_token('API_NAME',l_api_name);
107: fnd_message.set_token('SQL_ERROR',SQLERRM);
108: x_error_msg := fnd_message.get;
109:
110: END insert_retirement ;
111:
112:
184: EXCEPTION
185: WHEN OTHERS
186: THEN
187: x_return_status := fnd_api.G_RET_STS_ERROR ;
188: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
189: fnd_message.set_token('API_NAME',l_api_name);
190: fnd_message.set_token('SQL_ERROR',SQLERRM);
191: x_error_msg := fnd_message.get;
192:
185: WHEN OTHERS
186: THEN
187: x_return_status := fnd_api.G_RET_STS_ERROR ;
188: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
189: fnd_message.set_token('API_NAME',l_api_name);
190: fnd_message.set_token('SQL_ERROR',SQLERRM);
191: x_error_msg := fnd_message.get;
192:
193: END create_inv_rets ;
186: THEN
187: x_return_status := fnd_api.G_RET_STS_ERROR ;
188: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
189: fnd_message.set_token('API_NAME',l_api_name);
190: fnd_message.set_token('SQL_ERROR',SQLERRM);
191: x_error_msg := fnd_message.get;
192:
193: END create_inv_rets ;
194:
187: x_return_status := fnd_api.G_RET_STS_ERROR ;
188: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
189: fnd_message.set_token('API_NAME',l_api_name);
190: fnd_message.set_token('SQL_ERROR',SQLERRM);
191: x_error_msg := fnd_message.get;
192:
193: END create_inv_rets ;
194:
195: