2921:
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923:
2924: -- HZ_PARTIES_PK, HZ_PARTIES_U2
2925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2927: FND_MSG_PUB.ADD;
2928:
2929: WHEN OTHERS THEN
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923:
2924: -- HZ_PARTIES_PK, HZ_PARTIES_U2
2925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2927: FND_MSG_PUB.ADD;
2928:
2929: WHEN OTHERS THEN
2930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert parties other exception: ' || SQLERRM);
2933: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
2934:
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936:
2937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2938: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2939: FND_MSG_PUB.ADD;
2940:
2941: END process_insert_parties;
2934:
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936:
2937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2938: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2939: FND_MSG_PUB.ADD;
2940:
2941: END process_insert_parties;
2942:
9409:
9410: ROLLBACK to process_update_parties_pvt;
9411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9412:
9413: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9415: FND_MSG_PUB.ADD;
9416:
9417: END process_update_parties;
9410: ROLLBACK to process_update_parties_pvt;
9411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9412:
9413: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9415: FND_MSG_PUB.ADD;
9416:
9417: END process_update_parties;
9418:
9587: ROLLBACK TO load_parties_pvt;
9588: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9589: FND_FILE.put_line(fnd_file.log, l_errm);
9590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9591: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9592: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9593: FND_MSG_PUB.ADD;
9594: FND_MSG_PUB.Count_And_Get(
9595: p_encoded => FND_API.G_FALSE,
9588: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9589: FND_FILE.put_line(fnd_file.log, l_errm);
9590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9591: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9592: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9593: FND_MSG_PUB.ADD;
9594: FND_MSG_PUB.Count_And_Get(
9595: p_encoded => FND_API.G_FALSE,
9596: p_count => x_msg_count,
9601: ROLLBACK TO load_parties_pvt;
9602: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9603: FND_FILE.put_line(fnd_file.log, l_errm);
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9607: FND_MSG_PUB.ADD;
9608: FND_MSG_PUB.Count_And_Get(
9609: p_encoded => FND_API.G_FALSE,
9602: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9603: FND_FILE.put_line(fnd_file.log, l_errm);
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9607: FND_MSG_PUB.ADD;
9608: FND_MSG_PUB.Count_And_Get(
9609: p_encoded => FND_API.G_FALSE,
9610: p_count => x_msg_count,