358:
359: g_mesg :='Unexpected error: ' || SQLERRM;
360: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
361:
362: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
363: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
364: FND_MSG_PUB.ADD;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: END MERGE_BANKS;
359: g_mesg :='Unexpected error: ' || SQLERRM;
360: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
361:
362: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
363: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
364: FND_MSG_PUB.ADD;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: END MERGE_BANKS;
367:
844:
845: g_mesg :='Unexpected error:=' || SQLERRM;
846: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
847:
848: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
849: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852:
845: g_mesg :='Unexpected error:=' || SQLERRM;
846: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
847:
848: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
849: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852:
853: END BANK_ACCOUNTS_MERGE;