DBA Data[Home] [Help]

APPS.WSH_RU_ACTIONS dependencies on WSH_UTIL_CORE

Line 76: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

72: x_rowid => x_rowid,
73: x_role_id => l_role_id,
74: x_return_status => l_rs);
75:
76: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
77: x_return_status := l_rs;
78: rollback to before_role_definition;
79: --
80: -- Debug Statements

Line 124: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

120: x_rowid => l_dummy_rowid,
121: x_role_privilege_id => l_dummy_id,
122: x_return_status => l_rs);
123:
124: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
125: x_return_status := l_rs;
126: rollback to before_role_definition;
127: --
128: -- Debug Statements

Line 219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

215: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROLE_DEFINITION';
216: --
217: BEGIN
218:
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
220: --
221: -- Debug Statements
222: --
223: --

Line 259: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

255: p_role_record => l_role,
256: p_rowid => NULL,
257: x_return_status => l_rs);
258:
259: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
260: x_return_status := l_rs;
261: rollback to before_role_definition;
262: --
263: -- Debug Statements

Line 276: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

272: WSH_RU_ROLE_PRIVILEGES_PVT.Delete_Role_Privileges(
273: p_role_id => p_role_def_record.ROLE_ID,
274: x_return_status => l_rs);
275:
276: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
277: x_return_status := l_rs;
278: rollback to before_role_definition;
279: --
280: -- Debug Statements

Line 316: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

312: x_rowid => l_dummy_rowid,
313: x_role_privilege_id => l_dummy_id,
314: x_return_status => l_rs);
315:
316: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
317: x_return_status := l_rs;
318: rollback to before_role_definition;
319: --
320: -- Debug Statements

Line 368: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

364: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_DEF_RECORD.ROLE_ID',p_role_def_record.ROLE_ID);
365: END IF;
366: --
367: FND_MESSAGE.SET_NAME('WSH', 'NOT_IMPLEMENTED');
368: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
369: --
370: -- Debug Statements
371: --
372: IF l_debug_on THEN

Line 423: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

419: --
420: FOR p IN c_privileges(p_organization_id, fnd_profile.value('USER_ID')) LOOP
421: i:=i+1; x_privileges(i) := p.privilege_code;
422: END LOOP;
423: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
424:
425: --
426: -- Debug Statements
427: --

Line 435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

431: END IF;
432: --
433: EXCEPTION
434: WHEN others THEN
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
436: wsh_util_core.default_handler('WSH_RU_ACTIONS.GET_ORGANIZATION_PRIVILEGES');
437:
438: --
439: -- Debug Statements

Line 436: wsh_util_core.default_handler('WSH_RU_ACTIONS.GET_ORGANIZATION_PRIVILEGES');

432: --
433: EXCEPTION
434: WHEN others THEN
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
436: wsh_util_core.default_handler('WSH_RU_ACTIONS.GET_ORGANIZATION_PRIVILEGES');
437:
438: --
439: -- Debug Statements
440: --

Line 498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

494: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE',P_ENTITY_TYPE);
495: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
496: END IF;
497: --
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
499:
500: IF (p_entity_type = 'TRIP') THEN
501: edit_privilege := 'TRIP_EDIT';
502: view_privilege := 'TRIP_VIEW';

Line 575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

571: --
572: EXCEPTION
573: WHEN others THEN
574: x_access_type := 'NONE';
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
576: wsh_util_core.default_handler('WSH_RU_ACTIONS.ENTITY_ACCESS_IN_ORGANIZATION');
577:
578: --
579: -- Debug Statements

Line 576: wsh_util_core.default_handler('WSH_RU_ACTIONS.ENTITY_ACCESS_IN_ORGANIZATION');

572: EXCEPTION
573: WHEN others THEN
574: x_access_type := 'NONE';
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
576: wsh_util_core.default_handler('WSH_RU_ACTIONS.ENTITY_ACCESS_IN_ORGANIZATION');
577:
578: --
579: -- Debug Statements
580: --

Line 629: x_return_status := wsh_util_core.g_ret_sts_success;

625: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
626: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
627: END IF;
628:
629: x_return_status := wsh_util_core.g_ret_sts_success;
630:
631: insert into wsh_customized_activity_msgs
632: (customized_activity_mesg_id
633: ,role_id

Line 666: x_return_status := wsh_util_core.g_ret_sts_error;

662:
663: Exception
664: When others then
665: x_error_message := SQLERRM;
666: x_return_status := wsh_util_core.g_ret_sts_error;
667: IF l_debug_on THEN
668: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
669: wsh_debug_sv.pop(l_module_name);
670: END IF;

Line 709: x_return_status := wsh_util_core.g_ret_sts_success;

705: wsh_debug_sv.log(l_module_name,'l_login_id',l_login_id);
706: wsh_debug_sv.log(l_module_name,'l_sysdate',l_sysdate);
707: END IF;
708:
709: x_return_status := wsh_util_core.g_ret_sts_success;
710:
711: update wsh_customized_activity_msgs msg
712: set return_status = nvl(p_custom_message_rec.return_status,'W')
713: ,creation_date = l_sysdate

Line 733: x_return_status := wsh_util_core.g_ret_sts_error;

729:
730: Exception
731: When others then
732: x_error_message := SQLERRM;
733: x_return_status := wsh_util_core.g_ret_sts_error;
734: IF l_debug_on THEN
735: wsh_debug_sv.log(l_module_name,'x_return_status',x_return_status);
736: wsh_debug_sv.pop(l_module_name);
737: END IF;

Line 770: x_return_status := wsh_util_core.g_ret_sts_success;

766: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.validation_code',p_custom_message_rec.validation_code);
767: wsh_debug_sv.log(l_module_name,'p_custom_message_rec.return_status',p_custom_message_rec.return_status);
768: END IF;
769:
770: x_return_status := wsh_util_core.g_ret_sts_success;
771:
772: delete from wsh_customized_activity_msgs
773: where customized_activity_mesg_id = p_custom_message_rec.customized_activity_mesg_id;
774:

Line 784: x_return_status := wsh_util_core.g_ret_sts_error;

780:
781: Exception
782: When others then
783: x_error_message := SQLERRM;
784: x_return_status := wsh_util_core.g_ret_sts_error;
785: IF l_debug_on THEN
786: wsh_debug_sv.log(l_module_name,'l_return_status',x_return_status);
787: wsh_debug_sv.pop(l_module_name);
788: END IF;