3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_WF_HIERARCHY_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwwfhrb.pls';
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: -- have to define these as global because of recursion.
11: -- make sure to free the memory after use
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_WF_HIERARCHY_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwwfhrb.pls';
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: -- have to define these as global because of recursion.
11: -- make sure to free the memory after use
12:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114: IF FND_GLOBAL.User_Id IS NULL THEN
115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141: IF FND_GLOBAL.User_Id IS NULL THEN
1142: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: IF FND_GLOBAL.User_Id IS NULL THEN
1259: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;
1262:
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1461: FND_MSG_PUB.initialize;
1462: END IF;
1463: IF FND_GLOBAL.User_Id IS NULL THEN
1464: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631: IF FND_GLOBAL.User_Id IS NULL THEN
1632: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029: IF FND_GLOBAL.User_Id IS NULL THEN
2030: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033:
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: IF FND_GLOBAL.User_Id IS NULL THEN
2159: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2533: ------------------------------------------------------------------------------------------------------------
2534:
2535:
2536: function check_org_user_permission(org_id in number) return number is
2537: userId number := FND_GLOBAL.User_Id;
2538: l_dummy number;
2539: begin
2540: if (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') = 'N') OR (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') is null) then
2541: return 1;
2951: x_return_status := FND_API.G_RET_STS_SUCCESS;
2952: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2953: FND_MSG_PUB.initialize;
2954: END IF;
2955: IF FND_GLOBAL.User_Id IS NULL THEN
2956: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959:
3292: x_return_status := FND_API.G_RET_STS_SUCCESS;
3293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3294: FND_MSG_PUB.initialize;
3295: END IF;
3296: IF FND_GLOBAL.User_Id IS NULL THEN
3297: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3298: RAISE FND_API.G_EXC_ERROR;
3299: END IF;
3300: