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');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,
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');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
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');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(
447: p_encoded => FND_API.G_FALSE,
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');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
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;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
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;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
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;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,
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;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,