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_MESSAGE

Line 82: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ADDRESS_STYLE_INVALID');

78: AND descriptive_flex_context_code = p_context;
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;

Line 235: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');

231: -- Location table name is mandatory
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:

Line 244: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');

240: -- Country code is mandatory
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:

Line 256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');

252:
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:

Line 271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_INVALID');

267: WHERE territory_code = UPPER(p_geo_struct_map_rec.country_code);
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;

Line 295: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');

291: -- Not more than 10 rows can be passed in map details
292:
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:

Line 302: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');

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

Line 371: FND_MESSAGE.SET_NAME('AR', l_error_code);

367: i := p_geo_struct_map_dtl_tbl.next(i);
368: END LOOP;
369:
370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 373: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);

369:
370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 383: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

379:
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:

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

393: BEGIN
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';

Line 421: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');

417: i := l_geo_struct_map_dtl_tbl.next(i);
418: END LOOP;
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;

Line 422: FND_MESSAGE.SET_TOKEN('GEOTYPE',l_geo_struct_map_dtl_tbl(i).geo_type);

418: END LOOP;
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;

Line 534: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_MAP_ID');

530: ROLLBACK TO create_geo_struct_map;
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');

Line 538: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MAP_ROW_EXISTS');

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

Line 539: FND_MESSAGE.SET_TOKEN('TABLENAME', p_geo_struct_map_rec.loc_tbl_name);

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

Line 540: FND_MESSAGE.SET_TOKEN('COUNTRY', p_geo_struct_map_rec.country_code);

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

Line 541: FND_MESSAGE.SET_TOKEN('ADDRSTYLE', p_geo_struct_map_rec.address_style);

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

Line 545: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

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;
547:
548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');

Line 549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');

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;
551:
552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

Line 553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

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;
555: END IF;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,

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

559: p_data => x_msg_data);
560: WHEN OTHERS THEN
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,

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

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

Line 622: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');

618: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 629: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');

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

Line 644: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');

640: AND loc_tbl_name = p_location_table_name
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

Line 661: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');

657: AND loc_tbl_name = p_location_table_name
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;

Line 678: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');

674: WHERE map_id = p_map_id;
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

Line 715: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');

711: l_delete_mapping_also := 'Y';
712: EXCEPTION WHEN NO_DATA_FOUND THEN
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: */

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

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

Line 750: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');

746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
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;

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

782: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
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

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

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

Line 818: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');

814: x_return_status => l_return_status,
815: x_msg_count => l_msg_count,
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;

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

853: p_count => x_msg_count,
854: p_data => x_msg_data);
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,

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

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

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

928: CLOSE c_struct_map;
929:
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;

Line 946: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');

942:
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:

Line 978: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');

974: END IF;
975:
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;

Line 979: FND_MESSAGE.SET_TOKEN('GEOTYPE',p_geo_struct_map_dtl_tbl(i).geo_type);

975:
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:

Line 1021: FND_MESSAGE.SET_NAME('AR', l_error_code);

1017:
1018: END LOOP;
1019:
1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 1023: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);

1019:
1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 1080: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1078:
1079: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1080: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
1081: -- Changed the error message from HZ_GEO_DUP_LOC_SEQ_NUM to HZ_GEO_DUP_GEO_TYPE
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.

Line 1085: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

1081: -- Changed the error message from HZ_GEO_DUP_LOC_SEQ_NUM to HZ_GEO_DUP_GEO_TYPE
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');

Line 1089: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');

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;
1091:
1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

Line 1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

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;
1095: END IF;
1096:
1097: FND_MSG_PUB.Count_And_Get(

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

1100: p_data => x_msg_data);
1101: WHEN OTHERS THEN
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,

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

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

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

1166: CLOSE c_struct_map;
1167:
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;

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

1184: CLOSE c_struct_map_dtl;
1185:
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;

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

1234: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
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

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

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

Line 1279: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

1275: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');

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;
1285:
1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

Line 1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');

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;
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get(

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

1294: p_data => x_msg_data);
1295: WHEN OTHERS THEN
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,

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

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