eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEO_GET_PUB dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5: (p_location_table_name IN VARCHAR2,
6: p_location_id IN VARCHAR2,
7: p_zone_type IN VARCHAR2,
8: p_date IN DATE,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: x_zone_tbl OUT NOCOPY zone_tbl_type,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: l_country_found VARCHAR2(1);
52: l_country_code VARCHAR2(80);
53:
54: BEGIN
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56: i := 1;
57:
58: -- Validate zone type
59:

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: AND geography_use <> 'MASTER_REF'
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;

Line 72: RAISE FND_API.G_EXC_ERROR;

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
76: -- geography types

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: AND rownum = 1;
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;

Line 93: RAISE FND_API.G_EXC_ERROR;

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
97: BEGIN

Line 126: -- x_return_status := FND_API.G_RET_STS_ERROR;

122:
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;

Line 129: -- RAISE FND_API.G_EXC_ERROR;

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';
133:

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266:
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;

Line 273: RAISE FND_API.G_EXC_ERROR;

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
277: i := l_zone_tbl.FIRST;

Line 323: WHEN FND_API.G_EXC_ERROR THEN

319:
320: x_zone_tbl := l_zone_tbl_final;
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,

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: x_zone_tbl := l_zone_tbl_final;
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);

Line 326: p_encoded => FND_API.G_FALSE,

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
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

Line 332: p_encoded => FND_API.G_FALSE,

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:
336: WHEN OTHERS THEN

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333: p_count => x_msg_count,
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(

Line 342: p_encoded => FND_API.G_FALSE,

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:
346: END get_zone;