174: END IF;
175:
176: WHEN OTHERS THEN
177: ROLLBACK TO Update_Error_PVT;
178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
175:
176: WHEN OTHERS THEN
177: ROLLBACK TO Update_Error_PVT;
178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: WHEN OTHERS THEN
177: ROLLBACK TO Update_Error_PVT;
178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:
177: ROLLBACK TO Update_Error_PVT;
178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
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