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