158: END IF;
159:
160: SAVEPOINT before_insert;
161:
162: l_user_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_USER');
163: l_resp_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_RESP');
164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);
159:
160: SAVEPOINT before_insert;
161:
162: l_user_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_USER');
163: l_resp_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_RESP');
164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);
167: WSH_DEBUG_SV.logmsg(l_module_name,'Profile Responsibility Id : '||l_resp_id);