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

Line 84: FND_MSG_PUB.ADD;

80: THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MULTIPLE_GEO_COL');
82: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geography_id);
83: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_geography_type);
84: FND_MSG_PUB.ADD;
85: x_return_status := fnd_api.g_ret_sts_error;
86: END IF;
87: END LOOP;
88: CLOSE c_geo_parent;

Line 127: FND_MSG_PUB.ADD;

123: WHERE GEOGRAPHY_TYPE = l_geography_type;
124:
125: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
126: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
127: FND_MSG_PUB.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129:
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN

Line 244: FND_MSG_PUB.ADD;

240: WHEN NO_DATA_FOUND THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VALUE');
242: FND_MESSAGE.SET_TOKEN('VALUE', l_parent_geography_type);
243: FND_MESSAGE.SET_TOKEN('COLUMN', 'parent_geography_type');
244: FND_MSG_PUB.ADD;
245: RAISE FND_API.G_EXC_ERROR;
246: END;
247: -- check if geography_type is already 'PARENT_OF' parent_geography_type (bug fix 2838632)
248: SELECT count(*) INTO l_count FROM hz_relationship_types

Line 259: FND_MSG_PUB.ADD;

255: IF l_count > 0 THEN
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_REL_TYPE');
257: FND_MESSAGE.SET_TOKEN('CHILD', l_geography_type);
258: FND_MESSAGE.SET_TOKEN('PARENT', l_parent_geography_type);
259: FND_MSG_PUB.ADD;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:
263: --l_relationship_type_rec.relationship_type_id :=NULL;

Line 332: FND_MSG_PUB.ADD;

328: EXCEPTION WHEN NO_DATA_FOUND THEN
329: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');
331: FND_MESSAGE.SET_TOKEN('TOKEN2', 'relationship_type_id '||p_relationship_type_id);
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END;
335:
336: hz_utility_v2pub.validate_mandatory(

Line 421: FND_MSG_PUB.ADD;

417: IF l_country_code IS NULL THEN
418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
419: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code' );
420: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geo_structure_rec.geography_id );
421: FND_MSG_PUB.ADD;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: -- see whether this geography_element_column to be created is already being used with in this country

Line 438: FND_MSG_PUB.ADD;

434:
435: IF l_count > 0 THEN
436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
437: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;*/
441:
442: BEGIN

Line 658: FND_MSG_PUB.ADD;

654:
655: IF l_count > 0 THEN
656: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
657: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column for this geography_id' );
658: FND_MSG_PUB.ADD;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: BEGIN

Line 673: FND_MSG_PUB.ADD;

669:
670: IF p_object_version_number <> l_object_version_number THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: ELSE
676: p_object_version_number := l_object_version_number+1;
677: END IF;

Line 682: FND_MSG_PUB.ADD;

678: EXCEPTION WHEN NO_DATA_FOUND THEN
679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
680: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code , geography_element_column' );
681: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_ERROR;
684: END;
685:
686: BEGIN

Line 712: FND_MSG_PUB.ADD;

708: AND rownum <2;
709: --dbms_output.put_line('after execute');
710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_NONUPDATEABLE' );
711: --FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column' );
712: FND_MSG_PUB.ADD;
713: --x_return_status := FND_API.G_RET_STS_ERROR;
714: RAISE FND_API.G_EXC_ERROR;
715:
716: --dbms_output.put_line('l_count is '|| to_char(l_count));

Line 842: FND_MSG_PUB.ADD;

838:
839: IF l_error = TRUE THEN
840: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
841: FND_MESSAGE.SET_TOKEN( 'COLUMN', l_column );
842: FND_MSG_PUB.ADD;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:
846:

Line 860: FND_MSG_PUB.ADD;

856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
858: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'relationship_type_id,country_code' );
859: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;
863: -- code added for bug 4730508
864: BEGIN

Line 1350: FND_MSG_PUB.ADD;

1346: -- check if included_geography_type is COUNTRY and if yes, check for limited_by_geography_id to be null
1347: IF p_zone_type_rec.included_geography_type(i) = 'COUNTRY' THEN
1348: IF p_zone_type_rec.limited_by_geography_id IS NOT NULL THEN
1349: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');
1350: FND_MSG_PUB.ADD;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353: END IF;
1354:

Line 1378: FND_MSG_PUB.ADD;

1374:
1375: EXCEPTION WHEN NO_DATA_FOUND THEN
1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_INC_GEO_TYPE');
1377: FND_MESSAGE.SET_TOKEN('P_LIMITED_BY_GEOGRAPHY', l_limited_by_geo_type);
1378: FND_MSG_PUB.ADD;
1379: RAISE FND_API.G_EXC_ERROR;
1380: END;
1381: END IF;
1382:

Line 1504: FND_MSG_PUB.ADD;

1500: --validate object_version_number
1501: IF l_object_version_number <> p_object_version_number THEN
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');
1504: FND_MSG_PUB.ADD;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE
1507: p_object_version_number := l_object_version_number + 1;
1508: END IF;

Line 1514: FND_MSG_PUB.ADD;

1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1512: FND_MESSAGE.SET_TOKEN('TOKEN1','zone_type');
1513: FND_MESSAGE.SET_TOKEN('TOKEN2', 'zone_type '||p_geography_type);
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516:
1517: END;
1518:

Line 1548: FND_MSG_PUB.ADD;

1544: --dbms_output.put_line('l_count is '||to_char(l_count));
1545: IF l_count >0 THEN
1546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');
1548: FND_MSG_PUB.ADD;
1549: -- x_return_status := FND_API.G_RET_STS_ERROR;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552: END IF;

Line 1567: FND_MSG_PUB.ADD;

1563:
1564: IF l_count > 0 THEN
1565: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1566: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'limited_by_geography_id as there exists zones for this geography_type');
1567: FND_MSG_PUB.ADD;
1568: -- x_return_status := FND_API.G_RET_STS_ERROR;
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;

Line 1603: FND_MSG_PUB.ADD;

1599: -- check if included_geography_type is COUNTRY and if yes, check for limited_by_geography_id to be null
1600: IF p_zone_type_rec.included_geography_type(i) = 'COUNTRY' THEN
1601: IF p_zone_type_rec.limited_by_geography_id IS NOT NULL THEN
1602: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');
1603: FND_MSG_PUB.ADD;
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: END IF;
1607: Begin

Line 1738: FND_MSG_PUB.initialize;

1734: SAVEPOINT create_geography_type;
1735:
1736: -- Initialize message list if p_init_msg_list is set to TRUE.
1737: IF FND_API.to_Boolean(p_init_msg_list) THEN
1738: FND_MSG_PUB.initialize;
1739: END IF;
1740:
1741: -- Initialize API return status to success.
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1756: FND_MSG_PUB.Count_And_Get(

1752: RAISE FND_API.G_EXC_ERROR;
1753: END IF;
1754:
1755: -- Standard call to get message count and if count is 1, get message info.
1756: FND_MSG_PUB.Count_And_Get(
1757: p_encoded => FND_API.G_FALSE,
1758: p_count => x_msg_count,
1759: p_data => x_msg_data);
1760:

Line 1765: FND_MSG_PUB.Count_And_Get(

1761: EXCEPTION
1762: WHEN FND_API.G_EXC_ERROR THEN
1763: ROLLBACK TO create_geography_type;
1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: FND_MSG_PUB.Count_And_Get(
1766: p_encoded => FND_API.G_FALSE,
1767: p_count => x_msg_count,
1768: p_data => x_msg_data);
1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1772: FND_MSG_PUB.Count_And_Get(

1768: p_data => x_msg_data);
1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1770: ROLLBACK TO create_geography_type;
1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1772: FND_MSG_PUB.Count_And_Get(
1773: p_encoded => FND_API.G_FALSE,
1774: p_count => x_msg_count,
1775: p_data => x_msg_data);
1776:

Line 1784: FND_MSG_PUB.ADD;

1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;
1785: END IF;
1786: FND_MSG_PUB.Count_And_Get(
1787: p_encoded => FND_API.G_FALSE,
1788: p_count => x_msg_count,

Line 1786: FND_MSG_PUB.Count_And_Get(

1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;
1785: END IF;
1786: FND_MSG_PUB.Count_And_Get(
1787: p_encoded => FND_API.G_FALSE,
1788: p_count => x_msg_count,
1789: p_data => x_msg_data);
1790:

Line 1796: FND_MSG_PUB.ADD;

1792: ROLLBACK TO create_geography_type;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);

Line 1797: FND_MSG_PUB.Count_And_Get(

1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);
1801:

Line 1853: FND_MSG_PUB.initialize;

1849: SAVEPOINT create_geo_rel_type;
1850:
1851: -- Initialize message list if p_init_msg_list is set to TRUE.
1852: IF FND_API.to_Boolean(p_init_msg_list) THEN
1853: FND_MSG_PUB.initialize;
1854: END IF;
1855:
1856: -- Initialize API return status to success.
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1872: FND_MSG_PUB.Count_And_Get(

1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870:
1871: -- Standard call to get message count and if count is 1, get message info.
1872: FND_MSG_PUB.Count_And_Get(
1873: p_encoded => FND_API.G_FALSE,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data);
1876:

Line 1881: FND_MSG_PUB.Count_And_Get(

1877: EXCEPTION
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO create_geo_rel_type;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: FND_MSG_PUB.Count_And_Get(
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1888: FND_MSG_PUB.Count_And_Get(

1884: p_data => x_msg_data);
1885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1886: ROLLBACK TO create_geo_rel_type;
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: FND_MSG_PUB.Count_And_Get(
1889: p_encoded => FND_API.G_FALSE,
1890: p_count => x_msg_count,
1891: p_data => x_msg_data);
1892:

Line 1898: FND_MSG_PUB.ADD;

1894: ROLLBACK TO create_geo_rel_type;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1897: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: FND_MSG_PUB.Count_And_Get(
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data);

Line 1899: FND_MSG_PUB.Count_And_Get(

1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1897: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: FND_MSG_PUB.Count_And_Get(
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data);
1903:

Line 1956: FND_MSG_PUB.initialize;

1952: SAVEPOINT update_geo_rel_type;
1953:
1954: -- Initialize message list if p_init_msg_list is set to TRUE.
1955: IF FND_API.to_Boolean(p_init_msg_list) THEN
1956: FND_MSG_PUB.initialize;
1957: END IF;
1958:
1959: -- Initialize API return status to success.
1960: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1976: FND_MSG_PUB.Count_And_Get(

1972: RAISE FND_API.G_EXC_ERROR;
1973: END IF;
1974:
1975: -- Standard call to get message count and if count is 1, get message info.
1976: FND_MSG_PUB.Count_And_Get(
1977: p_encoded => FND_API.G_FALSE,
1978: p_count => x_msg_count,
1979: p_data => x_msg_data);
1980:

Line 1985: FND_MSG_PUB.Count_And_Get(

1981: EXCEPTION
1982: WHEN FND_API.G_EXC_ERROR THEN
1983: ROLLBACK TO update_geo_rel_type;
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1992: FND_MSG_PUB.Count_And_Get(

1988: p_data => x_msg_data);
1989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1990: ROLLBACK TO update_geo_rel_type;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1992: FND_MSG_PUB.Count_And_Get(
1993: p_encoded => FND_API.G_FALSE,
1994: p_count => x_msg_count,
1995: p_data => x_msg_data);
1996:

Line 2002: FND_MSG_PUB.ADD;

1998: ROLLBACK TO update_geo_rel_type;
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2000: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2001: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.Count_And_Get(
2004: p_encoded => FND_API.G_FALSE,
2005: p_count => x_msg_count,
2006: p_data => x_msg_data);

Line 2003: FND_MSG_PUB.Count_And_Get(

1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2000: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2001: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.Count_And_Get(
2004: p_encoded => FND_API.G_FALSE,
2005: p_count => x_msg_count,
2006: p_data => x_msg_data);
2007:

Line 2059: FND_MSG_PUB.initialize;

2055: SAVEPOINT create_geo_structure;
2056:
2057: -- Initialize message list if p_init_msg_list is set to TRUE.
2058: IF FND_API.to_Boolean(p_init_msg_list) THEN
2059: FND_MSG_PUB.initialize;
2060: END IF;
2061:
2062: -- Initialize API return status to success.
2063: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2077: FND_MSG_PUB.Count_And_Get(

2073: RAISE FND_API.G_EXC_ERROR;
2074: END IF;
2075:
2076: -- Standard call to get message count and if count is 1, get message info.
2077: FND_MSG_PUB.Count_And_Get(
2078: p_encoded => FND_API.G_FALSE,
2079: p_count => x_msg_count,
2080: p_data => x_msg_data);
2081:

Line 2086: FND_MSG_PUB.Count_And_Get(

2082: EXCEPTION
2083: WHEN FND_API.G_EXC_ERROR THEN
2084: ROLLBACK TO create_geo_structure;
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: FND_MSG_PUB.Count_And_Get(
2087: p_encoded => FND_API.G_FALSE,
2088: p_count => x_msg_count,
2089: p_data => x_msg_data);
2090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2093: FND_MSG_PUB.Count_And_Get(

2089: p_data => x_msg_data);
2090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2091: ROLLBACK TO create_geo_structure;
2092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2093: FND_MSG_PUB.Count_And_Get(
2094: p_encoded => FND_API.G_FALSE,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data);
2097:

Line 2104: FND_MSG_PUB.ADD;

2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.Count_And_Get(
2108: p_encoded => FND_API.G_FALSE,

Line 2107: FND_MSG_PUB.Count_And_Get(

2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.Count_And_Get(
2108: p_encoded => FND_API.G_FALSE,
2109: p_count => x_msg_count,
2110: p_data => x_msg_data);
2111:

Line 2117: FND_MSG_PUB.ADD;

2113: ROLLBACK TO create_geo_structure;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2117: FND_MSG_PUB.ADD;
2118: FND_MSG_PUB.Count_And_Get(
2119: p_encoded => FND_API.G_FALSE,
2120: p_count => x_msg_count,
2121: p_data => x_msg_data);

Line 2118: FND_MSG_PUB.Count_And_Get(

2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2117: FND_MSG_PUB.ADD;
2118: FND_MSG_PUB.Count_And_Get(
2119: p_encoded => FND_API.G_FALSE,
2120: p_count => x_msg_count,
2121: p_data => x_msg_data);
2122:

Line 2180: FND_MSG_PUB.initialize;

2176: SAVEPOINT update_geo_structure;
2177:
2178: -- Initialize message list if p_init_msg_list is set to TRUE.
2179: IF FND_API.to_Boolean(p_init_msg_list) THEN
2180: FND_MSG_PUB.initialize;
2181: END IF;
2182:
2183: -- Initialize API return status to success.
2184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2202: FND_MSG_PUB.Count_And_Get(

2198: RAISE FND_API.G_EXC_ERROR;
2199: END IF;
2200:
2201: -- Standard call to get message count and if count is 1, get message info.
2202: FND_MSG_PUB.Count_And_Get(
2203: p_encoded => FND_API.G_FALSE,
2204: p_count => x_msg_count,
2205: p_data => x_msg_data);
2206:

Line 2211: FND_MSG_PUB.Count_And_Get(

2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO update_geo_structure;
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: FND_MSG_PUB.Count_And_Get(
2212: p_encoded => FND_API.G_FALSE,
2213: p_count => x_msg_count,
2214: p_data => x_msg_data);
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2218: FND_MSG_PUB.Count_And_Get(

2214: p_data => x_msg_data);
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2216: ROLLBACK TO update_geo_structure;
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2218: FND_MSG_PUB.Count_And_Get(
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:

Line 2228: FND_MSG_PUB.ADD;

2224: ROLLBACK TO update_geo_structure;
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2228: FND_MSG_PUB.ADD;
2229: FND_MSG_PUB.Count_And_Get(
2230: p_encoded => FND_API.G_FALSE,
2231: p_count => x_msg_count,
2232: p_data => x_msg_data);

Line 2229: FND_MSG_PUB.Count_And_Get(

2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2228: FND_MSG_PUB.ADD;
2229: FND_MSG_PUB.Count_And_Get(
2230: p_encoded => FND_API.G_FALSE,
2231: p_count => x_msg_count,
2232: p_data => x_msg_data);
2233:

Line 2287: FND_MSG_PUB.initialize;

2283: SAVEPOINT delete_geo_structure;
2284:
2285: -- Initialize message list if p_init_msg_list is set to TRUE.
2286: IF FND_API.to_Boolean(p_init_msg_list) THEN
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:
2290: -- Initialize API return status to success.
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2307: FND_MSG_PUB.Count_And_Get(

2303: RAISE FND_API.G_EXC_ERROR;
2304: END IF;
2305:
2306: -- Standard call to get message count and if count is 1, get message info.
2307: FND_MSG_PUB.Count_And_Get(
2308: p_encoded => FND_API.G_FALSE,
2309: p_count => x_msg_count,
2310: p_data => x_msg_data);
2311:

Line 2316: FND_MSG_PUB.Count_And_Get(

2312: EXCEPTION
2313: WHEN FND_API.G_EXC_ERROR THEN
2314: ROLLBACK TO delete_geo_structure;
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: FND_MSG_PUB.Count_And_Get(
2317: p_encoded => FND_API.G_FALSE,
2318: p_count => x_msg_count,
2319: p_data => x_msg_data);
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2323: FND_MSG_PUB.Count_And_Get(

2319: p_data => x_msg_data);
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2321: ROLLBACK TO delete_geo_structure;
2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2323: FND_MSG_PUB.Count_And_Get(
2324: p_encoded => FND_API.G_FALSE,
2325: p_count => x_msg_count,
2326: p_data => x_msg_data);
2327:

Line 2333: FND_MSG_PUB.ADD;

2329: ROLLBACK TO delete_geo_structure;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2333: FND_MSG_PUB.ADD;
2334: FND_MSG_PUB.Count_And_Get(
2335: p_encoded => FND_API.G_FALSE,
2336: p_count => x_msg_count,
2337: p_data => x_msg_data);

Line 2334: FND_MSG_PUB.Count_And_Get(

2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2333: FND_MSG_PUB.ADD;
2334: FND_MSG_PUB.Count_And_Get(
2335: p_encoded => FND_API.G_FALSE,
2336: p_count => x_msg_count,
2337: p_data => x_msg_data);
2338:

Line 2388: FND_MSG_PUB.initialize;

2384: --dbms_output.put_line('In the beginning of create_master_geography');
2385:
2386: -- Initialize message list if p_init_msg_list is set to TRUE.
2387: IF FND_API.to_Boolean(p_init_msg_list) THEN
2388: FND_MSG_PUB.initialize;
2389: END IF;
2390:
2391: -- Initialize API return status to success.
2392: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2407: FND_MSG_PUB.Count_And_Get(

2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405:
2406: -- Standard call to get message count and if count is 1, get message info.
2407: FND_MSG_PUB.Count_And_Get(
2408: p_encoded => FND_API.G_FALSE,
2409: p_count => x_msg_count,
2410: p_data => x_msg_data);
2411:

Line 2416: FND_MSG_PUB.Count_And_Get(

2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO create_zone_type;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: FND_MSG_PUB.Count_And_Get(
2417: p_encoded => FND_API.G_FALSE,
2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2423: FND_MSG_PUB.Count_And_Get(

2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: ROLLBACK TO create_zone_type;
2422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2423: FND_MSG_PUB.Count_And_Get(
2424: p_encoded => FND_API.G_FALSE,
2425: p_count => x_msg_count,
2426: p_data => x_msg_data);
2427:

Line 2435: FND_MSG_PUB.ADD;

2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;
2436: END IF;
2437: FND_MSG_PUB.Count_And_Get(
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,

Line 2437: FND_MSG_PUB.Count_And_Get(

2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;
2436: END IF;
2437: FND_MSG_PUB.Count_And_Get(
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,
2440: p_data => x_msg_data);
2441:

Line 2447: FND_MSG_PUB.ADD;

2443: ROLLBACK TO create_zone_type;
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2447: FND_MSG_PUB.ADD;
2448: FND_MSG_PUB.Count_And_Get(
2449: p_encoded => FND_API.G_FALSE,
2450: p_count => x_msg_count,
2451: p_data => x_msg_data);

Line 2448: FND_MSG_PUB.Count_And_Get(

2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2447: FND_MSG_PUB.ADD;
2448: FND_MSG_PUB.Count_And_Get(
2449: p_encoded => FND_API.G_FALSE,
2450: p_count => x_msg_count,
2451: p_data => x_msg_data);
2452:

Line 2504: FND_MSG_PUB.initialize;

2500: SAVEPOINT update_zone_type;
2501:
2502: -- Initialize message list if p_init_msg_list is set to TRUE.
2503: IF FND_API.to_Boolean(p_init_msg_list) THEN
2504: FND_MSG_PUB.initialize;
2505: END IF;
2506:
2507: -- Initialize API return status to success.
2508: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2524: FND_MSG_PUB.Count_And_Get(

2520: RAISE FND_API.G_EXC_ERROR;
2521: END IF;
2522:
2523: -- Standard call to get message count and if count is 1, get message info.
2524: FND_MSG_PUB.Count_And_Get(
2525: p_encoded => FND_API.G_FALSE,
2526: p_count => x_msg_count,
2527: p_data => x_msg_data);
2528:

Line 2533: FND_MSG_PUB.Count_And_Get(

2529: EXCEPTION
2530: WHEN FND_API.G_EXC_ERROR THEN
2531: ROLLBACK TO update_zone_type;
2532: x_return_status := FND_API.G_RET_STS_ERROR;
2533: FND_MSG_PUB.Count_And_Get(
2534: p_encoded => FND_API.G_FALSE,
2535: p_count => x_msg_count,
2536: p_data => x_msg_data);
2537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2540: FND_MSG_PUB.Count_And_Get(

2536: p_data => x_msg_data);
2537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2538: ROLLBACK TO update_zone_type;
2539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2540: FND_MSG_PUB.Count_And_Get(
2541: p_encoded => FND_API.G_FALSE,
2542: p_count => x_msg_count,
2543: p_data => x_msg_data);
2544:

Line 2550: FND_MSG_PUB.ADD;

2546: ROLLBACK TO update_zone_type;
2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2549: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2550: FND_MSG_PUB.ADD;
2551: FND_MSG_PUB.Count_And_Get(
2552: p_encoded => FND_API.G_FALSE,
2553: p_count => x_msg_count,
2554: p_data => x_msg_data);

Line 2551: FND_MSG_PUB.Count_And_Get(

2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2549: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2550: FND_MSG_PUB.ADD;
2551: FND_MSG_PUB.Count_And_Get(
2552: p_encoded => FND_API.G_FALSE,
2553: p_count => x_msg_count,
2554: p_data => x_msg_data);
2555: