DBA Data[Home] [Help]

APPS.AS_ACCESS_PVT dependencies on FND_PROFILE

Line 121: := FND_PROFILE.Value('AS_OPP_ACCESS');

117: IF px_access_profile_rec.opp_access_profile_value IS NULL OR
118: px_access_profile_rec.opp_access_profile_value = FND_API.G_MISS_CHAR
119: THEN
120: px_access_profile_rec.opp_access_profile_value
121: := FND_PROFILE.Value('AS_OPP_ACCESS');
122: END IF;
123:
124: IF px_access_profile_rec.lead_access_profile_value IS NULL OR
125: px_access_profile_rec.lead_access_profile_value = FND_API.G_MISS_CHAR

Line 128: := FND_PROFILE.Value('AS_LEAD_ACCESS');

124: IF px_access_profile_rec.lead_access_profile_value IS NULL OR
125: px_access_profile_rec.lead_access_profile_value = FND_API.G_MISS_CHAR
126: THEN
127: px_access_profile_rec.lead_access_profile_value
128: := FND_PROFILE.Value('AS_LEAD_ACCESS');
129: END IF;
130:
131: IF px_access_profile_rec.cust_access_profile_value IS NULL OR
132: px_access_profile_rec.cust_access_profile_value = FND_API.G_MISS_CHAR

Line 135: := FND_PROFILE.Value('AS_CUST_ACCESS');

131: IF px_access_profile_rec.cust_access_profile_value IS NULL OR
132: px_access_profile_rec.cust_access_profile_value = FND_API.G_MISS_CHAR
133: THEN
134: px_access_profile_rec.cust_access_profile_value
135: := FND_PROFILE.Value('AS_CUST_ACCESS');
136: END IF;
137:
138: IF px_access_profile_rec.mgr_update_profile_value IS NULL OR
139: px_access_profile_rec.mgr_update_profile_value = FND_API.G_MISS_CHAR

Line 142: := FND_PROFILE.Value('AS_MGR_UPDATE');

138: IF px_access_profile_rec.mgr_update_profile_value IS NULL OR
139: px_access_profile_rec.mgr_update_profile_value = FND_API.G_MISS_CHAR
140: THEN
141: px_access_profile_rec.mgr_update_profile_value
142: := FND_PROFILE.Value('AS_MGR_UPDATE');
143: END IF;
144:
145: IF px_access_profile_rec.admin_update_profile_value IS NULL OR
146: px_access_profile_rec.admin_update_profile_value = FND_API.G_MISS_CHAR

Line 149: := FND_PROFILE.Value('AS_ADMIN_UPDATE');

145: IF px_access_profile_rec.admin_update_profile_value IS NULL OR
146: px_access_profile_rec.admin_update_profile_value = FND_API.G_MISS_CHAR
147: THEN
148: px_access_profile_rec.admin_update_profile_value
149: := FND_PROFILE.Value('AS_ADMIN_UPDATE');
150: END IF;
151: IF l_debug THEN
152: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
153: 'AS_CUST_ACCESS: ' ||

Line 595: 'allow change opp owner profile: ' || fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') );

591: 'p_lead_id: ' || p_lead_id);
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
593: 'ident salesforce_id: ' || p_identity_salesforce_id);
594: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'allow change opp owner profile: ' || fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') );
596: END IF;
597:
598:
599: --

Line 612: if fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') = 'Y'

608: x_update_access_flag := 'Y';
609: ELSE -- if p_check_access_flag = 'Y'
610: -- PRM security
611:
612: if fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER') = 'Y'
613: then
614: x_update_access_flag := 'Y';
615: end if;
616:

Line 1033: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN

1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1031: 'Private API: SALES_GROUP_ID is not valid');
1032: END IF;
1033: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1034: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1035: FND_MSG_PUB.ADD;
1036: ELSE
1037: AS_UTILITY_PVT.Set_Message(

Line 1057: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN

1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1055: 'Private API: SALES_GROUP_ID,SALESFORCE_ID is not valid');
1056: END IF;
1057: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1058: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1059: FND_MSG_PUB.ADD;
1060: ELSE
1061: AS_UTILITY_PVT.Set_Message(

Line 1943: and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'

1939:
1940: if (l_sales_team_rec.sales_lead_id is NOT NULL
1941: and l_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)
1942: and l_sales_team_rec.owner_flag = 'Y'
1943: and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'
1944: and p_check_access_flag = 'Y'
1945: then
1946: has_leadOwnerAccess
1947: ( p_api_version_number => 2.0

Line 1984: and fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER')<>'Y'

1980:
1981: if (l_sales_team_rec.lead_id is NOT NULL
1982: and l_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)
1983: and l_sales_team_rec.owner_flag = 'Y'
1984: and fnd_profile.value('AS_ALLOW_CHANGE_OPP_OWNER')<>'Y'
1985: --and p_check_access_flag = 'Y'
1986: then
1987: has_oppOwnerAccess
1988: ( p_api_version_number => 2.0

Line 2026: and (nvl(fnd_profile.value('AS_DEF_CUST_ST_ROLE'),'PS') <>'AM')

2022:
2023:
2024: -- Account manager
2025: if l_sales_team_rec.salesforce_role_code = 'AM'
2026: and (nvl(fnd_profile.value('AS_DEF_CUST_ST_ROLE'),'PS') <>'AM')
2027:
2028: then
2029: if not is_account_manager(p_identity_salesforce_id, l_sales_team_rec.customer_id)
2030: and (nvl(fnd_profile.value('AS_CUST_ACCESS'),'F') <>'F')

Line 2030: and (nvl(fnd_profile.value('AS_CUST_ACCESS'),'F') <>'F')

2026: and (nvl(fnd_profile.value('AS_DEF_CUST_ST_ROLE'),'PS') <>'AM')
2027:
2028: then
2029: if not is_account_manager(p_identity_salesforce_id, l_sales_team_rec.customer_id)
2030: and (nvl(fnd_profile.value('AS_CUST_ACCESS'),'F') <>'F')
2031: -- if login person is not account manager and not full access,he can't make other
2032: -- people account manager
2033:
2034: then

Line 2059: l_sales_team_rec.freeze_flag := Nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');

2055: -- end if;
2056: if l_sales_team_rec.freeze_flag is null
2057: or l_sales_team_rec.freeze_flag = fnd_api.g_miss_char
2058: then
2059: l_sales_team_rec.freeze_flag := Nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
2060: end if;
2061:
2062: --if l_sales_team_rec.owner_flag = 'Y' and (l_sales_team_rec.sales_lead_id is NOT NULL
2063: -- and l_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)

Line 2964: -- and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'

2960: --if (l_sales_team_rec.sales_lead_id is NOT NULL
2961: -- and l_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)
2962: -- and l_sales_team_rec.owner_flag = 'Y'
2963: -- and p_check_access_flag = 'Y'
2964: -- and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'
2965:
2966: if (l_sales_team_rec.sales_lead_id is NOT NULL
2967: and l_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)
2968: and l_sales_team_rec.owner_flag = 'Y'

Line 2969: and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'

2965:
2966: if (l_sales_team_rec.sales_lead_id is NOT NULL
2967: and l_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)
2968: and l_sales_team_rec.owner_flag = 'Y'
2969: and fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER')<>'Y'
2970:
2971: then
2972: open get_owner_flag (l_sales_team_rec.access_id);
2973: fetch get_owner_flag into l_owner_flag;

Line 3034: and (nvl(fnd_profile.value('AS_CUST_ACCESS'),'F') <>'F')

3030: -- if want to update someone to be account manager
3031: -- or update 'AM' to be not 'AM'
3032: then
3033: if not is_account_manager(p_identity_salesforce_id, l_sales_team_rec.customer_id)
3034: and (nvl(fnd_profile.value('AS_CUST_ACCESS'),'F') <>'F')
3035: -- if login person is not account manager,he can't make other
3036: -- people account manager or not account manager
3037:
3038: then