458: WHEN OTHERS THEN
459: --IBE_UTIL.enable_debug();
460:
461: --ROLLBACK TO create_credit_card;
462: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
463: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
464: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
465: FND_MESSAGE.Set_Token('REASON', SQLERRM);
466: FND_MSG_PUB.Add;
459: --IBE_UTIL.enable_debug();
460:
461: --ROLLBACK TO create_credit_card;
462: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
463: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
464: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
465: FND_MESSAGE.Set_Token('REASON', SQLERRM);
466: FND_MSG_PUB.Add;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460:
461: --ROLLBACK TO create_credit_card;
462: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
463: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
464: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
465: FND_MESSAGE.Set_Token('REASON', SQLERRM);
466: FND_MSG_PUB.Add;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Add;
461: --ROLLBACK TO create_credit_card;
462: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
463: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
464: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
465: FND_MESSAGE.Set_Token('REASON', SQLERRM);
466: FND_MSG_PUB.Add;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Add;
469: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,