DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on STANDARD

Line 1733: -- Standard start of API savepoint

1729: --l_geography_type_rec GEOGRAPHY_TYPE_REC_TYPE := p_geography_type_rec;
1730: p_index_name VARCHAR2(30);
1731:
1732: BEGIN
1733: -- Standard start of API savepoint
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

Line 1755: -- Standard call to get message count and if count is 1, get message info.

1751: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 1848: -- Standard start of API savepoint

1844: l_geo_rel_type_rec geo_rel_type_REC_TYPE := p_geo_rel_type_rec;
1845:
1846: BEGIN
1847:
1848: -- Standard start of API savepoint
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

Line 1871: -- Standard call to get message count and if count is 1, get message info.

1867: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 1951: -- Standard start of API savepoint

1947: --l_geo_rel_type_rec geo_rel_type_REC_TYPE := p_geo_rel_type_rec;
1948:
1949: BEGIN
1950:
1951: -- Standard start of API savepoint
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

Line 1975: -- Standard call to get message count and if count is 1, get message info.

1971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 2054: -- Standard start of API savepoint

2050: p_index_name VARCHAR2(30);
2051:
2052: BEGIN
2053:
2054: -- Standard start of API savepoint
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

Line 2076: -- Standard call to get message count and if count is 1, get message info.

2072: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 2175: -- Standard start of API savepoint

2171: ) IS
2172:
2173: BEGIN
2174:
2175: -- Standard start of API savepoint
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

Line 2201: -- Standard call to get message count and if count is 1, get message info.

2197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 2282: -- Standard start of API savepoint

2278:
2279:
2280: BEGIN
2281:
2282: -- Standard start of API savepoint
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

Line 2306: -- Standard call to get message count and if count is 1, get message info.

2302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 2382: -- Standard start of API savepoint

2378:
2379: p_index_name VARCHAR2(30);
2380:
2381: BEGIN
2382: -- Standard start of API savepoint
2383: SAVEPOINT create_zone_type;
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.

Line 2406: -- Standard call to get message count and if count is 1, get message info.

2402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 2499: -- Standard start of API savepoint

2495: ) IS
2496:
2497: BEGIN
2498:
2499: -- Standard start of API savepoint
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

Line 2523: -- Standard call to get message count and if count is 1, get message info.

2519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);