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_MSG_PUB

Line 40: FND_MSG_PUB.ADD;

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
43: BEGIN
44: SELECT map_id

Line 53: FND_MSG_PUB.ADD;

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:
56: END;
57: END IF;

Line 65: FND_MSG_PUB.ADD;

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
68: BEGIN
69: SELECT lookup_code

Line 78: FND_MSG_PUB.ADD;

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;
81: END IF;
82:

Line 87: FND_MSG_PUB.ADD;

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;
90:
91: -- Validate that one of the geography_type passed is COUNTRY

Line 108: FND_MSG_PUB.ADD;

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;
111:
112: -- Call table handler to insert row and make a

Line 143: FND_MSG_PUB.ADD;

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
146: BEGIN
147: SELECT 'X'

Line 157: FND_MSG_PUB.ADD;

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:
160: END;
161: END IF;

Line 193: FND_MSG_PUB.ADD;

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
196: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_ROW_EXISTS');
197: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);

Line 199: FND_MSG_PUB.ADD;

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

Line 205: FND_MSG_PUB.ADD;

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
208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);

Line 212: FND_MSG_PUB.ADD;

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:
215: END do_create_address_usages;
216:

Line 237: FND_MSG_PUB.initialize;

233: SAVEPOINT create_address_usages;
234:
235: -- Initialize message list if p_init_msg_list is set to TRUE.
236: IF FND_API.to_Boolean(p_init_msg_list) THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:
240: -- Initialize API return status to success.
241: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 263: FND_MSG_PUB.ADD;

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
267: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 268: 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);
272: END IF;

Line 275: FND_MSG_PUB.Count_And_Get(

271: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
272: END IF;
273:
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data);
279:

Line 284: FND_MSG_PUB.Count_And_Get(

280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO create_address_usages;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MSG_PUB.Count_And_Get(
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data);
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 291: FND_MSG_PUB.Count_And_Get(

287: p_data => x_msg_data);
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: ROLLBACK TO create_address_usages;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: FND_MSG_PUB.Count_And_Get(
292: p_encoded => FND_API.G_FALSE,
293: p_count => x_msg_count,
294: p_data => x_msg_data);
295: WHEN OTHERS THEN

Line 300: FND_MSG_PUB.ADD;

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

Line 301: FND_MSG_PUB.Count_And_Get(

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

Line 349: FND_MSG_PUB.initialize;

345: SAVEPOINT update_address_usages;
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 371: FND_MSG_PUB.ADD;

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;
374: ELSE
375:

Line 380: FND_MSG_PUB.ADD;

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;
383:
384: IF p_usage_code IS NULL THEN

Line 388: FND_MSG_PUB.ADD;

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;
391:
392: -- Check the valid combination for map_id and usage_code

Line 407: FND_MSG_PUB.ADD;

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;
410:
411: END IF;

Line 416: FND_MSG_PUB.ADD;

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:
420: hz_address_usages_pkg.Lock_Row (

Line 466: FND_MSG_PUB.ADD;

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
470: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 471: 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);
475: ELSE

Line 490: FND_MSG_PUB.Count_And_Get(

486: END;
487: END IF;
488:
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:

Line 499: FND_MSG_PUB.Count_And_Get(

495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO update_address_usages;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: FND_MSG_PUB.Count_And_Get(
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 506: FND_MSG_PUB.Count_And_Get(

502: p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO update_address_usages;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: FND_MSG_PUB.Count_And_Get(
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN OTHERS THEN

Line 515: FND_MSG_PUB.ADD;

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

Line 516: FND_MSG_PUB.Count_And_Get(

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

Line 557: FND_MSG_PUB.initialize;

553: SAVEPOINT create_address_usage_dtls;
554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean(p_init_msg_list) THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559:
560: -- Initialize API return status to success.
561: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 567: FND_MSG_PUB.ADD;

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
570: BEGIN
571: SELECT map_id, usage_code, status_flag

Line 580: FND_MSG_PUB.ADD;

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:
583: END;
584: END IF;

Line 598: FND_MSG_PUB.ADD;

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
601: BEGIN
602: SELECT 'X'

Line 612: FND_MSG_PUB.ADD;

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:
615: END;
616: END IF;

Line 650: FND_MSG_PUB.ADD;

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
654: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 655: 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);
659: END IF;

Line 662: FND_MSG_PUB.Count_And_Get(

658: --dbms_output.put_line('After Gen pkg Create usage dtls : map id :'|| l_map_id);
659: END IF;
660:
661: -- Standard call to get message count and if count is 1, get message info.
662: FND_MSG_PUB.Count_And_Get(
663: p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666:

Line 671: FND_MSG_PUB.Count_And_Get(

667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO create_address_usage_dtls;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MSG_PUB.Count_And_Get(
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data);
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 678: FND_MSG_PUB.Count_And_Get(

674: p_data => x_msg_data);
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO create_address_usage_dtls;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: FND_MSG_PUB.Count_And_Get(
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:

Line 691: FND_MSG_PUB.ADD;

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);
695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);

Line 697: FND_MSG_PUB.ADD;

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:
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,

Line 700: FND_MSG_PUB.Count_And_Get(

696: -- This geography type is already mapped for this usage.
697: FND_MSG_PUB.ADD;
698: END IF;
699:
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data);
704: WHEN OTHERS THEN

Line 709: FND_MSG_PUB.ADD;

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

Line 710: FND_MSG_PUB.Count_And_Get(

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

Line 750: FND_MSG_PUB.initialize;

746: SAVEPOINT delete_address_usages;
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean(p_init_msg_list) THEN
750: FND_MSG_PUB.initialize;
751: END IF;
752:
753: -- Initialize API return status to success.
754: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 761: FND_MSG_PUB.ADD;

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:
764: ELSE
765:

Line 776: FND_MSG_PUB.ADD;

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;
779:
780: IF p_address_usage_dtls_tbl.COUNT > 0 THEN

Line 798: FND_MSG_PUB.ADD;

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;
801:
802: BEGIN

Line 832: FND_MSG_PUB.ADD;

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: */
835: hz_address_usages_pkg.delete_row(p_usage_id);
836: i := p_address_usage_dtls_tbl.LAST;

Line 885: FND_MSG_PUB.ADD;

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
889: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 890: 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);
894: END IF;

Line 899: FND_MSG_PUB.Count_And_Get(

895: END IF;
896: END IF;
897:
898: -- Standard call to get message count and if count is 1, get message info.
899: FND_MSG_PUB.Count_And_Get(
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data);
903:

Line 908: FND_MSG_PUB.Count_And_Get(

904: EXCEPTION
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO delete_address_usages;
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: FND_MSG_PUB.Count_And_Get(
909: p_encoded => FND_API.G_FALSE,
910: p_count => x_msg_count,
911: p_data => x_msg_data);
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 915: FND_MSG_PUB.Count_And_Get(

911: p_data => x_msg_data);
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
913: ROLLBACK TO delete_address_usages;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: FND_MSG_PUB.Count_And_Get(
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data);
919: WHEN OTHERS THEN

Line 924: FND_MSG_PUB.ADD;

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

Line 925: FND_MSG_PUB.Count_And_Get(

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