DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on FND_FILE

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

422: END IF;
423:
424: EXCEPTION
425: WHEN DUP_VAL_ON_INDEX THEN
426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles dup val exception: ' || SQLERRM);
427: ROLLBACK to load_contactroles_pvt;
428: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

435: p_count => x_msg_count,
436: p_data => x_msg_data);
437:
438: WHEN OTHERS THEN
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles other exception: ' || SQLERRM);
440: ROLLBACK TO load_contactroles_pvt;
441: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

507: p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO load_contactroles_pvt;
511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);

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

508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO load_contactroles_pvt;
511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
516: FND_MSG_PUB.ADD;

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

520: p_data => x_msg_data);
521:
522: WHEN OTHERS THEN
523: ROLLBACK TO load_contactroles_pvt;
524: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
525: FND_FILE.put_line(fnd_file.log, l_errm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

521:
522: WHEN OTHERS THEN
523: ROLLBACK TO load_contactroles_pvt;
524: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
525: FND_FILE.put_line(fnd_file.log, l_errm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
529: FND_MSG_PUB.ADD;