41:
42:
43: BEGIN
44:
45: -- Standard Start of API savepoint
46: SAVEPOINT zpb_excp_pvt_populate_results;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call( l_api_version,
49: p_api_version,
43: BEGIN
44:
45: -- Standard Start of API savepoint
46: SAVEPOINT zpb_excp_pvt_populate_results;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call( l_api_version,
49: p_api_version,
50: l_api_name,
51: G_PKG_NAME)
75: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User validation complete.');
76:
77: -- End of API body.
78:
79: -- Standard check of p_commit.
80: IF FND_API.To_Boolean( p_commit ) THEN
81: COMMIT WORK;
82: END IF;
83: -- Standard call to get message count and if count is 1, get message info.
79: -- Standard check of p_commit.
80: IF FND_API.To_Boolean( p_commit ) THEN
81: COMMIT WORK;
82: END IF;
83: -- Standard call to get message count and if count is 1, get message info.
84: FND_MSG_PUB.Count_And_Get(
85: p_count => x_msg_count, p_data => x_msg_data );
86:
87: EXCEPTION
142:
143:
144: BEGIN
145:
146: -- Standard Start of API savepoint
147: SAVEPOINT zpb_excp_pvt_populate_results;
148: -- Standard call to check for call compatibility.
149: IF NOT FND_API.Compatible_API_Call( l_api_version,
150: p_api_version,
144: BEGIN
145:
146: -- Standard Start of API savepoint
147: SAVEPOINT zpb_excp_pvt_populate_results;
148: -- Standard call to check for call compatibility.
149: IF NOT FND_API.Compatible_API_Call( l_api_version,
150: p_api_version,
151: l_api_name,
152: G_PKG_NAME)
180: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Read access check complete.');
181:
182: -- End of API body.
183:
184: -- Standard check of p_commit.
185: IF FND_API.To_Boolean( p_commit ) THEN
186: COMMIT WORK;
187: END IF;
188: -- Standard call to get message count and if count is 1, get message info.
184: -- Standard check of p_commit.
185: IF FND_API.To_Boolean( p_commit ) THEN
186: COMMIT WORK;
187: END IF;
188: -- Standard call to get message count and if count is 1, get message info.
189: FND_MSG_PUB.Count_And_Get(
190: p_count => x_msg_count, p_data => x_msg_data );
191:
192: EXCEPTION
258:
259:
260: BEGIN
261:
262: -- Standard Start of API savepoint
263: SAVEPOINT zpb_excp_pvt_populate_results;
264: -- Standard call to check for call compatibility.
265: IF NOT FND_API.Compatible_API_Call( l_api_version,
266: p_api_version,
260: BEGIN
261:
262: -- Standard Start of API savepoint
263: SAVEPOINT zpb_excp_pvt_populate_results;
264: -- Standard call to check for call compatibility.
265: IF NOT FND_API.Compatible_API_Call( l_api_version,
266: p_api_version,
267: l_api_name,
268: G_PKG_NAME)
296: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User access state has been set to ' || l_readAcc || '.');
297:
298: -- End of API body.
299:
300: -- Standard check of p_commit.
301: IF FND_API.To_Boolean( p_commit ) THEN
302: COMMIT WORK;
303: END IF;
304: -- Standard call to get message count and if count is 1, get message info.
300: -- Standard check of p_commit.
301: IF FND_API.To_Boolean( p_commit ) THEN
302: COMMIT WORK;
303: END IF;
304: -- Standard call to get message count and if count is 1, get message info.
305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count, p_data => x_msg_data );
307:
308: EXCEPTION