149: );
150: WHEN OTHERS THEN
151: ROLLBACK TO INSERT_HEADERLOG_PVT;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
154: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
150: WHEN OTHERS THEN
151: ROLLBACK TO INSERT_HEADERLOG_PVT;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
154: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
158: -- Standard call to get message count and if count=1, get the message
151: ROLLBACK TO INSERT_HEADERLOG_PVT;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
154: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
158: -- Standard call to get message count and if count=1, get the message
159: FND_MSG_PUB.Count_And_Get (
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
154: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
158: -- Standard call to get message count and if count=1, get the message
159: FND_MSG_PUB.Count_And_Get (
160: p_encoded => FND_API.G_FALSE,
288:
289: WHEN OTHERS THEN
290: ROLLBACK TO INSERT_LINESLOG_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
289: WHEN OTHERS THEN
290: ROLLBACK TO INSERT_LINESLOG_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
297: -- Standard call to get message count and if count=1, get the message
290: ROLLBACK TO INSERT_LINESLOG_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
420:
421: WHEN OTHERS THEN
422: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
421: WHEN OTHERS THEN
422: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429: -- Standard call to get message count and if count=1, get the message
422: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429: -- Standard call to get message count and if count=1, get the message
430: FND_MSG_PUB.Count_And_Get (
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429: -- Standard call to get message count and if count=1, get the message
430: FND_MSG_PUB.Count_And_Get (
431: p_encoded => FND_API.G_FALSE,