DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_FINREPORTS_PKG dependencies on FND_FILE

Line 138: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial reports');

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(

Line 139: FND_FILE.put_line(fnd_file.log, SQLERRM);

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,

Line 151: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');

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);

Line 152: FND_FILE.put_line(fnd_file.log, 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;

Line 175: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');

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);

Line 176: FND_FILE.put_line(fnd_file.log, 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;

Line 532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports dup val exception: ' || SQLERRM);

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;

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports other exception: ' || SQLERRM);

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;

Line 769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update reports other exception: ' || SQLERRM);

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: