[Home] [Help]
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_ERROR_PVT.UPDATE_ERROR';
56:
57: BEGIN
58:
59: -- Standard begin of API savepoint
60: SAVEPOINT Update_Error_PVT;
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version,
63: p_api_version,
57: BEGIN
58:
59: -- Standard begin of API savepoint
60: SAVEPOINT Update_Error_PVT;
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version,
63: p_api_version,
64: l_api_name,
65: G_PKG_NAME)
118: END;
119:
120: x_return_status := l_return_status;
121:
122: -- Standard check for p_commit
123: IF FND_API.to_Boolean( p_commit )
124: THEN
125: COMMIT WORK;
126: END IF;
127: -- Debug Message
128:
129: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
130:
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: (p_count => x_msg_count,
134: p_data => x_msg_data
135: );
145:
146: WHEN FND_API.G_EXC_ERROR THEN
147: ROLLBACK TO Update_Error_PVT;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: -- Standard call to get message count and if count=1, get the message
150: FND_MSG_PUB.Count_And_Get (
151: p_encoded => FND_API.G_FALSE,
152: p_count => x_msg_count,
153: p_data => x_msg_data
160:
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO Update_Error_PVT;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:
185: -- Standard call to get message count and if count=1, get the message
186: FND_MSG_PUB.Count_And_Get (
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data