66: AND rownum = 1;
67:
68: IF l_count = 0 THEN
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ZONE_TYPE_INVALID');
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
86: END;
87:
88: IF l_count = 0 THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_ASSOC_GEO_TYPES');
91: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_zone_type);
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
87:
88: IF l_count = 0 THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_ASSOC_GEO_TYPES');
91: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_zone_type);
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
123: -- Below code is commenmted for bug # 5011582
124: -- Will display the message after the end loop of included_geo_types
125: -- IF l_count = 0 THEN
126: -- x_return_status := FND_API.G_RET_STS_ERROR;
127: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');
128: -- FND_MSG_PUB.ADD;
129: -- RAISE FND_API.G_EXC_ERROR;
130: -- END IF;
131:
267: -- If there is COUNTRY in included_geo_types and no GNR
268: IF (l_country_found = 'N' AND
269: l_gnr_count = 0) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275:
334: p_data => x_msg_data);
335:
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
340: FND_MSG_PUB.ADD;
341: FND_MSG_PUB.Count_And_Get(
342: p_encoded => FND_API.G_FALSE,
335:
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
340: FND_MSG_PUB.ADD;
341: FND_MSG_PUB.Count_And_Get(
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,