APPS.ASO_SECURITY_INT dependencies on FND_PROFILE

Line 49: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

45:
46: BEGIN
47:
48:
49: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
50:
51:
52: -- API body
53: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 80: IF FND_PROFILE.VALUE('ASO_API_MGR_ROLE_ACCESS') = 'UPDATE' THEN

76: l_access_level := 'READ';
77: END IF;
78: END LOOP;
79:
80: IF FND_PROFILE.VALUE('ASO_API_MGR_ROLE_ACCESS') = 'UPDATE' THEN
81: l_profile_access := 'Y';
82: END IF;
83:
84: FOR c_manager_access_rec IN C_manager_access(p_resource_id, p_quote_number) LOOP

Line 180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

176:
177: -- Initialize API return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);

Line 621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

617:
618: l_call_from_oafwk_flag varchar2(1) := fnd_api.g_false;
619:
620: Begin
621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;

Line 695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

691: l_quote_number NUMBER;
692: l_access_id NUMBER;
693:
694: BEGIN
695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Delete_Resource API ******', 1, 'Y');
698: END IF;
699:

Line 1094: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

1090: END IF;
1091:
1092: if l_obsolete_status = 'T' then
1093:
1094: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1095:
1096: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1097: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1098: END IF;

Line 1108: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);

1104: END IF;
1105:
1106: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1107:
1108: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
1109:
1110: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1111: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1112: END IF;

Line 1124: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);

1120: end if;
1121:
1122: else
1123:
1124: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1125:
1126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1127: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1128: END IF;

Line 1138: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);

1134: END IF;
1135:
1136: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1137:
1138: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1139:
1140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1141: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1142: END IF;