63: l_api_version CONSTANT NUMBER := 1.0;
64:
65: BEGIN
66:
67: -- Standard Start of API savepoint
68: SAVEPOINT Data_Extract_Summary;
69:
70: -- Standard call to check for call compatibility.
71: if not FND_API.Compatible_API_Call (l_api_version,
66:
67: -- Standard Start of API savepoint
68: SAVEPOINT Data_Extract_Summary;
69:
70: -- Standard call to check for call compatibility.
71: if not FND_API.Compatible_API_Call (l_api_version,
72: p_api_version,
73: l_api_name,
74: G_PKG_NAME)
182: end if;
183:
184: -- End of API body.
185:
186: -- Standard check of p_commit.
187:
188: if FND_API.to_Boolean (p_commit) then
189: commit work;
190: end if;
188: if FND_API.to_Boolean (p_commit) then
189: commit work;
190: end if;
191:
192: -- Standard call to get message count and if count is 1, get message info.
193:
194: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
195: p_data => p_msg_data);
196:
282: WHERE concurrent_request_id = -4712;
283: /* end bug no 4170600 */
284:
285: BEGIN
286: -- Standard Start of API savepoint
287: SAVEPOINT Validate_Data_Extract;
288:
289: -- Standard call to check for call compatibility.
290: if not FND_API.Compatible_API_Call (l_api_version,
285: BEGIN
286: -- Standard Start of API savepoint
287: SAVEPOINT Validate_Data_Extract;
288:
289: -- Standard call to check for call compatibility.
290: if not FND_API.Compatible_API_Call (l_api_version,
291: p_api_version,
292: l_api_name,
293: G_PKG_NAME)
399: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: raise FND_API.G_EXC_ERROR;
401: end if;
402:
403: -- Standard check of p_commit.
404: if FND_API.to_Boolean (p_commit) then
405: commit work;
406: end if;
407:
404: if FND_API.to_Boolean (p_commit) then
405: commit work;
406: end if;
407:
408: -- Standard call to get message count and if count is 1, get message info.
409: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
410: p_data => p_msg_data);
411: EXCEPTION
412: --