60: end if;
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Party Merge for AR_CMGT_CREDIT_REQUEST(-)');
62: Exception
63: when others then
64: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
65: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
66: FND_MSG_PUB.ADD;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: End;
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Party Merge for AR_CMGT_CREDIT_REQUEST(-)');
62: Exception
63: when others then
64: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
65: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
66: FND_MSG_PUB.ADD;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: End;
69:
126: end if;
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(-)');
128: Exception
129: when others then
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
132: FND_MSG_PUB.ADD;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: End;
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(-)');
128: Exception
129: when others then
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
132: FND_MSG_PUB.ADD;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: End;
135:
204: end if;
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');
206: Exception
207: when others then
208: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: End;
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');
206: Exception
207: when others then
208: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: End;
213:
289:
290: exception
291: when others then
292:
293: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
294: fnd_message.set_token('ERROR' ,SQLERRM);
295: fnd_msg_pub.add;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297:
290: exception
291: when others then
292:
293: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
294: fnd_message.set_token('ERROR' ,SQLERRM);
295: fnd_msg_pub.add;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297:
298:
373:
374: exception
375: when others then
376:
377: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
378: fnd_message.set_token('ERROR' ,SQLERRM);
379: fnd_msg_pub.add;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381:
374: exception
375: when others then
376:
377: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
378: fnd_message.set_token('ERROR' ,SQLERRM);
379: fnd_msg_pub.add;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381:
382:
459:
460: exception
461: when others then
462:
463: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
464: fnd_message.set_token('ERROR' ,SQLERRM);
465: fnd_msg_pub.add;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
460: exception
461: when others then
462:
463: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
464: fnd_message.set_token('ERROR' ,SQLERRM);
465: fnd_msg_pub.add;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: