DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_PARTY_SITE_USE_PKG dependencies on FND_FILE

Line 411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses dup val exception: ' || SQLERRM);

407: p_msg_level=>fnd_log.level_procedure);
408: END IF;
409: EXCEPTION
410: WHEN DUP_VAL_ON_INDEX THEN
411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses dup val exception: ' || SQLERRM);
412: ROLLBACK to process_insert_psu_pvt;
413: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses other exception: ' || SQLERRM);

420: p_count => x_msg_count,
421: p_data => x_msg_data);
422:
423: WHEN OTHERS THEN
424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses other exception: ' || SQLERRM);
425: ROLLBACK TO process_insert_psu_pvt;
426: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');

493: p_data => x_msg_data);
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO load_partysiteuses_pvt;
497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);

Line 498: FND_FILE.put_line(fnd_file.log, l_errm);

494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO load_partysiteuses_pvt;
497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;

Line 519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');

515: p_msg_level=>fnd_log.level_error);
516: END IF;
517:
518: ROLLBACK TO load_partysiteuses_pvt;
519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 520: FND_FILE.put_line(fnd_file.log, l_errm);

516: END IF;
517:
518: ROLLBACK TO load_partysiteuses_pvt;
519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;