[Home] [Help]
57: l_sql_statement VARCHAR2(200);
58: l_sla_line_tbl_type sla_line_tbl_type;
59: l_processed_flag DPP_XLA_HEADERS.PROCESSED_FLAG%TYPE := 'N';
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT CREATE_SLA_Extract_PUB;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
59: l_processed_flag DPP_XLA_HEADERS.PROCESSED_FLAG%TYPE := 'N';
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT CREATE_SLA_Extract_PUB;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
240: );
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_SLA_Extract_PUB;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: ROLLBACK TO CREATE_SLA_Extract_PUB;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
265: END IF;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data