APPS.HZ_GEO_GET_PUB dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.ADD;

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:
75: -- Validate that the zone type has associated reference

Line 92: FND_MSG_PUB.ADD;

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:
96: -- To get country_code for the location

Line 128: -- FND_MSG_PUB.ADD;

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:
132: l_country_found := 'N';

Line 272: FND_MSG_PUB.ADD;

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:
276: IF l_zone_tbl.COUNT > 0 THEN

Line 325: FND_MSG_PUB.Count_And_Get(

321:
322: EXCEPTION
323: WHEN FND_API.G_EXC_ERROR THEN
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get(
326: p_encoded => FND_API.G_FALSE,
327: p_count => x_msg_count,
328: p_data => x_msg_data);
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 331: FND_MSG_PUB.Count_And_Get(

327: p_count => x_msg_count,
328: p_data => x_msg_data);
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331: FND_MSG_PUB.Count_And_Get(
332: p_encoded => FND_API.G_FALSE,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335:

Line 340: FND_MSG_PUB.ADD;

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,
344: p_data => x_msg_data);

Line 341: FND_MSG_PUB.Count_And_Get(

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,
344: p_data => x_msg_data);
345: