DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on FND_API

Line 1537: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

1533: l_plan_ids number_tab;
1534: l_occurrences number_tab;
1535: BEGIN
1536:
1537: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1538:
1539: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1540: FND_LOG.string
1541: (

Line 1553: IF NOT FND_API.Compatible_API_Call

1549: -- Standard Start of API savepoint
1550: SAVEPOINT process_txn_post_commit_GRP;
1551:
1552: -- Standard call to check for call compatibility.
1553: IF NOT FND_API.Compatible_API_Call
1554: (
1555: l_api_version,
1556: NVL( p_api_version, 1.0 ),
1557: l_api_name,

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556: NVL( p_api_version, 1.0 ),
1557: l_api_name,
1558: g_pkg_name
1559: ) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;
1562:
1563: -- Initialize message list if p_init_msg_list is set to TRUE.
1564: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 1564: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;
1562:
1563: -- Initialize message list if p_init_msg_list is set to TRUE.
1564: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1565: FND_MSG_PUB.initialize;
1566: END IF;
1567:
1568: -- Initialize API return status to success

Line 1569: x_return_status := FND_API.G_RET_STS_SUCCESS;

1565: FND_MSG_PUB.initialize;
1566: END IF;
1567:
1568: -- Initialize API return status to success
1569: x_return_status := FND_API.G_RET_STS_SUCCESS;
1570:
1571: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1572: FND_LOG.string
1573: (

Line 1684: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1680: p_collection_id => p_collection_id,
1681: p_return_status => l_return_status
1682: );
1683:
1684: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1681: p_return_status => l_return_status
1682: );
1683:
1684: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string

Line 1711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1707: FALSE,
1708: 'DEFERRED' ,
1709: 'COLLECTION_ID'
1710: ) = FALSE ) THEN
1711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1712: END IF;
1713:
1714: -- Commit (if requested)
1715: IF ( l_commit ) THEN

Line 1737: WHEN FND_API.G_EXC_ERROR THEN

1733: END IF;
1734:
1735: EXCEPTION
1736:
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: ROLLBACK TO process_txn_post_commit_GRP;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.Count_And_Get
1741: (

Line 1739: x_return_status := FND_API.G_RET_STS_ERROR;

1735: EXCEPTION
1736:
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: ROLLBACK TO process_txn_post_commit_GRP;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.Count_And_Get
1741: (
1742: p_count => x_msg_count,
1743: p_data => x_msg_data

Line 1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1751: 'EXITING PROCEDURE: ERROR'
1752: );
1753: END IF;
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756: ROLLBACK TO process_txn_post_commit_GRP;
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1753: END IF;
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756: ROLLBACK TO process_txn_post_commit_GRP;
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,
1761: p_data => x_msg_data

Line 1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1771: END IF;
1772:
1773: WHEN OTHERS THEN
1774: ROLLBACK TO process_txn_post_commit_GRP;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1777: FND_MSG_PUB.Add_Exc_Msg
1778: (
1779: p_pkg_name => g_pkg_name,

Line 1928: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

1924: l_plan_ids number_tab;
1925: l_occurrences number_tab;
1926: BEGIN
1927:
1928: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1929:
1930: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1931: FND_LOG.string
1932: (

Line 1945: IF NOT FND_API.Compatible_API_Call

1941: -- Standard Start of API savepoint
1942: SAVEPOINT process_txn_for_eres_GRP;
1943:
1944: -- Standard call to check for call compatibility.
1945: IF NOT FND_API.Compatible_API_Call
1946: (
1947: l_api_version,
1948: NVL( p_api_version, 1.0 ),
1949: l_api_name,

Line 1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1948: NVL( p_api_version, 1.0 ),
1949: l_api_name,
1950: g_pkg_name
1951: ) THEN
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:
1955: -- Initialize message list if p_init_msg_list is set to TRUE.
1956: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 1956: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:
1955: -- Initialize message list if p_init_msg_list is set to TRUE.
1956: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1957: FND_MSG_PUB.initialize;
1958: END IF;
1959:
1960: -- Initialize API return status to success

Line 1961: x_return_status := FND_API.G_RET_STS_SUCCESS;

1957: FND_MSG_PUB.initialize;
1958: END IF;
1959:
1960: -- Initialize API return status to success
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1963: FND_LOG.string
1964: (
1965: FND_LOG.level_statement,

Line 2065: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2061: p_collection_id => p_collection_id,
2062: p_return_status => l_return_status
2063: );
2064:
2065: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2062: p_return_status => l_return_status
2063: );
2064:
2065: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2070: FND_LOG.string

Line 2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2095: FALSE,
2096: 'DEFERRED' ,
2097: 'COLLECTION_ID'
2098: ) = FALSE ) THEN
2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2100: END IF;
2101: */
2102:
2103: -- Commit (if requested)

Line 2127: WHEN FND_API.G_EXC_ERROR THEN

2123:
2124:
2125: EXCEPTION
2126:
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: ROLLBACK TO process_txn_for_eres_GRP;
2129: x_return_status := FND_API.G_RET_STS_ERROR;
2130: FND_MSG_PUB.Count_And_Get
2131: (

Line 2129: x_return_status := FND_API.G_RET_STS_ERROR;

2125: EXCEPTION
2126:
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: ROLLBACK TO process_txn_for_eres_GRP;
2129: x_return_status := FND_API.G_RET_STS_ERROR;
2130: FND_MSG_PUB.Count_And_Get
2131: (
2132: p_count => x_msg_count,
2133: p_data => x_msg_data

Line 2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2141: 'EXITING PROCEDURE: ERROR'
2142: );
2143: END IF;
2144:
2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146: ROLLBACK TO process_txn_for_eres_GRP;
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2148: FND_MSG_PUB.Count_And_Get
2149: (

Line 2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2143: END IF;
2144:
2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146: ROLLBACK TO process_txn_for_eres_GRP;
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2148: FND_MSG_PUB.Count_And_Get
2149: (
2150: p_count => x_msg_count,
2151: p_data => x_msg_data

Line 2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2161: END IF;
2162:
2163: WHEN OTHERS THEN
2164: ROLLBACK TO process_txn_for_eres_GRP;
2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
2167: FND_MSG_PUB.Add_Exc_Msg
2168: (
2169: p_pkg_name => g_pkg_name,

Line 2218: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

2214: l_return_status VARCHAR2(1);
2215:
2216: BEGIN
2217:
2218: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2219:
2220: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2221: FND_LOG.string
2222: (

Line 2232: IF NOT FND_API.Compatible_API_Call

2228: -- Standard Start of API savepoint
2229: SAVEPOINT enable_and_fire_action_GRP;
2230:
2231: -- Standard call to check for call compatibility.
2232: IF NOT FND_API.Compatible_API_Call
2233: (
2234: l_api_version,
2235: NVL( p_api_version, 1.0 ),
2236: l_api_name,

Line 2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2235: NVL( p_api_version, 1.0 ),
2236: l_api_name,
2237: g_pkg_name
2238: ) THEN
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241:
2242: -- Initialize message list if p_init_msg_list is set to TRUE.
2243: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 2243: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241:
2242: -- Initialize message list if p_init_msg_list is set to TRUE.
2243: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
2244: FND_MSG_PUB.initialize;
2245: END IF;
2246:
2247: -- Initialize API return status to success

Line 2248: x_return_status := FND_API.G_RET_STS_SUCCESS;

2244: FND_MSG_PUB.initialize;
2245: END IF;
2246:
2247: -- Initialize API return status to success
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2250: FND_LOG.string
2251: (
2252: FND_LOG.level_statement,

Line 2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2281: FALSE,
2282: 'DEFERRED' ,
2283: 'COLLECTION_ID'
2284: ) = FALSE ) THEN
2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2286: END IF;
2287:
2288: IF ( l_commit ) THEN
2289: COMMIT WORK;

Line 2310: WHEN FND_API.G_EXC_ERROR THEN

2306: END IF;
2307:
2308: EXCEPTION
2309:
2310: WHEN FND_API.G_EXC_ERROR THEN
2311: ROLLBACK TO enable_and_fire_action_GRP;
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: FND_MSG_PUB.Count_And_Get
2314: (

Line 2312: x_return_status := FND_API.G_RET_STS_ERROR;

2308: EXCEPTION
2309:
2310: WHEN FND_API.G_EXC_ERROR THEN
2311: ROLLBACK TO enable_and_fire_action_GRP;
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: FND_MSG_PUB.Count_And_Get
2314: (
2315: p_count => x_msg_count,
2316: p_data => x_msg_data

Line 2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2324: 'EXITING PROCEDURE: ERROR'
2325: );
2326: END IF;
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: ROLLBACK TO enable_and_fire_action_GRP;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MSG_PUB.Count_And_Get
2332: (

Line 2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2326: END IF;
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: ROLLBACK TO enable_and_fire_action_GRP;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MSG_PUB.Count_And_Get
2332: (
2333: p_count => x_msg_count,
2334: p_data => x_msg_data

Line 2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2344: END IF;
2345:
2346: WHEN OTHERS THEN
2347: ROLLBACK TO enable_and_fire_action_GRP;
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
2350: FND_MSG_PUB.Add_Exc_Msg
2351: (
2352: p_pkg_name => g_pkg_name,