DBA Data[Home] [Help]

APPS.HZ_GEO_GET_PUB dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ZONE_TYPE_INVALID');

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:

Line 90: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_ASSOC_GEO_TYPES');

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;

Line 91: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_zone_type);

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:

Line 127: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');

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:

Line 271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');

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:

Line 338: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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,

Line 339: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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,