155: );
156: WHEN OTHERS THEN
157: ROLLBACK TO INSERT_HEADERLOG_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
160: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
161: fnd_message.set_token('ERRNO', sqlcode);
162: fnd_message.set_token('REASON', sqlerrm);
163: FND_MSG_PUB.ADD;
156: WHEN OTHERS THEN
157: ROLLBACK TO INSERT_HEADERLOG_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
160: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
161: fnd_message.set_token('ERRNO', sqlcode);
162: fnd_message.set_token('REASON', sqlerrm);
163: FND_MSG_PUB.ADD;
164: -- Standard call to get message count and if count=1, get the message
157: ROLLBACK TO INSERT_HEADERLOG_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
160: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
161: fnd_message.set_token('ERRNO', sqlcode);
162: fnd_message.set_token('REASON', sqlerrm);
163: FND_MSG_PUB.ADD;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
160: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
161: fnd_message.set_token('ERRNO', sqlcode);
162: fnd_message.set_token('REASON', sqlerrm);
163: FND_MSG_PUB.ADD;
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,
300:
301: WHEN OTHERS THEN
302: ROLLBACK TO INSERT_LINESLOG_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
305: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
306: fnd_message.set_token('ERRNO', sqlcode);
307: fnd_message.set_token('REASON', sqlerrm);
308: FND_MSG_PUB.ADD;
301: WHEN OTHERS THEN
302: ROLLBACK TO INSERT_LINESLOG_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
305: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
306: fnd_message.set_token('ERRNO', sqlcode);
307: fnd_message.set_token('REASON', sqlerrm);
308: FND_MSG_PUB.ADD;
309: -- Standard call to get message count and if count=1, get the message
302: ROLLBACK TO INSERT_LINESLOG_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
305: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
306: fnd_message.set_token('ERRNO', sqlcode);
307: fnd_message.set_token('REASON', sqlerrm);
308: FND_MSG_PUB.ADD;
309: -- Standard call to get message count and if count=1, get the message
310: FND_MSG_PUB.Count_And_Get (
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
305: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
306: fnd_message.set_token('ERRNO', sqlcode);
307: fnd_message.set_token('REASON', sqlerrm);
308: FND_MSG_PUB.ADD;
309: -- Standard call to get message count and if count=1, get the message
310: FND_MSG_PUB.Count_And_Get (
311: p_encoded => FND_API.G_FALSE,
438:
439: WHEN OTHERS THEN
440: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
443: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
444: fnd_message.set_token('ERRNO', sqlcode);
445: fnd_message.set_token('REASON', sqlerrm);
446: FND_MSG_PUB.ADD;
439: WHEN OTHERS THEN
440: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
443: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
444: fnd_message.set_token('ERRNO', sqlcode);
445: fnd_message.set_token('REASON', sqlerrm);
446: FND_MSG_PUB.ADD;
447: -- Standard call to get message count and if count=1, get the message
440: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
443: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
444: fnd_message.set_token('ERRNO', sqlcode);
445: fnd_message.set_token('REASON', sqlerrm);
446: FND_MSG_PUB.ADD;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
443: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
444: fnd_message.set_token('ERRNO', sqlcode);
445: fnd_message.set_token('REASON', sqlerrm);
446: FND_MSG_PUB.ADD;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,