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_STRUCT_MAP_PUB dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.ADD;

79:
80: EXCEPTION WHEN NO_DATA_FOUND THEN
81: x_ret_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ADDRESS_STYLE_INVALID');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END;
86: END;
87:

Line 236: FND_MSG_PUB.ADD;

232:
233: IF p_geo_struct_map_rec.loc_tbl_name IS NULL THEN
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
236: FND_MSG_PUB.ADD;
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: -- Country code is mandatory

Line 245: FND_MSG_PUB.ADD;

241:
242: IF p_geo_struct_map_rec.country_code IS NULL THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- location table name should be one of

Line 257: FND_MSG_PUB.ADD;

253: IF UPPER(p_geo_struct_map_rec.loc_tbl_name) NOT IN ('HR_LOCATIONS_ALL',
254: 'HZ_LOCATIONS') THEN
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260:
261: -- country should exist in fnd_territories

Line 272: FND_MSG_PUB.ADD;

268:
269: EXCEPTION WHEN NO_DATA_FOUND THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_INVALID');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274:
275: END;
276:

Line 297: FND_MSG_PUB.ADD;

293: IF p_geo_struct_map_dtl_tbl.COUNT < 2 THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
296: -- Please enter at least two location components.
297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299:
300: ELSIF p_geo_struct_map_dtl_tbl.COUNT > 10 THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;

Line 303: FND_MSG_PUB.ADD;

299:
300: ELSIF p_geo_struct_map_dtl_tbl.COUNT > 10 THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305:
306: END IF;
307:

Line 375: FND_MSG_PUB.ADD;

371: FND_MESSAGE.SET_NAME('AR', l_error_code);
372: IF l_token_value IS NOT NULL THEN
373: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
374: END IF;
375: FND_MSG_PUB.ADD;
376: RAISE FND_API.G_EXC_ERROR;
377: END IF;
378: END;
379:

Line 384: FND_MSG_PUB.ADD;

380: BEGIN
381: IF p_geo_struct_map_dtl_tbl.count <> l_geo_struct_map_dtl_tbl.count THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: END;

Line 398: FND_MSG_PUB.ADD;

394: i := l_geo_struct_map_dtl_tbl.first;
395: IF l_geo_struct_map_dtl_tbl(i).geo_type <> 'COUNTRY' THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
398: FND_MSG_PUB.ADD;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE
401: l_geo_struct_map_dtl_tbl(i).geo_element_col := 'GEOGRAPHY_ELEMENT1';
402: END IF;

Line 423: FND_MSG_PUB.ADD;

419:
420: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
421: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('GEOTYPE',l_geo_struct_map_dtl_tbl(i).geo_type);
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: END;
427:

Line 488: FND_MSG_PUB.initialize;

484: SAVEPOINT create_geo_struct_map;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Initialize API return status to success.
492: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 508: FND_MSG_PUB.Count_And_Get(

504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: -- Standard call to get message count and if count is 1, get message info.
508: FND_MSG_PUB.Count_And_Get(
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data);
512:

Line 517: FND_MSG_PUB.Count_And_Get(

513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO create_geo_struct_map;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 524: FND_MSG_PUB.Count_And_Get(

520: p_data => x_msg_data);
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO create_geo_struct_map;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.Count_And_Get(
525: p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => x_msg_data);
528:

Line 535: FND_MSG_PUB.ADD;

531: x_return_status := FND_API.G_RET_STS_ERROR;
532: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
533: IF p_index_name = 'HZ_GEO_STRUCT_MAP_U1' THEN
534: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_MAP_ID');
535: FND_MSG_PUB.ADD;
536:
537: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_U2' THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MAP_ROW_EXISTS');
539: FND_MESSAGE.SET_TOKEN('TABLENAME', p_geo_struct_map_rec.loc_tbl_name);

Line 542: FND_MSG_PUB.ADD;

538: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MAP_ROW_EXISTS');
539: FND_MESSAGE.SET_TOKEN('TABLENAME', p_geo_struct_map_rec.loc_tbl_name);
540: FND_MESSAGE.SET_TOKEN('COUNTRY', p_geo_struct_map_rec.country_code);
541: FND_MESSAGE.SET_TOKEN('ADDRSTYLE', p_geo_struct_map_rec.address_style);
542: FND_MSG_PUB.ADD;
543:
544: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
545: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
546: FND_MSG_PUB.ADD;

Line 546: FND_MSG_PUB.ADD;

542: FND_MSG_PUB.ADD;
543:
544: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
545: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
546: FND_MSG_PUB.ADD;
547:
548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
550: FND_MSG_PUB.ADD;

Line 550: FND_MSG_PUB.ADD;

546: FND_MSG_PUB.ADD;
547:
548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
550: FND_MSG_PUB.ADD;
551:
552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
554: FND_MSG_PUB.ADD;

Line 554: FND_MSG_PUB.ADD;

550: FND_MSG_PUB.ADD;
551:
552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
554: FND_MSG_PUB.ADD;
555: END IF;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_msg_count,

Line 556: FND_MSG_PUB.Count_And_Get(

552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
554: FND_MSG_PUB.ADD;
555: END IF;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_msg_count,
559: p_data => x_msg_data);
560: WHEN OTHERS THEN

Line 565: FND_MSG_PUB.ADD;

561: ROLLBACK TO create_geo_struct_map;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);

Line 566: FND_MSG_PUB.Count_And_Get(

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570:

Line 623: FND_MSG_PUB.ADD;

619: IF p_map_id IS NULL THEN
620: IF p_location_table_name IS NULL THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626:
627: IF p_country IS NULL THEN

Line 630: FND_MSG_PUB.ADD;

626:
627: IF p_country IS NULL THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
630: FND_MSG_PUB.ADD;
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634: IF p_address_style IS NULL THEN

Line 645: FND_MSG_PUB.ADD;

641: AND address_style IS NULL;
642: EXCEPTION WHEN NO_DATA_FOUND THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
645: FND_MSG_PUB.ADD;
646:
647: END;
648: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
649: RAISE FND_API.G_EXC_ERROR;

Line 662: FND_MSG_PUB.ADD;

658: AND address_style = p_address_style;
659: EXCEPTION WHEN NO_DATA_FOUND THEN
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
662: FND_MSG_PUB.ADD;
663: END;
664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;

Line 679: FND_MSG_PUB.ADD;

675:
676: EXCEPTION WHEN NO_DATA_FOUND THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
679: FND_MSG_PUB.ADD;
680: END;
681:
682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;

Line 717: FND_MSG_PUB.ADD;

713: /*
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
716: -- At least two location components is required for the mapping
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;
719: */
720: -- only 1 mapping detail that will be deleted below, so just delete the
721: -- mapping itself.

Line 730: FND_MSG_PUB.ADD;

726:
727: IF p_geo_struct_map_dtl_tbl(i).geo_type = 'COUNTRY' THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
730: FND_MSG_PUB.ADD;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733: END;
734:

Line 752: FND_MSG_PUB.ADD;

748: x_msg_data => l_msg_data);
749: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
750: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
751: -- Error in Usage Delete API
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: END LOOP;
756: CLOSE c_address_usage_dtls;

Line 787: FND_MSG_PUB.ADD;

783: BEGIN
784: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
785: IF l_status = FND_API.G_RET_STS_ERROR THEN
786: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: EXCEPTION WHEN OTHERS THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 792: FND_MSG_PUB.ADD;

788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: EXCEPTION WHEN OTHERS THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END;
795: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
796: */

Line 820: FND_MSG_PUB.ADD;

816: x_msg_data => l_msg_data);
817: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
818: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
819: -- Error in Usage Delete API
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: END IF;
824:

Line 851: FND_MSG_PUB.Count_And_Get(

847: -- EXECUTE IMMEDIATE l_drp_sql;
848:
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:

Line 859: FND_MSG_PUB.ADD;

855:
856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MSG_PUB.ADD;
860: FND_MSG_PUB.Count_And_Get(
861: p_encoded => FND_API.G_FALSE,
862: p_count => x_msg_count,
863: p_data => x_msg_data);

Line 860: FND_MSG_PUB.Count_And_Get(

856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MSG_PUB.ADD;
860: FND_MSG_PUB.Count_And_Get(
861: p_encoded => FND_API.G_FALSE,
862: p_count => x_msg_count,
863: p_data => x_msg_data);
864:

Line 918: FND_MSG_PUB.initialize;

914: SAVEPOINT create_geo_struct_map_dtls;
915:
916: -- Initialize message list if p_init_msg_list is set to TRUE.
917: IF FND_API.to_Boolean(p_init_msg_list) THEN
918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: -- Initialize API return status to success.
922: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 934: FND_MSG_PUB.ADD;

930: IF (l_country IS NULL OR l_loc_tbl_name IS NULL) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
933: -- Please pass a valid map ID that is not NULL.
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: l_map_dtl_count := 0;

Line 947: FND_MSG_PUB.ADD;

943: -- Not more than 10 rows can be created in map details
944: IF (p_geo_struct_map_dtl_tbl.COUNT+l_map_dtl_count) > 10 THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950:
951: -- sort the map details table into a temporary

Line 980: FND_MSG_PUB.ADD;

976: IF (l_loc_seq_num IS NULL OR l_geo_element_column IS NULL) THEN
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('GEOTYPE',p_geo_struct_map_dtl_tbl(i).geo_type);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN

Line 1025: FND_MSG_PUB.ADD;

1021: FND_MESSAGE.SET_NAME('AR', l_error_code);
1022: IF l_token_value IS NOT NULL THEN
1023: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
1024: END IF;
1025: FND_MSG_PUB.ADD;
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: END;
1029:

Line 1054: FND_MSG_PUB.Count_And_Get(

1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get(
1055: p_encoded => FND_API.G_FALSE,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data);
1058:

Line 1063: FND_MSG_PUB.Count_And_Get(

1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO create_geo_struct_map_dtls;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: FND_MSG_PUB.Count_And_Get(
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data);
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1070: FND_MSG_PUB.Count_And_Get(

1066: p_data => x_msg_data);
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1068: ROLLBACK TO create_geo_struct_map_dtls;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data);
1074: WHEN DUP_VAL_ON_INDEX THEN

Line 1086: FND_MSG_PUB.ADD;

1082: -- In the new design we are overriding the LOC_SEQ_NUM passed by the user
1083: -- and deriving it based on GEO_TYPE. So, it is better to display GEO_TYPE
1084: -- unique index error message for LOC_SEQ_NUM also.
1085: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1086: FND_MSG_PUB.ADD;
1087:
1088: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1090: FND_MSG_PUB.ADD;

Line 1090: FND_MSG_PUB.ADD;

1086: FND_MSG_PUB.ADD;
1087:
1088: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1090: FND_MSG_PUB.ADD;
1091:
1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1094: FND_MSG_PUB.ADD;

Line 1094: FND_MSG_PUB.ADD;

1090: FND_MSG_PUB.ADD;
1091:
1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096:
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,

Line 1097: FND_MSG_PUB.Count_And_Get(

1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096:
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101: WHEN OTHERS THEN

Line 1106: FND_MSG_PUB.ADD;

1102: ROLLBACK TO create_geo_struct_map_dtls;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1105: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1106: FND_MSG_PUB.ADD;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);

Line 1107: FND_MSG_PUB.Count_And_Get(

1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1105: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1106: FND_MSG_PUB.ADD;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:

Line 1156: FND_MSG_PUB.initialize;

1152: SAVEPOINT update_geo_struct_map_dtls;
1153:
1154: -- Initialize message list if p_init_msg_list is set to TRUE.
1155: IF FND_API.to_Boolean(p_init_msg_list) THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success.
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1172: FND_MSG_PUB.ADD;

1168: IF (l_country IS NULL OR l_loc_tbl_name IS NULL) THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
1171: -- Please pass a valid map ID that is not NULL.
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176: IF p_geo_struct_map_dtl_tbl.COUNT > 0 THEN

Line 1190: FND_MSG_PUB.ADD;

1186: IF (l_loc_seq_num IS NULL OR l_geo_element_column IS NULL) THEN
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');
1189: -- A mapping does not exist for this geography type. Please map the geography type.
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN

Line 1239: FND_MSG_PUB.ADD;

1235: BEGIN
1236: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
1237: IF l_status = FND_API.G_RET_STS_ERROR THEN
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242: EXCEPTION WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');

Line 1244: FND_MSG_PUB.ADD;

1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242: EXCEPTION WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
1244: FND_MSG_PUB.ADD;
1245: RAISE FND_API.G_EXC_ERROR;
1246: END;
1247: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
1248: END IF;

Line 1253: FND_MSG_PUB.Count_And_Get(

1249:
1250: END IF;
1251:
1252: -- Standard call to get message count and if count is 1, get message info.
1253: FND_MSG_PUB.Count_And_Get(
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,
1256: p_data => x_msg_data);
1257:

Line 1262: FND_MSG_PUB.Count_And_Get(

1258: EXCEPTION
1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO update_geo_struct_map_dtls;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1269: FND_MSG_PUB.Count_And_Get(

1265: p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO update_geo_struct_map_dtls;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273: WHEN DUP_VAL_ON_INDEX THEN

Line 1280: FND_MSG_PUB.ADD;

1276: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1277:
1278: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1279: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
1280: FND_MSG_PUB.ADD;
1281:
1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1284: FND_MSG_PUB.ADD;

Line 1284: FND_MSG_PUB.ADD;

1280: FND_MSG_PUB.ADD;
1281:
1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1284: FND_MSG_PUB.ADD;
1285:
1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1288: FND_MSG_PUB.ADD;

Line 1288: FND_MSG_PUB.ADD;

1284: FND_MSG_PUB.ADD;
1285:
1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1288: FND_MSG_PUB.ADD;
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,

Line 1291: FND_MSG_PUB.Count_And_Get(

1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1288: FND_MSG_PUB.ADD;
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: WHEN OTHERS THEN

Line 1300: FND_MSG_PUB.ADD;

1296: ROLLBACK TO update_geo_struct_map_dtls;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);

Line 1301: FND_MSG_PUB.Count_And_Get(

1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305: