APPS.OZF_FUNDRULES_PVT dependencies on FND_PROFILE

Line 1081: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN

1077: -- Fix for Bug #14736414
1078: -- Global flag for an offer is checkedd against the profile global flag
1079:
1080: IF p_mode = 'CREATE' THEN
1081: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
1082: -- QP_SECURITY_PROFILE IS ON.
1083: IF(p_fund_rec.org_id IS NULL OR p_fund_rec.org_id = FND_API.G_MISS_NUM) THEN
1084: -- DEFAULT OU IS NULL
1085: IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN

Line 1085: IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN

1081: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
1082: -- QP_SECURITY_PROFILE IS ON.
1083: IF(p_fund_rec.org_id IS NULL OR p_fund_rec.org_id = FND_API.G_MISS_NUM) THEN
1084: -- DEFAULT OU IS NULL
1085: IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN
1086: OZF_Utility_PVT.Error_Message('OZF_ORG_ID_OR_GFLAG_REQD');
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSE
1089: l_offer_hdr_rec.global_flag := 'Y';

Line 1098: IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN

1094:
1095: END IF;
1096: ELSE
1097: --QP_SECURITY_PROFILE IS OFF.
1098: IF (NVL(fnd_profile.value('OZF_GLOBAL_FLAG'), 'N') = 'N') THEN
1099: -- OZF_GLOBAL_FLAG IS NO.
1100: OZF_Utility_PVT.Error_Message('QP_SEC_PROF_AND_GFLAG_NOT_COMP');
1101: RAISE FND_API.G_EXC_ERROR;
1102: ELSE

Line 1111: IF p_fund_rec.org_id IS NOT NULL AND p_fund_rec.org_id <> FND_API.G_MISS_NUM AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN

1107: ELSIF p_mode = 'UPDATE' THEN
1108:
1109: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'ozf_fundrules_pvt','Update mode = p_fund_rec.org_id'|| p_fund_rec.org_id);
1110:
1111: IF p_fund_rec.org_id IS NOT NULL AND p_fund_rec.org_id <> FND_API.G_MISS_NUM AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
1112: l_offer_hdr_rec.global_flag := 'N';
1113: l_offer_hdr_rec.orig_org_id := p_fund_rec.org_id; /*12_11_2012 pass it to offer API process_modifier*/
1114: ELSE
1115: l_offer_hdr_rec.global_flag := 'Y';