134:
135: WHEN FND_API.G_EXC_ERROR THEN
136: --dbms_output.put_line('load finreport exception ' || SQLERRM);
137:
138: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial reports');
139: FND_FILE.put_line(fnd_file.log, SQLERRM);
140: ROLLBACK TO load_finreports_pvt;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get(
135: WHEN FND_API.G_EXC_ERROR THEN
136: --dbms_output.put_line('load finreport exception ' || SQLERRM);
137:
138: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial reports');
139: FND_FILE.put_line(fnd_file.log, SQLERRM);
140: ROLLBACK TO load_finreports_pvt;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get(
143: p_encoded => FND_API.G_FALSE,
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: --dbms_output.put_line('load finreport exception ' || SQLERRM);
149:
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);
148: --dbms_output.put_line('load finreport exception ' || SQLERRM);
149:
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;
171: p_msg_level=>fnd_log.level_error);
172: END IF;
173:
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);
172: END IF;
173:
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;
528:
529: EXCEPTION
530: WHEN DUP_VAL_ON_INDEX THEN
531:
532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports dup val exception: ' || SQLERRM);
533: ROLLBACK to process_insert_finreports_pvt;
534:
535: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
536: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.ADD;
541:
542: WHEN OTHERS THEN
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports other exception: ' || SQLERRM);
545: ROLLBACK to process_insert_finreports_pvt;
546:
547: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update reports other exception: ' || SQLERRM);
770:
771: ROLLBACK to process_update_reports_pvt;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: