150: ROLLBACK TO load_finreports_pvt;
151: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
152: FND_FILE.put_line(fnd_file.log, SQLERRM);
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
155: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
156: FND_MSG_PUB.ADD;
157: FND_MSG_PUB.Count_And_Get(
158: p_encoded => FND_API.G_FALSE,
151: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
152: FND_FILE.put_line(fnd_file.log, SQLERRM);
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
155: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
156: FND_MSG_PUB.ADD;
157: FND_MSG_PUB.Count_And_Get(
158: p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
174: ROLLBACK TO load_finreports_pvt;
175: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
176: FND_FILE.put_line(fnd_file.log, SQLERRM);
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
175: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
176: FND_FILE.put_line(fnd_file.log, SQLERRM);
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
534:
535: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
536: x_return_status := FND_API.G_RET_STS_ERROR;
537:
538: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
540: FND_MSG_PUB.ADD;
541:
542: WHEN OTHERS THEN
535: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
536: x_return_status := FND_API.G_RET_STS_ERROR;
537:
538: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
540: FND_MSG_PUB.ADD;
541:
542: WHEN OTHERS THEN
543:
546:
547: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553:
554: END process_insert_reports;
547: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553:
554: END process_insert_reports;
555:
770:
771: ROLLBACK to process_update_reports_pvt;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
776: FND_MSG_PUB.ADD;
777:
778: END process_update_reports;
771: ROLLBACK to process_update_reports_pvt;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
776: FND_MSG_PUB.ADD;
777:
778: END process_update_reports;
779: