DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on FND_API

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

1495: l_plan_ids number_tab;
1496: l_occurrences number_tab;
1497: BEGIN
1498:
1499: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1500:
1501: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1502: FND_LOG.string
1503: (

Line 1515: IF NOT FND_API.Compatible_API_Call

1511: -- Standard Start of API savepoint
1512: SAVEPOINT process_txn_post_commit_GRP;
1513:
1514: -- Standard call to check for call compatibility.
1515: IF NOT FND_API.Compatible_API_Call
1516: (
1517: l_api_version,
1518: NVL( p_api_version, 1.0 ),
1519: l_api_name,

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1518: NVL( p_api_version, 1.0 ),
1519: l_api_name,
1520: g_pkg_name
1521: ) THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: END IF;
1524:
1525: -- Initialize message list if p_init_msg_list is set to TRUE.
1526: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

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

1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: END IF;
1524:
1525: -- Initialize message list if p_init_msg_list is set to TRUE.
1526: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:
1530: -- Initialize API return status to success

Line 1531: x_return_status := FND_API.G_RET_STS_SUCCESS;

1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:
1530: -- Initialize API return status to success
1531: x_return_status := FND_API.G_RET_STS_SUCCESS;
1532:
1533: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1534: FND_LOG.string
1535: (

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

1642: p_collection_id => p_collection_id,
1643: p_return_status => l_return_status
1644: );
1645:
1646: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: END IF;
1649:
1650: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1643: p_return_status => l_return_status
1644: );
1645:
1646: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: END IF;
1649:
1650: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1651: FND_LOG.string

Line 1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1669: FALSE,
1670: 'DEFERRED' ,
1671: 'COLLECTION_ID'
1672: ) = FALSE ) THEN
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: END IF;
1675:
1676: -- Commit (if requested)
1677: IF ( l_commit ) THEN

Line 1699: WHEN FND_API.G_EXC_ERROR THEN

1695: END IF;
1696:
1697: EXCEPTION
1698:
1699: WHEN FND_API.G_EXC_ERROR THEN
1700: ROLLBACK TO process_txn_post_commit_GRP;
1701: x_return_status := FND_API.G_RET_STS_ERROR;
1702: FND_MSG_PUB.Count_And_Get
1703: (

Line 1701: x_return_status := FND_API.G_RET_STS_ERROR;

1697: EXCEPTION
1698:
1699: WHEN FND_API.G_EXC_ERROR THEN
1700: ROLLBACK TO process_txn_post_commit_GRP;
1701: x_return_status := FND_API.G_RET_STS_ERROR;
1702: FND_MSG_PUB.Count_And_Get
1703: (
1704: p_count => x_msg_count,
1705: p_data => x_msg_data

Line 1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1713: 'EXITING PROCEDURE: ERROR'
1714: );
1715: END IF;
1716:
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO process_txn_post_commit_GRP;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: FND_MSG_PUB.Count_And_Get
1721: (

Line 1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1715: END IF;
1716:
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO process_txn_post_commit_GRP;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: FND_MSG_PUB.Count_And_Get
1721: (
1722: p_count => x_msg_count,
1723: p_data => x_msg_data

Line 1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1733: END IF;
1734:
1735: WHEN OTHERS THEN
1736: ROLLBACK TO process_txn_post_commit_GRP;
1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1738: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1739: FND_MSG_PUB.Add_Exc_Msg
1740: (
1741: p_pkg_name => g_pkg_name,

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

1886: l_plan_ids number_tab;
1887: l_occurrences number_tab;
1888: BEGIN
1889:
1890: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1891:
1892: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1893: FND_LOG.string
1894: (

Line 1907: IF NOT FND_API.Compatible_API_Call

1903: -- Standard Start of API savepoint
1904: SAVEPOINT process_txn_for_eres_GRP;
1905:
1906: -- Standard call to check for call compatibility.
1907: IF NOT FND_API.Compatible_API_Call
1908: (
1909: l_api_version,
1910: NVL( p_api_version, 1.0 ),
1911: l_api_name,

Line 1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1910: NVL( p_api_version, 1.0 ),
1911: l_api_name,
1912: g_pkg_name
1913: ) THEN
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: END IF;
1916:
1917: -- Initialize message list if p_init_msg_list is set to TRUE.
1918: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

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

1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: END IF;
1916:
1917: -- Initialize message list if p_init_msg_list is set to TRUE.
1918: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1919: FND_MSG_PUB.initialize;
1920: END IF;
1921:
1922: -- Initialize API return status to success

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: FND_MSG_PUB.initialize;
1920: END IF;
1921:
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1925: FND_LOG.string
1926: (
1927: FND_LOG.level_statement,

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

2023: p_collection_id => p_collection_id,
2024: p_return_status => l_return_status
2025: );
2026:
2027: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2024: p_return_status => l_return_status
2025: );
2026:
2027: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2032: FND_LOG.string

Line 2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2057: FALSE,
2058: 'DEFERRED' ,
2059: 'COLLECTION_ID'
2060: ) = FALSE ) THEN
2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2062: END IF;
2063: */
2064:
2065: -- Commit (if requested)

Line 2089: WHEN FND_API.G_EXC_ERROR THEN

2085:
2086:
2087: EXCEPTION
2088:
2089: WHEN FND_API.G_EXC_ERROR THEN
2090: ROLLBACK TO process_txn_for_eres_GRP;
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: FND_MSG_PUB.Count_And_Get
2093: (

Line 2091: x_return_status := FND_API.G_RET_STS_ERROR;

2087: EXCEPTION
2088:
2089: WHEN FND_API.G_EXC_ERROR THEN
2090: ROLLBACK TO process_txn_for_eres_GRP;
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: FND_MSG_PUB.Count_And_Get
2093: (
2094: p_count => x_msg_count,
2095: p_data => x_msg_data

Line 2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2103: 'EXITING PROCEDURE: ERROR'
2104: );
2105: END IF;
2106:
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2108: ROLLBACK TO process_txn_for_eres_GRP;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MSG_PUB.Count_And_Get
2111: (

Line 2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2105: END IF;
2106:
2107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2108: ROLLBACK TO process_txn_for_eres_GRP;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MSG_PUB.Count_And_Get
2111: (
2112: p_count => x_msg_count,
2113: p_data => x_msg_data

Line 2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2123: END IF;
2124:
2125: WHEN OTHERS THEN
2126: ROLLBACK TO process_txn_for_eres_GRP;
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
2129: FND_MSG_PUB.Add_Exc_Msg
2130: (
2131: p_pkg_name => g_pkg_name,

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

2176: l_return_status VARCHAR2(1);
2177:
2178: BEGIN
2179:
2180: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2181:
2182: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2183: FND_LOG.string
2184: (

Line 2194: IF NOT FND_API.Compatible_API_Call

2190: -- Standard Start of API savepoint
2191: SAVEPOINT enable_and_fire_action_GRP;
2192:
2193: -- Standard call to check for call compatibility.
2194: IF NOT FND_API.Compatible_API_Call
2195: (
2196: l_api_version,
2197: NVL( p_api_version, 1.0 ),
2198: l_api_name,

Line 2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2197: NVL( p_api_version, 1.0 ),
2198: l_api_name,
2199: g_pkg_name
2200: ) THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: -- Initialize message list if p_init_msg_list is set to TRUE.
2205: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

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

2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: -- Initialize message list if p_init_msg_list is set to TRUE.
2205: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
2206: FND_MSG_PUB.initialize;
2207: END IF;
2208:
2209: -- Initialize API return status to success

Line 2210: x_return_status := FND_API.G_RET_STS_SUCCESS;

2206: FND_MSG_PUB.initialize;
2207: END IF;
2208:
2209: -- Initialize API return status to success
2210: x_return_status := FND_API.G_RET_STS_SUCCESS;
2211: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2212: FND_LOG.string
2213: (
2214: FND_LOG.level_statement,

Line 2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2243: FALSE,
2244: 'DEFERRED' ,
2245: 'COLLECTION_ID'
2246: ) = FALSE ) THEN
2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2248: END IF;
2249:
2250: IF ( l_commit ) THEN
2251: COMMIT WORK;

Line 2272: WHEN FND_API.G_EXC_ERROR THEN

2268: END IF;
2269:
2270: EXCEPTION
2271:
2272: WHEN FND_API.G_EXC_ERROR THEN
2273: ROLLBACK TO enable_and_fire_action_GRP;
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: FND_MSG_PUB.Count_And_Get
2276: (

Line 2274: x_return_status := FND_API.G_RET_STS_ERROR;

2270: EXCEPTION
2271:
2272: WHEN FND_API.G_EXC_ERROR THEN
2273: ROLLBACK TO enable_and_fire_action_GRP;
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: FND_MSG_PUB.Count_And_Get
2276: (
2277: p_count => x_msg_count,
2278: p_data => x_msg_data

Line 2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2286: 'EXITING PROCEDURE: ERROR'
2287: );
2288: END IF;
2289:
2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2291: ROLLBACK TO enable_and_fire_action_GRP;
2292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2293: FND_MSG_PUB.Count_And_Get
2294: (

Line 2292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2288: END IF;
2289:
2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2291: ROLLBACK TO enable_and_fire_action_GRP;
2292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2293: FND_MSG_PUB.Count_And_Get
2294: (
2295: p_count => x_msg_count,
2296: p_data => x_msg_data

Line 2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2306: END IF;
2307:
2308: WHEN OTHERS THEN
2309: ROLLBACK TO enable_and_fire_action_GRP;
2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2311: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
2312: FND_MSG_PUB.Add_Exc_Msg
2313: (
2314: p_pkg_name => g_pkg_name,