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_ADDRESS_USAGES_PUB dependencies on FND_MESSAGE

Line 38: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');

34: -- Map Id is mandatory
35:
36: IF p_address_usages_rec.map_id IS NULL THEN
37: x_return_status := FND_API.G_RET_STS_ERROR;
38: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
39: -- The Map Id passed is NULL. Please use a valid Map Id to create a Address Usage.
40: FND_MSG_PUB.ADD;
41: RAISE FND_API.G_EXC_ERROR;
42: ELSE

Line 51: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');

47: WHERE map_id = p_address_usages_rec.map_id;
48:
49: EXCEPTION WHEN NO_DATA_FOUND THEN
50: x_return_status := FND_API.G_RET_STS_ERROR;
51: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
52: -- The mapping record that you are trying to create address usage does not exist.
53: FND_MSG_PUB.ADD;
54: RAISE FND_API.G_EXC_ERROR;
55:

Line 63: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');

59: -- Usage code is mandatory
60:
61: IF p_address_usages_rec.usage_code IS NULL THEN
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');
64: -- Please enter a valid usage.
65: FND_MSG_PUB.ADD;
66: RAISE FND_API.G_EXC_ERROR;
67: ELSE

Line 76: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');

72: WHERE lookup_type = 'HZ_GEOGRAPHY_USAGE'
73: AND lookup_code = p_address_usages_rec.usage_code;
74: EXCEPTION WHEN NO_DATA_FOUND THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');
77: -- The Usage Code is invalid. Please pass a valid Usage Code
78: FND_MSG_PUB.ADD;
79: RAISE FND_API.G_EXC_ERROR;
80: END;

Line 85: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_USAGE_DTL_MAND');

81: END IF;
82:
83: IF p_address_usage_dtls_tbl.COUNT < 2 THEN
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_USAGE_DTL_MAND');
86: -- Please enter two or more geography types for a usage.
87: FND_MSG_PUB.ADD;
88: RAISE FND_API.G_EXC_ERROR;
89: END IF;

Line 106: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');

102: END LOOP;
103:
104: IF l_usg_country_found <> 'Y' then
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
107: -- Please enter a geography type COUNTRY
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;

Line 141: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOGRAPHY_TYPE_MAND');

137: WHILE i IS NOT NULL LOOP
138:
139: IF p_address_usage_dtls_tbl(i).geography_type IS NULL THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOGRAPHY_TYPE_MAND');
142: -- Please enter a valid geography type
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;
145: ELSE

Line 155: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');

151: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
152:
153: EXCEPTION WHEN NO_DATA_FOUND THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');
156: -- Geography Type does not mapped with a location
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159:

Line 190: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_ID');

186: ROLLBACK TO do_create_address_usages;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
189: IF p_index_name = 'HZ_ADDRESS_USAGES_U1' THEN
190: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_ID');
191: FND_MESSAGE.SET_TOKEN('P_USAGE_ID',l_usage_id);
192: -- Usage ID already exists. Please use a unique ID
193: FND_MSG_PUB.ADD;
194:

Line 191: FND_MESSAGE.SET_TOKEN('P_USAGE_ID',l_usage_id);

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
189: IF p_index_name = 'HZ_ADDRESS_USAGES_U1' THEN
190: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_ID');
191: FND_MESSAGE.SET_TOKEN('P_USAGE_ID',l_usage_id);
192: -- Usage ID already exists. Please use a unique ID
193: FND_MSG_PUB.ADD;
194:
195: ELSIF p_index_name = 'HZ_ADDRESS_USAGES_U2' THEN

Line 196: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_ROW_EXISTS');

192: -- Usage ID already exists. Please use a unique ID
193: FND_MSG_PUB.ADD;
194:
195: ELSIF p_index_name = 'HZ_ADDRESS_USAGES_U2' THEN
196: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_ROW_EXISTS');
197: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
198: -- The mapping already exists for this usage. Please use another mapping.
199: FND_MSG_PUB.ADD;
200:

Line 197: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);

193: FND_MSG_PUB.ADD;
194:
195: ELSIF p_index_name = 'HZ_ADDRESS_USAGES_U2' THEN
196: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_ROW_EXISTS');
197: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
198: -- The mapping already exists for this usage. Please use another mapping.
199: FND_MSG_PUB.ADD;
200:
201: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN

Line 202: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');

198: -- The mapping already exists for this usage. Please use another mapping.
199: FND_MSG_PUB.ADD;
200:
201: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
203: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
204: -- Usage detail ID already exists. Please use a unique ID.
205: FND_MSG_PUB.ADD;
206:

Line 203: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);

199: FND_MSG_PUB.ADD;
200:
201: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
203: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
204: -- Usage detail ID already exists. Please use a unique ID.
205: FND_MSG_PUB.ADD;
206:
207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN

Line 208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');

204: -- Usage detail ID already exists. Please use a unique ID.
205: FND_MSG_PUB.ADD;
206:
207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
210: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
211: -- This geography type is already mapped for this usage.
212: FND_MSG_PUB.ADD;

Line 209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);

205: FND_MSG_PUB.ADD;
206:
207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
210: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
211: -- This geography type is already mapped for this usage.
212: FND_MSG_PUB.ADD;
213: END IF;

Line 210: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);

206:
207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
210: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
211: -- This geography type is already mapped for this usage.
212: FND_MSG_PUB.ADD;
213: END IF;
214:

Line 262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');

258: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
259: BEGIN
260: hz_gnr_gen_pkg.genpkg(p_address_usages_rec.map_id,l_pkgname,l_status);
261: IF l_status = FND_API.G_RET_STS_ERROR THEN
262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
263: FND_MSG_PUB.ADD;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: EXCEPTION WHEN OTHERS THEN

Line 267: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

263: FND_MSG_PUB.ADD;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: EXCEPTION WHEN OTHERS THEN
267: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END;
271: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);

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

294: p_data => x_msg_data);
295: WHEN OTHERS THEN
296: ROLLBACK TO create_address_usages;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
300: FND_MSG_PUB.ADD;
301: FND_MSG_PUB.Count_And_Get(
302: p_encoded => FND_API.G_FALSE,

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

295: WHEN OTHERS THEN
296: ROLLBACK TO create_address_usages;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
300: FND_MSG_PUB.ADD;
301: FND_MSG_PUB.Count_And_Get(
302: p_encoded => FND_API.G_FALSE,
303: p_count => x_msg_count,

Line 369: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

365: FROM hz_address_usages
366: WHERE usage_id = p_usage_id;
367: EXCEPTION WHEN NO_DATA_FOUND THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
370: -- Usage record does not exists for updation
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373: END;

Line 378: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');

374: ELSE
375:
376: IF p_map_id IS NULL THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
379: -- The Map Id passed is NULL. Please use a valid Map Id to create an Address Usage.
380: FND_MSG_PUB.ADD;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;

Line 386: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');

382: END IF;
383:
384: IF p_usage_code IS NULL THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');
387: -- The usage code passed is NULL. Please use a valid usage code.
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

Line 405: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

401: WHERE map_id = p_map_id
402: AND usage_code = p_usage_code;
403: EXCEPTION WHEN NO_DATA_FOUND THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
406: -- Usage record does not exists for updation
407: FND_MSG_PUB.ADD;
408: RAISE FND_API.G_EXC_ERROR;
409: END;

Line 414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

410:
411: END IF;
412:
413: IF db_object_version_number <> x_object_version_number THEN
414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
415: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ADDRESS_USAGES');
416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;

Line 415: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ADDRESS_USAGES');

411: END IF;
412:
413: IF db_object_version_number <> x_object_version_number THEN
414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
415: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ADDRESS_USAGES');
416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:

Line 465: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');

461: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
462: BEGIN
463: hz_gnr_gen_pkg.genpkg(db_map_id,l_pkgname,l_status);
464: IF l_status = FND_API.G_RET_STS_ERROR THEN
465: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: EXCEPTION WHEN OTHERS THEN

Line 470: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: EXCEPTION WHEN OTHERS THEN
470: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
471: FND_MSG_PUB.ADD;
472: RAISE FND_API.G_EXC_ERROR;
473: END;
474: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);

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

509: p_data => x_msg_data);
510: WHEN OTHERS THEN
511: ROLLBACK TO update_address_usages;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MSG_PUB.ADD;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,

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

510: WHEN OTHERS THEN
511: ROLLBACK TO update_address_usages;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MSG_PUB.ADD;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,

Line 565: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562:
563: IF p_usage_id IS NULL THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
566: -- Usage Id cannot be null. Please enter a valid Usage Id
567: FND_MSG_PUB.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569: ELSE

Line 578: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

574: WHERE usage_id = p_usage_id;
575:
576: EXCEPTION WHEN NO_DATA_FOUND THEN
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
579: -- Usage Id passed is not valid. Please enter a valid Usage Id.
580: FND_MSG_PUB.ADD;
581: RAISE FND_API.G_EXC_ERROR;
582:

Line 596: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOGRAPHY_TYPE_MAND');

592: WHILE i IS NOT NULL LOOP
593:
594: IF p_address_usage_dtls_tbl(i).geography_type IS NULL THEN
595: x_return_status := FND_API.G_RET_STS_ERROR;
596: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOGRAPHY_TYPE_MAND');
597: -- Please enter a valid geography type
598: FND_MSG_PUB.ADD;
599: RAISE FND_API.G_EXC_ERROR;
600: ELSE

Line 610: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');

606: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
607:
608: EXCEPTION WHEN NO_DATA_FOUND THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');
611: -- Geography Type does not mapped with a location
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614:

Line 649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');

645: --dbms_output.put_line('Before Gen pkg Create usage dtls : map id :'|| l_map_id);
646: BEGIN
647: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);
648: IF l_status = FND_API.G_RET_STS_ERROR THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653: EXCEPTION WHEN OTHERS THEN

Line 654: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653: EXCEPTION WHEN OTHERS THEN
654: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;
657: END;
658: --dbms_output.put_line('After Gen pkg Create usage dtls : map id :'|| l_map_id);

Line 688: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');

684: ROLLBACK TO create_address_usage_dtls;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
687: IF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
688: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
689: -- Usage detail ID already exists. Please use a unique ID.
690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN

Line 690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);

686: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
687: IF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
688: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
689: -- Usage detail ID already exists. Please use a unique ID.
690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);

Line 693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');

689: -- Usage detail ID already exists. Please use a unique ID.
690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
696: -- This geography type is already mapped for this usage.
697: FND_MSG_PUB.ADD;

Line 694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);

690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
696: -- This geography type is already mapped for this usage.
697: FND_MSG_PUB.ADD;
698: END IF;

Line 695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);

691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
696: -- This geography type is already mapped for this usage.
697: FND_MSG_PUB.ADD;
698: END IF;
699:

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

703: p_data => x_msg_data);
704: WHEN OTHERS THEN
705: ROLLBACK TO create_address_usage_dtls;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
708: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
709: FND_MSG_PUB.ADD;
710: FND_MSG_PUB.Count_And_Get(
711: p_encoded => FND_API.G_FALSE,

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

704: WHEN OTHERS THEN
705: ROLLBACK TO create_address_usage_dtls;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
708: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
709: FND_MSG_PUB.ADD;
710: FND_MSG_PUB.Count_And_Get(
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,

Line 759: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

755:
756: IF p_usage_id IS NULL THEN
757:
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
760: -- Usage Id cannot be null. Please enter a valid Usage Id
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_ERROR;
763:

Line 774: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

770: WHERE usage_id = p_usage_id;
771:
772: EXCEPTION WHEN NO_DATA_FOUND THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');
775: -- Usage Id passed is not valid. Please enter a valid Usage Id.
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_ERROR;
778: END;

Line 794: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_GEOTYPE_INVALID');

790: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
791:
792: EXCEPTION WHEN NO_DATA_FOUND THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_GEOTYPE_INVALID');
795: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',p_address_usage_dtls_tbl(i).geography_type);
796: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
797: -- Geography type does not exists for the given usage
798: FND_MSG_PUB.ADD;

Line 795: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',p_address_usage_dtls_tbl(i).geography_type);

791:
792: EXCEPTION WHEN NO_DATA_FOUND THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_GEOTYPE_INVALID');
795: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',p_address_usage_dtls_tbl(i).geography_type);
796: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
797: -- Geography type does not exists for the given usage
798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;

Line 796: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);

792: EXCEPTION WHEN NO_DATA_FOUND THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_GEOTYPE_INVALID');
795: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',p_address_usage_dtls_tbl(i).geography_type);
796: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
797: -- Geography type does not exists for the given usage
798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END;

Line 830: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_USAGE_DTL_MAND');

826: -- it means only 1 usage detail was there. Delete the usage only
827: -- usage detail will be deleted below
828: /*
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_USAGE_DTL_MAND');
831: -- At least two geography types are required for a usage
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: */

Line 884: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');

880: --dbms_output.put_line('Before Gen pkg Delete usage : map id :'|| l_map_id);
881: BEGIN
882: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);
883: IF l_status = FND_API.G_RET_STS_ERROR THEN
884: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
885: FND_MSG_PUB.ADD;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: EXCEPTION WHEN OTHERS THEN

Line 889: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

885: FND_MSG_PUB.ADD;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: EXCEPTION WHEN OTHERS THEN
889: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
890: FND_MSG_PUB.ADD;
891: RAISE FND_API.G_EXC_ERROR;
892: END;
893: --dbms_output.put_line('After Gen pkg Delete usage : map id :'|| l_map_id);

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

918: p_data => x_msg_data);
919: WHEN OTHERS THEN
920: ROLLBACK TO delete_address_usages;
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,

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

919: WHEN OTHERS THEN
920: ROLLBACK TO delete_address_usages;
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,