46: BEGIN
47: IF PG_DEBUG in ('Y', 'C') THEN
48: arp_util.debug('Validate_Global_Flexfield ()+');
49: END IF;
50: p_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: OPEN desc_flex_exists;
53: FETCH desc_flex_exists INTO l_flex_exists;
54: IF desc_flex_exists%NOTFOUND THEN
52: OPEN desc_flex_exists;
53: FETCH desc_flex_exists INTO l_flex_exists;
54: IF desc_flex_exists%NOTFOUND THEN
55: CLOSE desc_flex_exists;
56: p_return_status := FND_API.G_RET_STS_ERROR;
57: return;
58: END IF;
59: CLOSE desc_flex_exists;
60:
88:
89: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
90: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
91: FND_MSG_PUB.ADD ;
92: p_return_status := FND_API.G_RET_STS_ERROR;
93: END IF;
94:
95: l_count := fnd_flex_descval.segment_count;
96: