[Home] [Help]
54: FROM JTF_FM_REQUEST_HISTORY
55: WHERE HIST_REQ_ID = l_id;
56:
57: BEGIN
58: -- Standard Start of API savepoint
59: SAVEPOINT CREATE_Request_History_PVT;
60:
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
57: BEGIN
58: -- Standard Start of API savepoint
59: SAVEPOINT CREATE_Request_History_PVT;
60:
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
63: p_api_version_number,
64: l_api_name,
65: G_PKG_NAME)
187: --
188: -- End of API body
189: --
190:
191: -- Standard check for p_commit
192: IF FND_API.to_Boolean( p_commit )
193: THEN
194: COMMIT WORK;
195: END IF;
197:
198: -- Debug Message
199: --JTF_FM_REQUEST_GRP.PRINT_MESSAGE('Private API: ' || l_api_name || 'end');
200:
201: -- Standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get
203: (p_count => x_msg_count,
204: p_data => x_msg_data
205: );
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Request_History_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Request_History_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data