293: WHEN OTHERS THEN
294:
295: rollback to start_csi_transaction;
296:
297: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
298: fnd_message.set_token('ERR_MSG',SQLERRM);
299:
300: x_return_status := g_ret_sts_unexp_error;
301: x_error_message := fnd_message.get;
294:
295: rollback to start_csi_transaction;
296:
297: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
298: fnd_message.set_token('ERR_MSG',SQLERRM);
299:
300: x_return_status := g_ret_sts_unexp_error;
301: x_error_message := fnd_message.get;
302:
297: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
298: fnd_message.set_token('ERR_MSG',SQLERRM);
299:
300: x_return_status := g_ret_sts_unexp_error;
301: x_error_message := fnd_message.get;
302:
303: BEGIN
304: SELECT transaction_error_id
305: INTO l_txn_error_id
736: debug('l_return_status : '||l_return_status);
737: debug('l_msg_data : '||l_msg_data);
738: debug('l_msg_count : '||l_msg_count);
739:
740: l_msg_data := fnd_message.get;
741: debug('l_msg_data : '||l_msg_data);
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: x_error_message := l_msg_data; --- Added for bug 6030501
783: p_msg_count => l_msg_count,
784: p_msg_data => l_msg_data,
785: p_asset_key_ccid => l_asset_key_ccid);
786:
787: l_msg_data := fnd_message.get;
788: debug('l_msg_data : '||l_msg_data);
789:
790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
791: debug('Error in API pa_project_assets_pub.add_project_asset'); -- Added for Bug 6152305