252: , g_table_name
253: , 'Exception occurred in CREATE_USER when calling API'
254: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
255: END IF;
256: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','CREATE_USER','API error');
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN OTHERS THEN
260: /*** uncaught exception -> rollback and log sql error ***/
267: , 'Caught exception in CREATE_USER:' || fnd_global.local_chr(10) || sqlerrm
268: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
269: END IF;
270:
271: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','CREATE_USER',sqlerrm);
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: END CREATE_USER;
274:
275: /* Put all delete_user procedures here */
865: , 'Exception occurred in DELETE_USER when calling API'
866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
867: , 'csl_user_pkg');
868: END IF;
869: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER','API error');
870: x_return_status := FND_API.G_RET_STS_ERROR;
871:
872: WHEN OTHERS THEN
873: /*** uncaught exception -> rollback and log sql error ***/
881: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
882: , 'csl_user_pkg');
883: END IF;
884:
885: fnd_msg_pub.Add_Exc_Msg('CSL_USER_PKG','DELETE_USER',sqlerrm);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: END DELETE_USER;
888:
889: END CSL_USER_PKG;