DBA Data[Home] [Help]

APPS.HZ_GEO_GET_PUB dependencies on FND_MESSAGE

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

83: AND rownum = 1;
84:
85: IF l_count = 0 THEN
86: x_return_status := FND_API.G_RET_STS_ERROR;
87: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ZONE_TYPE_INVALID');
88: FND_MSG_PUB.ADD;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:

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

108: END IF;
109:
110: IF l_count = 0 THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_ASSOC_GEO_TYPES');
113: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_zone_type);
114: FND_MSG_PUB.ADD;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;

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

109:
110: IF l_count = 0 THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_ASSOC_GEO_TYPES');
113: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_zone_type);
114: FND_MSG_PUB.ADD;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:

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

157: -- Below code is commenmted for bug # 5011582
158: -- Will display the message after the end loop of included_geo_types
159: -- IF l_count = 0 THEN
160: -- x_return_status := FND_API.G_RET_STS_ERROR;
161: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');
162: -- FND_MSG_PUB.ADD;
163: -- RAISE FND_API.G_EXC_ERROR;
164: -- END IF;
165:

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

354: -- If there is COUNTRY in included_geo_types and no GNR
355: IF (l_country_found = 'N' AND
356: l_gnr_count = 0) THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_GEO_NAME_REF');
359: FND_MSG_PUB.ADD;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:

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

487: p_data => x_msg_data);
488:
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
492: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
493: FND_MSG_PUB.ADD;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,

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

488:
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
492: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
493: FND_MSG_PUB.ADD;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,